|
|
Joined: Sep 2002
Posts: 151
Member
|
|
Member
Joined: Sep 2002
Posts: 151 |
I have some serius my sql problems. A few minutes after optimizing tables from within Threads I lost contact with the database. At first I just got the "ERROR only visble to admin" message. Then, and thats is the currrent status, I just get this: <br />SQL ERROR: Unable to do_query: SELECT U_Username,U_Password,U_SessionId, U_StyleSheet, U_Status, U_Privates, U_FrontPage, U_Number, U_Banned, U_SideBar FROM w3t_Users WHERE U_Number = ''<br />No Database Selected<br /> My host can´t seem to find what´s wrong. Josh (thanks again for helping out, Josh!) had a look at it, and all he could find was: "Everything is OK with Threads - but there's something wrong with your MySQL server. It's not seeing or even being able to connect to the database." From the command line everything seems to work fine. No errors in any tables. I need help from someone who really knows how to work with a MySQL server on a linux machine. It has been like this for 24 hours now.  What really makes this a mess is that I am about to leave (tomorrow) for a looooong tour in Afrika, and I really need to get this done! Anyone? Please help! I am desperate! 
|
|
|
|
|
Joined: May 2003
Posts: 1,068
Junior Member
|
|
Junior Member
Joined: May 2003
Posts: 1,068 |
Just a couple of basic things, did you try to run a repair on the table(s) that you optimized? Also, have you tried restarting your MySql service on the server?
|
|
|
|
|
Joined: Sep 2002
Posts: 151
Member
|
|
Member
Joined: Sep 2002
Posts: 151 |
Yes on both questions. And I can nott find any errors.
I have reboted the entire server as well, without any luck.
|
|
|
|
|
Joined: Sep 2002
Posts: 151
Member
|
|
Member
Joined: Sep 2002
Posts: 151 |
Thanks to Nikos (niden.net), all is working again! I am so happy! 
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
|
|
|
|
|
Joined: Aug 2002
Posts: 1,191
Kahuna
|
|
Kahuna
Joined: Aug 2002
Posts: 1,191 |
Believe it or not it was caused by a corrupted config.inc.php file. Some quotation marks were missing and caused all this havoc! One more time that Zend Developer Studio paid off its money 
Nikos
|
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
Whoa, I read that site at least weekly, somebody help quick!
I can check for simple errors if you like, you can pm your current config file if you want.
|
|
|
|
|
Joined: Nov 2004
Posts: 2
Lurker
|
|
Lurker
Joined: Nov 2004
Posts: 2 |
Allen, I am the other Admin over there at HL. Other than file level access is there any way we can get that file? We were originally getting another error. I went in and "closed" the forums so that our users wouldnt see such an ugly error. Since doing that we cant get into the control panel. Can we reopen the forum through a SQL command? I would assume its just a flag in the DB, but I cant for the life of me find the right column or table.
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
I don't think it's a problem with your forum: >> Access denied for user: ' [email protected]' (Using password: YES) Your MySQL server isn't allowing you access. If the server, user and password it's using is incorrect, you can edit them in the config.inc.php file.
Last edited by JoshPet; 12/06/2004 12:55 AM.
|
|
|
|
|
Joined: Aug 2002
Posts: 1,191
Kahuna
|
|
Kahuna
Joined: Aug 2002
Posts: 1,191 |
and now it seems that the main.inc.php doesn't have the correct location of config.inc.php. This is easily recrifiable by verifying the path and uploading main.inc.php with the correct path for your installation.
Nikos
|
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
There was a line with a missing closing quotation mark.
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
badfrog
somewhere on the coast of Maine
Posts: 94
Joined: March 2007
|
|
|
Forums63
Topics37,575
Posts293,930
Members13,823
| |
Most Online6,139
Sep 21st, 2024
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
