| sql_errors [message #19909] |
Thu, 16 September 2004 01:53  |
dadnad
Messages: 12
Registered: February 2003
Karma: 0
|
Junior Member |
|
|
Hi I'm having a bit of trouble moving my forum from one server to another... I'm getting 'Fatal error: SQL Error has occurred, please contact the... review the forum's SQL query log in /home/vmbsg01/forum.vmbsg.com.au/forum/include/theme/default/err.inc on line 102' error. I've had a look at my sql_errors log, and a few posts here, how am I able to decipher this error?
[Thu Sep 16 1:39:16 GMT 2004] KCkgMTA0NDogQWNjZXNzIGRlbmllZCBmb3IgdXNlcjogJ3ZtYnNnMDFAbWVsMDEuc3RyYXRlZ2l jZGF0YS5pbnRlcm5hbCcgdG8gZGF0YWJhc2UgJ3ZtYnNnMDInPGJyIC8+ClF1ZXJ5OiBMT0NLIF RBQkxFUyBmdWQyM19zZXMgV1JJVEU8YnIgLz4KU2VydmVyIFZlcnNpb246IDQuMC4yMC1sb2c8Y nIgLz4K
Is there a script I can run to get the errors out? obviously I can't use the admin interface or I would have had some more success... my forum is currently version 2.3 but am going to upgrade to latest once I can jump this hurdle...
Cheers for any assistance.
Adam.
|
|
|
|
| Re: sql_errors [message #19918 is a reply to message #19909] |
Thu, 16 September 2004 18:46  |
zeeislandboy
Messages: 5
Registered: September 2004
Karma: 0
|
Junior Member |
|
|
Hi.
I've got exactly the same issues (though I'm not moving my forum) and have posted them in detail in the "How To" section under the heading "log-in problems for admin and everyone else". No solutions yet... Please let me know if you get anywhere and I'll do the same. Thanks.
[Updated on: Thu, 16 September 2004 18:48] Report message to a moderator |
|
|
|
| Re: sql_errors [message #19921 is a reply to message #19918] |
Thu, 16 September 2004 19:36 |
zeeislandboy
Messages: 5
Registered: September 2004
Karma: 0
|
Junior Member |
|
|
I've just gotten my problem figured out. It may be the same as yours. I have MySQL on my server, which allows me to see the database files. I'm a novice to all of this, so I might not get all the terms right. Once you see the files, fin your fud23_ses file. All this contains is info about the current sessions, so you can empty it without affecting your forum. You want to empty it, not "drop" it (these are the terms in MySQL. Sinced it will probably be "in use" you'll need to check the box next to the file and use the small pull-down list to chose empty. And that's it. Next time you or someone else logs onto your forum, the fud23_ses file gets filled up with fresh info (and hopefully you won't see the error message!).
Hope it works for you.
Curtis
[Updated on: Thu, 16 September 2004 20:15] Report message to a moderator |
|
|
|
|
|
| Re: sql_errors [message #19929 is a reply to message #19924] |
Fri, 17 September 2004 01:12 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
The error is due to lacking permissions, the plain text error is:
() 1044: Access denied for user: 'vmbsg01(at)mel01(dot)strategicdata(dot)internal' to database 'vmbsg02'<br />
Query: LOCK TABLES fud23_ses WRITE<br />
Server Version: 4.0.20-log<br />
You need to hav your admin give you ability to LOCK tables.
FUDforum Core Developer
|
|
|
|
|
|
|
|
| Re: sql_errors [message #20534 is a reply to message #19937] |
Mon, 18 October 2004 16:13 |
adrel
Messages: 1
Registered: October 2004
Karma: 0
|
Junior Member |
|
|
Hi,
I experienced the same problem, having to decode the base64 messages from the error file. The problem was that I could not log into the board and use that to decode them for me.
Therefore, I wrote a small PHP script to decode them for me. I put that in a directory, made a copy of the sql_errors file, and I set up limited access to it (just in case).
Anyhow, here's the script I used, someone else might find it handy. It requires the sql_errors file to put placed in the same directory as the script itself, but one can easy adjust that to match his/her own installation.
<?php
?>
<html>
<head>
<title>sql_errors</title>
</head>
<body>
<table border=1>
<?php
$f = fopen('sql_errors', 'r');
while(!feof($f)) {
$line = fgets($f, 32768);
if($line[0] != '[') continue;
if($line[28] != ']') continue;
$date = substr($line, 1, 27);
$encoded = substr($line, 30);
?>
<tr>
<td valign=middle><?= $date ?></td>
<td valign=top><?= base64_decode($encoded) ?></td>
</tr>
<?php
}
fclose($f);
?>
</table>
</body>
</html>
<?php
?>
It is a simple script, but it does the job. I hope this would be helpful to some other people having the same sort of problems.
Regards,
-Adrel
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
admin has access to error log viewer that shows the actual text of the errors.
]