vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)
-   -   can't change user profile in admin cp (https://vborg.vbsupport.ru/showthread.php?t=38395)

Sadie Frost 05-07-2002 10:47 PM

can't change user profile in admin cp
 
Having a bit of a weird problem. When I go to the admin cp and try to change a member's username, I get this error:

Quote:

Database error in vBulletin Control Panel 2.2.4:

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

mysql error number: 1064

Date: Wednesday 08th of May 2002 12:17:37 AM
Script: http://www.buffybytes.com/admin/user.php
Referer: http://www.buffybytes.com/admin/user...dit&userid=782
I checked the code in admin/user.php and the code around line 4 is the same as the unhacked file. I also tried uploading the user.php from my other board (that is working fine) and I still get that error. The other strange thing is that admins seem to be able to change their own names with no problem.

I do have a heavily hacked board, but I haven't touched any code or files lately. The only thing I can think of that it could have to do with is that my host just upgraded their php version and I had to get them to put register_globals back to on. But that was last week and I'm pretty sure it's been working since that happened.

Anyone have any suggestions? Thanks! :)

scsa20 05-07-2002 11:09 PM

it seems like a MySQL error...check to make sure the database is not coraupted (or however it's spelled)

but I could be wrong :confused:

Stylez 05-08-2002 12:30 AM

i have that same problem, except its when i change usergroups. its a brand new database and clean install of a 2.2.5 forum -_- its pissing me off alot.

Sadie Frost 05-11-2002 01:09 AM

I ran repair.php and still have the problem - any other suggestions? :)

FWC 05-11-2002 02:58 AM

You might get this error if your host upgraded to PHP 4.2.0 and you haven't downloaded the new user.php file from the Announcements forum at vbulletin.com. I had it happen.

Admin 05-11-2002 05:24 AM

FWC is correct, the new user.php corrects that problem.

Sadie Frost 05-14-2002 05:10 PM

Thanks! All better now :)


All times are GMT. The time now is 01:46 PM.

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.00923 seconds
  • Memory Usage 1,720KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)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