Import errors VM1

Joomill
Topic Author
Offline

10 years 10 months ago #220622 by Joomill

Import errors VM1 was created by Joomill

-- url of the page with the problem -- : Local
-- HikaShop version -- : 2.6.0
-- Joomla version -- : 3.4.5
-- PHP version -- : 5.6.8
-- Browser(s) name and version -- : firefox
-- Error-message(debug-mod must be tuned on) -- : Call stack
# Function Location
1 JApplicationCms->execute() C:\xampp\htdocs\harrybakker\administrator\index.php:47
2 JApplicationAdministrator->doExecute() C:\xampp\htdocs\harrybakker\libraries\cms\application\cms.php:252
3 JApplicationAdministrator->dispatch() C:\xampp\htdocs\harrybakker\libraries\cms\application\administrator.php:152
4 JComponentHelper::renderComponent() C:\xampp\htdocs\harrybakker\libraries\cms\application\administrator.php:98
5 JComponentHelper::executeComponent() C:\xampp\htdocs\harrybakker\libraries\cms\component\helper.php:372
6 require_once() C:\xampp\htdocs\harrybakker\libraries\cms\component\helper.php:392
7 hikashopController->execute() C:\xampp\htdocs\harrybakker\administrator\components\com_hikashop\hikashop.php:54
8 JControllerLegacy->execute() C:\xampp\htdocs\harrybakker\administrator\components\com_hikashop\helpers\helper.php:1601
9 ImportController->import() C:\xampp\htdocs\harrybakker\libraries\legacy\controller\legacy.php:728
10 ImportController->_vm() C:\xampp\htdocs\harrybakker\administrator\components\com_hikashop\controllers\import.php:66
11 hikashopImportvm1Helper->importFromVM() C:\xampp\htdocs\harrybakker\administrator\components\com_hikashop\controllers\import.php:143
12 hikashopImportvm1Helper->doImport() C:\xampp\htdocs\harrybakker\administrator\components\com_hikashop\helpers\import\vm1.php:44
13 hikashopImportvm1Helper->importCategories() C:\xampp\htdocs\harrybakker\administrator\components\com_hikashop\helpers\import\vm1.php:130
14 JDatabase->query() C:\xampp\htdocs\harrybakker\administrator\components\com_hikashop\helpers\import\vm1.php:796
15 JDatabaseDriverMysqli->execute() C:\xampp\htdocs\harrybakker\libraries\joomla\database\database.php:33

For a new client i need to upgrade the webshop from VM1 to Hikashop business

I have a fresh Joomla installation with Hikashop 2.6.0 installed
I've added the vm1-database-tables from the old site and move the images to the new site.
When i try to import the products i see the error as in the screenshot.

Can you help us?
Kind regards,
Jeroen

Please Log in or Create an account to join the conversation.

Jerome
Offline
HikaShop core developer

10 years 10 months ago #220628 by Jerome

Replied by Jerome on topic Import errors VM1

Hi,

It looks like your VM1 have some missing data.
In the file "administrator/components/com_hikashop/helpers/import/vm1.php" please replace

Code:

	$d = array(
		$id,
		$pid,
		"'product'",
		$this->db->quote($c->category_name),
		$this->db->quote($c->category_description),
		'1',
		(int)@$c->list_order,
		$this->db->quote($nameKey),
		$c->cdate,
		$c->mdate,
		"'all'",
		'0'
	);

Code:

	$d = array(
		$id,
		$pid,
		"'product'",
		$this->db->quote($c->category_name),
		$this->db->quote($c->category_description),
		'1',
		(int)@$c->list_order,
		$this->db->quote($nameKey),
		(int)@$c->cdate,
		(int)@$c->mdate,
		"'all'",
		'0'
	);

In order to force the "creation date" and "modification date" has integer (for the timestamp value).

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Please Log in or Create an account to join the conversation.

Time to create page: 0.161 seconds