vb.org Archive - Template sql errors, not again.... :( Errror 1064, I read sticky...

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - Template sql errors, not again.... :( Errror 1064, I read sticky... (https://vborg.vbsupport.ru/showthread.php?t=55354)

TheEnd

07-17-2003 08:43 AM

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

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...

Code:

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/showthrea...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)

All times are GMT. The time now is 12:05 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01016 seconds Memory Usage 1,730KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: