Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions

Reply
 
Thread Tools Display Modes
  #1  
Old 10-20-2007, 01:26 AM
aim4fun aim4fun is offline
 
Join Date: Aug 2007
Location: palestine
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default i need your help database error

my site gives me this database error
Code:
Database error in vBulletin 3.6.5:

Invalid SQL:

				SELECT * FROM user AS user
				LEFT JOIN usergroup AS usergroup ON (user.usergroupid = usergroup.usergroupid)
				WHERE user.username = 'Dr Mo'men';

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 'men'' at line 3
Error Number : 1064
Date         : Friday, October 19th 2007 @ 07:14:15 PM
Script       : http://aim4fun.com/vb/index.php
Referrer     : 
IP Address   : 41.235.132.127
Username     : dr-killer
Classname    : vb_database

any one can solve this problem ?

--------------- Added [DATE]1192850934[/DATE] at [TIME]1192850934[/TIME] ---------------

some one help
Reply With Quote
  #2  
Old 10-20-2007, 02:35 AM
MoT3rror MoT3rror is offline
 
Join Date: Mar 2007
Posts: 423
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
SELECT * FROM user AS user
LEFT JOIN usergroup AS usergroup ON (user.usergroupid = usergroup.usergroupid)
WHERE user.username = 'Dr Mo\'men';
That should make it work.
Reply With Quote
  #3  
Old 10-20-2007, 02:37 AM
aim4fun aim4fun is offline
 
Join Date: Aug 2007
Location: palestine
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

and how can i change it
????
this is an error massage
Reply With Quote
  #4  
Old 10-20-2007, 02:43 AM
MoT3rror MoT3rror is offline
 
Join Date: Mar 2007
Posts: 423
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

In your where statement you have this.
Quote:
WHERE user.username = 'Dr Mo'men';
The value Dr Mo'men was entered. The quote(') would stop the value at Dr Mo. You have to escape the quote(') with a slash(\) so it doesn't stop the query at the quote.
Reply With Quote
  #5  
Old 10-20-2007, 02:56 AM
aim4fun aim4fun is offline
 
Join Date: Aug 2007
Location: palestine
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i know but how may i change it
take look into my website
aim4fun.com/vb

i mean what should i do in order to fix this problem?
Reply With Quote
  #6  
Old 10-20-2007, 03:00 AM
MoT3rror MoT3rror is offline
 
Join Date: Mar 2007
Posts: 423
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Do you have any mods installed?
Did you edit the vBulletin code?
Reply With Quote
  #7  
Old 10-20-2007, 03:07 AM
aim4fun aim4fun is offline
 
Join Date: Aug 2007
Location: palestine
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Do you have any mods installed?
i don`t think so

Did you edit the vBulletin code?
not at all



--------------- Added [DATE]1192853300[/DATE] at [TIME]1192853300[/TIME] ---------------

i can`t even loginto my cpanel

--------------- Added [DATE]1192853519[/DATE] at [TIME]1192853519[/TIME] ---------------

there is an addon " name of members for the last 24 hr "
and the member mo`men is one of them

but i placed this addon long time ago and nothing happen
Reply With Quote
  #8  
Old 10-20-2007, 03:12 AM
MoT3rror MoT3rror is offline
 
Join Date: Mar 2007
Posts: 423
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sounds like a server problem if you can't sign into Cpanel. Also after you can sign in again, I reupload all of the files for vBulletin overwriting the ones on the server. Make sure you are uploading the files for your version of vBulletin that you are currently running.

Probably would be best to contact your hosting company.
Reply With Quote
  #9  
Old 10-20-2007, 03:22 AM
aim4fun aim4fun is offline
 
Join Date: Aug 2007
Location: palestine
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

nothing wrong with the server

using the query
Quote:
WHERE user.username = 'Dr Mo'men';
at the database gives you the error
but in case i use
Quote:
WHERE user.username = 'Dr Mo/'men';
this query is comletely right
but how may i force the script to use it
or how may i change it
i don`t know thats the problem
Reply With Quote
  #10  
Old 10-20-2007, 03:42 AM
MoT3rror MoT3rror is offline
 
Join Date: Mar 2007
Posts: 423
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Try downloading the files from vBulletin.com and reuploading all your vBulletin files. If that doesn't work post the bug here.
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 05: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.04016 seconds
  • Memory Usage 2,240KB
  • 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)bbcode_code
  • (4)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
  • (10)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_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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete