I can?t seem to get the SQL Query to work...
This is the dump of the "cron" table:
Code:
CREATE TABLE `cron` (
`cronid` int(10) unsigned NOT NULL auto_increment,
`nextrun` int(10) unsigned NOT NULL default '0',
`weekday` smallint(6) NOT NULL default '0',
`day` smallint(6) NOT NULL default '0',
`hour` smallint(6) NOT NULL default '0',
`minute` varchar(100) NOT NULL default '',
`filename` varchar(50) NOT NULL default '',
`loglevel` smallint(6) NOT NULL default '0',
`active` smallint(6) NOT NULL default '1',
`varname` varchar(100) NOT NULL default '',
`volatile` smallint(5) unsigned NOT NULL default '0',
`product` varchar(25) NOT NULL default '',
PRIMARY KEY (`cronid`),
UNIQUE KEY `varname` (`varname`),
KEY `nextrun` (`nextrun`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `cron`
--
/*!40000 ALTER TABLE `cron` DISABLE KEYS */;
LOCK TABLES `cron` WRITE;
INSERT INTO `cron` VALUES (1,1179093660,-1,-1,0,'a:1:{i:0;i:1;}','./includes/cron/birthday.php',1,1,'birthday',1,'vbulletin'),(2,1179014160,-1,-1,-1,'a:1:{i:0;i:56;}','./includes/cron/threadviews.php',0,1,'threadviews',1,'vbulletin'),(3,1179012300,-1,-1,-1,'a:1:{i:0;i:25;}','./includes/cron/promotion.php',1,1,'promotion',1,'vbulletin'),(4,1179093720,-1,-1,0,'a:1:{i:0;i:2;}','./includes/cron/digestdaily.php',1,1,'digestdaily',1,'vbulletin'),(5,1179095400,1,-1,0,'a:1:{i:0;i:30;}','./includes/cron/digestweekly.php',1,1,'digestweekly',1,'vbulletin'),(6,1179093720,-1,-1,0,'a:1:{i:0;i:2;}','./includes/cron/subscriptions.php',1,1,'subscriptions',1,'vbulletin'),(7,1179014700,-1,-1,-1,'a:1:{i:0;i:5;}','./includes/cron/cleanup.php',0,1,'cleanup',1,'vbulletin'),(8,1179011400,-1,-1,-1,'a:1:{i:0;i:10;}','./includes/cron/attachmentviews.php',0,1,'attachmentviews',1,'vbulletin'),(9,1179093780,-1,-1,0,'a:1:{i:0;i:3;}','./includes/cron/activate.php',1,1,'activate',1,'vbulletin'),(10,1179011700,-1,-1,-1,'a:1:{i:0;i:15;}','./includes/cron/removebans.php',1,1,'removebans',1,'vbulletin'),(11,1179012000,-1,-1,-1,'a:1:{i:0;i:20;}','./includes/cron/cleanup2.php',0,1,'cleanup2',1,'vbulletin'),(12,1179093600,-1,-1,0,'a:1:{i:0;i:0;}','./includes/cron/stats.php',0,1,'stats',1,'vbulletin'),(13,1179012300,-1,-1,-1,'a:2:{i:0;i:25;i:1;i:55;}','./includes/cron/reminder.php',0,1,'reminder',1,'vbulletin'),(14,1179094200,-1,-1,0,'a:1:{i:0;i:10;}','./includes/cron/dailycleanup.php',0,1,'dailycleanup',1,'vbulletin'),(15,1179012000,-1,-1,-1,'a:2:{i:0;i:20;i:1;i:50;}','./includes/cron/infractions.php',1,1,'infractions',1,'vbulletin'),(16,1179011400,-1,-1,-1,'a:1:{i:0;i:10;}','./includes/cron/ccbill.php',1,1,'ccbill',1,'vbulletin'),(17,1179011400,-1,-1,-1,'a:6:{i:0;i:0;i:1;i:10;i:2;i:20;i:3;i:30;i:4;i:40;i:5;i:50;}','./includes/cron/rssposter.php',1,1,'rssposter',1,'vbulletin'),(18,1179093900,-1,-1,0,'a:1:{i:0;i:5;}','./includes/cron/birthdaythread.php',1,1,'Automatic Birthday Thread',1,'vbulletin');
I just get the following error:
Quote:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 '" . TABLE_PREFIX . "cron (weekday,day,hour,minute,filename,loglevel,active, varna' at line 1
|
after editing the query to:
Code:
INSERT INTO cron VALUES (-1, 10, 0, 'a:1:{i:0;i:0;}', './includes/cron/cronautodelete.php', 1, 'Auto Delete/Move Thread After X days')
i then get the error:
Quote:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1136
error desc: Column count doesn't match value count at row 1
|
what is wrong?
|
More Information