Käynnissä

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.

Thanks,

Ben

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

About the Employer:
( 3 reviews ) Leeds, United Kingdom

Projektin tunnus: #4271068

Myönnetty käyttäjälle:

CindyAdams

Magento Expert

75 $ USD 1 päivässä
(17 arvostelua)
4.5

3 freelanceria on tarjonnut keskimäärin 70 $ tähän työhön

KatrinaQ

Freelance Professional.

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

I can help you. Thank you.

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