SELECT s.id AS sid, s.ses_id, s.data, s.returnto, s.sys_id, t.id AS theme_id, t.lang, t.name AS theme_name, t.locale, t.theme, t.pspell_lang, t.theme_opt, u.alias, u.posts_ppg, u.time_zone, u.sig, u.last_visit, u.last_read, u.cat_collapse_status, u.users_opt, u.ignore_list, u.ignore_list, u.buddy_list, u.id, u.group_leader_list, u.email, u.login, u.sq FROM fud26_ses s INNER JOIN fud26_users u ON u.id=(CASE WHEN s.user_id>2000000000 THEN 1 ELSE s.user_id END) INNER JOIN fud26_themes t ON t.id=u.theme WHERE s.ses_id='9e9e3f9316ecacac009c187e554bd479'
query count: 1 time taken: 0.002581
Affected rows: 1
total sql time: 0.002581
UPDATE fud26_users SET last_visit=1106113466 WHERE id=3
query count: 2 time taken: 0.001156
Affected rows: 1
total sql time: 0.003737
Return To Forum  
Admin Control Panel 
Checks/Consistency
Forum Consistency
Rebuild Search Index
Compact Messages

General Management
Global Settings Manager
Replacement & Censorship System
MIME Managment System
RDF Feed Managment
PDF Generation Managment
Forum Statistics
Action Log Viewer
Error Log Viewer
System Info

Forum Management
Category & Forum Management
Deleted Forums
Announcement Manager
Topic Pruning
Attachment Pruning
Mailing List Manager
Newsgroup Manager

User Management
Moderator/User Manager
Add User
Account Approval
Groups Manager
Mass Email
Rank Manager

Template Management
Theme Manager
Template Editor
Message Editor

Icon Management
Smiley Manager
Forum Icon Manager
Message Icon Manager

Avatar Management
Avatar Approval
Avatar Manager

Filters
Email filter
IP filter
Login filter
File filter

Forum Data Management
Make forum datadump
Import forum data
 
 Disabling the forum for the duration of maintenance run
Locking the database for checking

DROP TABLE IF EXISTS fud26_tmp_consist
query count: 3 time taken: 0.001069
Affected rows: 0
total sql time: 0.004806
CREATE TABLE fud26_tmp_consist (p INT, ps INT UNSIGNED, c INT)
query count: 4 time taken: 0.083953
Affected rows: 0
total sql time: 0.088759
SHOW TABLES LIKE 'fud26\_%'
query count: 5 time taken: 0.008603
Affected rows: 68
total sql time: 0.097362
LOCK TABLES fud26_action_log WRITE, fud26_ann_forums WRITE, fud26_announce WRITE, fud26_attach WRITE, fud26_avatar WRITE, fud26_blocked_logins WRITE, fud26_buddy WRITE, fud26_cat WRITE, fud26_custom_tags WRITE, fud26_email_block WRITE, fud26_ext_block WRITE, fud26_fc_view WRITE, fud26_fl_1 WRITE, fud26_fl_10 WRITE, fud26_fl_11 WRITE, fud26_fl_12 WRITE, fud26_fl_13 WRITE, fud26_fl_14 WRITE, fud26_fl_15 WRITE, fud26_fl_16 WRITE, fud26_fl_17 WRITE, fud26_fl_2 WRITE, fud26_fl_3 WRITE, fud26_fl_4 WRITE, fud26_fl_5 WRITE, fud26_fl_6 WRITE, fud26_fl_7 WRITE, fud26_fl_8 WRITE, fud26_fl_9 WRITE, fud26_fl_pm WRITE, fud26_forum WRITE, fud26_forum_notify WRITE, fud26_forum_read WRITE, fud26_group_cache WRITE, fud26_group_members WRITE, fud26_group_resources WRITE, fud26_groups WRITE, fud26_index WRITE, fud26_ip_block WRITE, fud26_level WRITE, fud26_mime WRITE, fud26_mlist WRITE, fud26_mod WRITE, fud26_mod_que WRITE, fud26_msg WRITE, fud26_msg_report WRITE, fud26_nntp WRITE, fud26_pmsg WRITE, fud26_poll WRITE, fud26_poll_opt WRITE, fud26_poll_opt_track WRITE, fud26_read WRITE, fud26_replace WRITE, fud26_search WRITE, fud26_search_cache WRITE, fud26_ses WRITE, fud26_smiley WRITE, fud26_stats_cache WRITE, fud26_themes WRITE, fud26_thr_exchange WRITE, fud26_thread WRITE, fud26_thread_notify WRITE, fud26_thread_rate_track WRITE, fud26_thread_view WRITE, fud26_title_index WRITE, fud26_tmp_consist WRITE, fud26_user_ignore WRITE, fud26_users WRITE, fud26_users u WRITE, fud26_forum f WRITE, fud26_thread t WRITE, fud26_poll p WRITE, fud26_poll_opt po WRITE, fud26_poll_opt_track pot WRITE, fud26_msg m WRITE, fud26_pmsg pm WRITE, fud26_mod mm WRITE, fud26_thread_rate_track trt WRITE, fud26_msg_report mr WRITE, fud26_cat c WRITE, fud26_forum_notify fn WRITE, fud26_thread_notify tn WRITE, fud26_buddy b WRITE, fud26_user_ignore i WRITE, fud26_msg m1 WRITE, fud26_msg m2 WRITE, fud26_users u1 WRITE, fud26_users u2 WRITE, fud26_attach a WRITE, fud26_thr_exchange te WRITE, fud26_read r WRITE, fud26_mime mi WRITE, fud26_group_members gm WRITE, fud26_group_resources gr WRITE, fud26_groups g WRITE, fud26_group_members gm1 WRITE, fud26_group_members gm2 WRITE, fud26_themes thm WRITE
query count: 6 time taken: 0.099705
Affected rows: 0
total sql time: 0.197067
Locked!
Validating category order

SELECT id, view_order, parent FROM fud26_cat ORDER BY parent, view_order, id
query count: 7 time taken: 0.001704
Affected rows: 3
total sql time: 0.198771
Done: Validating category order
Checking if moderator and users table match

SELECT mm.id FROM fud26_mod mm LEFT JOIN fud26_users u ON mm.user_id=u.id LEFT JOIN fud26_forum f ON f.id=mm.forum_id WHERE u.id IS NULL OR f.id IS NULL
query count: 8 time taken: 0.001809
Affected rows: 0
total sql time: 0.20058
OK
Rebuilding moderators

SELECT u.id, u.alias, f.id FROM fud26_mod mm INNER JOIN fud26_users u ON mm.user_id=u.id INNER JOIN fud26_forum f ON f.id=mm.forum_id ORDER BY f.id,u.alias
query count: 9 time taken: 0.002607
Affected rows: 20
total sql time: 0.203187
UPDATE fud26_forum SET moderators=NULL
query count: 10 time taken: 0.002104
Affected rows: 10
total sql time: 0.205291
UPDATE fud26_forum SET moderators='a:2:{i:4;s:5:\"Draco\";i:6;s:10:\"He Hate Me\";}' WHERE id=2
query count: 11 time taken: 0.000858
Affected rows: 1
total sql time: 0.206149
UPDATE fud26_forum SET moderators='a:2:{i:4;s:5:\"Draco\";i:6;s:10:\"He Hate Me\";}' WHERE id=3
query count: 12 time taken: 0.000812
Affected rows: 1
total sql time: 0.206961
UPDATE fud26_forum SET moderators='a:2:{i:4;s:5:\"Draco\";i:6;s:10:\"He Hate Me\";}' WHERE id=4
query count: 13 time taken: 0.000814
Affected rows: 1
total sql time: 0.207775
UPDATE fud26_forum SET moderators='a:2:{i:4;s:5:\"Draco\";i:6;s:10:\"He Hate Me\";}' WHERE id=5
query count: 14 time taken: 0.00081
Affected rows: 1
total sql time: 0.208585
UPDATE fud26_forum SET moderators='a:2:{i:4;s:5:\"Draco\";i:6;s:10:\"He Hate Me\";}' WHERE id=6
query count: 15 time taken: 0.000807
Affected rows: 1
total sql time: 0.209392
UPDATE fud26_forum SET moderators='a:2:{i:4;s:5:\"Draco\";i:6;s:10:\"He Hate Me\";}' WHERE id=7
query count: 16 time taken: 0.000807
Affected rows: 1
total sql time: 0.210199
UPDATE fud26_forum SET moderators='a:2:{i:4;s:5:\"Draco\";i:6;s:10:\"He Hate Me\";}' WHERE id=8
query count: 17 time taken: 0.00081
Affected rows: 1
total sql time: 0.211009
UPDATE fud26_forum SET moderators='a:2:{i:4;s:5:\"Draco\";i:6;s:10:\"He Hate Me\";}' WHERE id=9
query count: 18 time taken: 0.000808
Affected rows: 1
total sql time: 0.211817
UPDATE fud26_forum SET moderators='a:2:{i:4;s:5:\"Draco\";i:6;s:10:\"He Hate Me\";}' WHERE id=10
query count: 19 time taken: 0.000808
Affected rows: 1
total sql time: 0.212625
UPDATE fud26_forum SET moderators='a:2:{i:4;s:5:\"Draco\";i:6;s:10:\"He Hate Me\";}' WHERE id=11
query count: 20 time taken: 0.0008
Affected rows: 1
total sql time: 0.213425
UPDATE fud26_users SET users_opt=users_opt & ~ 524288 WHERE users_opt>=524288 AND (users_opt & 524288) > 0
query count: 21 time taken: 0.002352
Affected rows: 2
total sql time: 0.215777
UPDATE fud26_users SET users_opt=users_opt|524288 WHERE id IN(4,6,4,6,4,6,4,6,4,6,4,6,4,6,4,6,4,6,4,6) AND (users_opt & 1048576)=0
query count: 22 time taken: 0.001353
Affected rows: 2
total sql time: 0.21713
Done: Rebuilding moderators
Checking if all private messages have users

SELECT pm.id FROM fud26_pmsg pm LEFT JOIN fud26_users u ON u.id=pm.ouser_id LEFT JOIN fud26_users u2 ON u2.id=pm.duser_id WHERE (pm.pmsg_opt & 16) > 0 AND (u.id IS NULL OR u2.id IS NULL)
query count: 23 time taken: 0.001824
Affected rows: 0
total sql time: 0.218954
OK
Checking messages against users & threads

SELECT m.id FROM fud26_msg m LEFT JOIN fud26_users u ON u.id=m.poster_id LEFT JOIN fud26_thread t ON t.id=m.thread_id LEFT JOIN fud26_forum f ON f.id=t.forum_id WHERE (m.poster_id!=0 AND u.id IS NULL) OR t.id IS NULL OR f.id IS NULL
query count: 24 time taken: 0.026929
Affected rows: 0
total sql time: 0.245883
OK
Checking threads against forums

SELECT t.id FROM fud26_thread t LEFT JOIN fud26_forum f ON f.id=t.forum_id WHERE f.id IS NULL
query count: 25 time taken: 0.001785
Affected rows: 0
total sql time: 0.247668
OK
Checking message approvals

SELECT m.id FROM fud26_msg m INNER JOIN fud26_thread t ON m.thread_id=t.id INNER JOIN fud26_forum f ON t.forum_id=f.id WHERE m.apr=0 AND (f.forum_opt & 2) > 0
query count: 26 time taken: 0.001087
Affected rows: 0
total sql time: 0.248755
Done: Checking message approvals
Checking threads against messages

UPDATE fud26_thread SET replies=0
query count: 27 time taken: 0.003656
Affected rows: 51
total sql time: 0.252411
SELECT m.thread_id, t.id, count(*) as cnt FROM fud26_thread t LEFT JOIN fud26_msg m ON t.id=m.thread_id WHERE m.apr=1 GROUP BY m.thread_id,t.id ORDER BY cnt
query count: 28 time taken: 0.008382
Affected rows: 67
total sql time: 0.260793
UPDATE fud26_thread SET replies=1 WHERE id IN(1,19,47,49,35,38,11,40,59,73,16,61)
query count: 29 time taken: 0.002144
Affected rows: 12
total sql time: 0.262937
UPDATE fud26_thread SET replies=2 WHERE id IN(45,65,34,7,13,75)
query count: 30 time taken: 0.001278
Affected rows: 6
total sql time: 0.264215
UPDATE fud26_thread SET replies=3 WHERE id IN(64,33,53,25,39,72,17)
query count: 31 time taken: 0.001355
Affected rows: 7
total sql time: 0.26557
UPDATE fud26_thread SET replies=4 WHERE id IN(3,24,54,10,41)
query count: 32 time taken: 0.001142
Affected rows: 5
total sql time: 0.266712
UPDATE fud26_thread SET replies=5 WHERE id IN(32,22,36,37,56,74,30)
query count: 33 time taken: 0.001363
Affected rows: 7
total sql time: 0.268075
UPDATE fud26_thread SET replies=11 WHERE id IN(2)
query count: 34 time taken: 0.000737
Affected rows: 1
total sql time: 0.268812
UPDATE fud26_thread SET replies=12 WHERE id IN(20,21)
query count: 35 time taken: 0.00084
Affected rows: 2
total sql time: 0.269652
UPDATE fud26_thread SET replies=16 WHERE id IN(8)
query count: 36 time taken: 0.000736
Affected rows: 1
total sql time: 0.270388
UPDATE fud26_thread SET replies=17 WHERE id IN(44,18)
query count: 37 time taken: 0.000841
Affected rows: 2
total sql time: 0.271229
UPDATE fud26_thread SET replies=20 WHERE id IN(28)
query count: 38 time taken: 0.000733
Affected rows: 1
total sql time: 0.271962
UPDATE fud26_thread SET replies=21 WHERE id IN(43)
query count: 39 time taken: 0.000743
Affected rows: 1
total sql time: 0.272705
UPDATE fud26_thread SET replies=25 WHERE id IN(27)
query count: 40 time taken: 0.000736
Affected rows: 1
total sql time: 0.273441
UPDATE fud26_thread SET replies=26 WHERE id IN(5)
query count: 41 time taken: 0.000737
Affected rows: 1
total sql time: 0.274178
UPDATE fud26_thread SET replies=27 WHERE id IN(29)
query count: 42 time taken: 0.000738
Affected rows: 1
total sql time: 0.274916
UPDATE fud26_thread SET replies=28 WHERE id IN(26)
query count: 43 time taken: 0.000941
Affected rows: 1
total sql time: 0.275857
UPDATE fud26_thread SET replies=35 WHERE id IN(4)
query count: 44 time taken: 0.000743
Affected rows: 1
total sql time: 0.2766
UPDATE fud26_thread SET replies=36 WHERE id IN(23)
query count: 45 time taken: 0.000741
Affected rows: 1
total sql time: 0.277341
OK
Checking thread last & first post ids

SELECT m1.id, m2.id, t.id FROM fud26_thread t LEFT JOIN fud26_msg m1 ON t.root_msg_id=m1.id LEFT JOIN fud26_msg m2 ON t.last_post_id=m2.id WHERE m1.id IS NULL or m2.id IS NULL
query count: 46 time taken: 0.002936
Affected rows: 0
total sql time: 0.280277
Done: Checking thread last & first post ids
Checking forum & topic relations

SELECT id FROM fud26_forum
query count: 47 time taken: 0.001092
Affected rows: 17
total sql time: 0.281369
select SUM(replies), COUNT(*) FROM fud26_thread t INNER JOIN fud26_msg m ON t.root_msg_id=m.id AND m.apr=1 WHERE t.forum_id=1
query count: 48 time taken: 0.00137
Affected rows: 1
total sql time: 0.282739
SELECT MAX(last_post_id) FROM fud26_thread WHERE forum_id=1 AND moved_to=0
query count: 49 time taken: 0.000972
Affected rows: 1
total sql time: 0.283711
UPDATE fud26_forum SET thread_count=1, post_count=2, last_post_id=2 WHERE id=1
query count: 50 time taken: 0.000743
Affected rows: 0
total sql time: 0.284454
select SUM(replies), COUNT(*) FROM fud26_thread t INNER JOIN fud26_msg m ON t.root_msg_id=m.id AND m.apr=1 WHERE t.forum_id=2
query count: 51 time taken: 0.002409
Affected rows: 1
total sql time: 0.286863
SELECT MAX(last_post_id) FROM fud26_thread WHERE forum_id=2 AND moved_to=0
query count: 52 time taken: 0.001186
Affected rows: 1
total sql time: 0.288049
UPDATE fud26_forum SET thread_count=16, post_count=191, last_post_id=473 WHERE id=2
query count: 53 time taken: 0.000732
Affected rows: 0
total sql time: 0.288781
select SUM(replies), COUNT(*) FROM fud26_thread t INNER JOIN fud26_msg m ON t.root_msg_id=m.id AND m.apr=1 WHERE t.forum_id=3
query count: 54 time taken: 0.002239
Affected rows: 1
total sql time: 0.29102
SELECT MAX(last_post_id) FROM fud26_thread WHERE forum_id=3 AND moved_to=0
query count: 55 time taken: 0.001174
Affected rows: 1
total sql time: 0.292194
UPDATE fud26_forum SET thread_count=14, post_count=62, last_post_id=470 WHERE id=3
query count: 56 time taken: 0.000781
Affected rows: 0
total sql time: 0.292975
select SUM(replies), COUNT(*) FROM fud26_thread t INNER JOIN fud26_msg m ON t.root_msg_id=m.id AND m.apr=1 WHERE t.forum_id=4
query count: 57 time taken: 0.001267
Affected rows: 1
total sql time: 0.294242
SELECT MAX(last_post_id) FROM fud26_thread WHERE forum_id=4 AND moved_to=0
query count: 58 time taken: 0.000975
Affected rows: 1
total sql time: 0.295217
UPDATE fud26_forum SET thread_count=1, post_count=3, last_post_id=252 WHERE id=4
query count: 59 time taken: 0.00073
Affected rows: 0
total sql time: 0.295947
select SUM(replies), COUNT(*) FROM fud26_thread t INNER JOIN fud26_msg m ON t.root_msg_id=m.id AND m.apr=1 WHERE t.forum_id=5
query count: 60 time taken: 0.00147
Affected rows: 1
total sql time: 0.297417
SELECT MAX(last_post_id) FROM fud26_thread WHERE forum_id=5 AND moved_to=0
query count: 61 time taken: 0.001021
Affected rows: 1
total sql time: 0.298438
UPDATE fud26_forum SET thread_count=3, post_count=65, last_post_id=424 WHERE id=5
query count: 62 time taken: 0.000791
Affected rows: 0
total sql time: 0.299229
select SUM(replies), COUNT(*) FROM fud26_thread t INNER JOIN fud26_msg m ON t.root_msg_id=m.id AND m.apr=1 WHERE t.forum_id=6
query count: 63 time taken: 0.0022
Affected rows: 1
total sql time: 0.301429
SELECT MAX(last_post_id) FROM fud26_thread WHERE forum_id=6 AND moved_to=0
query count: 64 time taken: 0.001155
Affected rows: 1
total sql time: 0.302584
UPDATE fud26_forum SET thread_count=13, post_count=71, last_post_id=467 WHERE id=6
query count: 65 time taken: 0.000732
Affected rows: 0
total sql time: 0.303316
select SUM(replies), COUNT(*) FROM fud26_thread t INNER JOIN fud26_msg m ON t.root_msg_id=m.id AND m.apr=1 WHERE t.forum_id=7
query count: 66 time taken: 0.001254
Affected rows: 1
total sql time: 0.30457
SELECT MAX(last_post_id) FROM fud26_thread WHERE forum_id=7 AND moved_to=0
query count: 67 time taken: 0.000961
Affected rows: 1
total sql time: 0.305531
UPDATE fud26_forum SET thread_count=1, post_count=5, last_post_id=249 WHERE id=7
query count: 68 time taken: 0.000729
Affected rows: 0
total sql time: 0.30626
select SUM(replies), COUNT(*) FROM fud26_thread t INNER JOIN fud26_msg m ON t.root_msg_id=m.id AND m.apr=1 WHERE t.forum_id=8
query count: 69 time taken: 0.001403
Affected rows: 1
total sql time: 0.307663
SELECT MAX(last_post_id) FROM fud26_thread WHERE forum_id=8 AND moved_to=0
query count: 70 time taken: 0.000995
Affected rows: 1
total sql time: 0.308658
UPDATE fud26_forum SET thread_count=3, post_count=12, last_post_id=428 WHERE id=8
query count: 71 time taken: 0.000739
Affected rows: 0
total sql time: 0.309397
select SUM(replies), COUNT(*) FROM fud26_thread t INNER JOIN fud26_msg m ON t.root_msg_id=m.id AND m.apr=1 WHERE t.forum_id=9
query count: 72 time taken: 0.001632
Affected rows: 1
total sql time: 0.311029
SELECT MAX(last_post_id) FROM fud26_thread WHERE forum_id=9 AND moved_to=0
query count: 73 time taken: 0.001043
Affected rows: 1
total sql time: 0.312072
UPDATE fud26_forum SET thread_count=6, post_count=17, last_post_id=472 WHERE id=9
query count: 74 time taken: 0.000727
Affected rows: 0
total sql time: 0.312799
select SUM(replies), COUNT(*) FROM fud26_thread t INNER JOIN fud26_msg m ON t.root_msg_id=m.id AND m.apr=1 WHERE t.forum_id=10
query count: 75 time taken: 0.001319
Affected rows: 1
total sql time: 0.314118
SELECT MAX(last_post_id) FROM fud26_thread WHERE forum_id=10 AND moved_to=0
query count: 76 time taken: 0.000983
Affected rows: 1
total sql time: 0.315101
UPDATE fud26_forum SET thread_count=2, post_count=26, last_post_id=397 WHERE id=10
query count: 77 time taken: 0.000814
Affected rows: 0
total sql time: 0.315915
select SUM(replies), COUNT(*) FROM fud26_thread t INNER JOIN fud26_msg m ON t.root_msg_id=m.id AND m.apr=1 WHERE t.forum_id=11
query count: 78 time taken: 0.001861
Affected rows: 1
total sql time: 0.317776
SELECT MAX(last_post_id) FROM fud26_thread WHERE forum_id=11 AND moved_to=0
query count: 79 time taken: 0.001072
Affected rows: 1
total sql time: 0.318848
UPDATE fud26_forum SET thread_count=7, post_count=16, last_post_id=458 WHERE id=11
query count: 80 time taken: 0.000731
Affected rows: 0
total sql time: 0.319579
select SUM(replies), COUNT(*) FROM fud26_thread t INNER JOIN fud26_msg m ON t.root_msg_id=m.id AND m.apr=1 WHERE t.forum_id=12
query count: 81 time taken: 0.001284
Affected rows: 1
total sql time: 0.320863
UPDATE fud26_forum SET thread_count=0, post_count=0, last_post_id=0 WHERE id=12
query count: 82 time taken: 0.000761
Affected rows: 0
total sql time: 0.321624
select SUM(replies), COUNT(*) FROM fud26_thread t INNER JOIN fud26_msg m ON t.root_msg_id=m.id AND m.apr=1 WHERE t.forum_id=13
query count: 83 time taken: 0.001092
Affected rows: 1
total sql time: 0.322716
UPDATE fud26_forum SET thread_count=0, post_count=0, last_post_id=0 WHERE id=13
query count: 84 time taken: 0.00072
Affected rows: 0
total sql time: 0.323436
select SUM(replies), COUNT(*) FROM fud26_thread t INNER JOIN fud26_msg m ON t.root_msg_id=m.id AND m.apr=1 WHERE t.forum_id=14
query count: 85 time taken: 0.001091
Affected rows: 1
total sql time: 0.324527
UPDATE fud26_forum SET thread_count=0, post_count=0, last_post_id=0 WHERE id=14
query count: 86 time taken: 0.000723
Affected rows: 0
total sql time: 0.32525
select SUM(replies), COUNT(*) FROM fud26_thread t INNER JOIN fud26_msg m ON t.root_msg_id=m.id AND m.apr=1 WHERE t.forum_id=15
query count: 87 time taken: 0.001101
Affected rows: 1
total sql time: 0.326351
UPDATE fud26_forum SET thread_count=0, post_count=0, last_post_id=0 WHERE id=15
query count: 88 time taken: 0.000723
Affected rows: 0
total sql time: 0.327074
select SUM(replies), COUNT(*) FROM fud26_thread t INNER JOIN fud26_msg m ON t.root_msg_id=m.id AND m.apr=1 WHERE t.forum_id=16
query count: 89 time taken: 0.001086
Affected rows: 1
total sql time: 0.32816
UPDATE fud26_forum SET thread_count=0, post_count=0, last_post_id=0 WHERE id=16
query count: 90 time taken: 0.00072
Affected rows: 0
total sql time: 0.32888
select SUM(replies), COUNT(*) FROM fud26_thread t INNER JOIN fud26_msg m ON t.root_msg_id=m.id AND m.apr=1 WHERE t.forum_id=17
query count: 91 time taken: 0.001085
Affected rows: 1
total sql time: 0.329965
UPDATE fud26_forum SET thread_count=0, post_count=0, last_post_id=0 WHERE id=17
query count: 92 time taken: 0.000719
Affected rows: 0
total sql time: 0.330684
Done: Checking forum & topic relations
Validating Forum Order

SELECT id, cat_id, view_order FROM fud26_forum WHERE cat_id>0 ORDER BY cat_id, view_order
query count: 93 time taken: 0.001869
Affected rows: 10
total sql time: 0.332553
Done: Validating Forum Order
Checking for presence of forum lock tables

SELECT id FROM fud26_forum
query count: 94 time taken: 0.0011
Affected rows: 17
total sql time: 0.333653
Done: Checking for presence of forum lock tables
Checking thread_exchange

SELECT te.id FROM fud26_thr_exchange te LEFT JOIN fud26_thread t ON t.id=te.th LEFT JOIN fud26_forum f ON f.id=te.frm WHERE t.id IS NULL or f.id IS NULL
query count: 95 time taken: 0.000815
Affected rows: 0
total sql time: 0.334468
OK
Checking read table against users & threads

SELECT r.id FROM fud26_read r LEFT JOIN fud26_users u ON r.user_id=u.id LEFT JOIN fud26_thread t ON r.thread_id=t.id WHERE t.id IS NULL OR u.id IS NULL
query count: 96 time taken: 0.007481
Affected rows: 0
total sql time: 0.341949
OK
Checking file attachments against messages

SELECT a.id FROM fud26_attach a LEFT JOIN fud26_msg m ON a.message_id=m.id WHERE m.id IS NULL AND attach_opt=0
query count: 97 time taken: 0.00131
Affected rows: 0
total sql time: 0.343259
SELECT a.id FROM fud26_attach a LEFT JOIN fud26_pmsg pm ON a.message_id=pm.id WHERE pm.id IS NULL AND attach_opt=1
query count: 98 time taken: 0.001075
Affected rows: 0
total sql time: 0.344334
OK
Rebuild attachment cache for regular messages

UPDATE fud26_msg SET attach_cnt=0, attach_cache=NULL
query count: 99 time taken: 0.015719
Affected rows: 5
total sql time: 0.360053
SELECT a.id, a.original_name, a.fsize, a.dlcount, CASE WHEN mi.icon IS NULL THEN 'unknown.gif' ELSE mi.icon END, a.message_id FROM fud26_attach a LEFT JOIN fud26_mime mi ON a.mime_type=mi.id WHERE attach_opt=0
query count: 100 time taken: 0.001673
Affected rows: 5
total sql time: 0.361726
UPDATE fud26_msg SET attach_cnt=1, attach_cache='a:1:{i:0;a:5:{i:0;s:1:\"2\";i:1;s:17:\"cs_office0004.jpg\";i:2;s:6:\"158991\";i:3;s:2:\"48\";i:4;s:9:\"image.gif\";}}' WHERE id=463
query count: 101 time taken: 0.000994
Affected rows: 1
total sql time: 0.36272
UPDATE fud26_msg SET attach_cnt=1, attach_cache='a:1:{i:0;a:5:{i:0;s:1:\"3\";i:1;s:17:\"cs_office0005.jpg\";i:2;s:6:\"154604\";i:3;s:2:\"38\";i:4;s:9:\"image.gif\";}}' WHERE id=464
query count: 102 time taken: 0.000923
Affected rows: 1
total sql time: 0.363643
UPDATE fud26_msg SET attach_cnt=1, attach_cache='a:1:{i:0;a:5:{i:0;s:1:\"4\";i:1;s:17:\"cs_office0006.jpg\";i:2;s:6:\"132644\";i:3;s:2:\"33\";i:4;s:9:\"image.gif\";}}' WHERE id=465
query count: 103 time taken: 0.000994
Affected rows: 1
total sql time: 0.364637
UPDATE fud26_msg SET attach_cnt=1, attach_cache='a:1:{i:0;a:5:{i:0;s:1:\"5\";i:1;s:17:\"cs_office0009.jpg\";i:2;s:6:\"141091\";i:3;s:2:\"31\";i:4;s:9:\"image.gif\";}}' WHERE id=466
query count: 104 time taken: 0.000921
Affected rows: 1
total sql time: 0.365558
UPDATE fud26_msg SET attach_cnt=1, attach_cache='a:1:{i:0;a:5:{i:0;s:1:\"6\";i:1;s:15:\"cs_office10.jpg\";i:2;s:6:\"150044\";i:3;s:2:\"33\";i:4;s:9:\"image.gif\";}}' WHERE id=467
query count: 105 time taken: 0.000897
Affected rows: 1
total sql time: 0.366455
Done: Rebuild attachment cache for regular messages
Rebuild attachment cache for private messages

UPDATE fud26_pmsg SET attach_cnt=0
query count: 106 time taken: 0.001044
Affected rows: 0
total sql time: 0.367499
SELECT count(*), message_id FROM fud26_attach WHERE attach_opt=1 GROUP BY message_id
query count: 107 time taken: 0.000905
Affected rows: 0
total sql time: 0.368404
Done: Rebuild attachment cache for private messages
Checking message reports

SELECT mr.id FROM fud26_msg_report mr LEFT JOIN fud26_msg m ON mr.msg_id=m.id WHERE m.id IS NULL
query count: 108 time taken: 0.000738
Affected rows: 0
total sql time: 0.369142
OK
Checking polls against messages

SELECT p.id, m.id FROM fud26_poll p LEFT JOIN fud26_msg m ON p.id=m.poll_id WHERE m.id IS NULL OR p.id IS NULL
query count: 109 time taken: 0.002231
Affected rows: 0
total sql time: 0.371373
OK
Checking polls options against polls

SELECT po.id FROM fud26_poll_opt po LEFT JOIN fud26_poll p ON p.id=po.poll_id WHERE p.id IS NULL
query count: 110 time taken: 0.001417
Affected rows: 0
total sql time: 0.37279
OK
Checking polls votes

SELECT pot.id FROM fud26_poll_opt_track pot LEFT JOIN fud26_poll p ON p.id=pot.poll_id LEFT JOIN fud26_poll_opt po ON po.id=pot.poll_opt LEFT JOIN fud26_users u ON u.id=pot.user_id WHERE u.id IS NULL OR po.id IS NULL OR p.id IS NULL
query count: 111 time taken: 0.004107
Affected rows: 0
total sql time: 0.376897
OK
Rebuilding poll cache

UPDATE fud26_poll_opt SET count=0
query count: 112 time taken: 0.00403
Affected rows: 44
total sql time: 0.380927
SELECT poll_opt, count(*) FROM fud26_poll_opt_track GROUP BY poll_opt
query count: 113 time taken: 0.002832
Affected rows: 44
total sql time: 0.383759
UPDATE fud26_poll_opt SET count=1 WHERE id=1
query count: 114 time taken: 0.000865
Affected rows: 1
total sql time: 0.384624
UPDATE fud26_poll_opt SET count=5 WHERE id=4
query count: 115 time taken: 0.000731
Affected rows: 1
total sql time: 0.385355
UPDATE fud26_poll_opt SET count=4 WHERE id=5
query count: 116 time taken: 0.000727
Affected rows: 1
total sql time: 0.386082
UPDATE fud26_poll_opt SET count=3 WHERE id=12
query count: 117 time taken: 0.000726
Affected rows: 1
total sql time: 0.386808
UPDATE fud26_poll_opt SET count=3 WHERE id=13
query count: 118 time taken: 0.000727
Affected rows: 1
total sql time: 0.387535
UPDATE fud26_poll_opt SET count=2 WHERE id=14
query count: 119 time taken: 0.000726
Affected rows: 1
total sql time: 0.388261
UPDATE fud26_poll_opt SET count=2 WHERE id=15
query count: 120 time taken: 0.000719
Affected rows: 1
total sql time: 0.38898
UPDATE fud26_poll_opt SET count=5 WHERE id=33
query count: 121 time taken: 0.000727
Affected rows: 1
total sql time: 0.389707
UPDATE fud26_poll_opt SET count=1 WHERE id=35
query count: 122 time taken: 0.000727
Affected rows: 1
total sql time: 0.390434
UPDATE fud26_poll_opt SET count=1 WHERE id=36
query count: 123 time taken: 0.000725
Affected rows: 1
total sql time: 0.391159
UPDATE fud26_poll_opt SET count=4 WHERE id=37
query count: 124 time taken: 0.000725
Affected rows: 1
total sql time: 0.391884
UPDATE fud26_poll_opt SET count=1 WHERE id=38
query count: 125 time taken: 0.000727
Affected rows: 1
total sql time: 0.392611
UPDATE fud26_poll_opt SET count=5 WHERE id=44
query count: 126 time taken: 0.000725
Affected rows: 1
total sql time: 0.393336
UPDATE fud26_poll_opt SET count=1 WHERE id=45
query count: 127 time taken: 0.000727
Affected rows: 1
total sql time: 0.394063
UPDATE fud26_poll_opt SET count=1 WHERE id=48
query count: 128 time taken: 0.000733
Affected rows: 1
total sql time: 0.394796
UPDATE fud26_poll_opt SET count=2 WHERE id=49
query count: 129 time taken: 0.001642
Affected rows: 1
total sql time: 0.396438
UPDATE fud26_poll_opt SET count=4 WHERE id=50
query count: 130 time taken: 0.000725
Affected rows: 1
total sql time: 0.397163
UPDATE fud26_poll_opt SET count=2 WHERE id=54
query count: 131 time taken: 0.000727
Affected rows: 1
total sql time: 0.39789
UPDATE fud26_poll_opt SET count=5 WHERE id=55
query count: 132 time taken: 0.00072
Affected rows: 1
total sql time: 0.39861
UPDATE fud26_poll_opt SET count=2 WHERE id=57
query count: 133 time taken: 0.000731
Affected rows: 1
total sql time: 0.399341
UPDATE fud26_poll_opt SET count=3 WHERE id=59
query count: 134 time taken: 0.000727
Affected rows: 1
total sql time: 0.400068
UPDATE fud26_poll_opt SET count=1 WHERE id=60
query count: 135 time taken: 0.000719
Affected rows: 1
total sql time: 0.400787
UPDATE fud26_poll_opt SET count=2 WHERE id=61
query count: 136 time taken: 0.000928
Affected rows: 1
total sql time: 0.401715
UPDATE fud26_poll_opt SET count=1 WHERE id=62
query count: 137 time taken: 0.000721
Affected rows: 1
total sql time: 0.402436
UPDATE fud26_poll_opt SET count=4 WHERE id=63
query count: 138 time taken: 0.00072
Affected rows: 1
total sql time: 0.403156
UPDATE fud26_poll_opt SET count=1 WHERE id=64
query count: 139 time taken: 0.000719
Affected rows: 1
total sql time: 0.403875
UPDATE fud26_poll_opt SET count=3 WHERE id=65
query count: 140 time taken: 0.000716
Affected rows: 1
total sql time: 0.404591
UPDATE fud26_poll_opt SET count=5 WHERE id=66
query count: 141 time taken: 0.000717
Affected rows: 1
total sql time: 0.405308
UPDATE fud26_poll_opt SET count=4 WHERE id=67
query count: 142 time taken: 0.000718
Affected rows: 1
total sql time: 0.406026
UPDATE fud26_poll_opt SET count=3 WHERE id=68
query count: 143 time taken: 0.001092
Affected rows: 1
total sql time: 0.407118
UPDATE fud26_poll_opt SET count=3 WHERE id=69
query count: 144 time taken: 0.000741
Affected rows: 1
total sql time: 0.407859
UPDATE fud26_poll_opt SET count=5 WHERE id=71
query count: 145 time taken: 0.000725
Affected rows: 1
total sql time: 0.408584
UPDATE fud26_poll_opt SET count=2 WHERE id=75
query count: 146 time taken: 0.000722
Affected rows: 1
total sql time: 0.409306
UPDATE fud26_poll_opt SET count=2 WHERE id=76
query count: 147 time taken: 0.000723
Affected rows: 1
total sql time: 0.410029
UPDATE fud26_poll_opt SET count=1 WHERE id=77
query count: 148 time taken: 0.000724
Affected rows: 1
total sql time: 0.410753
UPDATE fud26_poll_opt SET count=3 WHERE id=78
query count: 149 time taken: 0.000724
Affected rows: 1
total sql time: 0.411477
UPDATE fud26_poll_opt SET count=5 WHERE id=79
query count: 150 time taken: 0.000725
Affected rows: 1
total sql time: 0.412202
UPDATE fud26_poll_opt SET count=1 WHERE id=99
query count: 151 time taken: 0.000726
Affected rows: 1
total sql time: 0.412928
UPDATE fud26_poll_opt SET count=3 WHERE id=100
query count: 152 time taken: 0.000713
Affected rows: 1
total sql time: 0.413641
UPDATE fud26_poll_opt SET count=2 WHERE id=101
query count: 153 time taken: 0.000715
Affected rows: 1
total sql time: 0.414356
UPDATE fud26_poll_opt SET count=1 WHERE id=102
query count: 154 time taken: 0.000716
Affected rows: 1
total sql time: 0.415072
UPDATE fud26_poll_opt SET count=3 WHERE id=103
query count: 155 time taken: 0.000717
Affected rows: 1
total sql time: 0.415789
UPDATE fud26_poll_opt SET count=2 WHERE id=105
query count: 156 time taken: 0.000729
Affected rows: 1
total sql time: 0.416518
UPDATE fud26_poll_opt SET count=5 WHERE id=106
query count: 157 time taken: 0.000726
Affected rows: 1
total sql time: 0.417244
SELECT id, name, count, poll_id FROM fud26_poll_opt ORDER BY poll_id
query count: 158 time taken: 0.003866
Affected rows: 64
total sql time: 0.42111
UPDATE fud26_msg SET poll_cache='a:3:{i:1;a:2:{i:0;s:3:\"Red\";i:1;s:1:\"1\";}i:2;a:2:{i:0;s:5:\"Green\";i:1;s:1:\"0\";}i:3;a:2:{i:0;s:4:\"Blue\";i:1;s:1:\"0\";}}' WHERE poll_id=1
query count: 159 time taken: 0.000868
Affected rows: 0
total sql time: 0.421978
UPDATE fud26_poll SET total_votes=1 WHERE id=1
query count: 160 time taken: 0.000907
Affected rows: 0
total sql time: 0.422885
UPDATE fud26_msg SET poll_cache='a:3:{i:4;a:2:{i:0;s:9:\"LAN Party\";i:1;s:1:\"5\";}i:5;a:2:{i:0;s:11:\"Craps Night\";i:1;s:1:\"4\";}i:17;a:2:{i:0;s:14:\"Not Interested\";i:1;s:1:\"0\";}}' WHERE poll_id=2
query count: 161 time taken: 0.000884
Affected rows: 0
total sql time: 0.423769
UPDATE fud26_poll SET total_votes=9 WHERE id=2
query count: 162 time taken: 0.000683
Affected rows: 0
total sql time: 0.424452
UPDATE fud26_msg SET poll_cache='a:5:{i:16;a:2:{i:0;s:14:\"Not Interested\";i:1;s:1:\"0\";}i:15;a:2:{i:0;s:5:\"Other\";i:1;s:1:\"2\";}i:14;a:2:{i:0;s:18:\"Saturday June 12th\";i:1;s:1:\"2\";}i:13;a:2:{i:0;s:16:\"Friday June 11th\";i:1;s:1:\"3\";}i:12;a:2:{i:0;s:17:\"Saturday June 5th\";i:1;s:1:\"3\";}}' WHERE poll_id=5
query count: 163 time taken: 0.000815
Affected rows: 0
total sql time: 0.425267
UPDATE fud26_poll SET total_votes=10 WHERE id=5
query count: 164 time taken: 0.000668
Affected rows: 0
total sql time: 0.425935
UPDATE fud26_msg SET poll_cache='a:4:{i:32;a:2:{i:0;s:20:\"No bangs (old style)\";i:1;s:1:\"0\";}i:33;a:2:{i:0;s:17:\"Bangs (new style)\";i:1;s:1:\"5\";}i:34;a:2:{i:0;s:13:\"No difference\";i:1;s:1:\"0\";}i:35;a:2:{i:0;s:17:\"Nothing will help\";i:1;s:1:\"1\";}}' WHERE poll_id=10
query count: 165 time taken: 0.000799
Affected rows: 0
total sql time: 0.426734
UPDATE fud26_poll SET total_votes=6 WHERE id=10
query count: 166 time taken: 0.000667
Affected rows: 0
total sql time: 0.427401
UPDATE fud26_msg SET poll_cache='a:4:{i:39;a:2:{i:0;s:24:\"Godlike amounts of pizza\";i:1;s:1:\"0\";}i:38;a:2:{i:0;s:17:\"4 Pieces of Pizza\";i:1;s:1:\"1\";}i:37;a:2:{i:0;s:17:\"3 Pieces of Pizza\";i:1;s:1:\"4\";}i:36;a:2:{i:0;s:17:\"2 Pieces of Pizza\";i:1;s:1:\"1\";}}' WHERE poll_id=11
query count: 167 time taken: 0.000801
Affected rows: 0
total sql time: 0.428202
UPDATE fud26_poll SET total_votes=6 WHERE id=11
query count: 168 time taken: 0.000666
Affected rows: 0
total sql time: 0.428868
UPDATE fud26_msg SET poll_cache='a:3:{i:43;a:2:{i:0;s:11:\"Huckleberry\";i:1;s:1:\"0\";}i:44;a:2:{i:0;s:9:\"Totenkopf\";i:1;s:1:\"5\";}i:45;a:2:{i:0;s:10:\"He Hate Me\";i:1;s:1:\"1\";}}' WHERE poll_id=13
query count: 169 time taken: 0.000782
Affected rows: 0
total sql time: 0.42965
UPDATE fud26_poll SET total_votes=6 WHERE id=13
query count: 170 time taken: 0.000667
Affected rows: 0
total sql time: 0.430317
UPDATE fud26_msg SET poll_cache='a:4:{i:51;a:2:{i:0;s:35:\"Null Set - None of them will finish\";i:1;s:1:\"0\";}i:50;a:2:{i:0;s:16:\"Fernando Mendoza\";i:1;s:1:\"4\";}i:49;a:2:{i:0;s:14:\"Anthony Miguel\";i:1;s:1:\"2\";}i:48;a:2:{i:0;s:14:\"Chris Clements\";i:1;s:1:\"1\";}}' WHERE poll_id=15
query count: 171 time taken: 0.000805
Affected rows: 0
total sql time: 0.431122
UPDATE fud26_poll SET total_votes=7 WHERE id=15
query count: 172 time taken: 0.000669
Affected rows: 0
total sql time: 0.431791
UPDATE fud26_msg SET poll_cache='a:4:{i:52;a:2:{i:0;s:5:\"Draco\";i:1;s:1:\"0\";}i:53;a:2:{i:0;s:11:\"Huckleberry\";i:1;s:1:\"0\";}i:54;a:2:{i:0;s:10:\"He Hate Me\";i:1;s:1:\"2\";}i:55;a:2:{i:0;s:9:\"Snakeeyes\";i:1;s:1:\"5\";}}' WHERE poll_id=16
query count: 173 time taken: 0.000794
Affected rows: 0
total sql time: 0.432585
UPDATE fud26_poll SET total_votes=7 WHERE id=16
query count: 174 time taken: 0.000666
Affected rows: 0
total sql time: 0.433251
UPDATE fud26_msg SET poll_cache='a:5:{i:60;a:2:{i:0;s:4:\"Blue\";i:1;s:1:\"1\";}i:59;a:2:{i:0;s:3:\"Red\";i:1;s:1:\"3\";}i:58;a:2:{i:0;s:10:\"Highlights\";i:1;s:1:\"0\";}i:57;a:2:{i:0;s:11:\"Light Brown\";i:1;s:1:\"2\";}i:56;a:2:{i:0;s:6:\"Blonde\";i:1;s:1:\"0\";}}' WHERE poll_id=17
query count: 175 time taken: 0.000796
Affected rows: 0
total sql time: 0.434047
UPDATE fud26_poll SET total_votes=6 WHERE id=17
query count: 176 time taken: 0.000741
Affected rows: 0
total sql time: 0.434788
UPDATE fud26_msg SET poll_cache='a:4:{i:61;a:2:{i:0;s:6:\"Briefs\";i:1;s:1:\"2\";}i:62;a:2:{i:0;s:6:\"Boxers\";i:1;s:1:\"1\";}i:63;a:2:{i:0;s:12:\"Boxer briefs\";i:1;s:1:\"4\";}i:64;a:2:{i:0;s:8:\"Commando\";i:1;s:1:\"1\";}}' WHERE poll_id=18
query count: 177 time taken: 0.000809
Affected rows: 0
total sql time: 0.435597
UPDATE fud26_poll SET total_votes=8 WHERE id=18
query count: 178 time taken: 0.000668
Affected rows: 0
total sql time: 0.436265
UPDATE fud26_msg SET poll_cache='a:2:{i:65;a:2:{i:0;s:3:\"Yes\";i:1;s:1:\"3\";}i:66;a:2:{i:0;s:2:\"No\";i:1;s:1:\"5\";}}' WHERE poll_id=19
query count: 179 time taken: 0.000765
Affected rows: 0
total sql time: 0.43703
UPDATE fud26_poll SET total_votes=8 WHERE id=19
query count: 180 time taken: 0.000667
Affected rows: 0
total sql time: 0.437697
UPDATE fud26_msg SET poll_cache='a:2:{i:68;a:2:{i:0;s:30:\"No, we need more damned forums\";i:1;s:1:\"3\";}i:67;a:2:{i:0;s:20:\"Yes, Too many forums\";i:1;s:1:\"4\";}}' WHERE poll_id=21
query count: 181 time taken: 0.000774
Affected rows: 0
total sql time: 0.438471
UPDATE fud26_poll SET total_votes=7 WHERE id=21
query count: 182 time taken: 0.00068
Affected rows: 0
total sql time: 0.439151
UPDATE fud26_msg SET poll_cache='a:4:{i:69;a:2:{i:0;s:11:\"Miller Lite\";i:1;s:1:\"3\";}i:70;a:2:{i:0;s:13:\"Vodka Martini\";i:1;s:1:\"0\";}i:71;a:2:{i:0;s:19:\"Long Island Ice Tea\";i:1;s:1:\"5\";}i:72;a:2:{i:0;s:9:\"Everclear\";i:1;s:1:\"0\";}}' WHERE poll_id=22
query count: 183 time taken: 0.000796
Affected rows: 0
total sql time: 0.439947
UPDATE fud26_poll SET total_votes=8 WHERE id=22
query count: 184 time taken: 0.000666
Affected rows: 0
total sql time: 0.440613
UPDATE fud26_msg SET poll_cache='a:5:{i:77;a:2:{i:0;s:8:\"4 slices\";i:1;s:1:\"1\";}i:76;a:2:{i:0;s:8:\"3 slices\";i:1;s:1:\"2\";}i:75;a:2:{i:0;s:8:\"2 slices\";i:1;s:1:\"2\";}i:74;a:2:{i:0;s:7:\"1 slice\";i:1;s:1:\"0\";}i:73;a:2:{i:0;s:8:\"0 slices\";i:1;s:1:\"0\";}}' WHERE poll_id=23
query count: 185 time taken: 0.000801
Affected rows: 0
total sql time: 0.441414
UPDATE fud26_poll SET total_votes=5 WHERE id=23
query count: 186 time taken: 0.000669
Affected rows: 0
total sql time: 0.442083
UPDATE fud26_msg SET poll_cache='a:2:{i:78;a:2:{i:0;s:3:\"Yes\";i:1;s:1:\"3\";}i:79;a:2:{i:0;s:2:\"No\";i:1;s:1:\"5\";}}' WHERE poll_id=24
query count: 187 time taken: 0.000767
Affected rows: 0
total sql time: 0.44285
UPDATE fud26_poll SET total_votes=8 WHERE id=24
query count: 188 time taken: 0.000668
Affected rows: 0
total sql time: 0.443518
UPDATE fud26_msg SET poll_cache='a:5:{i:102;a:2:{i:0;s:41:\"More than a week (Foo voted for this one)\";i:1;s:1:\"1\";}i:101;a:2:{i:0;s:72:\"None of the above I saw him eating a ho ho earlier in the bathroom stall\";i:1;s:1:\"2\";}i:100;a:2:{i:0;s:6:\"1 week\";i:1;s:1:\"3\";}i:99;a:2:{i:0;s:8:\"5-6 Days\";i:1;s:1:\"1\";}i:98;a:2:{i:0;s:8:\"3-4 Days\";i:1;s:1:\"0\";}}' WHERE poll_id=27
query count: 189 time taken: 0.000818
Affected rows: 0
total sql time: 0.444336
UPDATE fud26_poll SET total_votes=7 WHERE id=27
query count: 190 time taken: 0.000666
Affected rows: 0
total sql time: 0.445002
UPDATE fud26_msg SET poll_cache='a:3:{i:103;a:2:{i:0;s:37:\""I drank what!?" - Socrates\";i:1;s:1:\"3\";}i:104;a:2:{i:0;s:29:\""Doh" - Gen. Custer\";i:1;s:1:\"0\";}i:105;a:2:{i:0;s:58:\""Wonder what this button does." - Amelia Earhart\";i:1;s:1:\"2\";}}' WHERE poll_id=28
query count: 191 time taken: 0.000804
Affected rows: 0
total sql time: 0.445806
UPDATE fud26_poll SET total_votes=5 WHERE id=28
query count: 192 time taken: 0.000747
Affected rows: 0
total sql time: 0.446553
UPDATE fud26_msg SET poll_cache='a:2:{i:106;a:2:{i:0;s:3:\"Yes\";i:1;s:1:\"5\";}i:107;a:2:{i:0;s:2:\"No\";i:1;s:1:\"0\";}}' WHERE poll_id=29
query count: 193 time taken: 0.000803
Affected rows: 0
total sql time: 0.447356
UPDATE fud26_poll SET total_votes=5 WHERE id=29
query count: 194 time taken: 0.000671
Affected rows: 0
total sql time: 0.448027
Done: Rebuilding poll cache
Validating poll activation

SELECT t.forum_id, p.id FROM fud26_poll p INNER JOIN fud26_msg m ON m.poll_id=p.id INNER JOIN fud26_thread t ON m.thread_id=t.id AND m.apr=1 WHERE t.forum_id!=p.forum_id
query count: 195 time taken: 0.003129
Affected rows: 0
total sql time: 0.451156
Done: Validating poll activation
Checking smilies against disk files

SELECT img, id FROM fud26_smiley ORDER BY vieworder
query count: 196 time taken: 0.002067
Affected rows: 31
total sql time: 0.453223
UPDATE fud26_smiley SET vieworder=1 WHERE id=1
query count: 197 time taken: 0.000912
Affected rows: 0
total sql time: 0.454135
UPDATE fud26_smiley SET vieworder=2 WHERE id=2
query count: 198 time taken: 0.000733
Affected rows: 0
total sql time: 0.454868
UPDATE fud26_smiley SET vieworder=3 WHERE id=3
query count: 199 time taken: 0.000794
Affected rows: 0
total sql time: 0.455662
UPDATE fud26_smiley SET vieworder=4 WHERE id=4
query count: 200 time taken: 0.000728
Affected rows: 0
total sql time: 0.45639
UPDATE fud26_smiley SET vieworder=5 WHERE id=5
query count: 201 time taken: 0.000792
Affected rows: 0
total sql time: 0.457182
UPDATE fud26_smiley SET vieworder=6 WHERE id=6
query count: 202 time taken: 0.000727
Affected rows: 0
total sql time: 0.457909
UPDATE fud26_smiley SET vieworder=7 WHERE id=7
query count: 203 time taken: 0.000792
Affected rows: 0
total sql time: 0.458701
UPDATE fud26_smiley SET vieworder=8 WHERE id=8
query count: 204 time taken: 0.000757
Affected rows: 0
total sql time: 0.459458
UPDATE fud26_smiley SET vieworder=9 WHERE id=9
query count: 205 time taken: 0.000793
Affected rows: 0
total sql time: 0.460251
UPDATE fud26_smiley SET vieworder=10 WHERE id=10
query count: 206 time taken: 0.000727
Affected rows: 0
total sql time: 0.460978
UPDATE fud26_smiley SET vieworder=11 WHERE id=11
query count: 207 time taken: 0.000805
Affected rows: 0
total sql time: 0.461783
UPDATE fud26_smiley SET vieworder=12 WHERE id=12
query count: 208 time taken: 0.000733
Affected rows: 0
total sql time: 0.462516
UPDATE fud26_smiley SET vieworder=13 WHERE id=13
query count: 209 time taken: 0.000793
Affected rows: 0
total sql time: 0.463309
UPDATE fud26_smiley SET vieworder=14 WHERE id=14
query count: 210 time taken: 0.000728
Affected rows: 0
total sql time: 0.464037
UPDATE fud26_smiley SET vieworder=15 WHERE id=15
query count: 211 time taken: 0.000793
Affected rows: 0
total sql time: 0.46483
UPDATE fud26_smiley SET vieworder=16 WHERE id=16
query count: 212 time taken: 0.00073
Affected rows: 0
total sql time: 0.46556
UPDATE fud26_smiley SET vieworder=17 WHERE id=17
query count: 213 time taken: 0.000807
Affected rows: 0
total sql time: 0.466367
UPDATE fud26_smiley SET vieworder=18 WHERE id=18
query count: 214 time taken: 0.000777
Affected rows: 0
total sql time: 0.467144
UPDATE fud26_smiley SET vieworder=19 WHERE id=19
query count: 215 time taken: 0.000798
Affected rows: 0
total sql time: 0.467942
UPDATE fud26_smiley SET vieworder=20 WHERE id=20
query count: 216 time taken: 0.000732
Affected rows: 0
total sql time: 0.468674
UPDATE fud26_smiley SET vieworder=21 WHERE id=21
query count: 217 time taken: 0.000795
Affected rows: 0
total sql time: 0.469469
UPDATE fud26_smiley SET vieworder=22 WHERE id=22
query count: 218 time taken: 0.000732
Affected rows: 0
total sql time: 0.470201
UPDATE fud26_smiley SET vieworder=23 WHERE id=23
query count: 219 time taken: 0.000794
Affected rows: 0
total sql time: 0.470995
UPDATE fud26_smiley SET vieworder=24 WHERE id=24
query count: 220 time taken: 0.000732
Affected rows: 0
total sql time: 0.471727
UPDATE fud26_smiley SET vieworder=25 WHERE id=25
query count: 221 time taken: 0.000792
Affected rows: 0
total sql time: 0.472519
UPDATE fud26_smiley SET vieworder=26 WHERE id=26
query count: 222 time taken: 0.000725
Affected rows: 0
total sql time: 0.473244
UPDATE fud26_smiley SET vieworder=27 WHERE id=27
query count: 223 time taken: 0.000808
Affected rows: 0
total sql time: 0.474052
UPDATE fud26_smiley SET vieworder=28 WHERE id=28
query count: 224 time taken: 0.000729
Affected rows: 0
total sql time: 0.474781
UPDATE fud26_smiley SET vieworder=29 WHERE id=29
query count: 225 time taken: 0.000796
Affected rows: 0
total sql time: 0.475577
UPDATE fud26_smiley SET vieworder=30 WHERE id=30
query count: 226 time taken: 0.000733
Affected rows: 0
total sql time: 0.47631
UPDATE fud26_smiley SET vieworder=31 WHERE id=31
query count: 227 time taken: 0.000801
Affected rows: 0
total sql time: 0.477111
OK
Checking disk files against smilies

Warning: rename(C:/Inetpub/www.sugrat.net/FUDforum/tmp/icon_cache,C:/Inetpub/www.sugrat.net/FUDforum/cache/icon_cache): File exists in C:\Inetpub\www.sugrat.net\FUDforum\include\msg_icon_cache.inc on line 24
OK
Rebuild Smiley Cache

SELECT code, CONCAT('images/smiley_icons/', img), descr FROM fud26_smiley ORDER BY vieworder
query count: 228 time taken: 0.002898
Affected rows: 31
total sql time: 0.480009

Warning: rename(C:/Inetpub/www.sugrat.net/FUDforum/tmp/ps_cache,C:/Inetpub/www.sugrat.net/FUDforum/cache/ps_cache): File exists in C:\Inetpub\www.sugrat.net\FUDforum\include\sml_rcache.inc on line 32

Warning: rename(C:/Inetpub/www.sugrat.net/FUDforum/tmp/sp_cache,C:/Inetpub/www.sugrat.net/FUDforum/cache/sp_cache): File exists in C:\Inetpub\www.sugrat.net\FUDforum\include\sml_rcache.inc on line 38
Checking topic notification

SELECT tn.id FROM fud26_thread_notify tn LEFT JOIN fud26_thread t ON t.id=tn.thread_id LEFT JOIN fud26_users u ON u.id=tn.user_id WHERE u.id IS NULL OR t.id IS NULL
query count: 229 time taken: 0.002526
Affected rows: 0
total sql time: 0.482535
OK
Checking forum notification

SELECT fn.id FROM fud26_forum_notify fn LEFT JOIN fud26_forum f ON f.id=fn.forum_id LEFT JOIN fud26_users u ON u.id=fn.user_id WHERE u.id IS NULL OR f.id IS NULL
query count: 230 time taken: 0.000934
Affected rows: 0
total sql time: 0.483469
OK
Checking topic votes against topics

SELECT trt.id FROM fud26_thread_rate_track trt LEFT JOIN fud26_thread t ON t.id=trt.thread_id LEFT JOIN fud26_users u ON u.id=trt.user_id WHERE u.id IS NULL OR t.id IS NULL
query count: 231 time taken: 0.001329
Affected rows: 0
total sql time: 0.484798
OK
Rebuild topic rating cache

UPDATE fud26_thread SET rating=0, n_rating=0
query count: 232 time taken: 0.000943
Affected rows: 1
total sql time: 0.485741
SELECT thread_id, count(*), AVG(rating) FROM fud26_thread_rate_track GROUP BY thread_id
query count: 233 time taken: 0.000964
Affected rows: 1
total sql time: 0.486705
UPDATE fud26_thread SET rating=4, n_rating=1 WHERE id=43
query count: 234 time taken: 0.000739
Affected rows: 1
total sql time: 0.487444
Done: Rebuild topic rating cache
Rebuilding Topic Views

DELETE FROM fud26_thread_view
query count: 235 time taken: 0.0021060000000001
Affected rows: 67
total sql time: 0.48955
SELECT id FROM fud26_forum
query count: 236 time taken: 0.001114
Affected rows: 17
total sql time: 0.490664
SELECT fud26_thread.id FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE fud26_thread.forum_id=1 AND thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry)<=1106113466
query count: 237 time taken: 0.001097
Affected rows: 0
total sql time: 0.491761
DELETE FROM fud26_thread WHERE forum_id=1 AND last_post_date<1105854266 AND moved_to!=0
query count: 238 time taken: 0.00076
Affected rows: 0
total sql time: 0.492521
DELETE FROM fud26_thread_view WHERE forum_id=1
query count: 239 time taken: 0.000599
Affected rows: 0
total sql time: 0.49312
INSERT INTO fud26_thread_view (thread_id,forum_id,page) SELECT fud26_thread.id, 1, 2147483645 FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE forum_id=1 AND fud26_msg.apr=1 ORDER BY (CASE WHEN thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry>1106113466 OR fud26_thread.orderexpiry=0) THEN 4294967294 ELSE fud26_thread.last_post_date END) DESC, fud26_thread.last_post_id DESC
query count: 240 time taken: 0.002963
Affected rows: 1
total sql time: 0.496083
UPDATE fud26_thread_view SET page=CEILING(pos/40), pos=pos-(CEILING(pos/40)-1)*40 WHERE forum_id=1
query count: 241 time taken: 0.001092
Affected rows: 1
total sql time: 0.497175
SELECT fud26_thread.id FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE fud26_thread.forum_id=2 AND thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry)<=1106113466
query count: 242 time taken: 0.001174
Affected rows: 0
total sql time: 0.498349
DELETE FROM fud26_thread WHERE forum_id=2 AND last_post_date<1105854266 AND moved_to!=0
query count: 243 time taken: 0.000884
Affected rows: 0
total sql time: 0.499233
DELETE FROM fud26_thread_view WHERE forum_id=2
query count: 244 time taken: 0.000623
Affected rows: 0
total sql time: 0.499856
INSERT INTO fud26_thread_view (thread_id,forum_id,page) SELECT fud26_thread.id, 2, 2147483645 FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE forum_id=2 AND fud26_msg.apr=1 ORDER BY (CASE WHEN thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry>1106113466 OR fud26_thread.orderexpiry=0) THEN 4294967294 ELSE fud26_thread.last_post_date END) DESC, fud26_thread.last_post_id DESC
query count: 245 time taken: 0.004605
Affected rows: 16
total sql time: 0.504461
UPDATE fud26_thread_view SET page=CEILING(pos/40), pos=pos-(CEILING(pos/40)-1)*40 WHERE forum_id=2
query count: 246 time taken: 0.001875
Affected rows: 16
total sql time: 0.506336
SELECT fud26_thread.id FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE fud26_thread.forum_id=3 AND thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry)<=1106113466
query count: 247 time taken: 0.001085
Affected rows: 0
total sql time: 0.507421
DELETE FROM fud26_thread WHERE forum_id=3 AND last_post_date<1105854266 AND moved_to!=0
query count: 248 time taken: 0.001001
Affected rows: 0
total sql time: 0.508422
DELETE FROM fud26_thread_view WHERE forum_id=3
query count: 249 time taken: 0.000619
Affected rows: 0
total sql time: 0.509041
INSERT INTO fud26_thread_view (thread_id,forum_id,page) SELECT fud26_thread.id, 3, 2147483645 FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE forum_id=3 AND fud26_msg.apr=1 ORDER BY (CASE WHEN thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry>1106113466 OR fud26_thread.orderexpiry=0) THEN 4294967294 ELSE fud26_thread.last_post_date END) DESC, fud26_thread.last_post_id DESC
query count: 250 time taken: 0.004207
Affected rows: 14
total sql time: 0.513248
UPDATE fud26_thread_view SET page=CEILING(pos/40), pos=pos-(CEILING(pos/40)-1)*40 WHERE forum_id=3
query count: 251 time taken: 0.001718
Affected rows: 14
total sql time: 0.514966
SELECT fud26_thread.id FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE fud26_thread.forum_id=4 AND thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry)<=1106113466
query count: 252 time taken: 0.001083
Affected rows: 0
total sql time: 0.516049
DELETE FROM fud26_thread WHERE forum_id=4 AND last_post_date<1105854266 AND moved_to!=0
query count: 253 time taken: 0.000779
Affected rows: 0
total sql time: 0.516828
DELETE FROM fud26_thread_view WHERE forum_id=4
query count: 254 time taken: 0.000631
Affected rows: 0
total sql time: 0.517459
INSERT INTO fud26_thread_view (thread_id,forum_id,page) SELECT fud26_thread.id, 4, 2147483645 FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE forum_id=4 AND fud26_msg.apr=1 ORDER BY (CASE WHEN thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry>1106113466 OR fud26_thread.orderexpiry=0) THEN 4294967294 ELSE fud26_thread.last_post_date END) DESC, fud26_thread.last_post_id DESC
query count: 255 time taken: 0.002211
Affected rows: 1
total sql time: 0.51967
UPDATE fud26_thread_view SET page=CEILING(pos/40), pos=pos-(CEILING(pos/40)-1)*40 WHERE forum_id=4
query count: 256 time taken: 0.000996
Affected rows: 1
total sql time: 0.520666
SELECT fud26_thread.id FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE fud26_thread.forum_id=5 AND thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry)<=1106113466
query count: 257 time taken: 0.001112
Affected rows: 0
total sql time: 0.521778
DELETE FROM fud26_thread WHERE forum_id=5 AND last_post_date<1105854266 AND moved_to!=0
query count: 258 time taken: 0.000817
Affected rows: 0
total sql time: 0.522595
DELETE FROM fud26_thread_view WHERE forum_id=5
query count: 259 time taken: 0.00073
Affected rows: 0
total sql time: 0.523325
INSERT INTO fud26_thread_view (thread_id,forum_id,page) SELECT fud26_thread.id, 5, 2147483645 FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE forum_id=5 AND fud26_msg.apr=1 ORDER BY (CASE WHEN thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry>1106113466 OR fud26_thread.orderexpiry=0) THEN 4294967294 ELSE fud26_thread.last_post_date END) DESC, fud26_thread.last_post_id DESC
query count: 260 time taken: 0.002646
Affected rows: 3
total sql time: 0.525971
UPDATE fud26_thread_view SET page=CEILING(pos/40), pos=pos-(CEILING(pos/40)-1)*40 WHERE forum_id=5
query count: 261 time taken: 0.001286
Affected rows: 3
total sql time: 0.527257
SELECT fud26_thread.id FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE fud26_thread.forum_id=6 AND thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry)<=1106113466
query count: 262 time taken: 0.0011
Affected rows: 0
total sql time: 0.528357
DELETE FROM fud26_thread WHERE forum_id=6 AND last_post_date<1105854266 AND moved_to!=0
query count: 263 time taken: 0.000973
Affected rows: 0
total sql time: 0.52933
DELETE FROM fud26_thread_view WHERE forum_id=6
query count: 264 time taken: 0.000616
Affected rows: 0
total sql time: 0.529946
INSERT INTO fud26_thread_view (thread_id,forum_id,page) SELECT fud26_thread.id, 6, 2147483645 FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE forum_id=6 AND fud26_msg.apr=1 ORDER BY (CASE WHEN thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry>1106113466 OR fud26_thread.orderexpiry=0) THEN 4294967294 ELSE fud26_thread.last_post_date END) DESC, fud26_thread.last_post_id DESC
query count: 265 time taken: 0.004088
Affected rows: 13
total sql time: 0.534034
UPDATE fud26_thread_view SET page=CEILING(pos/40), pos=pos-(CEILING(pos/40)-1)*40 WHERE forum_id=6
query count: 266 time taken: 0.001685
Affected rows: 13
total sql time: 0.535719
SELECT fud26_thread.id FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE fud26_thread.forum_id=7 AND thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry)<=1106113466
query count: 267 time taken: 0.001063
Affected rows: 0
total sql time: 0.536782
DELETE FROM fud26_thread WHERE forum_id=7 AND last_post_date<1105854266 AND moved_to!=0
query count: 268 time taken: 0.00075
Affected rows: 0
total sql time: 0.537532
DELETE FROM fud26_thread_view WHERE forum_id=7
query count: 269 time taken: 0.000615
Affected rows: 0
total sql time: 0.538147
INSERT INTO fud26_thread_view (thread_id,forum_id,page) SELECT fud26_thread.id, 7, 2147483645 FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE forum_id=7 AND fud26_msg.apr=1 ORDER BY (CASE WHEN thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry>1106113466 OR fud26_thread.orderexpiry=0) THEN 4294967294 ELSE fud26_thread.last_post_date END) DESC, fud26_thread.last_post_id DESC
query count: 270 time taken: 0.002145
Affected rows: 1
total sql time: 0.540292
UPDATE fud26_thread_view SET page=CEILING(pos/40), pos=pos-(CEILING(pos/40)-1)*40 WHERE forum_id=7
query count: 271 time taken: 0.000989
Affected rows: 1
total sql time: 0.541281
SELECT fud26_thread.id FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE fud26_thread.forum_id=8 AND thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry)<=1106113466
query count: 272 time taken: 0.001076
Affected rows: 0
total sql time: 0.542357
DELETE FROM fud26_thread WHERE forum_id=8 AND last_post_date<1105854266 AND moved_to!=0
query count: 273 time taken: 0.000788
Affected rows: 0
total sql time: 0.543145
DELETE FROM fud26_thread_view WHERE forum_id=8
query count: 274 time taken: 0.000615
Affected rows: 0
total sql time: 0.54376
INSERT INTO fud26_thread_view (thread_id,forum_id,page) SELECT fud26_thread.id, 8, 2147483645 FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE forum_id=8 AND fud26_msg.apr=1 ORDER BY (CASE WHEN thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry>1106113466 OR fud26_thread.orderexpiry=0) THEN 4294967294 ELSE fud26_thread.last_post_date END) DESC, fud26_thread.last_post_id DESC
query count: 275 time taken: 0.002511
Affected rows: 3
total sql time: 0.546271
UPDATE fud26_thread_view SET page=CEILING(pos/40), pos=pos-(CEILING(pos/40)-1)*40 WHERE forum_id=8
query count: 276 time taken: 0.00117
Affected rows: 3
total sql time: 0.547441
SELECT fud26_thread.id FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE fud26_thread.forum_id=9 AND thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry)<=1106113466
query count: 277 time taken: 0.001065
Affected rows: 0
total sql time: 0.548506
DELETE FROM fud26_thread WHERE forum_id=9 AND last_post_date<1105854266 AND moved_to!=0
query count: 278 time taken: 0.000852
Affected rows: 0
total sql time: 0.549358
DELETE FROM fud26_thread_view WHERE forum_id=9
query count: 279 time taken: 0.000615
Affected rows: 0
total sql time: 0.549973
INSERT INTO fud26_thread_view (thread_id,forum_id,page) SELECT fud26_thread.id, 9, 2147483645 FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE forum_id=9 AND fud26_msg.apr=1 ORDER BY (CASE WHEN thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry>1106113466 OR fud26_thread.orderexpiry=0) THEN 4294967294 ELSE fud26_thread.last_post_date END) DESC, fud26_thread.last_post_id DESC
query count: 280 time taken: 0.002979
Affected rows: 6
total sql time: 0.552952
UPDATE fud26_thread_view SET page=CEILING(pos/40), pos=pos-(CEILING(pos/40)-1)*40 WHERE forum_id=9
query count: 281 time taken: 0.001375
Affected rows: 6
total sql time: 0.554327
SELECT fud26_thread.id FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE fud26_thread.forum_id=10 AND thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry)<=1106113466
query count: 282 time taken: 0.001069
Affected rows: 0
total sql time: 0.555396
DELETE FROM fud26_thread WHERE forum_id=10 AND last_post_date<1105854266 AND moved_to!=0
query count: 283 time taken: 0.000766
Affected rows: 0
total sql time: 0.556162
DELETE FROM fud26_thread_view WHERE forum_id=10
query count: 284 time taken: 0.000614
Affected rows: 0
total sql time: 0.556776
INSERT INTO fud26_thread_view (thread_id,forum_id,page) SELECT fud26_thread.id, 10, 2147483645 FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE forum_id=10 AND fud26_msg.apr=1 ORDER BY (CASE WHEN thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry>1106113466 OR fud26_thread.orderexpiry=0) THEN 4294967294 ELSE fud26_thread.last_post_date END) DESC, fud26_thread.last_post_id DESC
query count: 285 time taken: 0.002324
Affected rows: 2
total sql time: 0.5591
UPDATE fud26_thread_view SET page=CEILING(pos/40), pos=pos-(CEILING(pos/40)-1)*40 WHERE forum_id=10
query count: 286 time taken: 0.001073
Affected rows: 2
total sql time: 0.560173
SELECT fud26_thread.id FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE fud26_thread.forum_id=11 AND thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry)<=1106113466
query count: 287 time taken: 0.00106
Affected rows: 0
total sql time: 0.561233
DELETE FROM fud26_thread WHERE forum_id=11 AND last_post_date<1105854266 AND moved_to!=0
query count: 288 time taken: 0.00086
Affected rows: 0
total sql time: 0.562093
DELETE FROM fud26_thread_view WHERE forum_id=11
query count: 289 time taken: 0.000619
Affected rows: 0
total sql time: 0.562712
INSERT INTO fud26_thread_view (thread_id,forum_id,page) SELECT fud26_thread.id, 11, 2147483645 FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE forum_id=11 AND fud26_msg.apr=1 ORDER BY (CASE WHEN thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry>1106113466 OR fud26_thread.orderexpiry=0) THEN 4294967294 ELSE fud26_thread.last_post_date END) DESC, fud26_thread.last_post_id DESC
query count: 290 time taken: 0.003157
Affected rows: 7
total sql time: 0.565869
UPDATE fud26_thread_view SET page=CEILING(pos/40), pos=pos-(CEILING(pos/40)-1)*40 WHERE forum_id=11
query count: 291 time taken: 0.001539
Affected rows: 7
total sql time: 0.567408
SELECT fud26_thread.id FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE fud26_thread.forum_id=12 AND thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry)<=1106113466
query count: 292 time taken: 0.001028
Affected rows: 0
total sql time: 0.568436
DELETE FROM fud26_thread WHERE forum_id=12 AND last_post_date<1105854266 AND moved_to!=0
query count: 293 time taken: 0.00069
Affected rows: 0
total sql time: 0.569126
DELETE FROM fud26_thread_view WHERE forum_id=12
query count: 294 time taken: 0.000623
Affected rows: 0
total sql time: 0.569749
INSERT INTO fud26_thread_view (thread_id,forum_id,page) SELECT fud26_thread.id, 12, 2147483645 FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE forum_id=12 AND fud26_msg.apr=1 ORDER BY (CASE WHEN thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry>1106113466 OR fud26_thread.orderexpiry=0) THEN 4294967294 ELSE fud26_thread.last_post_date END) DESC, fud26_thread.last_post_id DESC
query count: 295 time taken: 0.001808
Affected rows: 0
total sql time: 0.571557
UPDATE fud26_thread_view SET page=CEILING(pos/40), pos=pos-(CEILING(pos/40)-1)*40 WHERE forum_id=12
query count: 296 time taken: 0.000857
Affected rows: 0
total sql time: 0.572414
SELECT fud26_thread.id FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE fud26_thread.forum_id=13 AND thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry)<=1106113466
query count: 297 time taken: 0.000999
Affected rows: 0
total sql time: 0.573413
DELETE FROM fud26_thread WHERE forum_id=13 AND last_post_date<1105854266 AND moved_to!=0
query count: 298 time taken: 0.000689
Affected rows: 0
total sql time: 0.574102
DELETE FROM fud26_thread_view WHERE forum_id=13
query count: 299 time taken: 0.000625
Affected rows: 0
total sql time: 0.574727
INSERT INTO fud26_thread_view (thread_id,forum_id,page) SELECT fud26_thread.id, 13, 2147483645 FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE forum_id=13 AND fud26_msg.apr=1 ORDER BY (CASE WHEN thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry>1106113466 OR fud26_thread.orderexpiry=0) THEN 4294967294 ELSE fud26_thread.last_post_date END) DESC, fud26_thread.last_post_id DESC
query count: 300 time taken: 0.001801
Affected rows: 0
total sql time: 0.576528
UPDATE fud26_thread_view SET page=CEILING(pos/40), pos=pos-(CEILING(pos/40)-1)*40 WHERE forum_id=13
query count: 301 time taken: 0.000864
Affected rows: 0
total sql time: 0.577392
SELECT fud26_thread.id FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE fud26_thread.forum_id=14 AND thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry)<=1106113466
query count: 302 time taken: 0.000996
Affected rows: 0
total sql time: 0.578388
DELETE FROM fud26_thread WHERE forum_id=14 AND last_post_date<1105854266 AND moved_to!=0
query count: 303 time taken: 0.000688
Affected rows: 0
total sql time: 0.579076
DELETE FROM fud26_thread_view WHERE forum_id=14
query count: 304 time taken: 0.000623
Affected rows: 0
total sql time: 0.579699
INSERT INTO fud26_thread_view (thread_id,forum_id,page) SELECT fud26_thread.id, 14, 2147483645 FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE forum_id=14 AND fud26_msg.apr=1 ORDER BY (CASE WHEN thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry>1106113466 OR fud26_thread.orderexpiry=0) THEN 4294967294 ELSE fud26_thread.last_post_date END) DESC, fud26_thread.last_post_id DESC
query count: 305 time taken: 0.001779
Affected rows: 0
total sql time: 0.581478
UPDATE fud26_thread_view SET page=CEILING(pos/40), pos=pos-(CEILING(pos/40)-1)*40 WHERE forum_id=14
query count: 306 time taken: 0.000921
Affected rows: 0
total sql time: 0.582399
SELECT fud26_thread.id FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE fud26_thread.forum_id=15 AND thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry)<=1106113466
query count: 307 time taken: 0.001058
Affected rows: 0
total sql time: 0.583457
DELETE FROM fud26_thread WHERE forum_id=15 AND last_post_date<1105854266 AND moved_to!=0
query count: 308 time taken: 0.00071
Affected rows: 0
total sql time: 0.584167
DELETE FROM fud26_thread_view WHERE forum_id=15
query count: 309 time taken: 0.000652
Affected rows: 0
total sql time: 0.584819
INSERT INTO fud26_thread_view (thread_id,forum_id,page) SELECT fud26_thread.id, 15, 2147483645 FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE forum_id=15 AND fud26_msg.apr=1 ORDER BY (CASE WHEN thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry>1106113466 OR fud26_thread.orderexpiry=0) THEN 4294967294 ELSE fud26_thread.last_post_date END) DESC, fud26_thread.last_post_id DESC
query count: 310 time taken: 0.001869
Affected rows: 0
total sql time: 0.586688
UPDATE fud26_thread_view SET page=CEILING(pos/40), pos=pos-(CEILING(pos/40)-1)*40 WHERE forum_id=15
query count: 311 time taken: 0.000856
Affected rows: 0
total sql time: 0.587544
SELECT fud26_thread.id FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE fud26_thread.forum_id=16 AND thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry)<=1106113466
query count: 312 time taken: 0.001001
Affected rows: 0
total sql time: 0.588545
DELETE FROM fud26_thread WHERE forum_id=16 AND last_post_date<1105854266 AND moved_to!=0
query count: 313 time taken: 0.000688
Affected rows: 0
total sql time: 0.589233
DELETE FROM fud26_thread_view WHERE forum_id=16
query count: 314 time taken: 0.000624
Affected rows: 0
total sql time: 0.589857
INSERT INTO fud26_thread_view (thread_id,forum_id,page) SELECT fud26_thread.id, 16, 2147483645 FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE forum_id=16 AND fud26_msg.apr=1 ORDER BY (CASE WHEN thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry>1106113466 OR fud26_thread.orderexpiry=0) THEN 4294967294 ELSE fud26_thread.last_post_date END) DESC, fud26_thread.last_post_id DESC
query count: 315 time taken: 0.001807
Affected rows: 0
total sql time: 0.591664
UPDATE fud26_thread_view SET page=CEILING(pos/40), pos=pos-(CEILING(pos/40)-1)*40 WHERE forum_id=16
query count: 316 time taken: 0.000864
Affected rows: 0
total sql time: 0.592528
SELECT fud26_thread.id FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE fud26_thread.forum_id=17 AND thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry)<=1106113466
query count: 317 time taken: 0.000996
Affected rows: 0
total sql time: 0.593524
DELETE FROM fud26_thread WHERE forum_id=17 AND last_post_date<1105854266 AND moved_to!=0
query count: 318 time taken: 0.000687
Affected rows: 0
total sql time: 0.594211
DELETE FROM fud26_thread_view WHERE forum_id=17
query count: 319 time taken: 0.000622
Affected rows: 0
total sql time: 0.594833
INSERT INTO fud26_thread_view (thread_id,forum_id,page) SELECT fud26_thread.id, 17, 2147483645 FROM fud26_thread INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id WHERE forum_id=17 AND fud26_msg.apr=1 ORDER BY (CASE WHEN thread_opt>=2 AND (fud26_msg.post_stamp+fud26_thread.orderexpiry>1106113466 OR fud26_thread.orderexpiry=0) THEN 4294967294 ELSE fud26_thread.last_post_date END) DESC, fud26_thread.last_post_id DESC
query count: 320 time taken: 0.00177
Affected rows: 0
total sql time: 0.596603
UPDATE fud26_thread_view SET page=CEILING(pos/40), pos=pos-(CEILING(pos/40)-1)*40 WHERE forum_id=17
query count: 321 time taken: 0.000867
Affected rows: 0
total sql time: 0.59747
Done: Rebuilding Topic Views
Rebuilding user ranks, message counts & last post ids

UPDATE fud26_users SET level_id=0, posted_msg_count=0, u_last_post_id=0, custom_status=NULL
query count: 322 time taken: 0.005476
Affected rows: 30
total sql time: 0.602946
INSERT INTO fud26_tmp_consist (ps, p, c) SELECT MAX(post_stamp), poster_id, count(*) FROM fud26_msg WHERE apr=1 GROUP BY poster_id ORDER BY poster_id
query count: 323 time taken: 0.051626
Affected rows: 21
total sql time: 0.654572
SELECT VERSION()
query count: 324 time taken: 0.000724
Affected rows: 1
total sql time: 0.655296
UPDATE fud26_users u, fud26_tmp_consist, fud26_msg m SET u.u_last_post_id=m.id, u.posted_msg_count=fud26_tmp_consist.c WHERE u.id=m.poster_id AND m.poster_id=fud26_tmp_consist.p AND m.post_stamp=fud26_tmp_consist.ps AND m.apr=1
query count: 325 time taken: 0.009046
Affected rows: 21
total sql time: 0.664342
SELECT id, post_count FROM fud26_level ORDER BY post_count DESC
query count: 326 time taken: 0.001248
Affected rows: 3
total sql time: 0.66559
UPDATE fud26_users SET level_id=1 WHERE level_id=0 AND posted_msg_count>=100
query count: 327 time taken: 0.002009
Affected rows: 0
total sql time: 0.667599
UPDATE fud26_users SET level_id=2 WHERE level_id=0 AND posted_msg_count>=30
query count: 328 time taken: 0.002631
Affected rows: 6
total sql time: 0.67023
UPDATE fud26_users SET level_id=3 WHERE level_id=0 AND posted_msg_count>=0
query count: 329 time taken: 0.004721
Affected rows: 24
total sql time: 0.674951
Done: Rebuilding user levels, message counts & last post ids
Checking buddy list entries

SELECT b.id FROM fud26_buddy b LEFT JOIN fud26_users u1 ON u1.id=b.user_id LEFT JOIN fud26_users u2 ON u2.id=b.bud_id WHERE u1.id IS NULL OR u2.id IS NULL
query count: 330 time taken: 0.000871
Affected rows: 0
total sql time: 0.675822
OK
Checking ignore list entries

SELECT i.id FROM fud26_user_ignore i LEFT JOIN fud26_users u1 ON u1.id=i.user_id LEFT JOIN fud26_users u2 ON u2.id=i.ignore_id WHERE u1.id IS NULL OR u2.id IS NULL
query count: 331 time taken: 0.000783
Affected rows: 0
total sql time: 0.676605
OK

UPDATE fud26_users SET buddy_list=NULL, ignore_list=NULL
query count: 332 time taken: 0.002053
Affected rows: 0
total sql time: 0.678658
Rebuilding buddy list cache

SELECT bud_id, user_id FROM fud26_buddy ORDER BY user_id
query count: 333 time taken: 0.000717
Affected rows: 0
total sql time: 0.679375
Done: Rebuilding buddy list cache
Rebuilding ignore list cache

SELECT ignore_id, user_id FROM fud26_user_ignore ORDER BY user_id
query count: 334 time taken: 0.000685
Affected rows: 0
total sql time: 0.68006
Done: Rebuilding ignore list cache
Rebuilding ip filter cache

SELECT ca, cb, cc, cd FROM fud26_ip_block
query count: 335 time taken: 0.000736
Affected rows: 0
total sql time: 0.680796
Done: Rebuilding ip filter cache
Rebuilding login filter cache

SELECT login FROM fud26_blocked_logins
query count: 336 time taken: 0.000751
Affected rows: 0
total sql time: 0.681547
Done: Rebuilding login filter cache
Rebuilding email filter cache

SELECT email_block_opt, string FROM fud26_email_block
query count: 337 time taken: 0.000825
Affected rows: 0
total sql time: 0.682372
Done: Rebuilding email filter cache
Rebuilding extension filter cache

SELECT ext FROM fud26_ext_block
query count: 338 time taken: 0.000737
Affected rows: 0
total sql time: 0.683109
Done: Rebuilding extension filter cache
Rebuilding custom tags for users

SELECT distinct(user_id) FROM fud26_custom_tags
query count: 339 time taken: 0.000911
Affected rows: 1
total sql time: 0.68402
SELECT name FROM fud26_custom_tags WHERE user_id=2 ORDER BY name
query count: 340 time taken: 0.000813
Affected rows: 1
total sql time: 0.684833
UPDATE fud26_users SET custom_status='Administrator' WHERE id=2
query count: 341 time taken: 0.000946
Affected rows: 1
total sql time: 0.685779
Done Rebuilding custom tags for users
Validating group resources

SELECT gr.id FROM fud26_group_resources gr LEFT JOIN fud26_forum f ON f.id=gr.resource_id LEFT JOIN fud26_groups g ON g.id=gr.group_id WHERE f.id IS NULL OR g.id IS NULL
query count: 342 time taken: 0.001496
Affected rows: 0
total sql time: 0.687275
OK
Done: Validating group resources
Validating group validity

SELECT g.id FROM fud26_groups g LEFT JOIN fud26_group_resources gr ON g.id=gr.group_id WHERE g.id > 2 AND gr.id IS NULL
query count: 343 time taken: 0.001582
Affected rows: 0
total sql time: 0.688857
OK

SELECT g.id FROM fud26_groups g LEFT JOIN fud26_forum f ON g.forum_id=f.id WHERE g.forum_id > 0 AND g.id > 2 AND f.id IS NULL
query count: 344 time taken: 0.001406
Affected rows: 0
total sql time: 0.690263
OK
Done: Validating group validity
Validating group members

SELECT gm.id FROM fud26_group_members gm LEFT JOIN fud26_users u ON u.id=gm.user_id LEFT JOIN fud26_groups g ON g.id=gm.group_id WHERE (u.id IS NULL AND gm.user_id NOT IN(0, 2147483647)) OR g.id IS NULL
query count: 345 time taken: 0.002123
Affected rows: 0
total sql time: 0.692386
OK
Done: Validating group members
Validating group/forum relations

SELECT f.id, f.name FROM fud26_forum f LEFT JOIN fud26_groups g ON f.id=g.forum_id WHERE g.id IS NULL
query count: 346 time taken: 0.001909
Affected rows: 0
total sql time: 0.694295
Done: Validating group/forum relations
Validating group/forum names

SELECT g.id, f.name FROM fud26_groups g INNER JOIN fud26_forum f ON f.id=g.forum_id WHERE g.id>2 AND f.name!=g.name
query count: 347 time taken: 0.002211
Affected rows: 0
total sql time: 0.696506
Done: Validating group/forum names (fixed: 0 relations)
Validating group/primary user relations

SELECT g.id, gm1.id, gm2.id FROM fud26_groups g LEFT JOIN fud26_group_members gm1 ON gm1.group_id=g.id AND gm1.user_id=0 LEFT JOIN fud26_group_members gm2 ON gm2.group_id=g.id AND gm2.user_id=2147483647 WHERE g.id>2 AND g.forum_id>0 AND (gm1.id IS NULL OR gm2.id IS NULL)
query count: 348 time taken: 0.002748
Affected rows: 0
total sql time: 0.699254
Done: Validating group/primary user relations
Rebuilding group leader cache

SELECT DISTINCT(user_id) FROM fud26_group_members WHERE group_members_opt>=131072 AND (group_members_opt & 131072) > 0
query count: 349 time taken: 0.001452
Affected rows: 0
total sql time: 0.700706
Done: Rebuilding group leader cache
Rebuilding group cache

SELECT gm.user_id AS uid, gm.group_members_opt AS gco, gr.resource_id AS rid FROM fud26_group_members gm INNER JOIN fud26_group_resources gr ON gr.group_id=gm.group_id WHERE gm.group_members_opt>=65536 AND (gm.group_members_opt & 65536) > 0
query count: 350 time taken: 0.00296
Affected rows: 34
total sql time: 0.703666
REPLACE INTO fud26_group_cache (resource_id, group_cache_opt, user_id) VALUES (1, 327683, 0),(1, 378767, 2147483647),(2, 327683, 0),(2, 378767, 2147483647),(3, 327683, 0),(3, 378767, 2147483647),(4, 327683, 0),(4, 378767, 2147483647),(5, 327683, 0),(5, 378767, 2147483647),(6, 327683, 0),(6, 378767, 2147483647),(7, 327683, 0),(7, 378767, 2147483647),(8, 327683, 0),(8, 378767, 2147483647),(9, 327683, 0),(9, 378767, 2147483647),(10, 327683, 0),(10, 378767, 2147483647),(11, 327683, 0),(11, 378767, 2147483647),(12, 327683, 0),(12, 378767, 2147483647),(13, 327683, 0),(13, 378767, 2147483647),(14, 327683, 0),(14, 378767, 2147483647),(15, 327683, 0),(15, 378767, 2147483647),(16, 327683, 0),(16, 378767, 2147483647),(17, 327683, 0),(17, 378767, 2147483647)
query count: 351 time taken: 0.005621
Affected rows: 68
total sql time: 0.709287
DELETE FROM fud26_group_cache WHERE id < LAST_INSERT_ID()
query count: 352 time taken: 0.000724
Affected rows: 0
total sql time: 0.710011
Done: Rebuilding group cache
Validating User/Theme Relations

SELECT u.id FROM fud26_users u LEFT JOIN fud26_themes thm ON thm.id=u.theme WHERE thm.id IS NULL
query count: 353 time taken: 0.001693
Affected rows: 0
total sql time: 0.711704
Done: Validating User/Theme Relations
Rebuilding Forum/Category order cache

SELECT c.id, f.id, c.parent, c.name FROM fud26_cat c LEFT JOIN fud26_forum f ON f.cat_id=c.id ORDER BY c.parent, c.view_order, f.view_order
query count: 354 time taken: 0.002294
Affected rows: 10
total sql time: 0.713998
DELETE FROM fud26_fc_view
query count: 355 time taken: 0.001838
Affected rows: 10
total sql time: 0.715836
INSERT INTO fud26_fc_view (c, f, lvl) VALUES(2,2,0)
query count: 356 time taken: 0.000878
Affected rows: 1
total sql time: 0.716714
INSERT INTO fud26_fc_view (c, f, lvl) VALUES(2,5,0)
query count: 357 time taken: 0.000714
Affected rows: 1
total sql time: 0.717428
INSERT INTO fud26_fc_view (c, f, lvl) VALUES(3,6,0)
query count: 358 time taken: 0.000706
Affected rows: 1
total sql time: 0.718134
INSERT INTO fud26_fc_view (c, f, lvl) VALUES(3,11,0)
query count: 359 time taken: 0.000703
Affected rows: 1
total sql time: 0.718837
INSERT INTO fud26_fc_view (c, f, lvl) VALUES(3,7,0)
query count: 360 time taken: 0.000712
Affected rows: 1
total sql time: 0.719549
INSERT INTO fud26_fc_view (c, f, lvl) VALUES(3,8,0)
query count: 361 time taken: 0.000706
Affected rows: 1
total sql time: 0.720255
INSERT INTO fud26_fc_view (c, f, lvl) VALUES(3,4,0)
query count: 362 time taken: 0.000704
Affected rows: 1
total sql time: 0.720959
INSERT INTO fud26_fc_view (c, f, lvl) VALUES(4,3,0)
query count: 363 time taken: 0.000737
Affected rows: 1
total sql time: 0.721696
INSERT INTO fud26_fc_view (c, f, lvl) VALUES(4,9,0)
query count: 364 time taken: 0.00071
Affected rows: 1
total sql time: 0.722406
INSERT INTO fud26_fc_view (c, f, lvl) VALUES(4,10,0)
query count: 365 time taken: 0.000702
Affected rows: 1
total sql time: 0.723108

Warning: rename(C:/Inetpub/www.sugrat.net/FUDforum/cache/cat_cache.inc.tmp,C:/Inetpub/www.sugrat.net/FUDforum/cache/cat_cache.inc): File exists in C:\Inetpub\www.sugrat.net\FUDforum\include\cat.inc on line 167

SELECT 0, name, description, cat_opt, parent, id FROM fud26_cat c
query count: 366 time taken: 0.00121
Affected rows: 3
total sql time: 0.724318

Warning: rename(C:/Inetpub/www.sugrat.net/FUDforum/cache/idx.inc.tmp,C:/Inetpub/www.sugrat.net/FUDforum/cache/idx.inc): File exists in C:\Inetpub\www.sugrat.net\FUDforum\include\cat.inc on line 191
Done: Rebuilding Forum/Category order cache
Remove absolete entries inside sessions table

DELETE FROM fud26_ses WHERE user_id>2000000000 AND time_sec < 1106113466 - 1800
query count: 367 time taken: 0.000818
Affected rows: 0
total sql time: 0.725136
Done: Removing absolete entries inside sessions table
Unlocking database

UNLOCK TABLES
query count: 368 time taken: 0.001754
Affected rows: 0
total sql time: 0.72689
DROP TABLE fud26_tmp_consist
query count: 369 time taken: 0.042865
Affected rows: 0
total sql time: 0.769755
Database unlocked
Cleaning forum's tmp directory
Done: Cleaning forum's tmp directory
Validate GLOBALS.php
Done: Validate GLOBALS.php
Re-enabling the forum.
DONE
It is recommended that you run SQL table optimizer after completing the consistency check. To do so click here, keep in mind that this process make take several minutes to perform.