All Questions

Tagged with
Filter by
Sorted by
Tagged with
0
votes
1answer
15 views

SQL Error when importing bulk data. Product_id goes out of sync with Entity_id

When importing about 12000 rows of products from a .csv file, it suddenly gives me the following error: General system exception happened Additional data: SQLSTATE[23000]: Integrity constraint ...
0
votes
0answers
23 views

DB Error SQLSTATE[42S02]

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mavikmarine_l2li.m_catalog_product_flat_1_tmp_indexer' doesn't exist, query was: UPDATE m_catalog_product_flat_1_tmp_indexer AS et ...
0
votes
0answers
23 views

Category SQL error

I recently found the following error in Magento2 log. Reading the query is missing there's an error in where condition --> WHERE (()) How I can debug? Tryed a crude "grep" in my filesystem but I ...
0
votes
0answers
202 views

Magento2 Database Lock wait timeout exceeded

In my magento admin panel i am getting below error. SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction, query was: UPDATE flag SET state = ?, last_update = '...
0
votes
0answers
43 views

Unique constraint violation found

when edition the product for the backend, I faced the unique constraint violation found in the Magento-2.3 . I have checked the exception log this shows SQLSTATE[23000]: Integrity constraint ...
2
votes
2answers
86 views

SQL Error when I try to reindex Magento 2

I have an issue in Magento 2.2.7 where my site has the message "One or more indexers are invalid." and looking at the indexers I see the following: However when I try to run php bin/magento indexer:...
1
vote
2answers
152 views

Deleted ShipperHQ module causing error in “All Customers” section of Magento 2

I'm currently trying to build a Magento 2 site to replace an existing Magento 1 site. As we currently use the MatrixRates Module we decided to give ShipperHQ a try but ultimately decided against using ...
1
vote
1answer
48 views

Error while adding layout update to the widget

I am using a theme that has been built on Magento 1.9. Whenever I am trying to add layout update to a widget and save it I am getting the error below. An error occurred during saving a widget: ...
0
votes
2answers
2k views

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'

Before Posting this question i read all duplicate question which is suggested by stack, un fortunately no previous question helped me. What i did Disable all module one by one ( except the default ...
1
vote
0answers
22 views

Core Resource Checking Permission make Server/Site Down afterwards

I am running website on Magento 1.9.2.4 When I access my site and check query in mysql SHOW PROCESSLIST I get state of "core_resource" table like Checking Permission. Also it shows State like Opening ...
0
votes
1answer
178 views

SQL error when trying to save product

There is an integrety violation when I try to save a product. I did some searches and some suggested to join tables and check for null values. I tried that without luck. How can I solve/debug this? ...
2
votes
1answer
355 views

We get following error message in logs any idea how to fix it?

a:5:{i:0;s:1058:"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.type_id' in 'where clause', query was: SELECT FLOOR((ROUND((e.min_price) * 1, 2)) / 1) + 1 AS `range`, COUNT(*) AS `count` ...
2
votes
2answers
437 views

Magento Admin Panel Returns 404 Error

Trying to login magento admin panel and it returns 404 error. Here's what I did so far. Did a check on /public_html/app/etc/local.xml <admin> <routers> <adminhtml> ...
0
votes
1answer
118 views

magento showing server error instead of 404 page

I am facing a strange kind of issue, which i never came across before. I have seen an increased number of server errors in my webmaster tool, when investigating I found this issue. the URL which is ...
0
votes
1answer
163 views

Filtering Sales Grid by SKU - SQL Error

When trying to filter the sales order grid by sku i get the following SQL error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that ...
4
votes
1answer
849 views

Configurable product super attribute Integrity constraint violation error

I have a script that create new configurable product, but I get an error when I try to save the super attribute price configuration, here's my code: function createConf(){ //other code before... $...
5
votes
1answer
1k views

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'CONCAT( REPEAT [closed]

When i go to Magento Admin and then SM Menu Item Manager: There has been an error processing your request SQLSTATE[42S22]: Column not found: 1054 Unknown column 'CONCAT( REPEAT( "--- ", (...
0
votes
1answer
227 views

Big problem with error SQLSTATE[HY000] [2006] MySQL server has gone away

For the last 4 days, somebody is constantly attacking my website , making it to go into SQLSTATE[HY000] [2006] MySQL server has gone away error. What he does basically is open up multiple pages , adds ...
2
votes
1answer
4k views

Product ID Conflicts - SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry

I am having major issues with payment on one of my customers websites, for example when you go through PayPal Express on the confirmation page were the customer chooses there shipping method they get ...
1
vote
0answers
306 views

Product Attribute Reindexing Error: Zend Problem [closed]

When attempting to run a reindex on the Product Attributes section of Magento, I get the message "There was a problem with the reindexing process." I've managed to get an error log out of the ...
0
votes
2answers
376 views

Base Table or view not found

Our storefront, at store.fraudfighter.com, suddenly started serving up the below error message. It's pretty much out of the blue. I can't even access via my admin panel, because when I try to ...
0
votes
1answer
2k views

SQL error during installing “Charity Checkout” extention

I received this error during installing the "Charity checkout" extension on magento 1.8 a:5:{i:0;s:237:"Error in file: "/home/golbon/domains/golbon.ir/public_html/app/code/local/GoodLabs/...
0
votes
1answer
204 views

Magento 1.7.0.2: sql installer show error

I have create an extension ,which has a sql Installer,When i am trying to run that extension,the installer show Error `a:5:{i:0;s:329:"Error in file: "/home/wwww/uat/app/code/local/Amit/...
1
vote
1answer
1k views

Weird “1103 Incorrect table name” error

The code: public function testAction(){ $Collection = Mage::getModel('catalog/product')->getCollection(); $Collection->getSelect()->join(array('t2' => 'SELECT ...
1
vote
1answer
754 views

Sorting custom model with getModel

I've managed to get custom models to load before with the following code: $model = Mage::getModel("banner/banner") ->getCollection() ->load(); But I need to now sort by an order value ...
10
votes
2answers
7k views

magento 1.7 : Cannot reindex product_flat_data

I get the following error while trying to reindex my magento database.. Product Flat Data index process unknown error: exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint ...