SmartCJ Support Forum

12.30 select g.id, g.gallery_md5, gs.total_shows as thumb_casts, gs.total_clicks as clicks, if (gs.total_shows < 500, 1, 0) as new_thumb FROM rot_galleries as g JOIN rot_gallery_stats as gs on gs.thumb_id = g.id WHERE g.status = 1 AND g.rgroup != 0 and gs.best_thumb = 'yes' ORDER BY activation_date DESC LIMIT 0, 100# queryitems:: :

i have encountered error on main page.

Mysql error:: 2006 (MySQL server has gone away) (db_link) in query select g.id, g.gallery_md5, gs.total_shows as thumb_casts, gs.total_clicks as clicks, if (gs.total_shows < 500, 1, 0) as new_thumb FROM rot_galleries as g JOIN rot_gallery_stats as gs on gs.thumb_id = g.id WHERE g.status = 1 AND g.rgroup != 0 and gs.best_thumb = 'yes' ORDER BY activation_date DESC LIMIT 0, 100# queryitems.
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/home/kenhirai/db_modules/mysql.php on line 249

another problem about speed. when I click the same gallery for a few times it just lag like hell. first time is usually fast, but if i click on it several time its damn slow...

site just got rejected by trafficholder due to error... so many problems.

finally figure out, its due to reddis cache. when i deactivate it, every load fast nomatter how many times i click... sometime too many addon will just has conflicts...

I don't think redis causes slow down in this situation ..