PDA

View Full Version : Template sql errors, not again.... :( Errror 1064, I read sticky...


TheEnd
07-17-2003, 08:43 AM
I did some template editing (just a little) and I get some errors some times, then I goto fix tables and it repairs them (BEST THING EVER!) How can I fix it though, cause it is kinda a pain to repair...


Database error in vBulletin 3.0.0 Beta 4:

Invalid SQL:
INSERT INTO post
(threadid, parentid, title, username, userid, dateline, pagetext,
allowsmilie,
showsignature, ipaddress, iconid, visible, attach)
VALUES
(15, , '',
'TheEnd', 2, 1058429378,
'test test test test', 1, 1,
'68.68.217.94', 0, 1, 0)

mysql error: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near ' '',
'TheEnd', 2, 1058429378,
'test test test test',

mysql error number: 1064

Date: Thursday 17th of July 2003 01:09:38 AM
Script: http://www.rec0n.com/cstrike/forums/newreply.php
Referer: http://www.rec0n.com/cstrike/forums/newreply.php
Username: TheEnd
IP Address: 68.68.217.94



I got some more emails too, Whats wrong with it?

Xenon
07-17-2003, 09:17 AM
there is no value set for parentid in the queryl.
but as you are using vb3, hacking is not supported here.
revert your files and templates and it should work again

TheEnd
07-17-2003, 11:31 AM
? make it default? :(

Xenon
07-17-2003, 11:53 AM
exactly

TheEnd
07-17-2003, 09:16 PM
I don't wanna go back to purple, is there a way I can figure out what did make the error, and not do that to the table? (like pinpoint it?)

TheEnd
07-18-2003, 12:21 AM
Ok, I read https://vborg.vbsupport.ru/showthread.php?s=&threadid=54118 and I didn't install any hacks. I added a button in the header and edited board color, boarder and table width. www.rec0n.com/cstrike/forums if you can take a quick look, lemmie know.

TheEnd
07-19-2003, 09:17 AM
<a href="https://vborg.vbsupport.ru/showthread.php?s=&threadid=54467" target="_blank">https://vborg.vbsupport.ru/showt...threadid=54467</a> Does anyone know if that will fix this problem forever? (its misc.php instead of newreplay.php)