Previous Thread
Next Thread
Print Thread
Rate Thread
Urgent help needed - MySQL error #278360
08/21/2004 12:02 PM
08/21/2004 12:02 PM
Joined: Sep 2002
Posts: 157
G
Gregori Offline OP
Member
Gregori  Offline OP
Member
G

Joined: Sep 2002
Posts: 157
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
Re: Urgent help needed - MySQL error [Re: tubedogg_dup1] #278361
08/21/2004 12:37 PM
08/21/2004 12:37 PM
Joined: May 2003
Posts: 1,109
E
ericgtr Offline
Junior Member
ericgtr  Offline
Junior Member
E

Joined: May 2003
Posts: 1,109
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?

Re: Urgent help needed - MySQL error [Re: BlarC] #278362
08/21/2004 1:29 PM
08/21/2004 1:29 PM
Joined: Sep 2002
Posts: 157
G
Gregori Offline OP
Member
Gregori  Offline OP
Member
G

Joined: Sep 2002
Posts: 157
Yes on both questions. And I can nott find any errors.

I have reboted the entire server as well, without any luck.

Re: Urgent help needed - MySQL error [Re: tubedogg_dup1] #278363
08/21/2004 4:27 PM
08/21/2004 4:27 PM
Joined: Sep 2002
Posts: 157
G
Gregori Offline OP
Member
Gregori  Offline OP
Member
G

Joined: Sep 2002
Posts: 157
Thanks to Nikos (niden.net), all is working again!

I am so happy!

Re: Urgent help needed - MySQL error [Re: tubedogg_dup1] #278364
08/22/2004 7:10 PM
08/22/2004 7:10 PM
Joined: Nov 2001
Posts: 11,330
Charlotte, NC
JoshPet Offline
I type Like navaho
JoshPet  Offline
I type Like navaho

Joined: Nov 2001
Posts: 11,330
Charlotte, NC
Yay! Go nikos!

Sponsored Links
Re: Urgent help needed - MySQL error [Re: Daine] #278365
11/08/2004 6:40 AM
11/08/2004 6:40 AM
Joined: Aug 2002
Posts: 1,271
Vienna, Austria
dimopoulos Offline
Kahuna
dimopoulos  Offline
Kahuna

Joined: Aug 2002
Posts: 1,271
Vienna, Austria
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
Re: Urgent help needed - MySQL error [Re: Hal_dup2] #278366
12/05/2004 10:51 AM
12/05/2004 10:51 AM
Joined: Jan 2004
Posts: 41
Covington, LA
RANCH4x4_dup1 Offline
User
RANCH4x4_dup1  Offline
User

Joined: Jan 2004
Posts: 41
Covington, LA
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

Re: Urgent help needed - MySQL error [Re: harsh] #278367
12/05/2004 1:51 PM
12/05/2004 1:51 PM
Joined: Mar 2000
Posts: 25,587
Texas
AllenAyres Offline
I type Like navaho
AllenAyres  Offline
I type Like navaho

Joined: Mar 2000
Posts: 25,587
Texas
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?
Re: Urgent help needed - MySQL error [Re: SurfMinister] #278368
12/05/2004 9:40 PM
12/05/2004 9:40 PM
Joined: Nov 2004
Posts: 2
T
TEXMudder Offline
Lurker
TEXMudder  Offline
Lurker
T

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.

Re: Urgent help needed - MySQL error [Re: angrylizard] #278369
12/05/2004 11:55 PM
12/05/2004 11:55 PM
Joined: Nov 2001
Posts: 11,330
Charlotte, NC
JoshPet Offline
I type Like navaho
JoshPet  Offline
I type Like navaho

Joined: Nov 2001
Posts: 11,330
Charlotte, NC
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/05/2004 11:55 PM.
Sponsored Links
Re: Urgent help needed - MySQL error [Re: Daine] #278370
12/06/2004 12:24 AM
12/06/2004 12:24 AM
Joined: Aug 2002
Posts: 1,271
Vienna, Austria
dimopoulos Offline
Kahuna
dimopoulos  Offline
Kahuna

Joined: Aug 2002
Posts: 1,271
Vienna, Austria
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
Re: Urgent help needed - MySQL error [Re: Hal_dup2] #278371
12/07/2004 9:29 PM
12/07/2004 9:29 PM
Joined: Mar 2000
Posts: 25,587
Texas
AllenAyres Offline
I type Like navaho
AllenAyres  Offline
I type Like navaho

Joined: Mar 2000
Posts: 25,587
Texas
There was a line with a missing closing quotation mark.


- Allen wavey
- What Drives You?

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
· Blue Host
· Interserver.net
Visit us on Facebook
Member Spotlight
Bill B
Bill B
Issaquah, WA
Posts: 84
Joined: December 2001
Show All Member Profiles 
Forum Statistics
Forums64
Topics37,467
Posts293,523
Members13,802
Most Online1,498
Mar 17th, 2017
Top Posters(All Time)
AllenAyres 25,587
JoshPet 11,330
Rick 8,373
LK 7,396
Lord Dexter 6,503
Gizmo 5,947
Greg Hard 5,533
Top Posters(30 Days)
isaac 1
Today's Statistics
Currently Online 748
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 15
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2018 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.7.0
(Snapshot build 20181115.dev)
PHP: 5.4.45 Page Time: 0.039s Queries: 15 (0.013s) Memory: 3.2497 MB (Peak: 3.4497 MB) Data Comp: Zlib Server Time: 2018-12-15 16:23:03 UTC