|
- 帖子
- 773
- 积分
- 645
- 威望
- 0
- 金币
- 18 个
- 体力
- 726
|
Discuz! info: MySQL Query Error
Time: 2007-9-8 9:32am
Script: /insenz_install.php
SQL: DROP TABLE IF EXISTS [Table]campaigns;
CREATE TABLE [Table]campaigns (
id mediumint(8) unsigned NOT NULL,
`type` tinyint(1) unsigned NOT NULL,
fid smallint(6) unsigned NOT NULL,
tid mediumint(8) unsigned NOT NULL,
`status` tinyint(1) NOT NULL default '0',
begintime int(10) unsigned NOT NULL,
starttime int(10) unsigned NOT NULL,
endtime int(10) unsigned NOT NULL,
expiration int(10) unsigned NOT NULL,
nextrun int(10) unsigned NOT NULL,
PRIMARY KEY (id,`type`),
KEY tid (tid),
KEY nextrun (nextrun)
) TYPE=MyISAM;
DELETE FROM [Table]crons WHERE filename IN ('insenz_onlinestats.inc.php', 'insenz_pushthreads.inc.php') ;
INSERT INTO [Table]crons (available, type, name, filename, lastrun, nextrun, weekday, day, hour, minute) VALUES (1, 'system', 'Insenz 在线人数统计', 'insenz_onlinestats.inc.php', 1177854019, 1177855200, -1, -1, -1, '10');
INSERT INTO [Table]crons (available, type, name, filename, lastrun, nextrun, weekday, day, hour, minute) VALUES (1, 'system', 'Insenz 主题推送', 'insenz_pushthreads.inc.php', 1177854068, 1177864200, -1, -1, 0, '0');
Error: 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 ';
CREATE TABLE [Table]campaigns (
id mediumint(8) unsigned NOT NULL,
`type` tin' at line 1
Errno.: 1064
Similar error report has beed dispatched to administrator before. |
|
