Domik309 19 Posted February 7, 2020 Share Posted February 7, 2020 Hi community, I wanted to ask if there is anyone who will help me solve this problem by sending me "QUERY" or directly a table named "itemshop.logs". In relation to this problem: SYSERR: Feb 6 22:33:24 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'player.itemshop_logs' doesn't exist query: Insert into player.itemshop_logs(account_id,coins,who,what,count,date) VALUES(7,100,'Himogy', 41347,1,CURRENT_TIMESTAMP) SYSERR: Feb 6 22:34:48 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'player.itemshop_logs' doesn't exist query: Insert into player.itemshop_logs(account_id,coins,who,what,count,date) VALUES(7,150,'Himogy', 75708,1,CURRENT_TIMESTAMP) SYSERR: Feb 6 22:40:41 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'player.itemshop_logs' doesn't exist query: Insert into player.itemshop_logs(account_id,coins,who,what,count,date) VALUES(7,50,'Himogy', 71107,1,CURRENT_TIMESTAMP) SYSERR: Feb 6 22:41:29 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'player.itemshop_logs' doesn't exist query: Insert into player.itemshop_logs(account_id,coins,who,what,count,date) VALUES(7,50,'Himogy', 71107,1,CURRENT_TIMESTAMP) SYSERR: Feb 6 22:46:43 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'player.itemshop_logs' doesn't exist query: Insert into player.itemshop_logs(account_id,coins,who,what,count,date) VALUES(7,50,'Nether', 71107,1,CURRENT_TIMESTAMP) SYSERR: Feb 6 22:47:04 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'player.itemshop_logs' doesn't exist query: Insert into player.itemshop_logs(account_id,coins,who,what,count,date) VALUES(7,150,'Nether', 45177,1,CURRENT_TIMESTAMP) SYSERR: Feb 6 22:47:34 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'player.itemshop_logs' doesn't exist query: Insert into player.itemshop_logs(account_id,coins,who,what,count,date) VALUES(7,100,'Nether', 41345,1,CURRENT_TIMESTAMP) I tried Google and unfortunately nothing found ... Thanks everyone for the help and Good bye. Link to comment Share on other sites More sharing options...
IonutRO 936 Posted February 7, 2020 Share Posted February 7, 2020 (edited) CREATE TABLE `itemshop_logs` ( `id` int(11) NOT NULL, `account_id` int(11) NOT NULL, `coins` int(11) NOT NULL DEFAULT 0, `who` varchar(24) NOT NULL, `what` int(11) DEFAULT NULL, `count` int(11) NOT NULL DEFAULT 0, `date` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ALTER TABLE `itemshop_logs` ADD PRIMARY KEY (`id`); ALTER TABLE `itemshop_logs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; COMMIT; Edited February 7, 2020 by Optimus Link to comment Share on other sites More sharing options...
Domik309 19 Posted February 7, 2020 Author Share Posted February 7, 2020 (edited) 1 hour ago, Optimus said: CREATE TABLE `itemshop_logs` ( `id` int(11) NOT NULL, `account_id` int(11) NOT NULL, `coins` int(11) NOT NULL DEFAULT 0, `who` varchar(24) NOT NULL, `what` int(11) DEFAULT NULL, `count` int(11) NOT NULL DEFAULT 0, `date` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 > 1067 - Invalid default value for 'date' > Time: 0,009s Edited February 7, 2020 by Domik309 Link to comment Share on other sites More sharing options...
IonutRO 936 Posted February 7, 2020 Share Posted February 7, 2020 2 hours ago, Domik309 said: CREATE TABLE `itemshop_logs` ( `id` int(11) NOT NULL, `account_id` int(11) NOT NULL, `coins` int(11) NOT NULL DEFAULT 0, `who` varchar(24) NOT NULL, `what` int(11) DEFAULT NULL, `count` int(11) NOT NULL DEFAULT 0, `date` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ALTER TABLE `itemshop_logs` ADD PRIMARY KEY (`id`); ALTER TABLE `itemshop_logs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; COMMIT; Link to comment Share on other sites More sharing options...
Domik309 19 Posted February 8, 2020 Author Share Posted February 8, 2020 16 hours ago, Optimus said: CREATE TABLE `itemshop_logs` ( `id` int(11) NOT NULL, `account_id` int(11) NOT NULL, `coins` int(11) NOT NULL DEFAULT 0, `who` varchar(24) NOT NULL, `what` int(11) DEFAULT NULL, `count` int(11) NOT NULL DEFAULT 0, `date` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 > 1146 - Table 'player.itemshop_logs' doesn't exist > Time: 0,007s Link to comment Share on other sites More sharing options...
Tallywa 35 Posted February 10, 2020 Share Posted February 10, 2020 your execute sql requete in good database? Link to comment Share on other sites More sharing options...
Domik309 19 Posted February 10, 2020 Author Share Posted February 10, 2020 Yes Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now