Sql error when installing Hikashop

  • Posts: 3
  • Thank you received: 0
10 years 9 months ago #142137

-- 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

Please Log in or Create an account to join the conversation.

  • Posts: 82909
  • Thank you received: 13379
  • MODERATOR
10 years 9 months ago #142141

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

Please Log in or Create an account to join the conversation.

  • Posts: 3
  • Thank you received: 0
10 years 9 months ago #142150

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

Please Log in or Create an account to join the conversation.

  • Posts: 3
  • Thank you received: 0
10 years 9 months ago #142153

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!

Please Log in or Create an account to join the conversation.

Time to create page: 0.059 seconds
Powered by Kunena Forum