Jump to content

[PROBLEM]MYSQL TABLE


Recommended Posts

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

  • Replies 6
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic


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 by Optimus

spacer.png

Link to comment
Share on other sites

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 by Domik309
Link to comment
Share on other sites

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;

 

spacer.png

Link to comment
Share on other sites

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

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



  • Similar Content

  • Activity

    1. 3

      Crystal Metinstone

    2. 3

      Feeding game source to LLM

    3. 113

      Ulthar SF V2 (TMP4 Base)

    4. 3

      Feeding game source to LLM

    5. 0

      Target Information System

    6. 3

      Feeding game source to LLM

    7. 2

      anti exp explanation pls

  • Recently Browsing

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.