2010 logs

[.Rebel]

Hi peaple i need a hand with the table money_log for the server files 2010

PHP Code:

4 10:12:38 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'money_log' (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 71118, 10) errno: 1616) 


i have made this

PHP Code:

DROP TABLE IF EXISTS `money_log`;
CREATE TABLE `money_log` (
  `VALUES` int(11) DEFAULT NULL,
  `DELAYED` int(11) DEFAULT NULL,
  `time` time DEFAULT NULL,
  `vnum` int(11) DEFAULT '0',
  `pid` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1; 


but still dont work -.-

[Legend2007]

PHP Code:

DROP TABLE IF EXISTS `money_log`;
CREATE TABLE `money_log` (
  `time` datetime DEFAULT NULL,
  `something` int(11) DEFAULT NULL,
  `vnum` int(11) DEFAULT '0',
  `pid` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1; 


Not sure if it works tho.. Didn't try it out yet.. Just wrote it by hand of the SQL Query. The money_log table I have in my db is wrong too since it has no entries..

Regards
Legend

[garrisson]

PHP Code:

DROP TABLE IF EXISTS `money_log`;
CREATE TABLE `money_log` (
  `VALUES` int(11) DEFAULT NULL,
  `DELAYED` int(11) DEFAULT NULL,
  `time` time DEFAULT NULL,
  `vnum` int(11) DEFAULT '0',
  `pid` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 


Use this. The problem is the storage-engine Innodb.
Use MyISAM to get it working.

[.Rebel]

Originally Posted by garrisson

PHP Code:

DROP TABLE IF EXISTS `money_log`;
CREATE TABLE `money_log` (
  `VALUES` int(11) DEFAULT NULL,
  `DELAYED` int(11) DEFAULT NULL,
  `time` time DEFAULT NULL,
  `vnum` int(11) DEFAULT '0',
  `pid` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 


Use this. The problem is the storage-engine Innodb.
Use MyISAM to get it working.

yes i have try also with Myisam before the post but also dont work

[[TM]SixSense]

RUN THIS S**T

DROP TABLE IF EXISTS `money_log`;
CREATE TABLE `money_log` (
`year` int(11) DEFAULT NULL,
`time` time DEFAULT NULL,
`vnum` int(11) DEFAULT '0',
`pid` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;