Hallo,
ich habe das Plugin AXAJ Who´s online eingebunden. Habe dann mit dem Befehl
<?php tms_user_online() ?>versucht das Plugin zu aktivieren und bekomme aber folgendes Ergebnis:
WordPress Datenbank-Fehler: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,PRIMARY KEY (`us]
CREATE TABLE `tms_online_users` (`user_id` int(11) NOT NULL default '0',`lastping` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,PRIMARY KEY (`user_id`));
WordPress Datenbank-Fehler: [Table 'd00505a3.tms_online_users' doesn't exist]
SELECT COUNT(*) FROM tms_online_users WHERE user_id = '1'
WordPress Datenbank-Fehler: [Table 'd00505a3.tms_online_users' doesn't exist]
INSERT INTO tms_online_users VALUES('1', '2007-5-24 11:45:9')
WordPress Datenbank-Fehler: [Table 'd00505a3.tms_online_users' doesn't exist]
SELECT user_id FROM tms_online_users WHERE lastping>=FROM_UNIXTIME('1179999889')
WordPress Datenbank-Fehler: [Table 'd00505a3.tms_online_users' doesn't exist]
SELECT user_id FROM tms_online_users WHERE lastping<FROM_UNIXTIME('1179999889') ORDER BY lastping DESC
No registered users are currently logged in.WordPress Datenbank-Fehler: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,PRIMARY KEY (`us]
CREATE TABLE `tms_online_users` (`user_id` int(11) NOT NULL default '0',`lastping` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,PRIMARY KEY (`user_id`));
WordPress Datenbank-Fehler: [Table 'd00505a3.tms_online_users' doesn't exist]
SELECT COUNT(*) FROM tms_online_users WHERE user_id = '1'
WordPress Datenbank-Fehler: [Table 'd00505a3.tms_online_users' doesn't exist]
INSERT INTO tms_online_users VALUES('1', '2007-5-24 11:44:39')
WordPress Datenbank-Fehler: [Table 'd00505a3.tms_online_users' doesn't exist]
SELECT user_id FROM tms_online_users WHERE lastping>=FROM_UNIXTIME('1179999859')
WordPress Datenbank-Fehler: [Table 'd00505a3.tms_online_users' doesn't exist]
SELECT user_id FROM tms_online_users WHERE lastping<FROM_UNIXTIME('1179999859') ORDER BY lastping DESC
No registered users are currently logged in.
Hat das Problem vielleicht noch jemand und kann mir gleich sagen woran es liegt??? Das wäre super !!!
Danke, Benedikt