2010 logs

02/04/2011 12:08 .Rebel#1

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 -.-

02/04/2011 13:34 Legend2007#2

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

02/04/2011 13:40 garrisson#3

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.

02/04/2011 14:29 .Rebel#4

Quote:

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

02/12/2012 13:49 [TM]SixSense#5

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;