SmartCJ Support Forum

Code: Select all

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/xxx/tentaclerapevideo.com/scj/includes/db_modules/mysql.php on line 236
Mysql error: 1054 (Unknown column 'g.gallery_slug' in 'field list') in query SELECT id, g.gallery_slug, g.gallery_md5, sponsor_id, url, source_url, rot_content_id, embed_template, thumb_url, embed_code, flv_url, flv_size_x, flv_size_y, flv_thumb_url, tags, type, rgroup, content, content_type, duration, date, activation_date, casts, clicks, rating, priority, crop_profile_id, status, alt, description, custom_var1, custom_var2, custom_var3 FROM rot_galleries as g LEFT JOIN rot_gallery_data as gd ON gd.gallery_md5 = g.gallery_md5 WHERE id IN (2862,2074,2048,1867,1956,1940,1915,1921,3623,1913,2149,3541,2342,2856,2996,1933,2202,3367,2477,1926,2937,2221,3637,3354,2297,3262,1865,1944,1893,2273,2789,2162,3358,3486,2007,3683,2975,2484,1878,2519,1872,1905,1965,3495,2734,2300,2508,2168,3518,3081,3171,2018,2834,2587,2040,1919,3463,2249,3092,1900,3390,2957,1924,2227,3134,2927,2729,2175,3098,2106,2031,3008,2438,2885,2016,2251,2278,2490,2388,2081,3445,3149,3207,2261,2591,2467,2671,2299,2426,2710) .
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/xxx/tentaclerapevideo.com/scj/includes/db_modules/mysql.php on line 236
Mysql error: 1054 (Unknown column 'g.gallery_slug' in 'field list') in query SELECT id, g.gallery_slug, g.gallery_md5, sponsor_id, url, source_url, rot_content_id, embed_template, thumb_url, embed_code, flv_url, flv_size_x, flv_size_y, flv_thumb_url, tags, type, rgroup, content, content_type, duration, date, activation_date, casts, clicks, rating, priority, crop_profile_id, status, alt, description, custom_var1, custom_var2, custom_var3 FROM rot_galleries as g LEFT JOIN rot_gallery_data as gd ON gd.gallery_md5 = g.gallery_md5 WHERE id IN (29,30,31,32,33,34) .
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/xxx/tentaclerapevideo.com/scj/includes/db_modules/mysql.php on line 236

Code: Select all

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'd' (0) in /home/xxx/tentacle.com/scj/includes/db_modules/mysql.php on line 11
Can not connect to database server.