
05-02-2004, 02:07 PM
|
 |
|
|
Join Date: Mar 2002
Location: Germany
Posts: 614
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
Originally Posted by Liquid1ce
ok done that & i get this error
Code:
Invalid SQL: INSERT INTO thread(threadid, title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline,iconid, visible, attach, similar) VALUES (NULL,'TEST user','1083501486','42','1','0','RegSystem','23','RegSystem','1083501486','1','1','0')
mysql error: Column count doesn't match value count at row 1
mysql error number: 1136
Now This data is put onto a forum for admin views only I use
Code:
$forumid = 42;
$postusername = "RegSystem";
$bbuserinfo[userid] = "23";
$iconid = "1";
$visible = "1";
For The Bot/Poster
Anyone see what else is wrong?
|
The SQL error message tells you exactly where the problem lies. Your thread table has either more or less entries then your statement.
Please try:
PHP Code:
Select * from thread limit 1;
And compare what you see and what you want to put into.
Cheers,
|