FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Error msg....!
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Error msg....! [message #10705] Sun, 08 June 2003 00:47 Go to next message
esm2002 is currently offline  esm2002   United States
Messages: 339
Registered: May 2002
Location: Atlanta Georgia
Karma: 0
Senior Member
signed into fudforum at my site as admin
signed into fudforum here at prohost.

I ran the following query in phpMyAdmin on my site
SELECT id,reply_to FROM fud25_msg WHERE thread_id=2;

Then tried to add a msg. Received the following error msg

(index.php) 1044: Access denied for user: 'acct@localhost' to database 'acct_ch'
Query: LOCK TABLES fud25_thread_view WRITE, fud25_level WRITE, 
fud25_users WRITE, fud25_forum WRITE, fud25_thread WRITE, 
fud25_msg WRITE
Server Version: 4.0.12
[Referring Page] http://www.mysite.com/forum/index.php?t=post


signed out of fudforum at prohost

Tried to add the msg again and received the same error msg as above

Neither msg showed up in my forum

Using phpMyAdmin I could see the two newly added msgs. I noticed that the "unapproved" field was set to no for both msgs.

Edited the first one and changed the status to approved.

Now my forum shows the first msg.

Edited the second one and changed the status to approved.

Now my forum shows both msgs.

Deleted the second msg.

Received the following error msg

(index.php) 1044: Access denied for user: 'acct@localhost' to database 'acct_ch'
Query: LOCK TABLES fud25_thr_exchange WRITE, fud25_thread_view 
WRITE, fud25_level WRITE, fud25_forum WRITE, fud25_forum_read 
WRITE, fud25_thread WRITE, fud25_msg WRITE, fud25_attach WRITE, 
fud25_poll WRITE, fud25_poll_opt WRITE, fud25_poll_opt_track 
WRITE, fud25_users WRITE, fud25_thread_notify WRITE, 
fud25_msg_report WRITE, fud25_thread_rate_track WRITE
Server Version: 4.0.12
[Referring Page] http://www.mysite.com/forum/index.php?t=mmod&del=20&rid=2

Tried to go to admin center and received the following error msg.


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/acct/public_html/forum/index.php on line 56


Now what?

Forums are down completely!


Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."
Re: Error msg....! [message #10706 is a reply to message #10705] Sun, 08 June 2003 00:53 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
Your server seems to disallow LOCK permission make sure MySQL allows LOCK queries to go through.

FUDforum Core Developer
Re: Error msg....! [message #10707 is a reply to message #10706] Sun, 08 June 2003 01:28 Go to previous messageGo to next message
esm2002 is currently offline  esm2002   United States
Messages: 339
Registered: May 2002
Location: Atlanta Georgia
Karma: 0
Senior Member
thanks. I passed that on the host.

will they be able to restore my admin login?



Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."
Re: Error msg....! [message #10708 is a reply to message #10706] Sun, 08 June 2003 01:30 Go to previous messageGo to next message
esm2002 is currently offline  esm2002   United States
Messages: 339
Registered: May 2002
Location: Atlanta Georgia
Karma: 0
Senior Member
prottoss wrote on Sat, 07 June 2003 20:53

Your server seems to disallow LOCK permission make sure MySQL allows LOCK queries to go through.


And why did this just start occurring?

Or have other people been trying to add msgs and getting the same errors, and just gave up and never told me????





Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."
Re: Error msg....! [message #10711 is a reply to message #10708] Sun, 08 June 2003 02:11 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
Your host may have changed the SQL permissions or something... don't know why it would suddently start happening.

FUDforum Core Developer
Re: Error msg....! [message #10742 is a reply to message #10711] Mon, 09 June 2003 10:54 Go to previous messageGo to next message
esm2002 is currently offline  esm2002   United States
Messages: 339
Registered: May 2002
Location: Atlanta Georgia
Karma: 0
Senior Member
I ran the upgrade script to move from 2.5 RC3 to 2.5 RC4. At least I can get to the Admin Panel. Very Happy

Here is the latest as of 6:45 EDT Monday.

Quote:


"It is not one of the message boards we provide."
Are we limited only to scripts that Lunarpages provides?


"I got the address thanks...What is it called?"
Did you go to the URL? The forum is called FUDForum.


"There was a symbolic link in your forum directory. I don't think it should be there."
What is a symbolic link? How do you identify a symbolic link?

"What is your script called,"
Why do you keep asking this????? I gave you the URL to the script. Go to that address and you will see the script in action.


"and who installed it?"
In my previous email, I stated that "I installed it on June 3" and it ran just fine until Jun 7.


Here is the error msg I get when I try to add a msg to the forum.

(index.php) 1044: Access denied for user: 'acct@localhost' to database 'acct_ch'
Query: LOCK TABLES fud25_thread_view WRITE, fud25_level WRITE, fud25_users WRITE, fud25_forum WRITE, fud25_thread WRITE, fud25_msg WRITE
Server Version: 4.0.12
[Referring Page] http://www.mysite.com/forum/index.php?t=post&reply_to=21&rid=2

A msg from the FUDForum support dept says
"Your server seems to disallow LOCK permission. Make sure MySQL allows LOCK queries to go through. Your host may have changed the SQL permissions or something."

QUESTION: Is the mySQL setup to allow LOCK queries to go thru?

QUESTION: Did you make any changes to mySQL on Saturday afternoon New York City Time?

QUESTION: Is there a mySQL error log? And if so, does it show an error for the above


An appropriate place to use QUOTE tags... Smile


Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."
Re: Error msg....! [message #10744 is a reply to message #10742] Mon, 09 June 2003 11:45 Go to previous message
esm2002 is currently offline  esm2002   United States
Messages: 339
Registered: May 2002
Location: Atlanta Georgia
Karma: 0
Senior Member
ahhh, support

the latest!
Quote:

"No, you're not limited to the scripts we provide, but we don't offer support for 3rd party scripts."
I knew that already. Here is what I asked:
QUESTION: Is the mySQL setup to allow LOCK queries to go thru?
QUESTION: Did you make any changes to mySQL on Saturday afternoon New York City Time?
QUESTION: Is there a mySQL error log? And if so, does it show an error for the above


"I went to the url you gave me and saw your forum. It was not working, and the name, "FUDForum" was not displayed."
Did you look at the bottom of the page and find:
Powered by: FUDforum 2.5.0RC4
Copyright ©2001-2003 Advanced Internet Designs Inc.

Also, what do you mean it was not working? It has been working and you can look at all the messages. I just cannot add a message.


"A symbolic link is a link to another file. You can see it if you connect via ftp."
Well, that does still not answer my question. I asked:
What is a symbolic link? How do you identify a symbolic link?

When, I look what will I see? Will it be coded in red? Will it have a green flag? Will it have some particular symbol next to it?


"I asked for the name of the script because the link you gave me was not working."
Well, the link does work.
And you went to it according to your statement above when you stated "I went to the url you gave me and saw your forum." You even went on to state "It was not working, and the name, "FUDForum" was not displayed."


"I asked who installed it because I wanted to know if you'd had help from one of us."
No problem with asking the question. But I answered it and then in later emails you asked it twice more.

No offense, but you do not appear to be very good at this and I am not sure that you know what you are talking about. Maybe you just don't know how to put your answers in an email. Based on your responses to what I wrote, you certainly do not appear to have read my emails.

Maybe it is better that someone else respond to this.



Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: 2.5.0RC4 - weird group management/forum manager bug
Next Topic: Error on last installation step
Goto Forum:
  

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

Current Time: Sat Nov 09 07:45:31 GMT 2024

Total time taken to generate the page: 0.02874 seconds