Go Back   vb.org Archive > Community Central > Community Lounge

Reply
 
Thread Tools Display Modes
  #1  
Old 09-11-2002, 02:15 AM
dumpster
Guest
 
Posts: n/a
Default Help My Site Please ..

i8 this iz my site www.liquidflo.com , But i cant edit users nor bann people for some reason , This iz whut comes up when i try

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: SELECT userid
FROM user
WHERE username='Da yung 1 '
AND userid <>
mysql error: You have an error in your SQL syntax near '' at line 4

mysql error number: 1064

Date: Tuesday 10th of September 2002 11:13:58 PM
Script: http://www.liquidflo.com/rap/rap/admin/user.php
Referer: http://www.liquidflo.com/rap/admin/u...edit&userid=13

--------

and i dont understand , me and the other admins r tryin to fix it but it's not working .. Plz help , if this iz the wrong forum , i'm sorry i just didnt kno where to put it ... plz help PLEEAAASEE :cross-eyed:

Peace
Reply With Quote
  #2  
Old 09-11-2002, 02:23 AM
TECK's Avatar
TECK TECK is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 4,182
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

how come you have VB225 installed? is a new board right? from teh number of posts...
Reply With Quote
  #3  
Old 09-11-2002, 02:24 AM
filburt1 filburt1 is offline
 
Join Date: Feb 2002
Location: Maryland, US
Posts: 6,144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Maybe upgrading to the most recent, most secure, least hackable version (2.2.7) will fix your woes.

'Course you'd download it from the member's area...:devious:
Reply With Quote
  #4  
Old 09-11-2002, 04:52 PM
Steve Machol's Avatar
Steve Machol Steve Machol is offline
 
Join Date: Nov 2001
Posts: 1,896
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

dumpster, please go to this page and enter your username, to show you are licensed. (you will need to use your customer number and password to access that page)
Thank you.
Reply With Quote
  #5  
Old 09-12-2002, 12:50 AM
supersimon supersimon is offline
 
Join Date: Aug 2002
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

sorry hes from my site and i cant upgrade to 2.2.7 because we have so many hacks installed / and all my templates are gone because when i back uped teh board they were left out so when ui upgrade will it restore the templates ?
Reply With Quote
  #6  
Old 09-12-2002, 02:01 AM
Steve Machol's Avatar
Steve Machol Steve Machol is offline
 
Join Date: Nov 2001
Posts: 1,896
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You need to upgrade to fix the problem.
Reply With Quote
  #7  
Old 09-13-2002, 01:19 AM
supersimon supersimon is offline
 
Join Date: Aug 2002
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

will i lose my hacks
Reply With Quote
  #8  
Old 09-13-2002, 01:21 AM
Steve Machol's Avatar
Steve Machol Steve Machol is offline
 
Join Date: Nov 2001
Posts: 1,896
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Whenever you upgrade all hacks involving changes to the vB php files will be overwritten. You will need to reapply those hacks to the new files. Customized templates are not overwritten though.
Reply With Quote
  #9  
Old 09-14-2002, 02:09 PM
supersimon supersimon is offline
 
Join Date: Aug 2002
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

umm ok is there a way if i tottally re install my board i can restore only the post and members ?
and i'll be installing teh 2.2.7 from teh 2.2.5
Reply With Quote
  #10  
Old 09-14-2002, 06:37 PM
DeadMan384AD's Avatar
DeadMan384AD DeadMan384AD is offline
 
Join Date: Aug 2002
Location: Right Behind you
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by dumpster
i8 this iz my site www.liquidflo.com , But i cant edit users nor bann people for some reason , This iz whut comes up when i try

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: SELECT userid
FROM user
WHERE username='Da yung 1 '
AND userid <>
It looks the user has a space at the end of his username, unless you copied and pasted wrong, tell him to remove the space after the "1"

That might help if you havent upgraded yet
Reply With Quote
Reply

Thread Tools
Display Modes

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 07:40 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04436 seconds
  • Memory Usage 2,240KB
  • Queries Executed 11 (?)
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)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (9)postbit_onlinestatus
  • (10)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_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
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • postbit_imicons
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete