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

SQLSTATE[HY000]: General error: 1193 Unknown system variable ‘SQL_MODE’
 
thiazi
Jr. Member
 
Total Posts:  5
Joined:  2008-01-20
 

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 error1193 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?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Moshe
Magento Team
 
Avatar
Total Posts:  1770
Joined:  2007-08-07
Los Angeles
 

Which version of mysql server do you have?

 
Magento Community Magento Community
Magento Community
Magento Community
 
thiazi
Jr. Member
 
Total Posts:  5
Joined:  2008-01-20
 

4.0.27-standard

 
Magento Community Magento Community
Magento Community
Magento Community
 
Moshe
Magento Team
 
Avatar
Total Posts:  1770
Joined:  2007-08-07
Los Angeles
 

Magento requires MySQL version 4.1 minimum..

 
Magento Community Magento Community
Magento Community
Magento Community
 
bodykits
Jr. Member
 
Total Posts:  1
Joined:  2008-05-09
 

Hello,

I am having the same problem.

However, I have:

MySQL client version: 4.1.22
Used PHP extensions: mysql

 
Magento Community Magento Community
Magento Community
Magento Community
 
buzz74
Jr. Member
 
Total Posts:  3
Joined:  2008-09-07
 

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…

 
Magento Community Magento Community
Magento Community
Magento Community
 
cgiguere
Jr. Member
 
Total Posts:  5
Joined:  2008-09-08
 
thiazi - 29 January 2008 10: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 error1193 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).

 
Magento Community Magento Community
Magento Community
Magento Community
 
JoeC
Jr. Member
 
Total Posts:  16
Joined:  2007-11-22
 

Same problem here - any ideas?

 
Magento Community Magento Community
Magento Community
Magento Community
 
cgiguere
Jr. Member
 
Total Posts:  5
Joined:  2008-09-08
 
JoeC - 09 September 2008 04: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

 
Magento Community Magento Community
Magento Community
Magento Community
 
JoeC
Jr. Member
 
Total Posts:  16
Joined:  2007-11-22
 

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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
JoeC
Jr. Member
 
Total Posts:  16
Joined:  2007-11-22
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
JoeC
Jr. Member
 
Total Posts:  16
Joined:  2007-11-22
 

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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
cgiguere
Jr. Member
 
Total Posts:  5
Joined:  2008-09-08
 
JoeC - 10 September 2008 05: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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
JoeC
Jr. Member
 
Total Posts:  16
Joined:  2007-11-22
 

Getting moved to a server with MySQL 4.1 today!

 
Magento Community Magento Community
Magento Community
Magento Community
 
JoeC
Jr. Member
 
Total Posts:  16
Joined:  2007-11-22
 

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! :(

 
Magento Community Magento Community
Magento Community
Magento Community
 
fitatcost
Jr. Member
 
Total Posts:  1
Joined:  2010-11-07
 

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:

$setupClass = new $className($resName);

But that class IS there!? 

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

HELP!

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top