Passwords not working

[Rushster]

We are having a terrible time with passwords, sometimes they work, sometimes they don't and it's causing all sorts of chaos.This started happening after an upgrade to Version 3.0.3. Any fixes for this?

[Steve Machol]

Can you please provide more info? What exactly is happening? Have you installed any hacks (including portals) or added any code to the footer, headinclude, header or phpinclude templates? Did you import from another BB system?

[Rushster]

Hi Steve

Nothing has changed, we just upgraded. Sometimes you can go to the boiard and you are logged out on your return( not keeping you logged in). Put the password in and it gives you the error page and a srtike. Other times it works fine. Basicly its driving users nuts. Tried in Firebird and IE, cleared all my cookies etc as well and still no joy.

Can you please provide more info? What exactly is happening? Have you installed any hacks (including portals) or added any code to the footer, headinclude, header or phpinclude templates? Did you import from another BB system?

[Steve Machol]

Have you installed any hacks (including portals) or added any code to the footer, headinclude, header or phpinclude templates?

[Rushster]

Hi Steve

Nothing has changed to make this happen, it was fine untilt the upgrade. we have acouple of things in the footer which were there before.

[Steve Machol]

Have you installed any hacks?

[Rushster]

Hope Steve, no hacks. However I just found a post concerning Apache 2 and adding a line to the config file which I am going to try.

[Rushster]

Nope that didn;t work. Still getting the password problem.

[Floris]

Could you perhaps tell us from which version you upgraded, and if you had any issues while upgrading?

[Rushster]

I can't remember which version we upgraded from for sure but I think it was 3.0 up to the latest version. There was no probs during upgrade.

[Steve Machol]

The first thing I recommend is that you reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

[Rushster]

Ok did as you suggested but it;s really messed things up Before doing this I hadn't noticed but the board had gone through it;s daily crashed tables routine and so before repairing anything I had upped the files as suggested. I now get...


Invalid SQL: INSERT INTO cpsession (userid, hash, dateline) VALUES (8, '017ebfaf48f3590da711e14d9667f470', 1104264441)
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'hash, dateline) VALUES (8, '017ebfaf48f3590da711e14d9667f470',
mysql error number: 1064
Date: Tuesday 28th of December 2004 08:07:23 PM
Script: http://www.blah.net/login.php
Referer: http://www.blah.net/admincp/index.php
Username: Blah
IP Address: xxxxxxxxxxxxxx

I will admit that Vbulletin has really been underperfomring for us and having to run the maintenance scripts to repair tables on a daily basis has become tiresome. This password issue is the latest problem though.

[Rushster]

It's Ok I resolved it. I will see if this has helped.

[Steve Machol]

I will admit that Vbulletin has really been underperfomring for us and having to run the maintenance scripts to repair tables on a daily basis has become tiresome. This password issue is the latest problem though.

Hmmm...this really shouldn't happen on an up-to-date and well-managed server. I have 3 forums on my server and I haven't had a single db problem in more than 2 years.

Is this a dedicated server? If so, you might want to get help optimizing your server, please see this thread:

http://www.vbulletin.com/forum/showthread.php?threadid=70117

Then post the requested info in a new thread in that forum.

[Rushster]

Stillthe same problems and the Db corrupted again after 3 hours of adding the files from the zip. I think we are just going to ditch the forums, they are on a dedicated server and have 95% of the SQL server to themselves.