Using phpMyAdmin to upload the post table I get this message when it's done with out showing the text that was upladed.
'Your SQL-query has been executed successfull.'
But it doesn't even list the 'post' table on the index.
When going to the board page I get an error and a E-mail with this message.
Database error in vBulletin: Invalid SQL: SELECT COUNT(*) AS posts FROM post
mysql error: Table 'vgchatc_vgchat.post' doesn't exist
mysql error number: 1146
is there something wrong in the file? This is what it looks like.
DROP TABLE IF EXISTS post;
CREATE TABLE post (
postid int(10) unsigned NOT NULL auto_increment,
threadid int(10) unsigned DEFAULT '0' NOT NULL,
username varchar(50) DEFAULT '' NOT NULL,
userid int(10) unsigned DEFAULT '0' NOT NULL,
title varchar(100) DEFAULT '' NOT NULL,
dateline int(10) unsigned DEFAULT '0' NOT NULL,
attachmentid smallint(5) unsigned DEFAULT '0' NOT NULL,
pagetext mediumtext,
allowsmilie smallint(6) DEFAULT '0' NOT NULL,
showsignature smallint(6) DEFAULT '0' NOT NULL,
ipaddress varchar(16) DEFAULT '' NOT NULL,
iconid smallint(5) unsigned DEFAULT '0' NOT NULL,
visible smallint(6) DEFAULT '0' NOT NULL,
edituserid int(10) unsigned DEFAULT '0' NOT NULL,
editdate int(10) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (postid),
KEY iconid (iconid),
KEY userid (userid),
KEY threadid (threadid,userid)
);
INSERT INTO post VALUES
(47,21,'Chrono',11,'',987624085,0,'Can I moderate the Super Smash Bros Message
board?',1,1,'208.247.249.121',0,1,0,0);
INSERT INTO post VALUES
(3,3,'NM/De',2,'',987584411,0,'Excellent.
',1,0,'142.165.70.20',0,1,0,0);
INSERT INTO post VALUES (4,4,'Ferry',5,'',987589027,1,'test
test test...',1,1,'212.127.181.234',4,1,0,0);
*SNIPED*
Plus 4.2 megs of more posts.
'Your SQL-query has been executed successfull.'
But it doesn't even list the 'post' table on the index.
When going to the board page I get an error and a E-mail with this message.
Database error in vBulletin: Invalid SQL: SELECT COUNT(*) AS posts FROM post
mysql error: Table 'vgchatc_vgchat.post' doesn't exist
mysql error number: 1146
is there something wrong in the file? This is what it looks like.
DROP TABLE IF EXISTS post;
CREATE TABLE post (
postid int(10) unsigned NOT NULL auto_increment,
threadid int(10) unsigned DEFAULT '0' NOT NULL,
username varchar(50) DEFAULT '' NOT NULL,
userid int(10) unsigned DEFAULT '0' NOT NULL,
title varchar(100) DEFAULT '' NOT NULL,
dateline int(10) unsigned DEFAULT '0' NOT NULL,
attachmentid smallint(5) unsigned DEFAULT '0' NOT NULL,
pagetext mediumtext,
allowsmilie smallint(6) DEFAULT '0' NOT NULL,
showsignature smallint(6) DEFAULT '0' NOT NULL,
ipaddress varchar(16) DEFAULT '' NOT NULL,
iconid smallint(5) unsigned DEFAULT '0' NOT NULL,
visible smallint(6) DEFAULT '0' NOT NULL,
edituserid int(10) unsigned DEFAULT '0' NOT NULL,
editdate int(10) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (postid),
KEY iconid (iconid),
KEY userid (userid),
KEY threadid (threadid,userid)
);
INSERT INTO post VALUES
(47,21,'Chrono',11,'',987624085,0,'Can I moderate the Super Smash Bros Message
board?',1,1,'208.247.249.121',0,1,0,0);
INSERT INTO post VALUES
(3,3,'NM/De',2,'',987584411,0,'Excellent.
',1,0,'142.165.70.20',0,1,0,0);
INSERT INTO post VALUES (4,4,'Ferry',5,'',987589027,1,'test
test test...',1,1,'212.127.181.234',4,1,0,0);
*SNIPED*
Plus 4.2 megs of more posts.
Comment