[Skip to main content](#vessel-content) # ERROR 500 ## - **[Kenzo](/forum/user/4526-kenzo "View Kenzo's Profile")** - [![Kenzo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4526-kenzo "View Kenzo's Profile") Topic Author - [ Offline](/forum/user/4526-kenzo) Less More - Posts: 33 - Thank you received: 0 - - 13 years 11 months ago [\#78248](#78248) by [Kenzo](/forum/user/4526-kenzo "View Kenzo's Profile") *[ERROR 500](/forum/3-bug-report/76062-error-500#78248 "Hello Hikashop Team, I have updated to joomla 3.0, and installed hikashop new version, maybe to soon. But now i got: 500 - Ha ocurrido un error. SQL=SELECT * FROM n28py_hikashop_widget WHERE widget_published=1 ORDER BY widget_ordering ASC")* was created by *[Kenzo](/forum/user/4526-kenzo "View Kenzo's Profile")* Hello Hikashop Team, I have updated to joomla 3.0, and installed hikashop new version, maybe to soon. But now i got: 500 - Ha ocurrido un error. SQL=SELECT * FROM n28py_hikashop_widget WHERE widget_published=1 ORDER BY widget_ordering ASC Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NjA2Mi1lcnJvci01MDA/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4077 - - [](http://obsi.dev) - 13 years 11 months ago [\#78256](#78256) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[ERROR 500](/forum/3-bug-report/76062-error-500#78256 "Hello Hikashop Team, I have updated to joomla 3.0, and installed hikashop new version, maybe to soon. But now i got: 500 - Ha ocurrido un error. SQL=SELECT * FROM n28py_hikashop_widget WHERE widget_published=1 ORDER BY widget_ordering ASC")* Hi, Please use the HikaMysqli driver in order to have the mysql error. [ www.hikashop.com/en/forum/2-general-talk...p-20-beta.html#72321](http://www.hikashop.com/en/forum/2-general-talk-about-hikashop/72191-hikashop-20-beta.html#72321) Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NjA2Mi1lcnJvci01MDA/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Kenzo](/forum/user/4526-kenzo "View Kenzo's Profile")** - [![Kenzo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4526-kenzo "View Kenzo's Profile") Topic Author - [ Offline](/forum/user/4526-kenzo) Less More - Posts: 33 - Thank you received: 0 - - 13 years 11 months ago [\#78280](#78280) by [Kenzo](/forum/user/4526-kenzo "View Kenzo's Profile") Replied by *[Kenzo](/forum/user/4526-kenzo "View Kenzo's Profile")* on topic *[ERROR 500](/forum/3-bug-report/76062-error-500#78280 "Hello Hikashop Team, I have updated to joomla 3.0, and installed hikashop new version, maybe to soon. But now i got: 500 - Ha ocurrido un error. SQL=SELECT * FROM n28py_hikashop_widget WHERE widget_published=1 ORDER BY widget_ordering ASC")* Hi Jerome, i went to the other Topic, installed (com_hikashop_Starter_2_0_0_2012-10-26.zip), followed the steps, no result, the error doesnt go away. And later on i see like alot more .zip. ¿Wich is the one i should install ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NjA2Mi1lcnJvci01MDA/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4077 - - [](http://obsi.dev) - 13 years 11 months ago [\#78281](#78281) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[ERROR 500](/forum/3-bug-report/76062-error-500#78281 "Hello Hikashop Team, I have updated to joomla 3.0, and installed hikashop new version, maybe to soon. But now i got: 500 - Ha ocurrido un error. SQL=SELECT * FROM n28py_hikashop_widget WHERE widget_published=1 ORDER BY widget_ordering ASC")* Hi, I asked you to install the HikaMysqli driver so install "hikamysqli.zip". Read the topic message 72321. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NjA2Mi1lcnJvci01MDA/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Kenzo](/forum/user/4526-kenzo "View Kenzo's Profile")** - [![Kenzo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4526-kenzo "View Kenzo's Profile") Topic Author - [ Offline](/forum/user/4526-kenzo) Less More - Posts: 33 - Thank you received: 0 - - 13 years 11 months ago [\#78285](#78285) by [Kenzo](/forum/user/4526-kenzo "View Kenzo's Profile") Replied by *[Kenzo](/forum/user/4526-kenzo "View Kenzo's Profile")* on topic *[ERROR 500](/forum/3-bug-report/76062-error-500#78285 "Hello Hikashop Team, I have updated to joomla 3.0, and installed hikashop new version, maybe to soon. But now i got: 500 - Ha ocurrido un error. SQL=SELECT * FROM n28py_hikashop_widget WHERE widget_published=1 ORDER BY widget_ordering ASC")* Perfect, i didn't had the correct permissions, sorry, Now i got this error: 1054 - Ha ocurrido un error. SQL Error Unknown column 'widget_published' in 'where clause' SELECT * FROM n28py_hikashop_widget WHERE widget_published=1 ORDER BY widget_ordering ASC Thank you again. - [ ![1054.JPG](/forum/attachment/7135) ](/forum/attachment/7135 "1054.JPG") [ ](/forum/attachment/7135?download=1 "1054.JPG") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NjA2Mi1lcnJvci01MDA/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4077 - - [](http://obsi.dev) - 13 years 11 months ago [\#78287](#78287) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[ERROR 500](/forum/3-bug-report/76062-error-500#78287 "Hello Hikashop Team, I have updated to joomla 3.0, and installed hikashop new version, maybe to soon. But now i got: 500 - Ha ocurrido un error. SQL=SELECT * FROM n28py_hikashop_widget WHERE widget_published=1 ORDER BY widget_ordering ASC")* Hi, It's like HikaShop does not execute SQL updates. HikaShop 1.5.9 added new columns in the widget table. From which HikaShop version did you update ? I think you would have to execute the SQL from 1.5.9, 1.6.0 and 2.0.0 updates. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NjA2Mi1lcnJvci01MDA/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Kenzo](/forum/user/4526-kenzo "View Kenzo's Profile")** - [![Kenzo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4526-kenzo "View Kenzo's Profile") Topic Author - [ Offline](/forum/user/4526-kenzo) Less More - Posts: 33 - Thank you received: 0 - - 13 years 11 months ago [\#80297](#80297) by [Kenzo](/forum/user/4526-kenzo "View Kenzo's Profile") Replied by *[Kenzo](/forum/user/4526-kenzo "View Kenzo's Profile")* on topic *[ERROR 500](/forum/3-bug-report/76062-error-500#80297 "Hello Hikashop Team, I have updated to joomla 3.0, and installed hikashop new version, maybe to soon. But now i got: 500 - Ha ocurrido un error. SQL=SELECT * FROM n28py_hikashop_widget WHERE widget_published=1 ORDER BY widget_ordering ASC")* Hi Jerome, Excuse my stupidity, i dont remember wich version it exactly was, normally i update each new update that comes out, that why i update to soon to Joomla 3.0. Can you explain me briefly how to solve it ? I have the essential Hikashop if it matters. I have to execute and older SQL ? or Install something ? Regards. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NjA2Mi1lcnJvci01MDA/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4077 - - [](http://obsi.dev) - 13 years 11 months ago [\#80312](#80312) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[ERROR 500](/forum/3-bug-report/76062-error-500#80312 "Hello Hikashop Team, I have updated to joomla 3.0, and installed hikashop new version, maybe to soon. But now i got: 500 - Ha ocurrido un error. SQL=SELECT * FROM n28py_hikashop_widget WHERE widget_published=1 ORDER BY widget_ordering ASC")* Hi, Would it be possible to have a backend access for you store and a PHPMyAdmin access ? We would make a manual SQL update of your HikaShop and check your server configuration. You can send me theses access by private message. Thanks --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NjA2Mi1lcnJvci01MDA/dG1wbD1tYXJrZG93bg==) 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.085 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)