[Skip to main content](#vessel-content)

#   Error 500 during installation

##

- **[korzo](/forum/user/34428-korzo "View korzo's Profile")**
- [![korzo's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar34428.png)](/forum/user/34428-korzo "View korzo's Profile") Topic Author
- [ Offline](/forum/user/34428-korzo)

Less More

- Posts: 193
- Thank you received: 76
-
-

11 years 7 months ago -  11 years 7 months ago [\#197015](#197015) by [korzo](/forum/user/34428-korzo "View korzo's Profile")  *[Error 500 during installation](/forum/3-bug-report/876114-error-500-during-installation#197015 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 2.5.28 -- PHP version -- : 5.6.3 -- Error-message(debug-mod must be tuned on) -- : JDatabaseMySQLi::query: 1146 - Table '#&#95;&#95;hikashop&#95;field' doesn't exist SQL=SELECT &#42; FROM pnius&#95;hikashop&#95;field  Call stack:")* was created by *[korzo](/forum/user/34428-korzo "View korzo's Profile")*

-- HikaShop version -- : 2.4.0
-- Joomla version -- : 2.5.28
-- PHP version -- : 5.6.3
-- Error-message(debug-mod must be tuned on) -- : JDatabaseMySQLi::query: 1146 - Table '#__hikashop_field' doesn't exist SQL=SELECT * FROM pnius_hikashop_field

Call stack: Code:

JAdministrator-&gt;dispatch() \administrator\index.php:46 JComponentHelper::renderComponent() \administrator\includes\application.php:153 JComponentHelper::executeComponent() \libraries\joomla\application\component\helper.php:348 require_once() \libraries\joomla\application\component\helper.php:380 JController-&gt;execute() \administrator\components\com_installer\installer.php:18 InstallerControllerInstall-&gt;install() \libraries\joomla\application\component\controller.php:761 InstallerModelInstall-&gt;install() \administrator\components\com_installer\controllers\install.php:29 JInstaller-&gt;install() \administrator\components\com_installer\models\install.php:105 JInstallerComponent-&gt;install() \libraries\joomla\installer\installer.php:472 JInstallerComponent-&gt;update() \libraries\joomla\installer\adapters\component.php:218 com_install() \libraries\joomla\installer\adapters\component.php:978 include_once() \administrator\components\com_hikashop\install.hikashop.php:6 hikashopDatabaseHelper-&gt;checkdb() \administrator\components\com_hikashop\helpers\helper.php:3273 JDatabase-&gt;loadObjectList() \administrator\components\com_hikashop\helpers\database.php:50 JDatabaseMySQLi-&gt;execute() \libraries\joomla\database\database.php:1126 JError::raiseError() \libraries\joomla\database\database\mysqli.php:396 JError::raise() \libraries\joomla\error\error.php:251

Last edit: 11 years 7 months ago by [korzo](/forum/user/34428-korzo "View korzo's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NzYxMTQtZXJyb3ItNTAwLWR1cmluZy1pbnN0YWxsYXRpb24/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[korzo](/forum/user/34428-korzo "View korzo's Profile")**
- [![korzo's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar34428.png)](/forum/user/34428-korzo "View korzo's Profile") Topic Author
- [ Offline](/forum/user/34428-korzo)

Less More

- Posts: 193
- Thank you received: 76
-
-

11 years 7 months ago [\#197017](#197017) by [korzo](/forum/user/34428-korzo "View korzo's Profile")  Replied by *[korzo](/forum/user/34428-korzo "View korzo's Profile")* on topic *[Error 500 during installation](/forum/3-bug-report/876114-error-500-during-installation#197017 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 2.5.28 -- PHP version -- : 5.6.3 -- Error-message(debug-mod must be tuned on) -- : JDatabaseMySQLi::query: 1146 - Table '#&#95;&#95;hikashop&#95;field' doesn't exist SQL=SELECT &#42; FROM pnius&#95;hikashop&#95;field  Call stack:")*

500 - An error has occurred.
JDatabaseMySQLi::query: 1146 - Table '#__hikashop_address' doesn't exist SQL=SHOW COLUMNS FROM #__hikashop_address

Call stack: Code:

JDatabase-&gt;loadObjectList() \administrator\components\com_hikashop\helpers\database.php:96

This error is for all tables.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NzYxMTQtZXJyb3ItNTAwLWR1cmluZy1pbnN0YWxsYXRpb24/dG1wbD1tYXJrZG93bg==) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86564
- Thank you received: 14311
-
-

11 years 7 months ago [\#197047](#197047) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error 500 during installation](/forum/3-bug-report/876114-error-500-during-installation#197047 "-- HikaShop version -- : 2.4.0 -- Joomla version -- : 2.5.28 -- PHP version -- : 5.6.3 -- Error-message(debug-mod must be tuned on) -- : JDatabaseMySQLi::query: 1146 - Table '#&#95;&#95;hikashop&#95;field' doesn't exist SQL=SELECT &#42; FROM pnius&#95;hikashop&#95;field  Call stack:")*

Hi,

This indicates that your Joomla installer didn't first install the HikaShop tables before running the install.
It can happen if Joomla thinks that HikaShop was already installed on your website (for example when you manually delete the tables from the database and then run the HikaShop install).
The solution will be to extract the back/tables.sql file from the install package of hikashop, change the #__ table prefix there to your table prefix and run the sql via your phpmyadmin. That will add all the HikaShop tables and you'll then be able to run the install.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NzYxMTQtZXJyb3ItNTAwLWR1cmluZy1pbnN0YWxsYXRpb24/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.057 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
