Try the Demo

Magento Forum

   
Warning: Number of variables doesn’t match number of parameters in prepared statement in Mysqli.php
 
Mexx
Member
 
Avatar
Total Posts:  35
Joined:  2007-09-04
Germany
 

Dear Community,

before I began to install Magento I checked the system requirements. Once I was sure my system matched everything I tried to install it.
Here my server specifications:
Apache
CGI/FastCGI

After entering all the database information etc. I clicked on “Next” and then the following error occurred:

Warningmysqli_stmt::bind_param() [function.mysqli-stmt-bind-param]Number of variables doesnt match number of parameters in prepared statement in /www/htdocs/w0079ad9/Magento/lib/Zend/Db/Statement/Mysqli.php on line 241
[0] in mysqli_stmt
->bind_param("ssss"2"general/locale""Locale options"8)
[1] in call_user_func_array(Array[2]Array[5]in /www/htdocs/w0079ad9/Magento/lib/Zend/Db/Statement/Mysqli.php on line 241
[2] in Zend_Db_Statement_Mysqli
->_execute(Array[4]in /www/htdocs/w0079ad9/Magento/lib/Zend/Db/Statement.php on line 279
[3] in Zend_Db_Statement
->execute(Array[4]in /www/htdocs/w0079ad9/Magento/lib/Zend/Db/Adapter/Abstract.php on line 396
[4] in Zend_Db_Adapter_Abstract
->query("INSERT INTO `core_config_field` (`level`, `path`, `frontend_label`, `sort_order`) VALUES (?, ?, ?, ?"Array[4]in /www/htdocs/w0079ad9/Magento/lib/Zend/Db/Adapter/Abstract.php on line 474
[5] in Zend_Db_Adapter_Abstract
->insert("core_config_field"Array[4]in /www/htdocs/w0079ad9/Magento/app/code/core/Mage/Core/Model/Resource/Setup.php on line 406
[6] in Mage_Core_Model_Resource_Setup
->addConfigField("general/locale""Locale options"in /www/htdocs/w0079ad9/Magento/app/code/core/Mage/Core/sql/core_setup/mysql4-upgrade-0.6.1-0.6.2.php on line 21
[7] in 
include("/www/htdocs/w0079ad9/Magento/app/code/core/Mage/Core/sql/core_setup/mysql4-upgrade-0.6.1-0.6.2.php"in /www/htdocs/w0079ad9/Magento/app/code/core/Mage/Core/Model/Resource/Setup.php on line 225
[8] in Mage_Core_Model_Resource_Setup
->_modifyResourceDb("upgrade""0.6.1""0.6.25"in /www/htdocs/w0079ad9/Magento/app/code/core/Mage/Core/Model/Resource/Setup.php on line 135
[9] in Mage_Core_Model_Resource_Setup
->_upgradeResourceDb("0.6.1""0.6.25"in /www/htdocs/w0079ad9/Magento/app/code/core/Mage/Core/Model/Resource/Setup.php on line 101
[10] in Mage_Core_Model_Resource_Setup
->applyUpdates() in /www/htdocs/w0079ad9/Magento/app/code/core/Mage/Core/Model/Resource/Setup.php on line 84
[11] in Mage_Core_Model_Resource_Setup
::applyAllUpdates() in /www/htdocs/w0079ad9/Magento/app/code/core/Mage/Core/Model/Config.php on line 135
[12] in Mage_Core_Model_Config
->init(NULLin /www/htdocs/w0079ad9/Magento/app/code/core/Mage/Core/Model/App.php on line 126
[13] in Mage_Core_Model_App
->init("base"NULLin /www/htdocs/w0079ad9/Magento/app/Mage.php on line 359
[14] in Mage
::app("base"NULLin /www/htdocs/w0079ad9/Magento/app/Mage.php on line 379
[15] in Mage
::run("base"in /www/htdocs/w0079ad9/Magento/index.php on line 28

The massage was even longer: To see it click here.

With best regards, Max

 Signature 

I love my work, I could sit and watch it all day long. wink

 
Magento Community Magento Community
Magento Community
Magento Community
 
Michael
Magento Team
 
Total Posts:  826
Joined:  2007-08-31
 

Is there any specific reason that you have different header version of mysqli extension ?

Client API library version     5.0.24
Client API header version     4.1.21

 
Magento Community Magento Community
Magento Community
Magento Community
 
Mexx
Member
 
Avatar
Total Posts:  35
Joined:  2007-09-04
Germany
 

No there is no special reason. I didnt even nodice it. Do you think that this is problematic?

 Signature 

I love my work, I could sit and watch it all day long. wink

 
Magento Community Magento Community
Magento Community
Magento Community
 
Michael
Magento Team
 
Total Posts:  826
Joined:  2007-08-31
 
Mexx - 21 November 2007 02:37 PM

Do you think that this is problematic?

Yes, I guess it can be. Could you try to run Magento under php5-cgi as described in Installing Magento on a PHP4 server knowledge base article ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Mexx
Member
 
Avatar
Total Posts:  35
Joined:  2007-09-04
Germany
 

OK, I will try this.

 Signature 

I love my work, I could sit and watch it all day long. wink

 
Magento Community Magento Community
Magento Community
Magento Community
 
Mexx
Member
 
Avatar
Total Posts:  35
Joined:  2007-09-04
Germany
 

Hi Michael,
thanks for help so far!

I downloaded the cgi, uploaded it to my root/cgi-bin/ and adjusted the .htaccess file.
I then surfed to my Magento directory and got a slidly different error message:

Zend_Db_Adapter_Mysqli_Exception Object
(
    
[_chainedException:protected] => 
    
[message:protected] => Level2:Commands out of syncyou cant run this command now
    [string
:private] => 
    
[code:protected] => 0
    [file
:protected] => /www/htdocs/w0079ad9/Magento/lib/Varien/Db/Adapter/Mysqli.php
    [line
:protected] => 154
    [trace
:private] => Array
        (
            
[0] => Array
                (
                    
[file] => /www/htdocs/w0079ad9/Magento/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] 
=> 423
                    [function] 
=> multi_query
                    [class] 
=> Varien_Db_Adapter_Mysqli
                    [type] 
=> ->
                    
[args] => Array

To see all of it, go here.

Greetings Mexx

 Signature 

I love my work, I could sit and watch it all day long. wink

 
Magento Community Magento Community
Magento Community
Magento Community
 
Michael
Magento Team
 
Total Posts:  826
Joined:  2007-08-31
 

Hi Mexx,

Could you try to replace the app\code\core\Mage\Install\Model\Installer\Db.php and app\etc\config.xml files with the attached ones ?

File Attachments
Db.php  (File Size: 2KB - Downloads: 175)
config.xml  (File Size: 12KB - Downloads: 185)
 
Magento Community Magento Community
Magento Community
Magento Community
 
Mexx
Member
 
Avatar
Total Posts:  35
Joined:  2007-09-04
Germany
 

Hi Michael,

thanks a lot for your support. I did exchange the given files and got another error:

Fatal errorCall to undefined method PDO::store_result() in /www/htdocs/w0079ad9/Magento/lib/Varien/Db/Adapter/Pdo/Mysql.php on line 107

The weird thing is, that I got Magento running on my local machine under “xampp lite”. Concerning the fact that Magento is beta, I don’t really care if we won’t get it running on my test-server. I can test it locally. With the release of Magento 1.0 I will have to watch out for another host anyway.

But thanks so far anyway, great community!

Mexx

 Signature 

I love my work, I could sit and watch it all day long. wink

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