[Skip to main content](#vessel-content) # Sql error when installing Hikashop ## - **[marcred](/forum/user/30977-marcred "View marcred's Profile")** - [![marcred's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30977-marcred "View marcred's Profile") Topic Author - [ Offline](/forum/user/30977-marcred) Less More - Posts: 3 - Thank you received: 0 - - 12 years 8 months ago [\#142137](#142137) by [marcred](/forum/user/30977-marcred "View marcred's Profile") *[Sql error when installing Hikashop](/forum/25-install-update/865521-sql-error-when-installing-hikashop#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")* was created by *[marcred](/forum/user/30977-marcred "View marcred's Profile")* -- 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NTUyMS1zcWwtZXJyb3Itd2hlbi1pbnN0YWxsaW5nLWhpa2FzaG9wP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 12 years 8 months ago [\#142141](#142141) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Sql error when installing Hikashop](/forum/25-install-update/865521-sql-error-when-installing-hikashop#142141 "-- 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NTUyMS1zcWwtZXJyb3Itd2hlbi1pbnN0YWxsaW5nLWhpa2FzaG9wP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[marcred](/forum/user/30977-marcred "View marcred's Profile")** - [![marcred's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30977-marcred "View marcred's Profile") Topic Author - [ Offline](/forum/user/30977-marcred) Less More - Posts: 3 - Thank you received: 0 - - 12 years 8 months ago [\#142150](#142150) by [marcred](/forum/user/30977-marcred "View marcred's Profile") Replied by *[marcred](/forum/user/30977-marcred "View marcred's Profile")* on topic *[Sql error when installing Hikashop](/forum/25-install-update/865521-sql-error-when-installing-hikashop#142150 "-- 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")* Great, I'll check now to see if it works. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NTUyMS1zcWwtZXJyb3Itd2hlbi1pbnN0YWxsaW5nLWhpa2FzaG9wP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[marcred](/forum/user/30977-marcred "View marcred's Profile")** - [![marcred's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30977-marcred "View marcred's Profile") Topic Author - [ Offline](/forum/user/30977-marcred) Less More - Posts: 3 - Thank you received: 0 - - 12 years 8 months ago [\#142153](#142153) by [marcred](/forum/user/30977-marcred "View marcred's Profile") Replied by *[marcred](/forum/user/30977-marcred "View marcred's Profile")* on topic *[Sql error when installing Hikashop](/forum/25-install-update/865521-sql-error-when-installing-hikashop#142153 "-- 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")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NTUyMS1zcWwtZXJyb3Itd2hlbi1pbnN0YWxsaW5nLWhpa2FzaG9wP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.094 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)