 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: 3
|
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 |
|
|
|
|
|
| Re: Fatal error when upgrading to 2.8.1 from 2.7.7 [message #159643 is a reply to message #159641] |
Sun, 14 June 2009 07:08  |
The Witcher
Messages: 675
Registered: May 2009
Location: USA
Karma: 3
|
Senior Member |
|
|
| naudefj wrote on Sun, 14 June 2009 01:55 | This nasty error means that FUDforum couldn't connect to its database. Check if the DB is running. Log in to the ACP and check your database settings (Global Settings Manager), check the Error Log Viewer for errors and try to rebuild the theme.
|
This nasty error means that FUDforum couldn't connect to its database. Check that is what I surmised.
Log in to the ACP and check your database settings (Global Settings Manager) check all as they should be, just as they had been installed 20 minutes prior when I restored my last available backup I did some house keeping and went to upgrade
I can go from 2.7.7 directly to 2.8.1 right?.
check the Error Log Viewer for errors and try to rebuild the theme. check I had already checked the error log and cleared it, there were errors (I will copy them next time, i will even crash it again if I have to) I will check again on all of the above.
This is all part of what I was trying to explain to you in our E-mails, and it is beyond my pay grade sorta.
"I'm a Witcher, I solve human problems; not always using a sword!"
|
|
|
|
| Re: Fatal error when upgrading to 2.8.1 from 2.7.7 [message #159666 is a reply to message #159643] |
Sun, 14 June 2009 21:57 |
The Witcher
Messages: 675
Registered: May 2009
Location: USA
Karma: 3
|
Senior Member |
|
|
Ok Frank
I got some sleep and I am well rested so let us tackle this varmint.
As I said I backed up the forum and downloaded it, and I am now ready to repeat the process.
Upgrade failed again same error.
Your instructions from last night Check if the DB is running. Log in to the ACP and check your database settings (Global Settings Manager), check the Error Log Viewer for errors and try to rebuild the theme.
It sounds like you expect me to do this before I reinstall the software and restore the backup, and that would be great if I could do that, unfortunately all I get is the error msg. so let's clarify that 1st.
Is it possible to access the admin panel separately?
No it is not as far as I know, but according to the searches I have done it should be via http://your_forum_url/adm/ I used http://piasa.info/adm/ specifically with a variety of adm.php files and received the exact same error as before, I have never been able to log in directly to the admin control panel except on those few occasions when I was kicked out and asked to log in again (usually after changing setting regarding avatars) or when I have closed the forum for maintenance even though I have tried.
Toggle Spoiler
My military mind tells me that this is something I should be able to do, the documentation tells me it can be done; I have just not been able to do it in the past so I quit trying.
So I will attack from a different direction, both the witcher.us and witchsbytchin.com are brand spanking new installs with no backups restored to them, so I attempted to log in to the admin panels on them using the same information as I did for Piasa, INSTANT SUCCESS, on both!
This is the 1st time to my recollection I have been able to access the admin control with out going through the front door so this is really great from my point of view.
That tells me that this problem has and is passed along in the restored backups I have been using, since WitchsBytchin had the same error when I I originally went to upgrade, which is why I dumped the back up and settled for a new install to begin with.
If that is correct it means the problem has existed since Oct 2008 on WitchsBytchin and since perhaps mid to late 2007 on piasa.
This may be my own fault as the result of my experimenting with functions or some other issue.
But I am determined that it will stop here!
Be advised regarding our group zero discussion yesterday, that WitchsBytchin has the Group zero displayed, new account registration is turned on and it goes away when turned off, this is a new install of 2.8.1.
But that is a gremlin I can squash later.
For now I will reinstall Piasa from scratch, and restore the backup, so we can continue.
"I'm a Witcher, I solve human problems; not always using a sword!"
|
|
|
|
| Re: Fatal error when upgrading to 2.8.1 from 2.7.7 [message #159667 is a reply to message #159641] |
Mon, 15 June 2009 04:48 |
The Witcher
Messages: 675
Registered: May 2009
Location: USA
Karma: 3
|
Senior Member |
|
|
OK I have it reinstalled, and restored, there are some items that were not restored, header images for example, but if I understand it they may need to be stored elsewhere.
And there were several items in the global configuration that I had to manually reset to different values, but all that is normal more or less, I just don't think it should be.
Most of all yes I can access the database and the admin panel Yippee.
To be honest I can't recall ever attempting to connect to the admin panel when I did not have an error to deal with.
There were around 48 error messages along the lines of:
[Error] Invalid Input
[Error] Invalid Message
[Message Sent to User] The message you are trying to view does not exist.
[Error] Disabled feature
[Message Sent to User] This feature has been disabled by the system administrator
Most of them from this IP which is reported as belonging to google, and another one that comes back as a ripe query (what ever that is) I can e-mail them to you but I think they are bots and spiders?
66.249.71.245
The meat you wanted should be these 2 errors
SQL Error Log [clear log]
Toggle Spoiler
Sun Jun 14 23:02:00 GMT 2009(/home/.conch/DB_User/Domain.com/index.php:75
/home/.conch/DB_User/Domain.com/index.php:314
/home/.conch/DB_User/Domain.com/theme/default/actions.php:102
/home/.conch/DB_User/Domain.com/index.php:1198
) 1064: 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 '' at line 1
Query: UPDATE fud26_ses SET sys_id='d58fc9c3bc4e6f4a8428223da3742bb6e3d8', forum_id=0, time_sec=1243200520, action='Snooping on other people, just like you', returnto='t=actions&rand=1971652754&S=c0836152e26b3b4d2827fe4022137 0cg' WHERE id=
_GET: array ( 't' => 'actions', 'rand' => '1971724754', 'S' => 'c0836133866b3bc2d827fe20221370bf', )
Server Version: 5.0.67-log
I have no idea what this one is, other than it seems to be referring to I spy!
Sun Jun 14 23:04:42 GMT 2009
(/home/.conch/DB_User/Domain.com/index.php:75
/home/.conch/DB_User/Domain.com/index.php:135
/home/.conch/DB_User/Domain.com/theme/default/tree.php:539
/home/.conch/DB_User/Domain.com/theme/default/tree.php:946
/home/.conch/DB_User/Domain.com/index.php:1198
) 1146: Table 'DATABASE_DB_User.fud26_tv_6' doesn't exist
Query: SELECT seq FROM fud26_tv_6 WHERE thread_id=19
_GET: array ( 'S' => '6a33af7ff769abb7fc1d678358ea3bea', 't' => 'tree', 'th' => '19', 'start' => '', )
Server Version: 5.0.67-log
I can't make head not tails out of that other than it is referring to fud26_tv6 as not existing and it is there, I looked at it, it refers to message 19 which seems not to be there which is what the message was about (the user had posted a topic but it went poof)
I obfuscated the codes, so if you need the actual numbers let me know and I will e-mail them. The 2nd one i would just delete, I'm not sure on the 1 st!
"I'm a Witcher, I solve human problems; not always using a sword!"
|
|
|
|
|
|
|
|
|
|
| Re: Fatal error when upgrading to 2.8.1 from 2.7.7 [message #159673 is a reply to message #159672] |
Mon, 15 June 2009 18:36 |
The Witcher
Messages: 675
Registered: May 2009
Location: USA
Karma: 3
|
Senior Member |
|
|
| naudefj wrote on Mon, 15 June 2009 12:28 | We need to look at the first error - line 16 - a simple mysql_connect() statement. Somehow MySQL denied your user access to the database, indicating that this is no FUDforum problem.
Check if the following settings in GLOBALS.php are correct: DBHOST, DBHOST_USER and DBHOST_PASSWORD. Also try to connect from command line with the provided values to verify that they are correct.
|
Ok I understand, it being a database problem with my being denied access, not specifically related to FUDforum (other than FUDforum must have access to the database to work properly). In this case we are doing an upgrade so it is ensuring that it has access to all the data stored in the database, and for some reason, thinks it does not have full access.
The rest of it I am a bit fuzzy on, "Globals.php" is one of the things I don't have much understanding of other than it is a simulated link of the non browsable files, is that correct?
DBHOST, DBHOST_USER and DBHOST_PASSWORD are respectively the forums equivalent of MYsql, Database user, and their password, correct?
What I don't understand is command line! I have asked before is that in reference to my browser window or is this located somewhere else. I normally access the database through my hosts Mysql, and the FUDforum Installation files through filezilla or my hosts web panel.
I am obviously looking for something that is different from the above.
I currently use exactly the same information as found in my admin control panel,
I'm on it! To see what I can find!
"I'm a Witcher, I solve human problems; not always using a sword!"
|
|
|
|
| Re: Fatal error when upgrading to 2.8.1 from 2.7.7 [message #159674 is a reply to message #159672] |
Mon, 15 June 2009 19:01 |
The Witcher
Messages: 675
Registered: May 2009
Location: USA
Karma: 3
|
Senior Member |
|
|
Negative on accessing globals via hosts ftp
Negative on even seeing globals in file zilla.
Downloaded Globals.php from control panel file manager into php editor OK!
DBHOST correct!
DBHOST_USER correct!
DBHOST_PASSWORD. Does not match ! it has 1 extra character in it than what it should have!
"I'm a Witcher, I solve human problems; not always using a sword!"
|
|
|
|
| Re: Fatal error when upgrading to 2.8.1 from 2.7.7 [message #159675 is a reply to message #159674] |
Mon, 15 June 2009 20:52 |
The Witcher
Messages: 675
Registered: May 2009
Location: USA
Karma: 3
|
Senior Member |
|
|
Changed password, it was refused! System does not accept the character!
Changed password on the host DB user account! Refused!
Tried to reinstall software, installation refused!
ERROR on step 2: Could not open the database you've specified, SQL Reason: Access denied for user 'host_db_user'@'206.87.148.0/255.255.183.0' to database 'zYx456g-*#Ctb$wN'
Currently cannot go forward with this, I have advised my host, in the meantime I will attempt another installation.
"I'm a Witcher, I solve human problems; not always using a sword!"
|
|
|
|
 Re: Fatal error when upgrading to 2.8.1 from 2.7.7 [message #159676 is a reply to message #159675] |
Mon, 15 June 2009 22:08 |
The Witcher
Messages: 675
Registered: May 2009
Location: USA
Karma: 3
|
Senior Member |
|
|
Success! Piasa now upgraded to 2.8.1 though it resides on a different domain temporarily.
I have saved backup to hard drive and will keep this installation to work on, and put Piasa back on its home domain as soon as I regain access to mysql.
naudefj You do your self proud, thanks for the assistance, and your patience, I am grateful.
"I'm a Witcher, I solve human problems; not always using a sword!"
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]