FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum » FUDforum Installation Issues » SQL Error has occurred on line 102 using the newest version.
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
SQL Error has occurred on line 102 using the newest version. [message #10863] Thu, 12 June 2003 03:59 Go to next message
craig_restraint is currently offline  craig_restraint   United States
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

Report message to a moderator

Re: SQL Error has occurred on line 102 using the newest version. [message #10877 is a reply to message #10863] Thu, 12 June 2003 16:56 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Login as the administrator and go to the error log viewer it should tell you what is the actual query that had failed.

FUDforum Core Developer

Report message to a moderator

Re: SQL Error has occurred on line 102 using the newest version. [message #10898 is a reply to message #10877] Thu, 12 June 2003 18:20 Go to previous messageGo to next message
craig_restraint is currently offline  craig_restraint   United States
Messages: 4
Registered: June 2003
Karma: 0
Junior Member
Hello,

I get this error right after i install. i click finish and then go and remove the install.php file like the instructions told me to (i also tried doing it the other way for grins). The page goes to try and bring up the login page (i would guess) and then that error happens.

I can give you the URL on the top of the page once i get home.

Thanks for any help you can provide.

-c

Report message to a moderator

Re: SQL Error has occurred on line 102 using the newest version. [message #10899 is a reply to message #10898] Thu, 12 June 2003 18:59 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Hmm your forum has errors/ directory inside you will find sql_errors file, send that file to me if you are unable to access the error viewer control panel.

FUDforum Core Developer

Report message to a moderator

Re: SQL Error has occurred on line 102 using the newest version. [message #10915 is a reply to message #10899] Fri, 13 June 2003 03:05 Go to previous messageGo to next message
craig_restraint is currently offline  craig_restraint   United States
Messages: 4
Registered: June 2003
Karma: 0
Junior Member
file sent.

Thanks for taking the time to look at this!!

-Craig

Report message to a moderator

Re: SQL Error has occurred on line 102 using the newest version. [message #10919 is a reply to message #10915] Fri, 13 June 2003 12:35 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
The error you are seeing is:
1044: Access denied for user: 'chicagoh_chcboar@localhost' to database 'chicagoh_msgboard'
Query: LOCK TABLES fud23_ses WRITE

It means your MySQL account does not have access to LOCK permissions. You need to ask your host to enable it.

FUDforum Core Developer

Report message to a moderator

Re: SQL Errors [message #10921 is a reply to message #10919] Fri, 13 June 2003 13:55 Go to previous messageGo to next message
scoutzilla is currently offline  scoutzilla   United States
Messages: 163
Registered: April 2002
Location: Southern Califorina
Karma: 0
Senior Member
While you are talking about SQL errors, I thought I would ask about these:

Wed Jun 11 20:10:45 GMT 2003 (index.php) :
Query: Initiating mysql_pconnect
Server Version: Unknown
[Referring Page] http://my/site/www/index.php?t=msg&goto=1431&rid=302

Wed Jun 11 20:11:19 GMT 2003 (index.php) :
Query: Initiating mysql_pconnect
Server Version: Unknown
[Referring Page] http://my/site/www/index.php?t=post&msg_id=1431&rid=302

thanks for the help

Got Torque?

Report message to a moderator

Re: SQL Errors [message #10922 is a reply to message #10921] Fri, 13 June 2003 14:31 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
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

Report message to a moderator

icon10.gif  Re: SQL Errors [message #10925 is a reply to message #10922] Fri, 13 June 2003 15:58 Go to previous messageGo to next message
scoutzilla is currently offline  scoutzilla   United States
Messages: 163
Registered: April 2002
Location: Southern Califorina
Karma: 0
Senior Member
Ah that explains why the forum is working with these "error" messages, thanks for addressing my minor questions. I will make a change to the settings just in case.

Got Torque?

Report message to a moderator

Re: SQL Errors [message #11006 is a reply to message #10925] Mon, 16 June 2003 17:24 Go to previous messageGo to next message
scoutzilla is currently offline  scoutzilla   United States
Messages: 163
Registered: April 2002
Location: Southern Califorina
Karma: 0
Senior Member
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?

Report message to a moderator

Re: SQL Error has occurred on line 102 using the newest version. [message #11119 is a reply to message #10863] Wed, 18 June 2003 06:52 Go to previous messageGo to next message
jenigma is currently offline  jenigma   United States
Messages: 2
Registered: June 2003
Karma: 0
Junior Member
I get the same error. In my sql_errors file is just a bunch of jibberish:
Quote:

[Wed Jun 18 6:12:15 GMT 2003] KHQ9bG9naW4mYWRtPTEpIDEwNDQ6IEFjY2VzcyBkZW5pZWQgZm9yIHVzZXI6ICdwb2Vta2lfamV uaWdtYUBsb2NhbGhvc3QnIHRvIGRhdGFiYXNlICdwb2Vta2lfZnVkZm9ydW0nPGJyIC8+ClF1ZX J5OiBMT0NLIFRBQkxFUyBmdWRfc2VzIFdSSVRFPGJyIC8+ClNlcnZlciBWZXJzaW9uOiA0LjAuM TM8YnIgLz4K
[Wed Jun 18 6:13:01 GMT 2003] KHQ9bG9naW4mYWRtPTEpIDEwNDQ6IEFjY2VzcyBkZW5pZWQgZm9yIHVzZXI6ICdwb2Vta2lfamV uaWdtYUBsb2NhbGhvc3QnIHRvIGRhdGFiYXNlICdwb2Vta2lfZnVkZm9ydW0nPGJyIC8+ClF1ZX J5OiBMT0NLIFRBQkxFUyBmdWRfc2VzIFdSSVRFPGJyIC8+ClNlcnZlciBWZXJzaW9uOiA0LjAuM TM8YnIgLz4K
[Wed Jun 18 6:15:52 GMT 2003] KCkgMTA0NDogQWNjZXNzIGRlbmllZCBmb3IgdXNlcjogJ3BvZW1raV9qZW5pZ21hQGxvY2FsaG9 zdCcgdG8gZGF0YWJhc2UgJ3BvZW1raV9mdWRmb3J1bSc8YnIgLz4KUXVlcnk6IExPQ0sgVEFCTE VTIGZ1ZF9zZXMgV1JJVEU8YnIgLz4KU2VydmVyIFZlcnNpb246IDQuMC4xMzxiciAvPgo=
[Wed Jun 18 6:27:56 GMT 2003] KCkgMTA0NDogQWNjZXNzIGRlbmllZCBmb3IgdXNlcjogJ3BvZW1raV9qZW5pZ21hQGxvY2FsaG9 zdCcgdG8gZGF0YWJhc2UgJ3BvZW1raV9mdWRmb3J1bSc8YnIgLz4KUXVlcnk6IExPQ0sgVEFCTE VTIGZ1ZF9zZXMgV1JJVEU8YnIgLz4KU2VydmVyIFZlcnNpb246IDQuMC4xMzxiciAvPgo=


Do I also need to ask my host to enable lock permissions?

Report message to a moderator

Re: SQL Error has occurred on line 102 using the newest version. [message #11128 is a reply to message #11119] Wed, 18 June 2003 12:15 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Nope, your error is different.
The SQL error you get is:
) 1044: Access denied for user: 'poemki_jenigma@localhost' to database 'poemki_fudforum'

Meaning that you have specified incorrect access credential for the MySQL database.

FUDforum Core Developer

Report message to a moderator

Re: SQL Error has occurred on line 102 using the newest version. [message #11135 is a reply to message #11128] Wed, 18 June 2003 16:41 Go to previous messageGo to next message
jenigma is currently offline  jenigma   United States
Messages: 2
Registered: June 2003
Karma: 0
Junior Member
The information I supplied is correct though. The database poemki_fudforum exists and user poemki_jenigma is added to it. My host is localhost and my password was entered correctly. When I go to the database in phpMyAdmin, I see that the tables were created; so why am I getting this error?

Report message to a moderator

Re: SQL Error has occurred on line 102 using the newest version. [message #11136 is a reply to message #11135] Wed, 18 June 2003 17:18 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
That's a question for your ISP, the error is quite clear, according to MySQL the specified credentials are insufficient. This does not even have to do with the forum.

FUDforum Core Developer

Report message to a moderator

SQL Error has occurred on err.inc on line 127 [message #11195 is a reply to message #10863] Sat, 21 June 2003 14:25 Go to previous messageGo to next message
compala is currently offline  compala   Czech Republic
Messages: 1
Registered: June 2003
Karma: 0
Junior Member
I have similar problem. In my sql_errors file is some like this:
Quote:


[Fri Jun 20 8:44:10 GMT 2003] KCkgMTA0NDogQWNjZXNzIGRlbmllZCBmb3IgdXNlcjogJ2RzMTAwOF90ZHJAbG9jYWxob3N0JyB 0byBkYXRhYmFzZSAnZHMxMDA4X3Rkcic8YnIgLz4KUXVlcnk6IExPQ0sgVEFCTEVTIGZ1ZDIzX3 NlcyBXUklURTxiciAvPgpTZXJ2ZXIgVmVyc2lvbjogNC4wLjEyLWxvZzxiciAvPgo=
[Fri Jun 20 8:44:10 GMT 2003] KCkgMTA0NDogQWNjZXNzIGRlbmllZCBmb3IgdXNlcjogJ2RzMTAwOF90ZHJAbG9jYWxob3N0JyB 0byBkYXRhYmFzZSAnZHMxMDA4X3Rkcic8YnIgLz4KUXVlcnk6IExPQ0sgVEFCTEVTIGZ1ZDIzX3 NlcyBXUklURTxiciAvPgpTZXJ2ZXIgVmVyc2lvbjogNC4wLjEyLWxvZzxiciAvPgo=
[Sat Jun 21 13:43:24 GMT 2003] KCkgMTA0NDogQWNjZXNzIGRlbmllZCBmb3IgdXNlcjogJ2RzMTAwOF90ZHJAbG9jYWxob3N0JyB 0byBkYXRhYmFzZSAnZHMxMDA4X3Rkcic8YnIgLz4KUXVlcnk6IExPQ0sgVEFCTEVTIGZ1ZDIzX3 NlcyBXUklURTxiciAvPgpTZXJ2ZXIgVmVyc2lvbjogNC4wLjEyLWxvZzxiciAvPgpbUmVmZXJya W5nIFBhZ2VdIGh0dHA6Ly93d3cuYXJjaGxpbmUuY3ovbWVudS5odG08YnIgLz4K
[Sat Jun 21 13:49:33 GMT 2003] KCkgMTA0NDogQWNjZXNzIGRlbmllZCBmb3IgdXNlcjogJ2RzMTAwOF90ZHJAbG9jYWxob3N0JyB 0byBkYXRhYmFzZSAnZHMxMDA4X3Rkcic8YnIgLz4KUXVlcnk6IExPQ0sgVEFCTEVTIGZ1ZDIzX3 NlcyBXUklURTxiciAvPgpTZXJ2ZXIgVmVyc2lvbjogNC4wLjEyLWxvZzxiciAvPgo=





Can You help me?

Report message to a moderator

Re: SQL Error has occurred on err.inc on line 127 [message #11198 is a reply to message #11195] Sat, 21 June 2003 15:06 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
The SQL error message is:
() 1044: Access denied for user: 'ds1008_tdr@localhost' to database 'ds1008_tdr'<br />

FUDforum Core Developer

Report message to a moderator

Re: SQL Error has occurred on line 102 using the newest version. [message #11272 is a reply to message #10863] Wed, 25 June 2003 17:18 Go to previous messageGo to next message
jibber_ish is currently offline  jibber_ish   Norway
Messages: 3
Registered: June 2003
Karma: 0
Junior Member
um, any info on the "jibberish" in my sql_error?

:

[Wed Jun 25 17:12:38 GMT 2003] KHQ9bG9naW4mYWRtPTEpIDEwNDQ6IEFjY2VzcyBkZW5pZWQgZm9yIHVzZXI6ICdubG9nYXhAMjE 3Ljc3LjM0LjIwMCcgdG8gZGF0YWJhc2UgJ25sb2dheCc8YnIgLz4KUXVlcnk6IExPQ0sgVEFCTE VTIGJvY3NlcyBXUklURTxiciAvPgpTZXJ2ZXIgVmVyc2lvbjogNC4wLjEyLWxvZzxiciAvPgpbU mVmZXJyaW5nIFBhZ2VdIGh0dHA6Ly9ib2FyZHNvZmNhbmFkYS5ubG9nYXgub3JnL2ZvcnVtL2lu c3RhbGwucGhwPzE3NDE2MjE4MTQ8YnIgLz4K

I get this after a successful install, after deleting install.php.

thanky wanky Smile

Report message to a moderator

Re: SQL Error has occurred on line 102 using the newest version. [message #11277 is a reply to message #11272] Wed, 25 June 2003 19:27 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
The error is:
1044: Access denied for user: 'nlogax(at)217(dot)77(dot)34(dot)200' to database 'nlogax'
Query: LOCK TABLES bocses WRITE

FUDforum Core Developer

Report message to a moderator

Re: SQL Error has occurred on line 102 using the newest version. [message #11278 is a reply to message #11277] Wed, 25 June 2003 19:42 Go to previous messageGo to next message
jibber_ish is currently offline  jibber_ish   Norway
Messages: 3
Registered: June 2003
Karma: 0
Junior Member
hum.
access denied huh? strange.

well, what does LOCK TABLES bocses WRITE mean?

any way to fix this?

Report message to a moderator

Re: SQL Error has occurred on line 102 using the newest version. [message #11279 is a reply to message #11278] Wed, 25 June 2003 19:50 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Make sure you have permissions to LOCK/UNLOCK tables.

FUDforum Core Developer

Report message to a moderator

Re: SQL Error has occurred on line 102 using the newest version. [message #11280 is a reply to message #11279] Wed, 25 June 2003 19:56 Go to previous messageGo to next message
jibber_ish is currently offline  jibber_ish   Norway
Messages: 3
Registered: June 2003
Karma: 0
Junior Member
ok, thanks a million, prottoss Smile

Report message to a moderator

Re: SQL Error has occurred on line 102 using the newest version. [message #11801 is a reply to message #11280] Thu, 17 July 2003 18:18 Go to previous messageGo to next message
andy_scouser is currently offline  andy_scouser   United Kingdom
Messages: 76
Registered: June 2003
Karma: 1
Member
I have just had a power outage (caused by my dad !!!)
The forum will not start now, I am getting the following in my sql_errors file.

Can anybody please diagnose this problem for me.

Most appreciated.

andy.

ps Time to get a test forum running on a different machine I feel.

[Thu Jul 17 18:19:14 GMT Standard Time 2003] KCkgMTAxNjogQ2FuJ3Qgb3BlbiBmaWxlOiA
nZnVkMjNfc2VzLk1ZSScuIChlcnJubzogMTQ1KTxiciAvPgpRdWVyeTogTE9DSyBUQUJMRVMgZn VkMjN
fc2VzIFdSSVRFPGJyIC8+ClNlcnZlciBWZXJzaW9uOiA0LjAuMTMtbWF4PGJyIC8+CltSZWZlcn Jpbmc
gUGFnZV0gaHR0cDovL3d3dy5ob25kYS1mb3J1bXMuY29tLzxiciAvPgo=

Report message to a moderator

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 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
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

Report message to a moderator

Re: SQL Error has occurred on line 102 using the newest version. [message #11803 is a reply to message #11802] Thu, 17 July 2003 18:43 Go to previous messageGo to next message
andy_scouser is currently offline  andy_scouser   United Kingdom
Messages: 76
Registered: June 2003
Karma: 1
Member
prottos my friend....

YOU ARE AN ABSOLUTE STAR..... well done Smile Smile Very Happy

site fixed in 2 seconds, did I say well done Smile

Report message to a moderator

Same problem. Please decipher this error? [message #15295 is a reply to message #11803] Tue, 09 December 2003 05:10 Go to previous messageGo to next message
HarmonyMajor is currently offline  HarmonyMajor   United States
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

Report message to a moderator

Re: Same problem. Please decipher this error? [message #15296 is a reply to message #15295] Tue, 09 December 2003 13:26 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
index.php) 1044: Access denied for user: 'harmonym_Harmony@localhost' to database 'harmonym_FudForum'

FUDforum Core Developer

Report message to a moderator

Thank you! [message #15311 is a reply to message #15296] Tue, 09 December 2003 23:35 Go to previous message
HarmonyMajor is currently offline  HarmonyMajor   United States
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

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Translation in to Danish
Next Topic: Impossible to install on my ISP
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 10 00:14:15 GMT 2024

Total time taken to generate the page: 0.02147 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software