Magento

Guys… Im starting with a clean install of the new beta (12510) .  But during the installation I’m getting a string of errors:

exception ‘Mage_Core_Exception’ with message ‘Error in file: “public_html/app/code/core/Mage/GoogleAnalytics/sql/googleanalytics_setup/mysql4-install-0.1.0.php” - Mysqli statement execute error : Duplicate entry ‘web_track’ for key 2’ in /home/kmg/public_html/app/Mage.php:290
Stack trace:
#0 public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(242): Mage::exception(’Mage_Core’, ‘Error in file: ...’)
#1 public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(121): Mage_Core_Model_Resource_Setup->_modifyResourceDb(’install’, ‘’, ‘0.1.0’)
#2 public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(108): Mage_Core_Model_Resource_Setup->_installResourceDb(’0.1.0’)
#3 public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(82): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 public_html/app/code/core/Mage/Core/Model/Config.php(151): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 public_html/app/Mage.php(328): Mage_Core_Model_Config->init(NULL)
#6 public_html/app/Mage.php(349): Mage::init(NULL)
#7 public_html/index.php(27): Mage::run(’base’)
#8 {main}

I’ll try it again.. but not sure the issue here…

what version are you installing?

The Lite Version.

Heres the error:
Zend_Db_Statement_Mysqli_Exception Object
(
[message:protected] => Mysqli statement execute error : Duplicate entry ‘web_track/google’ for key 2
[string:private] =>
[code:protected] => 0
[file:protected] => /home/kmg/public_html/lib/Zend/Db/Statement/Mysqli.php
[line:protected] => 251
[trace:private] => Array

I’ll try with the other version and respond.. few mins.

Ok.. I can confirm that the HEAVY Version (w/ Demo Images) does not have the issue above.  Only the lite version.. So i’m guessing its just some sort of syntax issue in
/Zend/Db/Statement/Mysqli.php

OK - thanks NickL. We are looking at it.

Hi.

I also have some problems with new release.

Above I paste part of exception trace - I use mysql 5.1.x - is any possibility to use PDO instead of mysqli driver? I think the reason can lie in diffrent driver and database server version.

If you need, I can send whole trace of exception.

Thx for any help or suggestions.

Hi again,

I also want to add, that I use full package, now I will try to install light version instead, but in my opinion the problem lie in the different mysql server version, and PHP driver for mysqli used by magento programmers (for mysql 4.1.x). If someone know how to change default driver from mysqli to PDO please put the solution on forum.

----------
EDIT:

Yes, I have the same exception with the light version.

in app/etc/config.xml line 38 there’s

replace with pdo_mysql, retry the page

Did it help switching to pdo for setup?

One second I go from company to home - we have 11 PM in Poland

--------------------
EDIT

Same problem with PDO, below part of the trace:

Any idea what to do? I can test app on other enviroment - now i will try to do the same installation with mysql 4.x (not loclahost instance of the mysql) - someone try that combination?

Same problem with remote database server - i check connection works ok via mysql client, but application throw same exceptions (MySQL 4.1.7). Now I will try the same installation on the other server (with different version of PHP, libraries, etc). Any other ideas to solve this problem or find the what can cause it?

Thx for any help.
-------------------
EDIT: I give up - my other server has PHP 5.1.x so magento don’t even start an installation. If someone has any idea to repair this problem, please post the solution on the forum. Maybe there is possiblity to create database via one SQL scirpt -can anybody dump the default created db afret installtaion?

just installed the light version on Windows XP using XAMMP and it went fine with no issues.

Thanks

yoav

About the “error” beginning with

You have to verify if your database user can use the DROP command (or every other MySql command). if not, you can do it with the command line :

Ps : excuse my poor english, I’m a little frenchie

I use root account on mysql server, and have the same problem. So it’s not a problem with drop command.

I think problem lie in the difference between libraries used by Magento programmers to server loaded extensions and mysql server version. Some of this layers are incompatible in my opinion.

Ok, but can you show us what are the last lines of your error page ? Because it seems that the error message is located at the end of the page.