PHP Forum Software GOing Haywire?

Web hosting discussion, programming, and shared and dedicated servers.
2 posts Page 1 of 1
by Steve Cross » Tue Jul 19, 2011 11:50 am
Recently while performing a basic forum software upgrade through PHPbb3 on my website hosted through Sonic.net I encountered a problem. Not sure exactly what the problem is, and I am unsure how to address it.
Here is the link to what would normally be the forum index page:
http://sonomacountyairsoft.com/forum/phpBB3/

"SQL ERROR [ mysql4 ]

Access denied for user 'carwedla_sca-all'@'c.custweb.sonic.net' (using password: YES) [1045]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
"

Can anyone give me some guidance as to how I can address this problem and get my forum back up and running as it was before?
by kgc » Tue Jul 19, 2011 12:04 pm
Just a guess that the software now requires mysql5? If that is the case, it's relatively easy to fix. Use the membertools to create a new mysql5 database and then dump and restore from the old database to it and update the forum's configuration.

It is probably easiest to do this from a shell:

$ mysqldump -h old.server -u old.admin-user -p old.db > backup.sql
$ mysql -h new.server -u new.admin-user -p new.db < backup.sql

Once you are finished and back up and running then use the membertools to drop the old database.
Kelsey Cummings
System Architect, Sonic.net, Inc.
2 posts Page 1 of 1

Who is online

In total there are 83 users online :: 0 registered, 0 hidden and 83 guests (based on users active over the past 5 minutes)
Most users ever online was 999 on Mon May 10, 2021 1:02 am

Users browsing this forum: No registered users and 83 guests