Sql error when installing Hikashop

-- url of the page with the problem -- : admin panel
-- HikaShop version -- : 2.2.3
-- Joomla version -- : 3.2.1
-- PHP version -- : 5.3.3.7
-- Browser(s) name and version -- : Google Chrome
-- Error-message(debug-mod must be tuned on) -- : An error has occurred.
0 SQL=SELECT * FROM szbg5_hikashop_widget WHERE widget_published=1 ORDER BY widget_ordering ASC

I tried to install Hikashop on a test domain today, but I received sometimes 500 error sometimes SQL errors, like this one:

An error has occurred.
0 SQL=SELECT * FROM szbg5_hikashop_widget WHERE widget_published=1 ORDER BY widget_ordering ASC

How to solve it?

Thanks

Hi,

That SQL query is correct. If it generates an error, it means that this table is probably missing in the database or that it doesn't have the widget_published column. So you should check your database with phpmyadmin and see if you have that table and if it's not missing that column. If it is, then add the column/table based on the structure of the table in the file administrator/components/com_hikashop/tables.sql

Great, I'll check now to see if it works.

everything works now... I had to recreate all the tables, probably there was a problem with the prefix of the table... I had to replace "#_", not only "#" with my table prefix

CREATE TABLE IF NOT EXISTS `#__hikashop_address` (
`address_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`address_user_id` int(10) unsigned NOT NULL DEFAULT '0',

to

CREATE TABLE IF NOT EXISTS `szbg5_hikashop_address` (
`address_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`address_user_id` int(10) unsigned NOT NULL DEFAULT '0',

Thanks!