SQL Error has occurred on line 102 using the newest version. [message #10863] |
Thu, 12 June 2003 03:59 |
craig_restraint
Messages: 4 Registered: June 2003
Karma: 0
|
Junior Member |
|
|
Hello,
getting this error:
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/chicagoh/public_html/forum/include/theme/default/err.inc on line 102
everything looks right in globals.php
the install file was uploaded in binary mode.
the only other response to an error like this was one to update the users_adm.inc.t file but in the release notes after that post it looks like it was taken care of.
I have several other php scripts that hit this mySQL setup
and yes i'm using a different db for the forum
any ideas?
thanks,
-Craig
|
|
|
|
|
|
|
|
|
Re: SQL Errors [message #10922 is a reply to message #10921] |
Fri, 13 June 2003 14:31 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Not a forum bug, the error simply means mysql_pconnect had failed, most likely this is the result of too many open connections at the time of connect. Unless you have A LOT of those errors they are pretty safe to ignore. As a safety measure I would however disable persistent MySQL connections (sql section of forum's settings).
FUDforum Core Developer
|
|
|
|
Re: SQL Errors [message #11006 is a reply to message #10925] |
Mon, 16 June 2003 17:24 |
|
I made the change to my SQL settings as you suggested. Checked the error log after a few days and No SQL errors!!
Thanks for the great support!!
Got Torque?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: SQL Error has occurred on line 102 using the newest version. [message #11802 is a reply to message #11801] |
Thu, 17 July 2003 18:28 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
The error is:
1016: Can't open file: 'fud23_ses.MYI'. (errno: 145)
To fix it you need to repair all MySQL tables, because after a power failure they have become corrupt since they were not closed correctly.
Ex. REPAIR TABLE [table_name];
FUDforum Core Developer
|
|
|
|
Same problem. Please decipher this error? [message #15295 is a reply to message #11803] |
Tue, 09 December 2003 05:10 |
HarmonyMajor
Messages: 46 Registered: September 2003
Karma: 0
|
Member |
|
|
Hello. Please decipher what the following error(s) mean?
Everything was working fine for several months, and I'm just
noticing this error today. It worked fine earlier today, too.
Quote: | [Tue Dec 9 4:47:35 GMT 2003] KGluZGV4LnBocCkgMTA0NDogQWNjZXNzIGRlbmllZCBmb3IgdXNlcjogJ2hhcm1vbnltX0hhcm1 vbnlAbG9jYWxob3N0JyB0byBkYXRhYmFzZSAnaGFybW9ueW1fRnVkRm9ydW0nPGJyIC8+ClF1ZX J5OiBMT0NLIFRBQkxFUyBGVURGb3J1bV9zZXMgV1JJVEU8YnIgLz4KU2VydmVyIFZlcnNpb246I DQuMC4xNS1zdGFuZGFyZDxiciAvPgo=
[Tue Dec 9 4:47:37 GMT 2003] KGluZGV4LnBocCkgMTA0NDogQWNjZXNzIGRlbmllZCBmb3IgdXNlcjogJ2hhcm1vbnltX0hhcm1 vbnlAbG9jYWxob3N0JyB0byBkYXRhYmFzZSAnaGFybW9ueW1fRnVkRm9ydW0nPGJyIC8+ClF1ZX J5OiBMT0NLIFRBQkxFUyBGVURGb3J1bV9zZXMgV1JJVEU8YnIgLz4KU2VydmVyIFZlcnNpb246I DQuMC4xNS1zdGFuZGFyZDxiciAvPgo=
[Tue Dec 9 4:47:41 GMT 2003] KGluZGV4LnBocCkgMTA0NDogQWNjZXNzIGRlbmllZCBmb3IgdXNlcjogJ2hhcm1vbnltX0hhcm1 vbnlAbG9jYWxob3N0JyB0byBkYXRhYmFzZSAnaGFybW9ueW1fRnVkRm9ydW0nPGJyIC8+ClF1ZX J5OiBMT0NLIFRBQkxFUyBGVURGb3J1bV9zZXMgV1JJVEU8YnIgLz4KU2VydmVyIFZlcnNpb246I DQuMC4xNS1zdGFuZGFyZDxiciAvPgo=
[Tue Dec 9 4:59:07 GMT 2003] KGluZGV4LnBocCkgMTA0NDogQWNjZXNzIGRlbmllZCBmb3IgdXNlcjogJ2hhcm1vbnltX0hhcm1 vbnlAbG9jYWxob3N0JyB0byBkYXRhYmFzZSAnaGFybW9ueW1fRnVkRm9ydW0nPGJyIC8+ClF1ZX J5OiBMT0NLIFRBQkxFUyBGVURGb3J1bV9zZXMgV1JJVEU8YnIgLz4KU2VydmVyIFZlcnNpb246I DQuMC4xNS1zdGFuZGFyZDxiciAvPgo=
[Tue Dec 9 4:59:22 GMT 2003] KGluZGV4LnBocCkgMTA0NDogQWNjZXNzIGRlbmllZCBmb3IgdXNlcjogJ2hhcm1vbnltX0hhcm1 vbnlAbG9jYWxob3N0JyB0byBkYXRhYmFzZSAnaGFybW9ueW1fRnVkRm9ydW0nPGJyIC8+ClF1ZX J5OiBMT0NLIFRBQkxFUyBGVURGb3J1bV9zZXMgV1JJVEU8YnIgLz4KU2VydmVyIFZlcnNpb246I DQuMC4xNS1zdGFuZGFyZDxiciAvPgo=
|
Thank you.
Namaste,
FitnessJunkie
|
|
|
|
Thank you! [message #15311 is a reply to message #15296] |
Tue, 09 December 2003 23:35 |
HarmonyMajor
Messages: 46 Registered: September 2003
Karma: 0
|
Member |
|
|
That was weird. It seemed to have just reset itself or something.
I went into my Web host control panel, added that user to the
FudForum MySQL database again, and all was well. :-\
Thanks again.
Namaste,
FitnessJunkie
|
|
|