Code: Select all
php rotation.php check_search_queries=trueCode: Select all
Core error: Mysql error 1146: Table 'base_name.rot_gallery_stats26' doesn't exist (SELECT gs.thumb_id, gi.sponsor_id, gi.url, gi.crop_profile_id, gi.content_count, gt.thumb_url, gt.thumb_url, gt.extra_thumb, gs.total_shows, gs.total_ctr, gd.alt, gd.description, gd.custom_var1, gd.custom_var2, gd.custom_var3 FROM rot_gallery_info AS gi JOIN rot_gallery_stats26 as gs on gs.gallery_id = gi.gallery_id JOIN rot_gallery_data1 as gd on gd.gallery_id = gi.gallery_id JOIN rot_thumbs AS gt ON gt.thumb_id = gs.thumb_id WHERE gi.gallery_type = 1 and gi.source_url = '26' /* site_id */ and content_type = '0' /* set_id */ )
Core error: Rotation warning: you run rotation.php without the HTTP_HOST variable. This can affect traffic counting, please fix crontab job.
Core error: Mysql error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY gs.total_ctr DESC LIMIT 0, 1# queryitems' at line 4 (SELECT gs.gallery_id, gs.thumb_id, gi.sponsor_id, gi.content_count, gi.content_type, gs.total_shows, gs.total_clicks, gs.total_ctr, gt.thumb_url, gd.*, gi.content_count, gi.crop_profile_id, gs.activation_date, gi.added_date, gi.duration, gi.url, gi.gallery_total_shows, gi.sponsor_id, gi.source_url, gi.custom_gallery FROM rot_gallery_stats27 as gs JOIN rot_gallery_info as gi on gi.gallery_id = gs.gallery_id JOIN rot_gallery_data1 as gd on gd.gallery_id = gs.gallery_id JOIN rot_thumbs as gt on gt.thumb_id = gs.thumb_id WHERE 1 = 1 AND gi.gallery_status = 'active' AND gi.gallery_type = 0 and gs.best_thumb = 'yes' and gs.group_id = 0 and ) ORDER BY gs.total_ctr DESC LIMIT 0, 1# queryitems)