Гость
01 Июнь 2012 04:26

When I click on "Sections" in the Kobalt main menu, I get the error below

500 - An error has occurred.

Table 'db17342_sa22644_main.jos_js_res_sections' doesn't exist SQL=SELECT a.*, (SELECT COUNT() FROM jos_js_res_categories WHERE section_id = a.id) as fieldnum FROM jos_js_res_sections AS a WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.name asc Table 'db17342_sa22644_main.jos_js_res_sections' doesn't exist SQL=SELECT a., (SELECT COUNT() FROM jos_js_res_categories WHERE section_id = a.id) as fieldnum FROM jos_js_res_sections AS a WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.name asc Table 'db17342_sa22644_main.jos_js_res_sections' doesn't exist SQL=SELECT a., (SELECT COUNT(*) FROM jos_js_res_categories WHERE section_id = a.id) as fieldnum FROM jos_js_res_sections AS a WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.name asc

Последние изменения: 02 Март 2014


Гость
01 Июнь 2012 04:28

Same for "Votes" menu

500 - An error has occurred.

Unknown column 'a.ref_id' in 'on clause' SQL=SELECT a.,r.title AS record, r.id AS record_id,u.username, u.id AS userid, u.email AS useremail FROM jos_js_res_vote AS a LEFT JOIN jos_js_res_record AS r ON r.id = a.ref_id LEFT JOIN jos_js_res_record_category AS c ON c.record_id = r.id LEFT JOIN jos_users AS u ON u.id = a.user_id GROUP BY a.id ORDER BY a.ctime desc Unknown column 'a.ref_id' in 'on clause' SQL=SELECT a.,r.title AS record, r.id AS record_id,u.username, u.id AS userid, u.email AS useremail FROM jos_js_res_vote AS a LEFT JOIN jos_js_res_record AS r ON r.id = a.ref_id LEFT JOIN jos_js_res_record_category AS c ON c.record_id = r.id LEFT JOIN jos_users AS u ON u.id = a.user_id GROUP BY a.id ORDER BY a.ctime desc Unknown column 'a.ref_id' in 'on clause' SQL=SELECT a.*,r.title AS record, r.id AS record_id,u.username, u.id AS userid, u.email AS useremail FROM jos_js_res_vote AS a LEFT JOIN jos_js_res_record AS r ON r.id = a.ref_id LEFT JOIN jos_js_res_record_category AS c ON c.record_id = r.id LEFT JOIN jos_users AS u ON u.id = a.user_id GROUP BY a.id ORDER BY a.ctime desc

Return to Control Panel


Гость
01 Июнь 2012 04:34

This error connects to the wrong installation too. Please wait for corrected release of the component.


Sergey
Total posts: 13,748
03 Июнь 2012 07:22

Something wrong with installation. tables are gone or not installed properly. Try to update Cobalt over.


Гость
22 Авг 2012 22:04

I have the exact same problem did any one have a fix for this yet?


Sergey
Total posts: 13,748
22 Авг 2012 22:54

Tryt o uninstall and install it again. Sometimes this works.

If not you will need to install tables manually.


Гость
23 Авг 2012 15:49

how do i install tables manually?


Sergey
Total posts: 13,748
23 Авг 2012 21:10

There is SQL file in the com_cobalt.v.7.****.zip/admin/sql. Or you can probably find it in joomlaroot/administrator/com_cobalt/sql/install.utf8.sql

You have to run this query to your DB. But you also have to replace #__ with your prefix.

Работает на Cobalt