What is this error?

Post Reply
kenhirai
Posts: 330
Joined: Wed Jan 02, 2013 4:25 am

What is this error?

Post by kenhirai »

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:: :
kenhirai
Posts: 330
Joined: Wed Jan 02, 2013 4:25 am

Re: What is this error?

Post by kenhirai »

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
kenhirai
Posts: 330
Joined: Wed Jan 02, 2013 4:25 am

Re: What is this error?

Post by kenhirai »

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.
kenhirai
Posts: 330
Joined: Wed Jan 02, 2013 4:25 am

Re: What is this error?

Post by kenhirai »

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...
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: What is this error?

Post by admin »

I don't think redis causes slow down in this situation ..
Don't forget to run script update
Post Reply