Need PHPBB help!

[SuperSix]

Had to post here - not much traffic over there.

Mods - please delete if you have to.

http://www.ihadav8.com/phpbb

Complete error:

"Website Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1044 Access denied for user: 'dbo94026672@%' to database 'db94026672'

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('7476c7f97682211a8b5751b086b33d4c', 2, 1198430585, 1198430585, '48bbe4c1', 0, 1, 0)

Line : 217
File : sessions.php"

This error just popped up. I checked the config.php files, all password info is correct. I can get into database thru PHPmyAdmin just fine. I thought the sessions table was full, I emptied it in PYPMyAdmin, no success. (This is recommended in such an error)

It's on a shared server with 1and1 (yea, I know, but it's been near flawless for 5 years, 3 of those were free), I'm not sure if they changed some configuration which is causing this error.

I will pay a bit to get this fixed.

The nessage board doesn't get huge traffic, but there's a dedicated fan base.

HELP!!

Thanks
Mark

 

[purbeast0]

your user for the db is 'dbo94026672@%', wich the @ and % at the end of it? was it always like that? isnt % used as an operator in sql?

 

[SuperSix]

Originally posted by: purbeast0
your user for the db is 'dbo94026672@%', wich the @ and % at the end of it? was it always like that? isnt % used as an operator in sql?

I'm assuming it was always like that. As I said - nothign was changed, and the config.php file is correct, and unchanged.

'dbo94026672@%' - Ids the "%" a variable indicating where the database is? web addy?

 

[Injury]

If it randomly happened, someone probably attempted to change the config file with a failed hack attempt.

Download the config file that tells the script what database to use and double check it.

This sort of thing is not uncommon with phpbb. If this isn't the issue though, and you didn't change anything, either your DB is corrupted or the host botched something.

 

[SuperSix]

Originally posted by: Injury
If it randomly happened, someone probably attempted to change the config file with a failed hack attempt.

Download the config file that tells the script what database to use and double check it.

This sort of thing is not uncommon with phpbb. If this isn't the issue though, and you didn't change anything, either your DB is corrupted or the host botched something.

I checked the config.php - all is correct. I am leaning towards host too. I opened a ticket with them, we will see how long it takes them to respond, given the holiday and all.

 

[purbeast0]

Originally posted by: SuperSix

Originally posted by: purbeast0
your user for the db is 'dbo94026672@%', wich the @ and % at the end of it? was it always like that? isnt % used as an operator in sql?

I'm assuming it was always like that. As I said - nothign was changed, and the config.php file is correct, and unchanged.

'dbo94026672@%' - Ids the "%" a variable indicating where the database is? web addy?

i would say just go to the sql db in your cpanel and verify the username on the db and change the password as well, then change it in the phpbb config to match the new one.

 

[Injury]

Originally posted by: SuperSix

Originally posted by: Injury
If it randomly happened, someone probably attempted to change the config file with a failed hack attempt.

Download the config file that tells the script what database to use and double check it.

This sort of thing is not uncommon with phpbb. If this isn't the issue though, and you didn't change anything, either your DB is corrupted or the host botched something.

I checked the config.php - all is correct. I am leaning towards host too. I opened a ticket with them, we will see how long it takes them to respond, given the holiday and all.

K, so if you didn't change anything and the config file is correct, the two previously mentioned items are all it could really be.

DB Corrupted: Try backing up the current one, then upload an OLD backup (You DO have one, right? ) and see if that works. If it's working, a portion of data is screwed. (I'm no SQL expert, but this shouldn't be a problem unless that portion of data is called up, right? So it's probably not just a normal post or anything, it's probably in the settings or headers somewhere.)

Host botched something: Could be anything from an upgrade in PHP or MySQL that caused some compatibility issues with the phpbb or maybe they swapped the drive from one box to a new one and didn't set something up properly... You can test the first part by (if you have the time) creating a second database and try a fresh install. If it installs and runs, then there is no issue with versions and such.

 

[SuperSix]

Originally posted by: purbeast0

Originally posted by: SuperSix

Originally posted by: purbeast0
your user for the db is 'dbo94026672@%', wich the @ and % at the end of it? was it always like that? isnt % used as an operator in sql?

I'm assuming it was always like that. As I said - nothign was changed, and the config.php file is correct, and unchanged.

'dbo94026672@%' - Ids the "%" a variable indicating where the database is? web addy?

i would say just go to the sql db in your cpanel and verify the username on the db and change the password as well, then change it in the phpbb config to match the new one.

Good idea. I did that - Now have tio wait for PW change to take effect on server. After changing - I now get:

"Website Critical Error
Could not connect to the database"

So I at least know I am changing the right file.

 

[SuperSix]

Ok = now I am getting the same error after verifying the info in config.php, and changing the password.

I think I found the problem!

My max MySQL database size is 100MB, and my database is currently 149MB. It was my IP table - it was up to ~125MB. I emptied that table - we'll see what happens, the DB is now 25.7MB, I think it may take awhile for the deletions to complete, at least it loks that way on my site admin site.

 

[Injury]

Originally posted by: SuperSix
Ok = now I am getting the same error after verifying the info in config.php, and changing the password.

I think I found the problem!

My max MySQL database size is 100MB, and my database is currently 149MB. It was my IP table - it was up to ~125MB. I emptied that table - we'll see what happens.

Hahahaah.

If that's it, that's kinda funny. 125MB of IPs? Geez.

 

[SuperSix]

Originally posted by: Injury

Originally posted by: SuperSix
Ok = now I am getting the same error after verifying the info in config.php, and changing the password.

I think I found the problem!

My max MySQL database size is 100MB, and my database is currently 149MB. It was my IP table - it was up to ~125MB. I emptied that table - we'll see what happens.

Hahahaah.

If that's it, that's kinda funny. 125MB of IPs? Geez.

Is there some way to auto-empty SQL tables if they get to a certain size?

Storage Space
Used Storage Space 149.86 MB
Maximum Storage Space 100 MB
Available Storage Space -49.86 MB

I'm suprised it didn't choke earlier. 49MB over quote.

PHPMyAdmin is now reporting 27~MB, but my control panel is still showing the -9.86MB number. I huess it may take awhile for the host to delete ~125MB table?

 

[keeleysam]

You could make a cron job to do it, but why store all of that data?

 

[SuperSix]

Originally posted by: keeleysam
You could make a cron job to do it, but why store all of that data?

Not sure - It's the BB default. I will see if there's an option to limit the file, once I can get back into the board admin panel.

Thanks

 

[911paramedic]

session_user_id = -1

How do you get a user ID of -1? LOL, never seen that before...

 

[911paramedic]

Just read some of the above posts, go into phpmyadmin and optimize your dbase, it should be a single button. It will remove all overhead.