vb.org Archive - i need your help database error

Page 1 of 2

Show 40 post(s) from this thread on one page

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

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - i need your help database error (https://vborg.vbsupport.ru/showthread.php?t=160617)

aim4fun

10-20-2007 01:26 AM

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

MoT3rror

10-20-2007 02:35 AM

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.

aim4fun

10-20-2007 02:37 AM

and how can i change it
????
this is an error massage

MoT3rror

10-20-2007 02:43 AM

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.

aim4fun

10-20-2007 02:56 AM

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?

MoT3rror

10-20-2007 03:00 AM

Do you have any mods installed?
Did you edit the vBulletin code?

aim4fun

10-20-2007 03:07 AM

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

MoT3rror

10-20-2007 03:12 AM

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.

aim4fun

10-20-2007 03:22 AM

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

MoT3rror

10-20-2007 03:42 AM

Try downloading the files from vBulletin.com and reuploading all your vBulletin files. If that doesn't work post the bug here.

All times are GMT. The time now is 01:40 AM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02789 seconds Memory Usage 1,743KB 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 (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: