Error msg....! [message #10705] |
Sun, 08 June 2003 00:47 |
|
esm2002
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 |
Ilia
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 #10711 is a reply to message #10708] |
Sun, 08 June 2003 02:11 |
Ilia
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 |
|
esm2002
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.
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...
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 |
|
esm2002
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."
|
|
|