PDA

View Full Version : Urgent!!!


Webmasta XT
08-27-2002, 01:05 AM
Database error in vBulletin 2.2.6:

Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,at tachmentid,pagetext,allowsmilie,showsignature,ipad dress,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
08-27-2002, 01:11 AM
open up newreply.php

find:

'$title'

replace with:

'".addslashes($title)."'

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

g-force2k2

Webmasta XT
08-27-2002, 03:06 AM
I can't find


'$title'

g-force2k2
08-27-2002, 03:34 AM
do you have this code?

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

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

just find this code:

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

And give me that line :) thanks in advance...

g-force2k2

Webmasta XT
08-27-2002, 03:40 AM
nvm, i solved the prob, thnx anywayz

Webmasta XT
08-27-2002, 03:41 AM
lol, i figured it out, one sec b4 ur post, thank you for the help, lol

g-force2k2
08-27-2002, 03:43 AM
yeah lol x_X just saw it in the other post :p sorry man... i knew it had to do with the addslashes :p just didn't know that Xenon had replace coding :p until i saw it in the other thread... i was wondering why the title didn't have the addslashes() function :p
regards...

g-force2k2

Webmasta XT
08-27-2002, 06:04 PM
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,at tachmentid,pagetext,allowsmilie,showsignature,ipad dress,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
08-27-2002, 06:23 PM
Webmasta XT find and remove this code:

'',

see if that works :) regards...

g-force2k2

Webmasta XT
08-27-2002, 06:28 PM
CAN U COME on AIM? plz.. my S/N is Otaku XT

Webmasta XT
08-27-2002, 06:30 PM
cannot find string
'',

Webmasta XT
08-27-2002, 06:38 PM
sry about the caps.. !_!

Webmasta XT
08-27-2002, 06:48 PM
g-force2k2, don't you have AIM? would be a lot easier m8

g-force2k2
08-27-2002, 06:54 PM
yeah i do Webmasta XT just post your AIM s/n i keep a low profile so i don't allow anyone to contact me unless they're on my buddy list... regards...

g-force2k2