[Skip to main content](#vessel-content) # Demo data ## - **[n3t](/forum/user/47021-n3t "View n3t's Profile")** - [![n3t's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/47021-n3t "View n3t's Profile") Topic Author - [ Offline](/forum/user/47021-n3t) Less More - Posts: 38 - Thank you received: 1 - - 9 years 2 months ago [\#275784](#275784) by [n3t](/forum/user/47021-n3t "View n3t's Profile") *[Demo data](/forum/25-install-update/891493-demo-data#275784 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.0.12 -- Error-message(debug-mod must be tuned on) -- : Can't open file /tmp/dataexample/script.sql Hi, when I tried to install sample data on new HikaShop installation, I got this message 'Can't open file /tmp/dataexample/script.sql'. Retried with error reporting on and following warning appeared Note that my tmp folder settings is so outside of joomla root and the folder is writable. After quick view to update.php seems, that Hikashop relies on existence of tmp folder in Joomla root. Moreover, I downloded the sampledata manually and tried to run the script through phpMyAdmin. There is error in statement #1054 - Unknown column 'name' in 'field list' after removing the field and values for it (all NULLs), script worked as expected. Pavel")* was created by *[n3t](/forum/user/47021-n3t "View n3t's Profile")* -- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.0.12 -- Error-message(debug-mod must be tuned on) -- : Can't open file /tmp/dataexample/script.sql Hi, when I tried to install sample data on new HikaShop installation, I got this message 'Can't open file /tmp/dataexample/script.sql'. Retried with error reporting on and following warning appeared Code: Warning: fopen(../tmp/dataexample/script.sql): failed to open stream: No such file or directory in /path_to_site/www/administrator/components/com_hikashop/controllers/update.php on line 506 Note that my tmp folder settings is Code: /path_to_site/.tmp/ so outside of joomla root and the folder is writable. After quick view to update.php seems, that Hikashop relies on existence of tmp folder in Joomla root. Moreover, I downloded the sampledata manually and tried to run the script through phpMyAdmin. There is error in statement Code: INSERT IGNORE INTO `#__hikashop_order_product` \#1054 - Unknown column 'name' in 'field list' after removing the field and values for it (all NULLs), script worked as expected. Pavel Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MTQ5My1kZW1vLWRhdGE/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[n3t](/forum/user/47021-n3t "View n3t's Profile")** - [![n3t's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/47021-n3t "View n3t's Profile") Topic Author - [ Offline](/forum/user/47021-n3t) Less More - Posts: 38 - Thank you received: 1 - - 9 years 2 months ago [\#275785](#275785) by [n3t](/forum/user/47021-n3t "View n3t's Profile") Replied by *[n3t](/forum/user/47021-n3t "View n3t's Profile")* on topic *[Demo data](/forum/25-install-update/891493-demo-data#275785 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.0.12 -- Error-message(debug-mod must be tuned on) -- : Can't open file /tmp/dataexample/script.sql Hi, when I tried to install sample data on new HikaShop installation, I got this message 'Can't open file /tmp/dataexample/script.sql'. Retried with error reporting on and following warning appeared Note that my tmp folder settings is so outside of joomla root and the folder is writable. After quick view to update.php seems, that Hikashop relies on existence of tmp folder in Joomla root. Moreover, I downloded the sampledata manually and tried to run the script through phpMyAdmin. There is error in statement #1054 - Unknown column 'name' in 'field list' after removing the field and values for it (all NULLs), script worked as expected. Pavel")* One more small issue, demo data installs item 'customtext_202_14_27_55'. When this field is removed in administration, database fields remains. All other fields, wehn removed, are removed from database correctly (I tried to remove just item, entry and order fields). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MTQ5My1kZW1vLWRhdGE/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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: 4078 - - [](http://obsi.dev) - 9 years 2 months ago [\#275821](#275821) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Demo data](/forum/25-install-update/891493-demo-data#275821 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.0.12 -- Error-message(debug-mod must be tuned on) -- : Can't open file /tmp/dataexample/script.sql Hi, when I tried to install sample data on new HikaShop installation, I got this message 'Can't open file /tmp/dataexample/script.sql'. Retried with error reporting on and following warning appeared Note that my tmp folder settings is so outside of joomla root and the folder is writable. After quick view to update.php seems, that Hikashop relies on existence of tmp folder in Joomla root. Moreover, I downloded the sampledata manually and tried to run the script through phpMyAdmin. There is error in statement #1054 - Unknown column 'name' in 'field list' after removing the field and values for it (all NULLs), script worked as expected. Pavel")* Hello, Thanks for the report ; we will update the code to handle the configured Joomla temp folder. About the customtext field ; that specific kind of custom field do not create a column in the database, customtext are fixed text so there is no data stored in the database. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MTQ5My1kZW1vLWRhdGE/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[n3t](/forum/user/47021-n3t "View n3t's Profile")** - [![n3t's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/47021-n3t "View n3t's Profile") Topic Author - [ Offline](/forum/user/47021-n3t) Less More - Posts: 38 - Thank you received: 1 - - 9 years 2 months ago [\#275833](#275833) by [n3t](/forum/user/47021-n3t "View n3t's Profile") Replied by *[n3t](/forum/user/47021-n3t "View n3t's Profile")* on topic *[Demo data](/forum/25-install-update/891493-demo-data#275833 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.0.12 -- Error-message(debug-mod must be tuned on) -- : Can't open file /tmp/dataexample/script.sql Hi, when I tried to install sample data on new HikaShop installation, I got this message 'Can't open file /tmp/dataexample/script.sql'. Retried with error reporting on and following warning appeared Note that my tmp folder settings is so outside of joomla root and the folder is writable. After quick view to update.php seems, that Hikashop relies on existence of tmp folder in Joomla root. Moreover, I downloded the sampledata manually and tried to run the script through phpMyAdmin. There is error in statement #1054 - Unknown column 'name' in 'field list' after removing the field and values for it (all NULLs), script worked as expected. Pavel")* Hi, however demodata install script contains these two lines Code: ALTER TABLE `#__hikashop_cart_product` ADD `customtext_202_14_27_55` TEXT NULL; ALTER TABLE `#__hikashop_order_product` ADD `customtext_202_14_27_55` TEXT NULL; so it creates those fields, even it should not... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MTQ5My1kZW1vLWRhdGE/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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: 4078 - - [](http://obsi.dev) - 9 years 2 months ago [\#275841](#275841) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Demo data](/forum/25-install-update/891493-demo-data#275841 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.0.12 -- Error-message(debug-mod must be tuned on) -- : Can't open file /tmp/dataexample/script.sql Hi, when I tried to install sample data on new HikaShop installation, I got this message 'Can't open file /tmp/dataexample/script.sql'. Retried with error reporting on and following warning appeared Note that my tmp folder settings is so outside of joomla root and the folder is writable. After quick view to update.php seems, that Hikashop relies on existence of tmp folder in Joomla root. Moreover, I downloded the sampledata manually and tried to run the script through phpMyAdmin. There is error in statement #1054 - Unknown column 'name' in 'field list' after removing the field and values for it (all NULLs), script worked as expected. Pavel")* Hello, There might have a missing check in the script which allow the team to generate the sample data package. I will check the tools and see to fix that. Afterwards I'll contact the rest of the team to re-generate a sample data package. In your end, the best would be to directly remove the columns via your PHPMyAdmin. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MTQ5My1kZW1vLWRhdGE/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[n3t](/forum/user/47021-n3t "View n3t's Profile")** - [![n3t's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/47021-n3t "View n3t's Profile") Topic Author - [ Offline](/forum/user/47021-n3t) Less More - Posts: 38 - Thank you received: 1 - - 9 years 2 months ago [\#275857](#275857) by [n3t](/forum/user/47021-n3t "View n3t's Profile") Replied by *[n3t](/forum/user/47021-n3t "View n3t's Profile")* on topic *[Demo data](/forum/25-install-update/891493-demo-data#275857 "-- HikaShop version -- : 3.1.1 -- Joomla version -- : 3.7.4 -- PHP version -- : 7.0.12 -- Error-message(debug-mod must be tuned on) -- : Can't open file /tmp/dataexample/script.sql Hi, when I tried to install sample data on new HikaShop installation, I got this message 'Can't open file /tmp/dataexample/script.sql'. Retried with error reporting on and following warning appeared Note that my tmp folder settings is so outside of joomla root and the folder is writable. After quick view to update.php seems, that Hikashop relies on existence of tmp folder in Joomla root. Moreover, I downloded the sampledata manually and tried to run the script through phpMyAdmin. There is error in statement #1054 - Unknown column 'name' in 'field list' after removing the field and values for it (all NULLs), script worked as expected. Pavel")* Hi, that's what I did ![:)](/media/kunena/emoticons/3.png ":)") thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg5MTQ5My1kZW1vLWRhdGE/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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.072 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)