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

Getting error --- Mysqli statement execute error : Incorrect integer value: ‘’ for column ‘entity_id’ at row 1
 
retrograde
Jr. Member
 
Total Posts:  4
Joined:  2007-12-04
 

Recieving the following error in various modules:

Mysqli statement execute error : Incorrect integer value: ‘’ for column ‘entity_id’ at row 1

I get this same error both when viewing the cart as a customer, and when adding products as an admin.

The installation went smoothly (all required module/php extensions installed fine). Given this is showing up at multiple points in the application, I figure it’s more an installation/configuration issue than bug within the app.

I’m running

magento-0.6.13700
php 5.2.4
apache 2.2
mysql 5.0.45

installed via XAMPP 1.6.4 on a Windows XP laptop.

Any help in getting my install sorted out would be much appreciated.

Thanks

Stack trace below:

exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli statement execute error : Incorrect integer value: '' for column 'value' at row 1' in C:\dev\magento\lib\Zend\Db\Statement\Mysqli.php:251
Stack trace
:
#0 C:\dev\magento\lib\Zend\Db\Statement.php(279): Zend_Db_Statement_Mysqli->_execute(Array)
#1 C:\dev\magento\lib\Zend\Db\Adapter\Abstract.php(396): Zend_Db_Statement->execute(Array)
#2 C:\dev\magento\lib\Zend\Db\Adapter\Abstract.php(517): Zend_Db_Adapter_Abstract->query('UPDATE `sales_q...', Array)
#3 C:\dev\magento\app\code\core\Mage\Eav\Model\Entity\Abstract.php(1102): Zend_Db_Adapter_Abstract->update('sales_quote_ent...', Array, 'entity_type_id=...')
#4 C:\dev\magento\app\code\core\Mage\Eav\Model\Entity\Abstract.php(1040): Mage_Eav_Model_Entity_Abstract->_updateAttribute(Object(Mage_Sales_Model_Quote_Address), Object(Mage_Eav_Model_Entity_Attribute), 13, false)
#5 C:\dev\magento\app\code\core\Mage\Eav\Model\Entity\Abstract.php(807): Mage_Eav_Model_Entity_Abstract->_processSaveData(Array)
#6 C:\dev\magento\app\code\core\Mage\Eav\Model\Entity\Collection\Abstract.php(789): Mage_Eav_Model_Entity_Abstract->save(Object(Mage_Sales_Model_Quote_Address))
#7 C:\dev\magento\app\code\core\Mage\Sales\Model\Entity\Quote\Attribute\Backend\Parent.php(29): Mage_Eav_Model_Entity_Collection_Abstract->save()
#8 C:\dev\magento\app\code\core\Mage\Eav\Model\Entity\Abstract.php(580): Mage_Sales_Model_Entity_Quote_Attribute_Backend_Parent->afterSave(Object(Mage_Sales_Model_Quote))
#9 C:\dev\magento\app\code\core\Mage\Eav\Model\Entity\Abstract.php(1154): Mage_Eav_Model_Entity_Abstract->walkAttributes(Array, Array)
#10 C:\dev\magento\app\code\core\Mage\Eav\Model\Entity\Abstract.php(814): Mage_Eav_Model_Entity_Abstract->_afterSave('backend/afterSa...', Array)
#11 C:\dev\magento\app\code\core\Mage\Core\Model\Abstract.php(173): Mage_Eav_Model_Entity_Abstract->save(Object(Mage_Sales_Model_Quote))
#12 C:\dev\magento\app\code\core\Mage\Checkout\Block\Onepage\Review.php(35): Mage_Core_Model_Abstract->save(Object(Mage_Sales_Model_Quote))
#13 C:\dev\magento\lib\Varien\Object.php(75): Mage_Checkout_Block_Onepage_Review->_construct()
#14 C:\dev\magento\app\code\core\Mage\Core\Block\Abstract.php(120): Varien_Object->__construct()
#15 C:\dev\magento\app\code\core\Mage\Core\Block\Template.php(45): Mage_Core_Block_Abstract->__construct(Array)
#16 C:\dev\magento\app\code\core\Mage\Core\Model\Layout.php(343): Mage_Core_Block_Template->__construct()
#17 C:\dev\magento\app\code\core\Mage\Core\Model\Layout.php(189): Mage_Core_Model_Layout->addBlock()
#18 C:\dev\magento\app\code\core\Mage\Core\Model\Layout.php(158): Mage_Core_Model_Layout->_generateBlock('Mage_Checkout_B...', 'checkout.onepag...')
#19 C:\dev\magento\app\code\core\Mage\Core\Model\Layout.php(159): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
#20 C:\dev\magento\app\code\core\Mage\Core\Model\Layout.php(163): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#21 C:\dev\magento\app\code\core\Mage\Core\Controller\Varien\Action.php(270): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#22 C:\dev\magento\app\code\core\Mage\Core\Controller\Varien\Action.php(207): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
#23 C:\dev\magento\app\code\core\Mage\Checkout\controllers\OnepageController.php(74): Mage_Core_Controller_Varien_Action->loadLayout()
#24 C:\dev\magento\app\code\core\Mage\Core\Controller\Varien\Action.php(325): Mage_Checkout_OnepageController->indexAction()
#25 C:\dev\magento\app\code\core\Mage\Core\Controller\Varien\Router\Standard.php(149): Mage_Core_Controller_Varien_Action->dispatch()
#26 C:\dev\magento\app\code\core\Mage\Core\Controller\Varien\Front.php(166): Mage_Core_Controller_Varien_Router_Standard->match('index')
#27 C:\dev\magento\app\Mage.php(380): Mage_Core_Controller_Varien_Front->dispatch(Object(Zend_Controller_Request_Http))
#28 C:\dev\magento\index.php(29): Mage::run()
#29 {main}
 
Magento Community Magento Community
Magento Community
Magento Community
 
Michael_1
Enthusiast
 
Total Posts:  826
Joined:  2007-08-31
 

Hi retrograde,

Can you try the latest Magento version 0.6.14100 ?

Please let me know if the problem persists.

Thank you.

 
Magento Community Magento Community
Magento Community
Magento Community
 
retrograde
Jr. Member
 
Total Posts:  4
Joined:  2007-12-04
 

Will do.

Thanks.

 
Magento Community Magento Community
Magento Community
Magento Community
 
retrograde
Jr. Member
 
Total Posts:  4
Joined:  2007-12-04
 

I downloaded the latest beta and sadly see the same error message:

Mysqli statement execute error : Incorrect integer value: ‘’ for column ‘entity_id’ at row 1

when attempting to add a new product as an admin.

Also saw the code when entering a dummy discount code during checkout on the front end.

To verify my XAMPP install, I downloaded and reinstalled all the php extensions as well as php_pdo_mysql dll from the site listed in installation post.

It’s very helpful to have a demo/beta site on my XP laptop. Any guidance or pointers in resolving this problem is appreciated.

-Chris

 
Magento Community Magento Community
Magento Community
Magento Community
 
retrograde
Jr. Member
 
Total Posts:  4
Joined:  2007-12-04
 

Reinstalled PHP and all is good. Problem solved.

 
Magento Community Magento Community
Magento Community
Magento Community
 
tsc
Jr. Member
 
Total Posts:  1
Joined:  2007-12-16
 

I had the same problem when check out… Please help!!!

exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli statement execute error : Incorrect integer value: '' for column 'value' at row 1' in C:\wwwroot\magento\lib\Zend\Db\Statement\Mysqli.php:251
Stack trace
:
#0 C:\wwwroot\magento\lib\Zend\Db\Statement.php(279): Zend_Db_Statement_Mysqli->_execute(Array)
#1 C:\wwwroot\magento\lib\Zend\Db\Adapter\Abstract.php(396): Zend_Db_Statement->execute(Array)
#2 C:\wwwroot\magento\lib\Zend\Db\Adapter\Abstract.php(517): Zend_Db_Adapter_Abstract->query('UPDATE `sales_q...', Array)
#3 C:\wwwroot\magento\app\code\core\Mage\Eav\Model\Entity\Abstract.php(1105): Zend_Db_Adapter_Abstract->update('sales_quote_ent...', Array, 'entity_type_id=...')
#4 C:\wwwroot\magento\app\code\core\Mage\Eav\Model\Entity\Abstract.php(1043): Mage_Eav_Model_Entity_Abstract->_updateAttribute(Object(Mage_Sales_Model_Quote_Address), Object(Mage_Eav_Model_Entity_Attribute), 5, false)
#5 C:\wwwroot\magento\app\code\core\Mage\Eav\Model\Entity\Abstract.php(810): Mage_Eav_Model_Entity_Abstract->_processSaveData(Array)
#6 C:\wwwroot\magento\app\code\core\Mage\Eav\Model\Entity\Collection\Abstract.php(803): Mage_Eav_Model_Entity_Abstract->save(Object(Mage_Sales_Model_Quote_Address))
#7 C:\wwwroot\magento\app\code\core\Mage\Sales\Model\Entity\Quote\Attribute\Backend\Parent.php(29): Mage_Eav_Model_Entity_Collection_Abstract->save()
#8 [internal function]: Mage_Sales_Model_Entity_Quote_Attribute_Backend_Parent->afterSave(Object(Mage_Sales_Model_Quote))
#9 C:\wwwroot\magento\app\code\core\Mage\Eav\Model\Entity\Abstract.php(580): call_user_func_array(Array, Array)
#10 C:\wwwroot\magento\app\code\core\Mage\Eav\Model\Entity\Abstract.php(1157): Mage_Eav_Model_Entity_Abstract->walkAttributes('backend/afterSa...', Array)
#11 C:\wwwroot\magento\app\code\core\Mage\Eav\Model\Entity\Abstract.php(817): Mage_Eav_Model_Entity_Abstract->_afterSave(Object(Mage_Sales_Model_Quote))
#12 C:\wwwroot\magento\app\code\core\Mage\Core\Model\Abstract.php(170): Mage_Eav_Model_Entity_Abstract->save(Object(Mage_Sales_Model_Quote))
#13 C:\wwwroot\magento\app\code\core\Mage\Checkout\Block\Onepage\Review.php(35): Mage_Core_Model_Abstract->save()
#14 C:\wwwroot\magento\lib\Varien\Object.php(75): Mage_Checkout_Block_Onepage_Review->_construct()
#15 C:\wwwroot\magento\app\code\core\Mage\Core\Block\Abstract.php(120): Varien_Object->__construct(Array)
#16 C:\wwwroot\magento\app\code\core\Mage\Core\Block\Template.php(45): Mage_Core_Block_Abstract->__construct()
#17 C:\wwwroot\magento\app\code\core\Mage\Core\Model\Layout.php(343): Mage_Core_Block_Template->__construct()
#18 C:\wwwroot\magento\app\code\core\Mage\Core\Model\Layout.php(189): Mage_Core_Model_Layout->addBlock('Mage_Checkout_B...', 'checkout.onepag...')
#19 C:\wwwroot\magento\app\code\core\Mage\Core\Model\Layout.php(158): Mage_Core_Model_Layout->_generateBlock(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
#20 C:\wwwroot\magento\app\code\core\Mage\Core\Model\Layout.php(159): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#21 C:\wwwroot\magento\app\code\core\Mage\Core\Model\Layout.php(163): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#22 C:\wwwroot\magento\app\code\core\Mage\Core\Controller\Varien\Action.php(270): Mage_Core_Model_Layout->generateBlocks()
#23 C:\wwwroot\magento\app\code\core\Mage\Core\Controller\Varien\Action.php(207): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
#24 C:\wwwroot\magento\app\code\core\Mage\Checkout\controllers\OnepageController.php(84): Mage_Core_Controller_Varien_Action->loadLayout()
#25 C:\wwwroot\magento\app\code\core\Mage\Core\Controller\Varien\Action.php(325): Mage_Checkout_OnepageController->indexAction()
#26 C:\wwwroot\magento\app\code\core\Mage\Core\Controller\Varien\Router\Standard.php(149): Mage_Core_Controller_Varien_Action->dispatch('index')
#27 C:\wwwroot\magento\app\code\core\Mage\Core\Controller\Varien\Front.php(166): Mage_Core_Controller_Varien_Router_Standard->match(Object(Zend_Controller_Request_Http))
#28 C:\wwwroot\magento\app\Mage.php(382): Mage_Core_Controller_Varien_Front->dispatch()
#29 C:\wwwroot\magento\index.php(29): Mage::run('base')
#30 {main}
 
Magento Community Magento Community
Magento Community
Magento Community
 
Michael_1
Enthusiast
 
Total Posts:  826
Joined:  2007-08-31
 

Hi guys,

Can you please post here the following files that you have in your Magento installation:

app\code\core\Mage\Sales\etc\config.xml
app\etc\config
.xml
and any tags (except <host>,<username>,<password> and <dbname>), that you have in your app\etc\local.xml between tags <connection>...</connection> (it is repeated 2 times there).

Please make sure that you don’t post here <host>,<username>,< password> and <dbname> before posting - I don’t need this info!

Thank you.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ChickenDinnerWinner
Jr. Member
 
Total Posts:  2
Joined:  2007-12-01
 

Michael,

I am having the same problem when trying to create a new simple product or duplicate the product in the demo data.  I’ve attached the two config.xml files as requested.  In the local.xml file the only tag I have besides the four you said to omit is:

<active>1</active>

I’m running local on an XP laptop with:

magento-0.6.14100 (had the same problem on 0.6.13700 )
php 5.2.5
apache 2.2
mysql 5.0.45

I tried reinstalling PHP as retrograde did but it did not help.

File Attachments
config.xml  (File Size: 5KB - Downloads: 295)
config.xml  (File Size: 12KB - Downloads: 111)
 
Magento Community Magento Community
Magento Community
Magento Community
 
mcgwest
Jr. Member
 
Total Posts:  7
Joined:  2008-01-16
 

Did you ever find a resolution to this problem? I just installed Magento and got the following error when trying to add a new product:

SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘’ for column ‘entity_id’ at row 1

Any ideas?

 
Magento Community Magento Community
Magento Community
Magento Community
 
ChickenDinnerWinner
Jr. Member
 
Total Posts:  2
Joined:  2007-12-01
 

I have not found the answer yet and I just installed 0.7.14800 and I’m still getting the same error.

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