Error modifying user data

[Jwoodall]

I'm using 2.03 (can't seem to find a secure telnet client that's free).. and when I modify a user's data, I get the following (pretty sure it worked in the past):

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


Database error in vBulletin Control Panel: Invalid SQL: SELECT COUNT(*) AS users FROM user,usergroup WHERE user.usergroupid=usergroup.usergroupid AND usergroup.cancontrolpanel=1 AND user.userid<>
mysql error: You have an error in your SQL syntax near '' at line 1
mysql error number: 1064
Date: Sunday 29th of September 2002 02:22:19 PM
Script: /~rooster/lol/forums/admin/user.php
Referer: http://jupiter.phpwebhosting.com/~rooster/lol/forums/admin/user.php?action=edit&userid=46I really don't know what to do about this. I can still create and remove users, just can't seem to edit anything in their profile.

[eva2000]

if your host upgrade their PHP on your server you will need to upgrade your vB to 2.2.8 using upgrade instructions at http://vbulletin.com/members/upgrade.html

[eva2000]

putty is ssh client that's free http://www.chiark.greenend.org.uk/~sgtatham/putty/

[Jwoodall]

Originally posted by eva2000
if your host upgrade their PHP on your server you will need to upgrade your vB to 2.2.8 using upgrade instructions at http://vbulletin.com/members/upgrade.html How can you tell if I need them to upgrade their PHP version?

[Steve Machol]

What he meant was that if you host has already upgraded to PHP 4.2.x, then you will need to upgrade your vB. And from the error message you posted it would appear that this is what they've done.

[Jwoodall]

Ahh. Yes, they've upgraded to 4.2.2.

Now I can't get in to the Telnet/SSH -- denying my password. I know it's correct, but I'm not 100% sure I'm doing it right. :(

Gah, I work on so much hardware, I feel stupid not knowing jack about my own website/PHP/MySQL. :confused:

[eva2000]

Originally posted by Jwoodall
How can you tell if I need them to upgrade their PHP version? create a file named phpinfo.php and place this code in it and post the url/link to it from your web site

<?
phpinfo();
?>

i.e. yourdomain.com/phpinfo.php

check the build date on that page.. that will tell you when php was upgraded

[eva2000]

Originally posted by Jwoodall
Ahh. Yes, they've upgraded to 4.2.2.

Now I can't get in to the Telnet/SSH -- denying my password. I know it's correct, but I'm not 100% sure I'm doing it right. :(

Gah, I work on so much hardware, I feel stupid not knowing jack about my own website/PHP/MySQL. :confused: you sure it's SSH1 mode ?

[Jwoodall]

Well, I'm not sure what you mean, but I just tried normal telnet (vs SSH) and it refused the connection.

[Jwoodall]

http://www.legionoflions.com/phpinfo.php

[eva2000]

Originally posted by Jwoodall
Well, I'm not sure what you mean, but I just tried normal telnet (vs SSH) and it refused the connection. you should be able to select normal telnet, SSH1, SSH2...

[eva2000]

Originally posted by Jwoodall
http://www.legionoflions.com/phpinfo.php strange php was built on July 22, 2002 and you only noticed this error now ? i'd upgrade to vB 2.2.8 to fix your problem

[Jwoodall]

Right..

But, I can't back up the database without being able to connect via Telnet/SSH.

So I can't upgrade without backing up (wich really scares me) -- not to mention given my modifications of style stuff, I have NO idea what will happen to my forums.

Can I just backup my entire directory whole-hog and copy it back out if it blows up?

[eva2000]

Originally posted by Jwoodall
Right..

But, I can't back up the database without being able to connect via Telnet/SSH.

So I can't upgrade without backing up (wich really scares me) -- not to mention given my modifications of style stuff, I have NO idea what will happen to my forums.

Can I just backup my entire directory whole-hog and copy it back out if it blows up? backing up directory is no good as mysql resides in a mysql data partition which is not included in your site directory

why can't you get your host to help with the backup or to fix your ssh/telnet issue ?

[Jwoodall]

ooh! automated attendant just enabled my telnet ability.

Okay.. now I get to venture into the great unknown.

[eva2000]

Originally posted by Jwoodall
ooh! automated attendant just enabled my telnet ability.

Okay.. now I get to venture into the great unknown. good to hear - remember to read the guide at http://www.webmasterbase.com/article/678 on how to properly backup your database and restore it

[Jwoodall]

I'm looking at it, but honestly, I have no clue what I'm looking at. I don't know code at all (I'm a spoiled windows user)...

I've tried entering some of it.. and all I get back is:
[rooster@jupiter rooster]$ show databases
bash: show: command not found

[eva2000]

really you only need to type 2 commands in telnet/ssh preferably with forum closed

to backup/dump:

mysqldump --opt -u user -p dbname > /path/to/backup.sql

to reimport your backup.sql file

mysql -u user -p emptydbname < /path/to/backup.sql

where

user = the mysql username
dbname = name of forum database
emptydbname = newly created empty databasename
backup.sql = name of your backup/dump file

[Jwoodall]

Alrighty.

Well, if I blow it up, I gotta lot of work ahead of me.

It seems I backed it up successfully (24MB backup.sql file in the direcotry of my choosing).

[eva2000]

Originally posted by Jwoodall
Alrighty.

Well, if I blow it up, I gotta lot of work ahead of me.

It seems I backed it up successfully (24MB backup.sql file in the direcotry of my choosing). to test it you can create a new empty database and reimport that backup.sql into the new empty database and use phpmyadmin to view the tables and size and compare to original

[Jwoodall]

Well, that was SOOOO much easier than I thought. :D

Only had to figure out where to upload some of the stuff.

Thanks a million for your help (everyone). :D

[eva2000]

Originally posted by Jwoodall
Well, that was SOOOO much easier than I thought. :D

Only had to figure out where to upload some of the stuff.

Thanks a million for your help (everyone). :D easy ain't it :)