Database problem

[tinbin]

When trying to change a user's status, i get this error:
-----
There seems to have been a slight problem with the Awesome Forums 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 2.2.5:

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

mysql error number: 1064

Date: Monday 24th of March 2003 04:43:14 PM
------

Can anyone tell me what to do to solve this problem or point me in the right direction ? :(

[tinbin]

Update:
I *think* the problem began when running this query in the database for the shoutbox:

CREATE TABLE `shoutbox` (
`shoutid` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`shout_text` text NOT NULL,
`timestamp` int(11) NOT NULL default '0',
PRIMARY KEY (`shoutid`)
) TYPE=MyISAM;

Since then my 'active users today' doesn't seem to be working either :(

Anyone able to help please?

[Lesane]

I think that this is a bug in 2.2.5 (<> empty), i recommend upgrading to a new version.

[Xenon]

Lesane is right, it's a bug with vb versions below 2.2.6 and php versions over 4.2.x

[tinbin]

Hmmm i never updated before...
Any tutorials for it or is it too easy?

[Xenon]

look at my sig, there is a lint to a tutorial :)

[tinbin]

another question: can i update directly from 2.2.5 to 2.2.9?

[Xenon]

yes, just follow the instructions in the tutorial for the files and then run the right upgrade srcipt (you can see which one to run after runnen any one of them ;))

[tinbin]

Ok, thank u for the help...
I'm upgrading now...
Fingers crossed :(

[tinbin]

I edited all the code with the program the way u described in your tutorial.
Do i need to install upgrade scripts too?
Just go to /admin/upgrade20.php for example and run it?
What if anything goes wrong with that? Can it be put back? or only by replacing db with an earlier one?

[Xenon]

run the latest upgradescript, you will see a list of upgradescripts then.

you can see which upgradescripts have to be run then ;)

[tinbin]

Didn't work :(((
I spend hours editing all the php files.
Uploaded them then & runned the upgrade scripts..

All i get now is:

Parse error: parse error in /home/awesome-/public_html/forum/admin/functions.php on line 505

Fatal error: Call to undefined function: iif() in /home/awesome-/public_html/forum/admin/functions.php on line 352

[Xenon]

you've made a mistake while editing functions.php

look into line 505 and around that.
you've made a mistake there

[tinbin]

I will try to fix it...
I put the backup i made somewhere else now and the forum runs there temporarly...

Would it be hard to delete the entire database at my original host, re-install the latest version of vB there and then import posts etc from the backupped database?

I fear the importing of the data, because i have no experience at all with it :(
But it would be the only solution i guess if i don't want to lose any memberinfo/posts etc..
Then i lose the hacks i installed of course, but that can be overcome.

But first i'm gonna have a look at functions.php, but i fear the worst :(

[Xenon]

don't do it this way!

if you can get it to work just upload the unchanged vb230 files and run the upgradescripts.

you'll loose the hacks then but the posts and everything will stay

[tinbin]

I owe u one m8!!
U really saved me a lot of trouble with this suggestion :D

The board is upgraded and working now.
The hacks are all gone, but there weren't too much anyway...

Couldn't have done this without help!
Really appreciated m8

[Xenon]

:)

you're welcome :)

[Erwin]

tinbin,

You are currently showing up as unlicensed. To be able to download hacks and/or receive support here at vBulletin.org, we ask you to please click here (http://www.vbulletin.com/members/forums.php) (vB-germany users click here (http://www.vbulletin-germany.com/members/forums.php)) and enter your email address, to show us that you are licensed.

You will need to use your customer number and password (which will be in the email you got when you paid for your license) to access that page. Please note that your email is case sensitive.

Thank you.

[tinbin]

Sorted :)

It's not tinbin here, i'm in name of tinbin.
Therefore i changed the emailaddress at this forum to be able to receive notification at new posts.
Didn't know it would get me in trouble :)

[Xenon]

thx :)

you can tell the owner to add your email address to the form, too, so you can change the one you use here :)

[tinbin]

Yup did that too :)