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

Page 1 of 2
Zend_Db_Statement_Mysqli_Exception Object
 
nicmare
Member
 
Total Posts:  32
Joined:  2007-11-14
 

After Installing Magento (the step after database config and url settings) i get the following message:
Zend_Db_Statement_Mysqli_Exception Object
(
[message:protected] => Mysqli statement execute error : Duplicate entry ‘general/locale/code’ for key 2
[string:private] =>
[code:protected] => 0
[file:protected] => /www/htdocs/w00885cf/magento/lib/Zend/Db/Statement/Mysqli.php
[line:protected] => 251
[trace:private] => Array
...
...
...

what goes wrong?
it doesnt matter which path i am using.
http://www.url.de/magento/install/wizard/configPost/ or
http://www.url.de/magento/

its a shared webspace with mysqli enabled and php 5.2.3. did not received a error message from magento install guide.
tried it two times. now i have to clear the complete folder and db tables and have to reupload :(

 
Magento Community Magento Community
Magento Community
Magento Community
 
Phliplip
Member
 
Total Posts:  46
Joined:  2007-08-31
Copenhagen, Denmark
 

I also got one for you

Zend_Db_Statement_Mysqli_Exception Object
(
[message:protected] => Mysqli prepare error: Table ‘domain.core_config_field’ doesn’t exist
[string:private] =>
[code:protected] => 0
[file:protected] => /home/domains/domain/www/magento/lib/Zend/Db/Statement/Mysqli.php
[line:protected] => 85
[trace:private] => Array
(
[0] => Array
(
[file] => /home/domains/domain/www/magento/lib/Zend/Db/Statement.php
[line] => 109
[function] => _prepare
[class] => Zend_Db_Statement_Mysqli
[type] => ->
[args] => Array
(
[0] => select * from core_config_field where path=?
)

)

Before that i had a , comma in an ALTER TABLE sql that went wrong! This is second time i try the new release. Also was not able to get the previous release installed, because of a table missing after install!

 
Magento Community Magento Community
Magento Community
Magento Community
 
wimdenocker
Jr. Member
 
Total Posts:  6
Joined:  2007-08-31
Antwerp, Belgium
 

I’m also having the same installation trouble on a windows setup (php 5.2.4, mysql 5.1)
Also tried the previous releases, without success.
I also followed several links to possible solutions (changes in mysqlI settings, adjusting some Zend Framework files,) given in these forums.
Without success, however.

It would be nice to have this issue resolved.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Phliplip
Member
 
Total Posts:  46
Joined:  2007-08-31
Copenhagen, Denmark
 

Funny thing is, im running a Freebsd 6.1 with apache 2.2.6, PHP 5.2.4 with all extension requirements met, MySQL 5.1.22-rc

 
Magento Community Magento Community
Magento Community
Magento Community
 
Michael_1
Enthusiast
 
Total Posts:  826
Joined:  2007-08-31
 

Hi guys,

What package did you install ? Does the problem appears only for a full one ?

Thank you.

 
Magento Community Magento Community
Magento Community
Magento Community
 
wimdenocker
Jr. Member
 
Total Posts:  6
Joined:  2007-08-31
Antwerp, Belgium
 

As far as I remember, I downloaded the full package.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Michael_1
Enthusiast
 
Total Posts:  826
Joined:  2007-08-31
 
wim - 20 November 2007 06:11 AM

As far as I remember, I downloaded the full package.

Could you try the solution described at http://www.magentocommerce.com/wiki/mediatemple_installation_guide_-_grid_service#known_issues ?

Please let me know if it helps.

Thank you.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Phliplip
Member
 
Total Posts:  46
Joined:  2007-08-31
Copenhagen, Denmark
 

Don’t work for me!

 
Magento Community Magento Community
Magento Community
Magento Community
 
tristan2
Jr. Member
 
Total Posts:  11
Joined:  2007-11-21
Netherlands
 

Having some trouble here as well before restoring the mysql database with the sql file mentioned above from the wiki I got this error in the content part of the site, menu backend and loging in worked fine:

exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento.tag_summary' doesn't exist' in /****/public_html/magento/lib/Zend/Db/Statement/Pdo.php:227

Now I’m just getting a blank page with:

Fatal errorCall to undefined method PDO::store_result() in /****/public_html/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php on line 107

Any clues?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Michael_1
Enthusiast
 
Total Posts:  826
Joined:  2007-08-31
 

Hi Tristan,
What versions of php and mysql do you have ? What does your phpinfo display in pdo_mysql section?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Michael_1
Enthusiast
 
Total Posts:  826
Joined:  2007-08-31
 
Phliplip - 21 November 2007 03:05 AM

Don’t work for me!

What did you get after apllied that sql-file ? What are the error messages you have now ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
tristan2
Jr. Member
 
Total Posts:  11
Joined:  2007-11-21
Netherlands
 
Michael - 21 November 2007 04:42 AM

Hi Tristan,
What versions of php and mysql do you have ? What does your phpinfo display in pdo_mysql section?

Sorry about that it’s the cgi php as provided on this site: PHP Version 5.2.3 the pdo_mysql says:

PDO Driver for MySQL, client library version 4.1.20

 
Magento Community Magento Community
Magento Community
Magento Community
 
wimdenocker
Jr. Member
 
Total Posts:  6
Joined:  2007-08-31
Antwerp, Belgium
 

I’m using php 5.2.4, with all needed extensions enabled.
PDO_mysql information from phpinfo = PDO Driver for MySQL, client library version 5.0.45
Both mysql and mysqli drivers are loaded, also at version 5.0.45

I remember having tried the external .sql file, but without any success…

 
Magento Community Magento Community
Magento Community
Magento Community
 
metuga
Jr. Member
 
Total Posts:  1
Joined:  2007-11-27
 

I have the same error here.
Someone have find the solution for this issue?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Michael_1
Enthusiast
 
Total Posts:  826
Joined:  2007-08-31
 

Could you try this one - http://www.magentocommerce.com/boards/viewthread/1670/#t7920 ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
tristan2
Jr. Member
 
Total Posts:  11
Joined:  2007-11-21
Netherlands
 

Then I get this error:

Fatal errorCall to undefined method PDO::store_result() in***/public_html/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php on line 107
 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 1 of 2