News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Database error

Started by erka, May 27, 2012, 20:27:05 PM

Previous topic - Next topic

erka

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 ;

PRO

what version of vmart are you using
?

erka


PRO

have you tried the "install or update tables" in vmart tools?


erka

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.