Magento database with errors - needs fixing

I have a Magento ver. 1.7 but currently have some db errors which need fixing. I dont know the exact problems but some examples are:

I cannot reindex product prices - I get the error "There was a problem with reindexing process."

My web developer cannot copy the DB to a local environment. error is:

Fatal error: Uncaught exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '7bec5e01e314f80cce1226696b6b29edc' for key 'PRIMARY'' in /usr/local/psa/admin/plib/Zend/Db/Statement/[url removed, login to view] Stack trace: #0 /usr/local/psa/admin/plib/Zend/Db/[url removed, login to view](283): Zend_Db_Statement_Pdo->_execute(Array) #1 /usr/local/psa/admin/plib/Zend/Db/Adapter/[url removed, login to view](433): Zend_Db_Statement->execute(Array) #2 /usr/local/psa/admin/plib/Zend/Db/Adapter/Pdo/[url removed, login to view](230): Zend_Db_Adapter_Abstract->query('INSERT INTO `se...', Array) #3 /usr/local/psa/admin/plib/Zend/Db/Adapter/[url removed, login to view](511): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `se...', Array) #4 /usr/local/psa/admin/plib/Zend/Db/Table/[url removed, login to view](924): Zend_Db_Adapter_Abstract->insert('sessions', Array) #5 /usr/local/psa/admin/plib/Zend/Session/SaveHandler/[url removed, login to view](354): Zend_Db_Table_Abstract->insert(Array) #6 /usr/local/psa/admin/plib/CommonPanel/Session/[url removed, login to view](48): Zend_Session_SaveH in /usr/local/psa/admin/plib/Zend/Db/Statement/[url removed, login to view] on line 238

For some one with lots of Magento DB experience I am sure this will be easy to fix.



Taidot: Magento, MySQL, PHP, SQL

Näytä lisää: web developer database problems, statement of the problems, statement of the problem examples, problem with error, problem statement examples, my sql developer, fixing problems, examples of problem statement, a problem statement, web developer magento, php pdo, php error fixing, pdo, magento web developer, magento errors, magento database, fixing fatal, integrity constraint violation duplicate entry key, reindexing, trace stack, php table array, pdo 23000, easy product database, magento reindex product prices, magento query

Tietoa työnantajasta:
( 3 arvostelua ) Leeds, United Kingdom

Projektin tunnus: #4271068

Myönnetty käyttäjälle:


Magento Expert

$75 USD 1 päivässä
(17 Arvostelua)

3 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Freelance Professional.

$80 USD 1 päivässä
(474 arvostelua)

I can help you. Thank you.

$55 USD 1 päivässä
(46 arvostelua)