Hello,

When I select the "Plans" menu link, it take longer time to load the "Plans" page than any other page in CBSubs, CB or any other in joomla backend.

Also, when the "Plans" page show, it doesn't list the plans in the table as it should, I have to select the "plan" I want from the "Filter" above to show it.

What can be the problem?





Post edited by: tto, at: 2010/11/23 15:37

Post edited by: krileon, at: 2010/12/13 21:37

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,

Hello,

I checked with cpanel & phpmyadmin, no errors at all!

I also had a professional programmer to check, no errors in the database, everything is fine.

What can I do?