Fatal error when upgrading to 2.8.1 from 2.7.7 RESOLVED [message #159640] |
Sun, 14 June 2009 06:47 |
The Witcher
Messages: 675 Registered: May 2009 Location: USA
Karma:
|
Senior Member |
|
|
I have this beautiful brand new theme courtesy of naudefj AKA Frank but when I go to upgrade it crashes big time every time.
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'Db_admin_User'@'server.Host.org' (using password: YES) in
/home/.server/FTP_User/FUDforum/include/theme/default/db.inc on line 16
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in
/home/.server/FTP_User/FUDforum/include/theme/default/db.inc on line 16
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
/home/.server/FTP_User/FUDforum/include/theme/default/db.inc on line 16
Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /home/.server/FTP_User/FUDforum/include/core.inc on line 194
Now by my own admission I am a rank amateur compared to most of you here, but I am a long way from being dumb, I just have very little in the way of knowledge and experience with PHP, coding etc. and what knowledge I do have is hard fought and won (mostly by trial and error) by my own efforts and scouring the internet for information which is generally way over my head.
Of particular concern to me is the "supplied argument is not a valid MySQL-Link resource" portion of this error (I am no stranger to getting errors I do not comprehend) if I cannot sort it out in a reasonable period of time, my usual approach is the biggest hammer option of uninstalling, reinstalling and restoring the most recent backups which might actually contribute to my problem rather than solve it.
But that approach has to stop sometime, and there is no time like the present so if any one has some input I am all ears.
RESOLVED: The quick answer is below the spoiler.
Toggle Spoiler
This problem was resolved after replacing an incorrect character contained in the DBHOST_PASSWORD section of the Globals.php.
With some guidance from naudefj I found and accessed the globals.php through the "File Manager" section of the admin control panel > download. And opening it with PHP Editor and comparing the information there with that contained in the global settings.
The DBHOST_PASSWORD contained an extra character ( \ ) which made it different than the correct password. That should have been there.
Replacing that character and restoring the Globals.php resolved the issue.
Two lessons learned:
1. The admin should be able to access the admin panel from the browser command line using http://your_forum_url/adm/ to correct errors. The inability to do so is in itself an issue that must be resolved.
2. Gained valuable insight into the Globals PHP and most importantly how to edit it in the future.
How the extra character got there is unknown, but since that is a character my Host does not allow I must assume that I some how added it.
"I'm a Witcher, I solve human problems; not always using a sword!"
[Updated on: Mon, 22 June 2009 01:30] Report message to a moderator
|
|
|