Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 10-06-2002, 12:33 PM
groovesalad groovesalad is offline
 
Join Date: Aug 2002
Posts: 210
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default In Need of Help

I've installed some hacks on my board, but each of them seemed to install correctly. But now, when I try to go to Admin CP and go to Add New User Groups, when I fill out the information and click on Save, I get this error:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: INSERT INTO usergroup (usergroupid,title,usertitle,cancontrolpanel,canmo difyprofile,canviewmembers,canview,canviewvbindex, showgroup,cansearch,canemail,canpostnew,canmove,ca nopenclose,candeletethread,canreplyown,canreplyoth ers,canviewothers,caneditpost,candeletepost,canuse pm,canpostpoll,canvote,canpostattachment,ismoderat or,canpublicevent,canpublicedit,canthreadrate,cant rackpm,candenypmreceipts,maxbuddypm,maxforwardpm,c anwhosonline,canwhosonlineip,cangetattachment)
VALUES (NULL,'test','',0,1,1,,,1,1,0,0,0,0,0,0,0,1,0,0,1, 1,1,1,0,0,0,1,0,0,0,0,1,0,1)
mysql error: You have an error in your SQL syntax near ',1,1,0,0,0,0,0,0,0,1,0,0,1,1,1,1,0,0,0,1,0,0,0,0, 1,0,1)' at line 2

mysql error number: 1064

Date: Sunday 06th of October 2002 06:27:59 AM
Script: http://groove-salad.com/forum/forum/admin/usergroup.php
Referer: http://groove-salad.com/forum/admin/...php?action=add


Anyone know what I should do? Also, I have this error when my page loads:

Line:339
Char:40
Error: Unterminated String Constant
Code: 0
URL: http://www.groove-salad.com/forum/index.php?s=

Any help would be greatly appreciated.
Reply With Quote
  #2  
Old 10-06-2002, 01:30 PM
Chris M's Avatar
Chris M Chris M is offline
 
Join Date: Dec 2001
Location: Northampton, England
Posts: 6,186
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You will need to edit your usergroup.php file...

Check that all the lines in the "Add Usergroup" part are correct...

Any with extra ","s where there are not any on others could be the cause of the problem...

If you still cant figure it out, email me your usergroup.php file to:

chris.m@noxmedia.net

Regards,

Satan
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:53 PM.


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.01469 seconds
  • Memory Usage 2,165KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete