When I activate the Joomla diagnostic console (the on that disaplyas a lot of information at the bottom of every page) I get this database error message on all of my Joomla pages along with a 500 error:
JDatabaseMySQLi::query: 1146 - Table 'c1test.krt_vm_product' doesn't exist SQL=SELECT content.product_id AS id, COUNT(comments.product_id) AS count FROM krt_vm_product AS content LEFT JOIN krt_vm_product_reviews AS comments ON comments.product_id = content.product_id WHERE comments.published AND ( content.product_id = 16 OR content.product_id = 20 OR content.product_id = 1 OR content.product_id = 21 OR content.product_id = 9 OR content.product_id = 12 ) GROUP BY comments.product_id ;
what version of vmart are you using
?
2.0.6
have you tried the "install or update tables" in vmart tools?
I tried that now and it didn´t make any difference. Except that after I did that the Joomla database fix function says I got this error in my database:
Tabell 'krt_session' saknar kolumnen 'data' med typen 'MEDIUMTEXT'. (Från filen 1.7.1-2011-09-15.sql.)
Translated:
Tabel 'krt_session' missing column 'data' with type 'MEDIUMTEXT'. (from file 1.7.1-2011-09-15.sql.)
I click fix but it doesn´t make any difference.