SmartCJ Support Forum

Code: Select all

Fatal error: Uncaught exception 'Exception' with message 'Mysql error:: 1146 (Table 'porn_tube_scj.rot_gallery_data4' doesn't exist) (ext_db_link) 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_keywords, gr_data.group_custom_var1, gr_data.group_custom_var2, gr_data.group_custom_var3, gr_data.status as group_status, gr.parent_id, tmp.* FROM rot_groups AS gr JOIN rot_groups_data AS gr_data ON gr_data.group_id = gr.id and gr_data.site_id = '4' LEFT OUTER JOIN ( SELECT gi.url, g.*, gs.total_shows, gs.total_ctr, gd.alt, gd.description FROM rot_gallery_info AS gi JOIN rot_galleries AS g ON g.gallery_md5 = gi.gallery_md5 and g.rgroup = 0 and g.sponsor_id = 0 and content_type = '0' JOIN rot_gallery_stats4 as gs on gs.thumb_id = g.id JOIN rot_gallery_data4 AS gd ON gd.gallery_md5 = g.gallery_md5 WHERE gi.url != 0 and gi.source_url = '4' ) as tmp ON tmp.url = gr.id in /home/httpd/domain.com/content/html/scj/includes/db_modules/mysql.php on line 62

Code: Select all

Fatal error: Uncaught exception 'Exception' with message 'Mysql error:: 1050 (Table 'rot_gallery_data2' already exists) (ext_db_link) in query CREATE TABLE rot_gallery_data2 LIKE rot_gallery_data . (domain.com) ' in /home/httpd/domain.com/content/html/scj/includes/db_modules/mysql.php:62 Stack trace: #0 /home/httpd/domain.com/content/html/scj/includes/db_modules/mysql.php(75): db_error('CREATE TABLE ro...', 1050, 'Table 'rot_gall...', 'ext_db_link') #1 /home/httpd/domain.com/content/html/scj/admin/files/rot_settings.php(0): db_query() #2 /home/httpd/domain.com/content/html/scj/admin/index.php(0): unknown() #3 {main} thrown in /home/httpd/domain.com/content/html/scj/includes/db_modules/mysql.php on line 62 err