Need PHPBB help!

[SuperSix]

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

 

[ScottMac]

Remember that the privileges are for the "web page user" (like "nobody" or "www") not you as root or any other user.

You have to make sure that the user name representing the web page has the correct access rights.

You may also want to check the scope (like plain ol' username versus username@thewebservers.whatever)

Look in the users table of the mysql database for examples.

Good Luck

Scott

 

[SuperSix]

Originally posted by: ScottMac
Remember that the privileges are for the "web page user" (like "nobody" or "www") not you as root or any other user.

You have to make sure that the user name representing the web page has the correct access rights.

You may also want to check the scope (like plain ol' username versus username@thewebservers.whatever)

Look in the users table of the mysql database for examples.

Good Luck

Scott

Thanks

What baffles me, is that it started all of a sudden, no changes, or anything.


"You have to make sure that the user name representing the web page has the correct access rights. "

I am not quite following you on this. Can you explain further?

TIA,
Mark

 

[SuperSix]

Solved it.

I had a table that was HUGE, and made the overall DB size way over my 100MB limit. I emptied the table, and all is well. THanks for the response.