vb.org Archive - cant edit users profile in cp.

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

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

- - cant edit users profile in cp. (https://vborg.vbsupport.ru/showthread.php?t=41211)

Brad	07-17-2002 09:57 PM

cant edit users profile in cp.

i get this:

Database error in vBulletin Control Panel 2.2.6:

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

mysql error number: 1064

Date: Wednesday 17th of July 2002 06:52:55 PM
Script: http://www.kousetsu.net/newforum/admin/user.php
Referer: http://www.kousetsu.net/mewforum/adm...edit&userid=54

scsa20

07-17-2002 10:28 PM

Quote:

Quoted from another post I posted recently, should work with your problem cuz the guy I helped had that same problem

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 ;)

Steve Machol

07-17-2002 10:45 PM

Also make sure you are using the user.php file from 2.2.6. Reupload it and overwrite the one on the system.

Brad	07-19-2002 07:20 AM

re-uploaded a clean file from the 2.2.6 final zip, the problem is still their.

Chris M

07-24-2002 09:19 PM

I am getting this problem also...

Did you manage to fix it Anime-loo?

Satan

Brad	07-25-2002 04:40 AM

nope

Dean C

07-25-2002 01:31 PM

search for the code in the original php file and just replace that bit of code into your current user.php file... thats what i did :D

DrkFusion

07-25-2002 06:00 PM

Try running repair.php or something, if Mists suggestion didn't work.

Drk

All times are GMT. The time now is 10:28 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01037 seconds Memory Usage 1,727KB 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_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)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: