FUDforum: Bug Reports » Forum Consistency check error

Home » FUDforum Development » Bug Reports » Forum Consistency check error

Show: Today's Messages :: Polls :: Message Navigator

Forum Consistency check error [message #25846]

Thu, 23 June 2005 14:23

keneisman

Messages: 68
Registered: May 2005

Karma: 0

Member

I'm repeatedly getting this error when I run a Forum Consistency check:

Checking for presence of forum lock tables
(c:\GEMSForumData\include\theme\default\db.inc:122
c:\Inetpub\wwwroot\gemsforum\adm\consist.php:266
) 1050: Table 'gemsforum_fl_1' already exists
Query: CREATE TABLE GEMSForum_fl_1 (id INT)
_POST: conf=Yes&S=0391ae50ed420d6207a9c5b364bab3b2&SQ=45da5b5c47a6c66654c4 cdc9b98fa99a&
Server Version: 4.1.11-nt
[Referring Page] http://mail.co.matagorda.tx.us/gemsforum/adm/consist.php?S=0391ae50ed420d62 07a9c5b364bab3b2&SQ=45da5b5c47a6c66654c4cdc9b98fa99a

*************************************************************************** **

I can manually drop this table and I'll get the same error for the gemsforum_fl_pm file. I drop that file and then everything runs okay.

Next time I try to run the Consistency check, I get the errors again. Any idea what I'm doing wrong?

Thanks
Ken

*************************************************************************** *****
System Configuration
PHP built On: Windows NT MAIL01 5.2 build 3790
Database Version: 4.1.11-nt
PHP Version: 5.0.4
Web Server: Microsoft-IIS/6.0
WebServer to PHP interface: isapi
Forum Version: 2.6.14RC1
Relavent PHP Settings: Safe Mode: OFF
Open basedir: none
Display Errors: OFF
File Uploads: ON
Magic Quotes: OFF
Register Globals: OFF
Output Buffering: Yes
Disabled Functions: none
PSpell Support: Yes
Zlib Support: Yes

Report message to a moderator

Re: Forum Consistency check error [message #25852 is a reply to message #25846]

Thu, 23 June 2005 15:09

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

It seems that the forum does not detect the availability of that table.

See if this patch fixes that:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=3611

FUDforum Core Developer

Report message to a moderator

Re: Forum Consistency check error [message #25854 is a reply to message #25852]

Thu, 23 June 2005 15:40

keneisman

Messages: 68
Registered: May 2005

Karma: 0

Member

No, that didn't help.

It appears to me that the consistency check is building these forum lock tables and then not dropping them when it's done.

I can drop the tables, run the check (all is well) and then immediately re-run the check and I get the error and all those lock tables are present with nothing in them.

There a LOT of these tables fl_1-fl_28 looks like and a fl_pm.

Thanks
Ken

[Updated on: Thu, 23 June 2005 15:42]

Report message to a moderator

Re: Forum Consistency check error [message #25864 is a reply to message #25854]

Thu, 23 June 2005 21:43

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

These tables should always exist, the problem is that for some reason the forum thinks that they do not exist.

I really need to see what the get_fud_table_list() function outputs on your system.

Open consist.php look for the call to the function, and on the next line add

var_dump($tbls);

FUDforum Core Developer

Report message to a moderator

Re: Forum Consistency check error [message #25867 is a reply to message #25864]

Thu, 23 June 2005 22:01

keneisman

Messages: 68
Registered: May 2005

Karma: 0

Member

Here's the output you requested:
***********************************************
Locking the database for checking
array(79) { [0]=> string(20) "gemsforum_action_log" [1]=> string(20) "gemsforum_ann_forums" [2]=> string(18) "gemsforum_announce" [3]=> string(16) "gemsforum_attach" [4]=> string(16) "gemsforum_avatar" [5]=> string(24) "gemsforum_blocked_logins" [6]=> string(15) "gemsforum_buddy" [7]=> string(13) "gemsforum_cat" [8]=> string(21) "gemsforum_custom_tags" [9]=> string(21) "gemsforum_email_block" [10]=> string(19) "gemsforum_ext_block" [11]=> string(17) "gemsforum_fc_view" [12]=> string(14) "gemsforum_fl_1" [13]=> string(15) "gemsforum_fl_10" [14]=> string(15) "gemsforum_fl_11" [15]=> string(15) "gemsforum_fl_12" [16]=> string(15) "gemsforum_fl_13" [17]=> string(15) "gemsforum_fl_14" [18]=> string(15) "gemsforum_fl_15" [19]=> string(15) "gemsforum_fl_16" [20]=> string(15) "gemsforum_fl_17" [21]=> string(15) "gemsforum_fl_18" [22]=> string(15) "gemsforum_fl_19" [23]=> string(14) "gemsforum_fl_2" [24]=> string(15) "gemsforum_fl_20" [25]=> string(15) "gemsforum_fl_21" [26]=> string(15) "gemsforum_fl_22" [27]=> string(15) "gemsforum_fl_23" [28]=> string(15) "gemsforum_fl_24" [29]=> string(15) "gemsforum_fl_25" [30]=> string(15) "gemsforum_fl_26" [31]=> string(15) "gemsforum_fl_27" [32]=> string(15) "gemsforum_fl_28" [33]=> string(14) "gemsforum_fl_3" [34]=> string(14) "gemsforum_fl_4" [35]=> string(14) "gemsforum_fl_5" [36]=> string(14) "gemsforum_fl_6" [37]=> string(14) "gemsforum_fl_7" [38]=> string(14) "gemsforum_fl_8" [39]=> string(14) "gemsforum_fl_9" [40]=> string(15) "gemsforum_fl_pm" [41]=> string(15) "gemsforum_forum" [42]=> string(22) "gemsforum_forum_notify" [43]=> string(20) "gemsforum_forum_read" [44]=> string(21) "gemsforum_group_cache" [45]=> string(23) "gemsforum_group_members" [46]=> string(25) "gemsforum_group_resources" [47]=> string(16) "gemsforum_groups" [48]=> string(15) "gemsforum_index" [49]=> string(18) "gemsforum_ip_block" [50]=> string(15) "gemsforum_level" [51]=> string(14) "gemsforum_mime" [52]=> string(15) "gemsforum_mlist" [53]=> string(13) "gemsforum_mod" [54]=> string(17) "gemsforum_mod_que" [55]=> string(13) "gemsforum_msg" [56]=> string(20) "gemsforum_msg_report" [57]=> string(14) "gemsforum_nntp" [58]=> string(14) "gemsforum_pmsg" [59]=> string(14) "gemsforum_poll" [60]=> string(18) "gemsforum_poll_opt" [61]=> string(24) "gemsforum_poll_opt_track" [62]=> string(14) "gemsforum_read" [63]=> string(17) "gemsforum_replace" [64]=> string(16) "gemsforum_search" [65]=> string(22) "gemsforum_search_cache" [66]=> string(13) "gemsforum_ses" [67]=> string(16) "gemsforum_smiley" [68]=> string(21) "gemsforum_stats_cache" [69]=> string(16) "gemsforum_themes" [70]=> string(22) "gemsforum_thr_exchange" [71]=> string(16) "gemsforum_thread" [72]=> string(23) "gemsforum_thread_notify" [73]=> string(27) "gemsforum_thread_rate_track" [74]=> string(21) "gemsforum_thread_view" [75]=> string(21) "gemsforum_title_index" [76]=> string(21) "gemsforum_tmp_consist" [77]=> string(21) "gemsforum_user_ignore" [78]=> string(15) "gemsforum_users" } Locked!

Report message to a moderator