Magento

Hi there,

I have downloaded the new, recent release of Magento (0.7.15480) since I had problems with the installation wizard in the previous version. During the installation wizard in the newer version, after I enter the database connection information and attempt to continue to the next page, I get the following error:

I have verified the given database credentials do work with a test connection. Has anyone else ran into this?

Which version of mysql server do you have?

4.0.27-standard

Magento requires MySQL version 4.1 minimum..

Hello,

I am having the same problem.

However, I have:

MySQL client version: 4.1.22
Used PHP extensions: mysql

Hello,

I am having the same problem with MySQL client version: 5.0.27

you asked a long time ago

did you find the solution ?

please…

thiazi - 29 January 2008 11:35 AM

Hi there,

I have downloaded the new, recent release of Magento (0.7.15480) since I had problems with the installation wizard in the previous version. During the installation wizard in the newer version, after I enter the database connection information and attempt to continue to the next page, I get the following error:

SQLSTATE[HY000]: General error: 1193 Unknown system variable 'SQL_MODE'
Database connection error

I have verified the given database credentials do work with a test connection. Has anyone else ran into this?

I am using MySQL v5.0.51b version and had the same problem.
Solution: Apache mod_rewrite must be enabled en all the needed PHP extensions (php_mcrypt, php_pdo_mysql and php_curl) must be loaded).

Same problem here - any ideas?

JoeC - 09 September 2008 05:36 AM

Same problem here - any ideas?

I have found some additional information today. Are you using WAMP? Apparently there would be a known bug. See this:
http://www.magentocommerce.com/wiki/general/installing_on_windows_with_xampp_and_wamp

Tonight, I am attending a monthly meeting for Open Source in Den Bosch. One of the topic is Magento. If i can, I ask him if he knows about this and what is the work around. If anything interesting, I post it here for all those with the same question.

greetings

I’ll e-mail my admin and ask him about WAMP.

The error I get is “ *
o SQLSTATE[HY000]: General error: 1193 Unknown system variable ‘SQL_MODE’
o Database connection error”

At first I thought it was me putting the MySQL details in incorrectly.

Thanks for the advice.

Damn - no reply from admin of server. Wish I could get past this :(

Well I got a reply and it looks like I’m moving servers to solve this..

Thank you for contacting us. We have checked your issue. We have seen that the mysql version in the server is 4.0.27. Unfortunately we cannot upgrade the mysql version in the server, however we can move your accounts to another server with a higher version of mysql. Please feel free to get back to us if you want us to move your accounts.

JoeC - 10 September 2008 06:41 AM

Well I got a reply and it looks like I’m moving servers to solve this..

Thank you for contacting us. We have checked your issue. We have seen that the mysql version in the server is 4.0.27. Unfortunately we cannot upgrade the mysql version in the server, however we can move your accounts to another server with a higher version of mysql. Please feel free to get back to us if you want us to move your accounts.

Indeed, and as Moshe said in an earlier posting, Magento requires MySQL version 4.1 and higher. If this does not help, plse post here again.

Getting moved to a server with MySQL 4.1 today!

I’ve been moved and updated nameservers etc.

Went through installation process and now get “Fatal error: Class ‘Mage_Catalog_Model_Resource_Eav_Mysql4_Setup’ not found in /home/mysiteaccountname/public_html/test/app/code/core/Mage/Core/Model/Resource/Setup.php on line 125”

Why is Magento so hard to install! :(

Did you ever find a solution to that problem: “Mage_Catalog_Model_Resource_Eav_Mysql4_Setup” not found?  I’m doing a fresh install and im getting that error.  It refers to:

But that class IS there!? 

UGH, Just spent 210 US on a theme which I might not be able to use!

HELP!