vb.org Archive - ~<< Help >>~

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

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - ~<< Help >>~ (https://vborg.vbsupport.ru/showthread.php?t=40747)

Dean C

07-06-2002 05:29 PM

~<< Help >>~

im getting this error when i try to save a change to a user in the admin cp ...

PHP Code:


		
			
Database error in vBulletin Control Panel 2.2.6:



Invalid SQL: SELECT userid

                    FROM user

                    WHERE username='Mist'

                        AND userid <> 

mysql error: You have an error in your SQL syntax near '' at line 4



mysql error number: 1064



Date: Saturday 06th of July 2002 02:27:17 PM

Script: [url]http://www.theironmic.com/board/board/admin/user.php[/url]

Referer:

I will attach my admin/user.php file below so someone can have a look at it :D

Hopefully someone can fix it ! :D

Thanks in Advance

Steve Machol

07-06-2002 05:33 PM

It is against the license agreement to post vB files. I suggest you reupload the original user.php file from the 2.2.6 zip file and see if that fixes the problem. Make sure you upload in ASCII and overwrite the existing file.

Dean C

07-06-2002 05:39 PM

im sorry... i didn't realise... ive installed lots of hacks ... so i dont kno which one has caused it... and i dont want to go installing all the hacks again...

what can i do?

if ure on AIM at the moment smachol i can send u the file over there if you would be willing to fix it....

AIM = XSMCOG

Steve Machol

07-06-2002 05:48 PM

Sorry I don't fix hacked files. IMO it's never a good idea to install a lot of hacks without first making sure that each hack works and doesn't cause problem before moving on to the next one. Good luck!

Dean C

07-06-2002 05:51 PM

i did do that... but what i normally do iwhen i edit a file is go to an instance of that file and see if the page loads... and it did up to now... the page loads fine... but im getting that error when i try to change a user ...

scsa20

07-06-2002 06:35 PM

here, try this, do a search for "SELECT userid" tell you come to the second "SELECT userid" (it should get to the one that drops down)

replace SELECT userid down to AND userid <> with:

PHP Code:


		
			
SELECT userid

                    FROM user

                    WHERE username='".addslashes(htmlspecialchars($ausername))."'

                        AND userid <> $userid")) {

plus, before replaceing, you should check to make sure the code is the same of above and if not, then replace it with that. hope this works ;)

Dean C

07-06-2002 06:45 PM

THANKYOU !!! :D

it fixed it

scsa20

07-06-2002 07:44 PM

your welcome ;)

Dean C

07-15-2002 11:26 AM

UPDATE:

im getting this errror again whenever i try to edit a profile thru the admin cp:

PHP Code:


		
			
Database error in vBulletin Control Panel 2.2.6:



Invalid SQL: SELECT userid

            FROM user

            WHERE username='Ill Knowledge'

            AND userid <> 

mysql error: You have an error in your SQL syntax near '' at line 4



mysql error number: 1064



Date: Monday 15th of July 2002 08:28:43 AM

Script: [url]http://www.theironmic.com/board/board/admin/user.php[/url]

Referer:

Dean C

07-16-2002 05:01 PM

sorry to bump but i need to fix the problem :D

Thanks

Dean C

07-17-2002 02:40 PM

neva mind i fixed it :D

All times are GMT. The time now is 06:55 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01175 seconds Memory Usage 1,738KB 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 (3)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (11)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
Messages: