Hello Krileon,
When I enabled the error mode, I received the fallowing error:
start
500 - An error has occurred.
JDatabaseMySQL::query: 126 - Incorrect key file for table '/tmp/#sql_100f_0.MYI'; try to repair it SQL=SELECT a.`id`, a.`name`, a.`alias`, a.`exclusive`, a.`rate`, a.`validity`, IF( ( a.`recurring_max_times` = 0 ), 'unlimited', a.`recurring_max_times` ) AS `recurring_max`, a.`first_rate`, a.`first_validity`, a.`ordering`, a.`published`, a.`allow_newsubscriptions`, a.`allow_registration`, a.`allow_upgrade_to_this`, a.`access`, a.`default`, a.`usergroup`, IF( ( a.`owner` = 0 ), 'System', c.`username` ) AS `owner_name`, COUNT( DISTINCT d.`id` ) AS `change_logs`, COUNT( DISTINCT e.`id` ) AS `subscribers`, a.`currency`, a.`cssclass`, a.`description`, b.`id` AS `parent` FROM `jos_cbsubs_plans` AS a LEFT JOIN `jos_cbsubs_plans` AS b ON b.`id` = a.`parent` LEFT JOIN `jos_users` AS c ON c.`id` = a.`owner` LEFT JOIN `jos_cbsubs_history` AS d ON d.`table_name` = '#__cbsubs_plans' AND d.`table_key_id` = a.`id` LEFT JOIN `jos_cbsubs_subscriptions` AS e ON e.`plan_id` = a.`id` GROUP BY a.`id` ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, ( 11000 + a.`ordering` ) ) ASC, a.`ordering` ASC, b.`ordering` ASC, a.`ordering` LIMIT 20
end
Also below the above error was a "Call stack" table with 23 rows.
What do you recommend?
Thanks,