-
- ewule1

-
Total Posts: 1
Joined: 2012-07-05
|
Hi
Im using magento 1.7 .. i was trying to import a spreadsheet of about 3000 products. I had used opeoffice to save it in csv (utf-8) format.
The first time i tried, the magento import process froze, stopping at line 1080 of the spreadsheet. So i followed the advice in a post online, to spread the product list into 3 spreadsheets (each with about a thousand products). i started the import but this time the import window opened but stayed at 0 without counting up. ..and afterward, the frontend showed the error message below. I have read a lot of posts here while seeking a solution but no luck.
please advice
error message -----------------------------
There has been an error processing your request
SQLSTATE[42000]: Syntax error or access violation: 1142 INSERT command denied to user ‘ufos_722628_0001’@’linweb9.atlas.pipex.net’ for table ‘log_visitor’
Trace:
#0 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’INSERT INTO `lo...’, Array)
#4 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(’INSERT INTO `lo...’, Array)
#5 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/lib/Zend/Db/Adapter/Abstract.php(574): Varien_Db_Adapter_Pdo_Mysql->query(’INSERT INTO `lo...’, Array)
#6 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(453): Zend_Db_Adapter_Abstract->insert(’log_visitor’, Array)
#7 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mage_Log_Model_Visitor))
#8 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Log/Model/Visitor.php(167): Mage_Core_Model_Abstract->save()
#9 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Model/App.php(1338): Mage_Log_Model_Visitor->initByRequest(Object(Varien_Event_Observer))
#10 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Log_Model_Visitor), ‘initByRequest’, Object(Varien_Event_Observer))
#11 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/Mage.php(447): Mage_Core_Model_App->dispatchEvent(’controller_acti...’, Array)
#12 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(528): Mage::dispatchEvent(’controller_acti...’, Array)
#13 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Controller/Front/Action.php(64): Mage_Core_Controller_Varien_Action->preDispatch()
#14 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(408): Mage_Core_Controller_Front_Action->preDispatch()
#15 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(’index’)
#16 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#17 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#18 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#19 /websites/123reg/LinuxPackage22/fo/sp/um/fospumps.co.uk/public_html/index.php(87): Mage::run(’’, ‘store’)
#20 {main}
|