Urgent!!!

Database error in vBulletin 2.2.6:

Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'274','Re: what programs do you have/use/love?','','Otaku XT','1','1030498933','0','whatever,  :rolleyes:','1','1','24.102.188.168','0','1')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Tuesday 27th of August 2002 09:42:13 PM
Script: http://www.xtreme-forumz.net/~admin1/newreply.php
Referer: http://62.95.108.21/~admin1/showthread.php?threadid=274

What does that error mean??? please help!! :cry:

[g-force2k2]

open up newreply.php

find:

PHP Code:

'$title' 

replace with:

PHP Code:

'".addslashes($title)."' 

that should do the trick and then go back and resubmit... regards

g-force2k2

[Webmasta XT]

I can't find

PHP Code:

'$title' 

[g-force2k2]

do you have this code?

PHP Code:

'".addslashes(htmlspecialchars($title))."' 

because i can see that the query isn't parsing out the (')

just find this code:

PHP Code:

      $DB_site->query("INSERT INTO post (postid 

And give me that line thanks in advance...

g-force2k2

[Webmasta XT]

nvm, i solved the prob, thnx anywayz

[Webmasta XT]

lol, i figured it out, one sec b4 ur post, thank you for the help, lol

[g-force2k2]

yeah lol x_X just saw it in the other post sorry man... i knew it had to do with the addslashes just didn't know that Xenon had replace coding until i saw it in the other thread... i was wondering why the title didn't have the addslashes() function
regards...

g-force2k2

[Webmasta XT]

thnx, got another prob for u to solve, lol

Database error in vBulletin 2.2.6:

Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'274','Re: what programs do you have/use/love?','','Otaku XT','1','1030496414','0','lol, i use what i want, u use what u want.. :upside:','1','1','24.102.188.168','0','1')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Tuesday 27th of August 2002 09:00:14 PM
Script: http://www.xtreme-forumz.net/~admin1/newreply.php
Referer: http://62.95.108.21/~admin1/showthread.php?threadid=274

[g-force2k2]

Webmasta XT find and remove this code:

PHP Code:

'', 

see if that works regards...

g-force2k2

[Webmasta XT]

CAN U COME on AIM? plz.. my S/N is Otaku XT