SmartCJ Support Forum

I tried to upgrade the script from 1.49 to 1.50 and got the following error on header of index page:

Mysql error: 1054 (Unknown column 'g.url' in 'where clause') in query SELECT gr.name as category_name, gr_data.custom_name as category_custom_name, gr_data.description as category_description, gr.id as category_id, gr_data.group_custom_var1, gr_data.group_custom_var2, gr_data.group_custom_var3, gr_data.status as group_status, gr.parent_id, g.*, gs.total_shows FROM rot_galleries AS g JOIN rot_gallery_stats as gs on gs.thumb_id = g.id JOIN rot_groups AS gr ON g.url = gr.id JOIN rot_groups_data AS gr_data ON g.url = gr_data.group_id where g.rgroup = 0 and g.sponsor_id = 0 and g.url != 0 and content_type = '0' and gr_data.site_id = '0' and g.source_url = '' order by category_name asc.
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/admin/domains/domain.com/public_html/scj/includes/db_modules/mysql.php on line 236
Mysql error: 1054 (Unknown column 'g.url' in 'where clause') in query SELECT gr.name as category_name, gr_data.custom_name as category_custom_name, gr_data.description as category_description, gr.id as category_id, gr_data.group_custom_var1, gr_data.group_custom_var2, gr_data.group_custom_var3, gr_data.status as group_status, gr.parent_id, g.*, gs.total_shows FROM rot_galleries AS g JOIN rot_gallery_stats as gs on gs.thumb_id = g.id JOIN rot_groups AS gr ON g.url = gr.id JOIN rot_groups_data AS gr_data ON g.url = gr_data.group_id where g.rgroup = 0 and g.sponsor_id = 0 and g.url != 0 and content_type = '0' and gr_data.site_id = '0' and g.source_url = '' order by gs.total_ctr desc.
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/admin/domains/domain.com/public_html/scj/includes/db_modules/mysql.php on line 236

The galleries are not loading also on main page. How can I fix the problem ?

Did you interrupt the update ?

yes, they are not upgraded on 1.50
here is the last few line at the end of upgrade on ssh

Stopping rotation for a while
Creating rot_gallery_info
Altering rot_gallery_data
Can not delete file ./host.php. Please, delete it manually and rerun update.[admin]

So did you do this ?

yes I deleted host.php than run update.php again, that they requested to delete ./files/graph.php file.Than I deleted that again that file, run update.php again than requested to delete ./bin/hostfile.php....etc...etc...
Is that any solution for this problem or only to remove completly the script ?

The problem is that you've installed script under one user and run update using another one.

The solution is either change files owner ot update using the same user.

yes, that was the problem.
Problem fixed
Thanks.

NP