vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Help with code please. (https://vborg.vbsupport.ru/showthread.php?t=62250)

David Coutts 03-07-2004 05:00 PM
Help with code please.
 
Quote:
INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL,1,'What usergroups can view the board while it\'s off','canviewclosed','6,5,7','What usergroups can view the board even if it\'s closed (seperate with a comma)','','3')
Is there anything wrong with that? Because when I try to go Query the DB, it says the following, basically that I have a Syntax Error, and seeing as I'm hopeless at whatever that is, I can't tell what's wrong with it.

Quote:
Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL,1,'What usergroups can view the board while it's off','canviewclosed','6,5,7','What usergroups can view the board even if it's closed (seperate with a comma)','','3')

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 's off','canviewclosed','6,5,7','What usergroups can view the bo

mysql error number: 1064

NTLDR 03-07-2004 09:31 PM
Quote:
Originally Posted by David Coutts
optioncode,displayorde r)
If the space atually exists between the e and the r it shouldn't.

Xenon 03-07-2004 09:49 PM
the space comes from the autowrapping long strings ;)

actually the error occurs becasue of the unescaped ' here:
Quote:
if it's closed

David Coutts 03-08-2004 01:31 AM
Thank you so much. I'll go take a peek, and see if that allows me to do it. I'll post again in a minute, with an update. Thanks again.

David Coutts 03-08-2004 01:35 AM
Woah, thanks so much. I had a problem, but I re-read your instructions, and it works now. Thanks so much, guys!

Xenon 03-09-2004 05:44 PM
glad we could help :)


All times are GMT. The time now is 07:31 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01010 seconds
  • Memory Usage 1,719KB
  • 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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