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