Jump to content

Error en el importe de DATOS CSV


Recommended Posts

Hola

 

Tengo un error que no entiendo, a lo mejor lo conoce alguien de vosotros.

 

Quiero hacer un importe massivo de CSV. A lo primero viene este Error.

[PrestaShopDatabaseException]

Field 'sc_path' doesn't have a default value


INSERT INTO `ps_image` (`id_product`, `position`, `cover`) VALUES ('1530', '1', '1')

at line 635 in file classes/db/Db.php
629. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
630. 		}
631. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
632. 		{
633. 			if ($sql)
634. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
635. 			throw new PrestaShopDatabaseException($this->getMsgError());
636. 		}
637. 	}
638. 
639. 	/**
DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 609 - classes/db/Db.php] - [1 Arguments]
DbCore->q - [line 390 - classes/db/Db.php] - [2 Arguments]
DbCore->insert - [line 455 - classes/ObjectModel.php] - [3 Arguments]
ObjectModelCore->add - [line 90 - classes/Image.php] - [2 Arguments]
ImageCore->add - [line 1684 - controllers/admin/AdminImportController.php]
AdminImportControllerCore->productImport - [line 3257 - controllers/admin/AdminImportController.php]
AdminImportControllerCore->postProcess - [line 171 - classes/controller/Controller.php]
ControllerCore->run - [line 373 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 54 - admin/index.php]

Me puede decir al quien como puedo resolver este problema? El Internet no me dice mucho sobre esto..

 

Saludos

 

Jose

 

 

Share this post


Link to post
Share on other sites

Hola

 

Tengo un error que no entiendo, a lo mejor lo conoce alguien de vosotros.

 

Quiero hacer un importe massivo de CSV. A lo primero viene este Error.

[PrestaShopDatabaseException]

Field 'sc_path' doesn't have a default value


INSERT INTO `ps_image` (`id_product`, `position`, `cover`) VALUES ('1530', '1', '1')

at line 635 in file classes/db/Db.php
629. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
630. 		}
631. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
632. 		{
633. 			if ($sql)
634. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
635. 			throw new PrestaShopDatabaseException($this->getMsgError());
636. 		}
637. 	}
638. 
639. 	/**
DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 609 - classes/db/Db.php] - [1 Arguments]
DbCore->q - [line 390 - classes/db/Db.php] - [2 Arguments]
DbCore->insert - [line 455 - classes/ObjectModel.php] - [3 Arguments]
ObjectModelCore->add - [line 90 - classes/Image.php] - [2 Arguments]
ImageCore->add - [line 1684 - controllers/admin/AdminImportController.php]
AdminImportControllerCore->productImport - [line 3257 - controllers/admin/AdminImportController.php]
AdminImportControllerCore->postProcess - [line 171 - classes/controller/Controller.php]
ControllerCore->run - [line 373 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 54 - admin/index.php]

Me puede decir al quien como puedo resolver este problema? El Internet no me dice mucho sobre esto..

 

Saludos

 

Jose

Hola Jose,

 

Aquí encontraras información que esperamos te sea de mucha utilidad.

 

http://www.prestashop.com/forums/topic/338721-%C2%A1la-mejor-manera-de-importar-tus-productos/?do=findComment&comment=1709552

 

http://www.prestashop.com/forums/topic/343697-%C2%BFd%C3%B3nde-puedo-obtner-la-informaci%C3%B3n-t%C3%A9cnica-de-los-productos-y-%C2%BFc%C3%B3mo-puedo-importar-esa-informaci%C3%B3n/?do=findComment&comment=1732540

 

WASATO Team.

Share this post


Link to post
Share on other sites
  • nadie locked this topic
Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More