MySQL Error when I go to post

[Preech]

Database error in vBulletin 3.0.0 Release Candidate 2:

Invalid SQL:
INSERT INTO post
(threadid, parentid, title, username, userid, dateline, pagetext, allowsmilie,
showsignature, ipaddress, iconid, visible, attach)
VALUES
(24358, 0, 'test',
'Stoic Contrast', 29, 1076661833,
'test', 1, 1,
'24.205.226.213', 0, 1, 0

mysql error: You have an error in your SQL syntax near '' at line 10

mysql error number: 1064

Date: Friday 13th of February 2004 03:43:53 AM
Script: http://www.originalaspect.com/forum/newthread.php
Referer: http://www.originalaspect.com/forum/newthread.php?do=newthread&f=303
Username: Stoic Contrast
IP Address: 24.205.226.213


I get this error when I go to post...any ideas?

[Andreas]

Do you have any hacks installed?
Seems like the closing bracket is missing.

[Preech]

what php file would that possibly be in?

[assassingod]

Looks like newthread.php. Might also be functions_newpost.php

Have you installed any hacks recently that alter any of those files?

[Andreas]

Most likely functions_newpost.php in function build_new_post().

[Preech]

thanks, but i just tried substituting those files in and out with the defaults and it didnt make a difference...

any other ideas would be appreciated

[Andreas]

You replace them with the originals and you still get this error?

Hmm ... did you modify any other files like functions.php, functions_bbcodeparse.php, init.php, sessions.php, global.php, db_mysql.php, functions_databuild.php or functions_misc.php?

[Preech]

No...none of the files where modified. I've re-upload the original untouched files. And cleared all templates. Error still exist.

[Andreas]

Hmm ... now this is getting a bit strenge. These should have been all files that could be involved in posting, and I somehow doubt that it is a template-problem.

Can you manually insert a record into table post (using phpMyAdmin)?

[Boofo]

How about trying to repair the table in the Admin CP? It couldn't hurt. If anything is slightly wrong with it, that should take care of it. Just a guess here. ;)

[g-force2k2]

Make sure that in functions_newpost.php that this exists:

$DB_site->query("
INSERT INTO " . TABLE_PREFIX . "post
(threadid, parentid, title, username, userid, dateline, pagetext, allowsmilie,
showsignature, ipaddress, iconid, visible, attach)
VALUES
($threadinfo[threadid], $parentid, '" . addslashes($post['title']) . "',
'" . addslashes($post['postusername']) . "', $bbuserinfo[userid], " . TIMENOW . ",
'" . addslashes($post['message']) . "', $post[enablesmilies], $post[signature],
'" . addslashes($post['ipaddress']) . "', $post[iconid], $post[visible], $totalattachments)
");

For insurance you could always upload a new one in the includes folder.

Cheers,
g-force2k2