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

Home » FUDforum » FUDforum Installation Issues » DELETE FROM fud26_msg_store (Cannot login to forum)
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
DELETE FROM fud26_msg_store [message #35657] Mon, 29 January 2007 11:33 Go to next message
lloydm is currently offline  lloydm   United States
Messages: 20
Registered: April 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I cannot login my forum after upgrading to 2.7.6 for I get this message.

Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /FUDforum/include/core.inc on line 188

and I see this message below in sql_error log.

) 1100: Table 'fud26_msg_store' was not locked with LOCK TABLES<br />
Query: DELETE FROM fud26_msg_store WHERE id=455<br />


Any ideas
Re: DELETE FROM fud26_msg_store [message #35658 is a reply to message #35657] Mon, 29 January 2007 19:58 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
add to buddy list
ignore all messages by this user
On what page did you get this error message?

FUDforum Core Developer
Re: DELETE FROM fud26_msg_store [message #35661 is a reply to message #35658] Mon, 29 January 2007 21:57 Go to previous messageGo to next message
lloydm is currently offline  lloydm   United States
Messages: 20
Registered: April 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I get this message within browser after atempting a login to the forum. I also have users e-mail me for their getting the message also.

Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /FUDforum/include/core.inc on line 188

and this comes from sql_error log file..

?748 ?1170125169?(/public_html/forum/index.php:75<br />
/FUDforum/include/theme/default/private.inc:257<br />
/FUDforum/include/users_adm.inc:47<br />
/public_html/forum/theme/default/login.php:476<br />
/public_html/forum/index.php:1194<br />
) 1100: Table 'fud26_msg_store' was not locked with LOCK TABLES<br />
Query: DELETE FROM fud26_msg_store WHERE id=455<br />

[Updated on: Mon, 29 January 2007 21:58]

Report message to a moderator

Re: DELETE FROM fud26_msg_store [message #35665 is a reply to message #35661] Tue, 30 January 2007 09: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
add to buddy list
ignore all messages by this user
Fixed in CVS.

FUDforum Core Developer
Re: DELETE FROM fud26_msg_store [message #35671 is a reply to message #35665] Tue, 30 January 2007 12:04 Go to previous messageGo to next message
lloydm is currently offline  lloydm   United States
Messages: 20
Registered: April 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Sorry to be a bother, but how to I apply the patch. have never done this before. Do I just copy over the older file.

Re: DELETE FROM fud26_msg_store [message #35677 is a reply to message #35671] Tue, 30 January 2007 20:30 Go to previous messageGo to next message
lloydm is currently offline  lloydm   United States
Messages: 20
Registered: April 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Applied the fix, but still does not work. Now I am getting this message in sql_error.

?664 ?1170201935?(/public_html/forum/index.php:75<br />
/FUDforum/include/users_adm.inc:25<br />
/public_html/forum/theme/default/login.php:476<br />
/public_html/forum/index.php:1194<br />
) 1100: Table 'fud26_mod' was not locked with LOCK TABLES<br />
Query: DELETE FROM fud26_mod WHERE user_id IN(61)<br />

Re: DELETE FROM fud26_msg_store [message #35681 is a reply to message #35671] Wed, 31 January 2007 10:38 Go to previous messageGo to next message
lloydm is currently offline  lloydm   United States
Messages: 20
Registered: April 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Applied patch, but still did not resolve the issue, for now I am getting a different sql_error message.

?664 ?1170201935?(/public_html/forum/index.php:75<br />
/FUDforum/include/users_adm.inc:25<br />
/public_html/forum/theme/default/login.php:476<br />
/public_html/forum/index.php:1194<br />
) 1100: Table 'fud26_mod' was not locked with LOCK TABLES<br />
Query: DELETE FROM fud26_mod WHERE user_id IN(61)<br />

[Updated on: Wed, 31 January 2007 10:39]

Report message to a moderator

Re: DELETE FROM fud26_msg_store [message #35683 is a reply to message #35681] Wed, 31 January 2007 18: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
add to buddy list
ignore all messages by this user
Once you've applied the patch, did you rebuild the theme?

FUDforum Core Developer
Re: DELETE FROM fud26_msg_store [message #35693 is a reply to message #35683] Thu, 01 February 2007 15:45 Go to previous messageGo to next message
lloydm is currently offline  lloydm   United States
Messages: 20
Registered: April 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I tried rebuilding the themes and now I get this message.

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /FUDforum/include/compiler.inc on line 708

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /FUDforum/include/compiler.inc on line 708

and during forum consistency I get.

Warning: Invalid argument supplied for foreach() in /public_html/forum/adm/consist.php on line 438

Re: DELETE FROM fud26_msg_store [message #35695 is a reply to message #35693] Thu, 01 February 2007 18: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
add to buddy list
ignore all messages by this user
lloydm wrote on Thu, 01 February 2007 15:45

I tried rebuilding the themes and now I get this message.

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /FUDforum/include/compiler.inc on line 708

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /FUDforum/include/compiler.inc on line 708

and during forum consistency I get.

Warning: Invalid argument supplied for foreach() in /public_html/forum/adm/consist.php on line 438




What version of the forum are you running?


FUDforum Core Developer
Re: DELETE FROM fud26_msg_store [message #35700 is a reply to message #35695] Thu, 01 February 2007 21:54 Go to previous messageGo to next message
lloydm is currently offline  lloydm   Canada
Messages: 20
Registered: April 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
PHP built On: SunOS media4 5.8 Generic_117350-18 sun4u
Database Version: 4.0.27
PHP Version: 5.0.5-20051114
Web Server: Zeus/4.3
WebServer to PHP interface: cgi
WebServer User/Group: 2520 / 2520
Forum Version: 2.7.7RC1
Relavent PHP Settings: Safe Mode: OFF
Open basedir: none
Display Errors: ON
File Uploads: ON
Maximum File Upload Size: 2097152
Magic Quotes: ON
Register Globals: OFF
Output Buffering: No
Disabled Functions: none
PSpell Support: No
Zlib Support: Yes

Re: DELETE FROM fud26_msg_store [message #35713 is a reply to message #35700] Sun, 04 February 2007 11:45 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
add to buddy list
ignore all messages by this user
Ok, both issues are now resolved in CVS.

FUDforum Core Developer
Re: DELETE FROM fud26_msg_store [message #35756 is a reply to message #35713] Wed, 07 February 2007 15:56 Go to previous messageGo to next message
lloydm is currently offline  lloydm   United States
Messages: 20
Registered: April 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Thanks Guys that did fix my issue. One minor issue which I was able to handle myself.

When rebuilding themes you get error message.

cannot copy "/FUDforum/thm/default/i18n/english/img/tree_view.gif" to "/public_html/forum/theme/default/images//tree_view.gif"


I was able to copy the files myself.
Re: DELETE FROM fud26_msg_store [message #35764 is a reply to message #35756] Wed, 07 February 2007 19:11 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
I suspect the destination file already existed and was owned by YOU, so when webserver tried to overwrite it (as web server user) it got a permission error.

FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Can't get any email to work
Next Topic: Where is WWW Root stored?
Goto Forum:
  

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

Current Time: Sat Apr 21 13:30:53 EDT 2018

Total time taken to generate the page: 0.00848 seconds