Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Sep 2002
Posts: 151
Member
Member
Offline
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:
Code
<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 />

http://www.hard.nu/aforum

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!

Sponsored Links
Joined: May 2003
Posts: 1,068
Junior Member
Junior Member
Offline
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
Offline
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
Offline
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
Yay! Go nikos!

Sponsored Links
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: Jan 2004
Posts: 40
User
User
Joined: Jan 2004
Posts: 40
I'm having this same problem and I just finished optimizing the tables. I could use some help.

http://www.highlifter.com/ubbthreads/ubbthreads.php

Thanks

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.


- Allen wavey
- What Drives You?
Joined: Nov 2004
Posts: 2
Lurker
Lurker
Offline
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.
Sponsored Links
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.


- Allen wavey
- What Drives You?

Link Copied to Clipboard
Donate Today!
Donate via PayPal

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.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Bill B
Bill B
Issaquah, WA
Posts: 87
Joined: December 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)