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

Home » FUDforum Development » Bug Reports » After upgrade from 3.0.4 on my test 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
After upgrade from 3.0.4 on my test forum :) [message #169150] Sun, 25 August 2013 04:34 Go to next message
TheDude is currently offline  TheDude
Messages: 120
Registered: November 2012
Location: France
Karma: 2
Senior Member
add to buddy list
ignore all messages by this user
This is what I end up with :

Query #1 on MasterDB: time taken: 0.0008, affected rows: 1, total sql time: 0.0008

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.posted_msg_count, u.topics_per_page, u.ignore_list, u.ignore_list, u.buddy_list, u.id, u.group_leader_list, u.email, u.login, u.sq, u.ban_expiry, u.flag_cc FROM fud30_ses s INNER JOIN fud30_users u ON u.id=(CASE WHEN s.user_id>2000000000 THEN 1 ELSE s.user_id END) LEFT OUTER JOIN fud30_themes t ON t.id=u.theme WHERE s.ses_id='8e146f46e1332e5f46c5a56971793c39'

Query #2 on MasterDB: time taken: 0.0003, affected rows: 0, total sql time: 0.0011

UPDATE fud30_users SET last_visit=1377419126 WHERE id=2

Query #3 on MasterDB: time taken: 0.0004, affected rows: 28, total sql time: 0.0015

SELECT m.subject, m.id, m.post_stamp, u.id, u.alias, f.cat_id, f.forum_icon, f.id, f.last_post_id, f.moderators, f.name, f.descr, f.url_redirect, f.post_count, f.thread_count, fr.last_view, mo.id, COALESCE(g2.group_cache_opt, g1.group_cache_opt) AS group_cache_opt, c.cat_opt FROM fud30_fc_view v INNER JOIN fud30_cat c ON c.id=v.c INNER JOIN fud30_forum f ON f.id=v.f INNER JOIN fud30_group_cache g1 ON g1.user_id=2147483647 AND g1.resource_id=f.id LEFT JOIN fud30_msg m ON f.last_post_id=m.id LEFT JOIN fud30_users u ON u.id=m.poster_id LEFT JOIN fud30_forum_read fr ON fr.forum_id=f.id AND fr.user_id=2 LEFT JOIN fud30_mod mo ON mo.user_id=2 AND mo.forum_id=f.id LEFT JOIN fud30_group_cache g2 ON g2.user_id=2 AND g2.resource_id=f.id WHERE f.parent = 0 ORDER BY v.id

Query #4 on MasterDB: time taken: 0.0003, affected rows: 0, total sql time: 0.0018

UPDATE fud30_ses SET sys_id='1b713ce61e333d91342a4438b5876f1b', forum_id=0, time_sec=1377419126, action='Browsing the <a href=\"index.php?t=index\">forum list</a>', returnto='t=index&' WHERE id=27

Query #5 on MasterDB: time taken: 0.0002, affected rows: 1, total sql time: 0.0020

SELECT count(*) FROM fud30_users WHERE users_opt>=16777216 AND users_opt & 16777216 > 0

Query #6 on MasterDB: time taken: 0.0001, affected rows: 1, total sql time: 0.0021

SELECT count(*) FROM fud30_msg_report

Query #7 on MasterDB: time taken: 0.0001, affected rows: 1, total sql time: 0.0023

SELECT count(*) FROM fud30_thr_exchange

Query #8 on MasterDB: time taken: 0.0002, affected rows: 1, total sql time: 0.0024

SELECT count(*) FROM fud30_msg m INNER JOIN fud30_thread t ON m.thread_id=t.id INNER JOIN fud30_forum f ON t.forum_id=f.id WHERE m.apr=0 AND f.forum_opt>=2

Query #9 on MasterDB: time taken: 0.0002, affected rows: 1, total sql time: 0.0026

SELECT count(*) FROM fud30_pmsg WHERE duser_id=2 AND fldr=1 AND read_stamp=0

Query #10 on MasterDB: time taken: 0.0002, affected rows: 1, total sql time: 0.0028

SELECT sc.*, m.subject AS last_msg_subject, u.alias AS last_user_alias FROM fud30_stats_cache sc INNER JOIN fud30_users u ON u.id=sc.last_user_id LEFT JOIN fud30_msg m ON m.id=4426 WHERE sc.cache_age>1377419026 


I'd like these messages to disappear of course.
Additionaly, I still can't display pictures that I have uploaded.

The new Announcement manager works fine.


Re: After upgrade from 3.0.4 on my test forum :) [message #169151 is a reply to message #169150] Sun, 25 August 2013 05:17 Go to previous messageGo to next message
naudefj is currently offline  naudefj   
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
1. Disable debugging.

2. Search for "Images uploaded don't show up in message"
Re : Re: After upgrade from 3.0.4 on my test forum :) [message #169152 is a reply to message #169151] Sun, 25 August 2013 05:24 Go to previous message
TheDude is currently offline  TheDude
Messages: 120
Registered: November 2012
Location: France
Karma: 2
Senior Member
add to buddy list
ignore all messages by this user
Perfect ! Smile

Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Version 3.0.5RC2 Installation Bugs
Next Topic: Errors version 3.0.5RC2
Goto Forum:
  

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

Current Time: Thu Dec 14 23:46:06 EST 2017

Total time taken to generate the page: 0.00663 seconds