Tags & Search Not Working

Post Reply
trevesty
Posts: 5
Joined: Thu Oct 13, 2016 6:25 pm

Tags & Search Not Working

Post by trevesty »

Hi,

I get error on tag pages:

"Sorry, there was an error. Please, reload page in a minute."

In logs:

Code: Select all

2017-02-25 12:19:46:#0 ../scj/includes/db_modules/mysql.php(94): db_error('SELECT   gs.gal...', 1054, 'Unknown column ...', 'db_link')
#1 ../scj/includes/libs/tpl_functions.php(0): db_query('SELECT   gs.gal...', 'db_link')
#2 ../scj/includes/libs/tpl_functions.php(0): rot_get_item_execute_query('SELECT   gs.gal...', Array, Array)
#3 ../scj/includes/libs/tpl_functions.php(0): rot_get_items(Array, 0, Array)
#4 ../scj/tube/index.php(0): rot_create_page('content_search', 0, Array, Array, Array)
#5 {main}
Mysql error:: 1054 (Unknown column 'rs.date' in 'where clause') (db_link) in query 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, gi.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_stats1 as gs  JOIN rot_gallery_data1 as gd on gd.gallery_id = gs.gallery_id 
			JOIN rot_gallery_info as gi on gi.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 rs.date > "2017-01-26 00:00:00"  and gs.gallery_id IN (5095)  ORDER BY  field(gs.gallery_id, 5095) # queryitems. (vpornclips.com) 
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Tags & Search Not Working

Post by admin »

Hi,

what build is that ?
Don't forget to run script update
trevesty
Posts: 5
Joined: Thu Oct 13, 2016 6:25 pm

Re: Tags & Search Not Working

Post by trevesty »

Build 201702241147
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Tags & Search Not Working

Post by admin »

PM admin area plz and a link where you see an errot

Thank you
Don't forget to run script update
trevesty
Posts: 5
Joined: Thu Oct 13, 2016 6:25 pm

Re: Tags & Search Not Working

Post by trevesty »

ok, its done
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Tags & Search Not Working

Post by admin »

Try to run update plz
Don't forget to run script update
trevesty
Posts: 5
Joined: Thu Oct 13, 2016 6:25 pm

Re: Tags & Search Not Working

Post by trevesty »

I've left a request with my sysadmin to do so.
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Tags & Search Not Working

Post by admin »

ok
Don't forget to run script update
trevesty
Posts: 5
Joined: Thu Oct 13, 2016 6:25 pm

Re: Tags & Search Not Working

Post by trevesty »

just fyi for others who may have same issue - latest build as of today fixes
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Tags & Search Not Working

Post by admin »

Ok, thanks
Don't forget to run script update
Post Reply