SmartCJ Support Forum

Code: Select all

Fatal error: Uncaught exception 'Exception' with message 'Mysql error:: 1054 (Unknown column 'h' in 'field list') (db_link) in query insert into day (h) values ('5.smartcj.sponsor'). (freepornmega.com) ' in /home/era/freepornmega.com/ten/includes/db_modules/mysql.php:58 Stack trace: #0 /home/era/freepornmega.com/ten/includes/db_modules/mysql.php(71): db_error('insert into day...', 1054, 'Unknown column ...', 'db_link') #1 /home/era/freepornmega.com/ten/includes/db_modules/mysql.php(148): db_query('insert into day...', 'db_link') #2 /home/era/freepornmega.com/ten/admin/files/rot_sponsors.php(0): db_perform() #3 /home/era/freepornmega.com/ten/admin/index.php(0): unknown() #4 {main} thrown in /home/era/freepornmega.com/ten/includes/db_modules/mysql.php on line 58
err
Fatal error: Call to private method Session::write() from context '' in Unknown on line 0

Fatal error: Call to private method Session::close() from context '' in Unknown on line 0

Code: Select all

2014-07-16 18:08:10 : Mysql error: 1054 (Unknown column 'rot_models_data.model_total_galleries' in 'field list') in query UPDATE rot_models_data

	INNER JOIN (SELECT model_id, SUM( gs.total_ctr)/count(gi.gallery_id) AS total_ctr, count(gi.gallery_id) as total_galleries
	FROM rot_gal2model AS g2m 
	LEFT JOIN rot_gallery_info AS gi ON gi.gallery_id = g2m.gallery_id
	LEFT JOIN rot_gallery_stats1 AS gs ON gs.gallery_id = gi.gallery_id and gs.best_thumb = 'yes'
	WHERE gi.gallery_status = 'active' 
	GROUP BY model_id) as tmp

	ON (rot_models_data.model_id = tmp.model_id and rot_models_data.site_id IN (1) )
	SET rot_models_data.model_total_galleries = tmp.total_galleries, rot_models_data.model_average_ctr = tmp.total_ctr