Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

SQLSTATE[42000]: Syntax error or access violation: 1142 INSERT command denied to user
 
theelman
Jr. Member
 
Total Posts:  29
Joined:  2008-08-26
 

Hi,

I was updating via a CSV and it crashed. The admin panel still works but the user side is now compltely broken saying

SQLSTATE[42000]Syntax error or access violation1142 INSERT command denied to user 'db name@ ipaddress' for table 'log_visitor'

I seriously have no idea what went wrong or what these means. The only thing I find on these forums is in Polish.

this is urgent!! any help grateful!

thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
theelman
Jr. Member
 
Total Posts:  29
Joined:  2008-08-26
 

I seem to of foudn that the DB is too big for my server people.. Its now 150MB! Surely this is way too large.. is there a way to shrink this?

 
Magento Community Magento Community
Magento Community
Magento Community
 
theelman
Jr. Member
 
Total Posts:  29
Joined:  2008-08-26
 

on PHPmyadmin dataflow_batch_import is 75MB.. is this normal?  Is there a way to stop this?

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top