![]() |
database problem since uploading hacks...
hey all,
in the last few days i have put up the birthday bit, users online today hacks. now, when i do something with the admin panel and try to help users change their e mail or password i get this error: Invalid SQL: SELECT userid FROM user WHERE username='amitybeth' AND userid <> mysql error: You have an error in your SQL syntax near '' at line 4 mysql error number: 1064 Date: Wednesday 26th of June 2002 10:58:30 PM Script: http://www.amitymama.com/vb/vb/admin/user.php Referer: http://www.amitymama.com/vb/admin/us...=edit&userid=1 any ideas? i am just not sure what this is... both hacks are up and running fine, but i am not sure if i changed something? thanks for your help in advance!! am |
See if you have this:
PHP Code:
PHP Code:
|
and contact your host if they upgraded to new PHP version. If yes, you need to upgrade your board to 2.2.6 (or apply the fix). More info at vb.com's announcement board..
|
i have about 6 or 7 of them running right now, and i can't imagine having to do them all over again. i haven't upgraded since 2.2.4 out of sheer fear. :rolleyes: i have 2100+ registered and at least 550 of those visit daily. i would hate to screw the boards up.
any tips or thoughts for me? thanks guys! amity |
as logician said, seems to be the php42x bug.
you'll have to go to vbulletin.com and download the bugfix or upgrade to vb226 |
Quote:
Here is a general tip: Always have a (or a few) mirror of your site in your local computer. Nakkid has a instruction regarding the issue in Hints board. Install PHP, MYSQL and Apache to your computer and copy all directory tree of your site to your computer together with MYSQL database. Now you can test everything there and make sure it will be ok. This applies to installing new hacks, trying code changes, upgrading, reapplying hacks, anything you can think of. If you dont encounter any problems, you can do it in your real board.. By the way you may like to give a shot for the fix, but it may not work (it didnt work here). |
hey guys,
i tried the script change, that didn't work. i also applied the bug fix, and that didn't work either. any thoughts on what this is? i am considering uploading a new user.php file. what do you think? thanks!! amity |
Quote:
I STRONGLY suggest upgrading your board and reapply your hacks. They are only 7, how much time can it take? |
All times are GMT. The time now is 11:02 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 | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|