You are viewing an old revision of this post, from November 11, 2014 @ 09:55:48. See below for differences between this version and the current revision.

[Magento Fix] SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range

Last week, while working on a client’s Magento 1.7.x website, we were trying to delete all the catalogue products, but it did not happen and it kept on throwing this error,

 
1
SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in '(`magento_store`.`q`.`items_count` - 1)'

Here are three different options,which you can try one by one :

Option 1

 
1
DELETE FROM sales_flat_quote WHERE updated_at < DATE_SUB(Now(),INTERVAL 30 DAY);

Option 2

 
1
DELETE FROM sales_flat_quote WHERE customer_is_guest = 0;

Option 3

 
1
2
3
4
5
6
7
8
SET FOREIGN_KEY_CHECKS=0;
#truncate customer_sales_flat_quote;
#truncate customer_sales_flat_quote_address;
truncate flat_quote;
truncate flat_quote_item;
truncate flat_quote_address;
truncate flat_quote_shipping_rate;
SET FOREIGN_KEY_CHECKS=1;

Revisions

Revision Differences

November 11, 2014 @ 09:55:48Current Revision
Content
Unchanged: <div class="entry">Unchanged: <div class="entry">
Deleted: <p style="margin: 0px 0px 20px;padding: 0px;font-size: 14px">Added: <p>
Unchanged: Last week, while working on a client&rsquo;s Magento 1.7.x website, we were trying to delete all the catalogue products, but it did not happen and it kept on throwing this error,Unchanged: Last week, while working on a client&rsquo;s Magento 1.7.x website, we were trying to delete all the catalogue products, but it did not happen and it kept on throwing this error,
Unchanged: </p>Unchanged: </p>
Deleted: <div style="margin: 0px;padding: 0px">Added: <div>
Unchanged: <div class="syntaxhighlighter php" id="highlighter_424290">Unchanged: <div class="syntaxhighlighter php" id="highlighter_424290">
Unchanged: <div class="toolbar">Unchanged: <div class="toolbar">
Deleted: <a class="toolbar_item command_help help" href="http:// www.learnmagento.org/magento- bug-fixes/magento- fix-sqlstate22003- numeric-value-range-1690- bigint-unsigned- value-range/#" style="color: white !important;text-decoration: none !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;margin: 0px !important;overflow: visible !important;padding: 1px 0px 0px !important;text-align: center !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important;background: none !important">?</a>Added: &nbsp;
Unchanged: </div>Unchanged: </div>
Deleted: <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse;border-spacing: 0px;width: 460px;margin: 0px !important;padding: 0px !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;font-size: 1em !important;direction: ltr !important;background: none !important"> 
Deleted: <tbody style="border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;margin: 0px !important;overflow: visible !important;padding: 0px !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important;background: none !important"> 
Deleted: <tr style="border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;margin: 0px !important;overflow: visible !important;padding: 0px !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important;background: none !important">Added: <table border="0" cellpadding="0" cellspacing="0">
 Added: <tbody>
 Added: <tr>
Unchanged: <td class="gutter">Unchanged: <td class="gutter">
Unchanged: <div class="line number1 index0 alt2">Unchanged: <div class="line number1 index0 alt2">
Unchanged: 1Unchanged: 1
Unchanged: </div>Unchanged: </div>
Unchanged: </td>Unchanged: </td>
Deleted: <td class="code" style="width: 432.666656494141px;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;font-size: 1em !important;direction: ltr !important;background: none !important"> 
Deleted: <div class="container" style="margin: 0px !important;padding: 0px !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important;background: none !important"> 
Deleted: <div class="line number1 index0 alt2" style="margin: 0px !important;padding: 0px 1em !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important"> 
 Added: <td class="code">
 Added: <div class="container">
 Added: <div class="line number1 index0 alt2">
Deleted: <code class="php plain" style="font-size: 1em !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;border: 0px !important;padding: 0px !important;margin: 0px !important;line-height: 1.1em !important;overflow: visible !important;float: none !important;height: auto !important;vertical-align: baseline !important;width: auto !important;direction: ltr !important;color: white !important;background: none !important">SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in </code><code class="php string">&#039; (`magento_store`.`q`.`items_count` - 1)&#039;</code> Added: <code class="php plain">SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in </code><code class="php string">&#039; (`magento_store`.`q`.`items_count` - 1)&#039;</code>
Unchanged: </div>Unchanged: </div>
Unchanged: </div>Unchanged: </div>
Unchanged: </td>Unchanged: </td>
Unchanged: </tr>Unchanged: </tr>
Unchanged: </tbody>Unchanged: </tbody>
Unchanged: </table>Unchanged: </table>
Unchanged: </div>Unchanged: </div>
Unchanged: </div>Unchanged: </div>
Deleted: <p style="margin: 0px 0px 20px;padding: 0px;font-size: 14px">Added: <p>
Unchanged: Here are three different options,which you can try one by one :Unchanged: Here are three different options,which you can try one by one :
Unchanged: </p>Unchanged: </p>
Unchanged: <h3>Unchanged: <h3>
Unchanged: Option 1Unchanged: Option 1
Unchanged: </h3>Unchanged: </h3>
Deleted: <div style="margin: 0px;padding: 0px">Added: <div>
Unchanged: <div class="syntaxhighlighter php" id="highlighter_31033">Unchanged: <div class="syntaxhighlighter php" id="highlighter_31033">
Unchanged: <div class="toolbar">Unchanged: <div class="toolbar">
Deleted: <a class="toolbar_item command_help help" href="http:// www.learnmagento.org/magento- bug-fixes/magento- fix-sqlstate22003- numeric-value-range-1690- bigint-unsigned- value-range/#" style="color: white !important;text-decoration: none !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;margin: 0px !important;overflow: visible !important;padding: 1px 0px 0px !important;text-align: center !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important;background: none !important">?</a>Added: &nbsp;
Unchanged: </div>Unchanged: </div>
Deleted: <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse;border-spacing: 0px;width: 460px;margin: 0px !important;padding: 0px !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;font-size: 1em !important;direction: ltr !important;background: none !important"> 
Deleted: <tbody style="border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;margin: 0px !important;overflow: visible !important;padding: 0px !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important;background: none !important"> 
Deleted: <tr style="border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;margin: 0px !important;overflow: visible !important;padding: 0px !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important;background: none !important">Added: <table border="0" cellpadding="0" cellspacing="0">
 Added: <tbody>
 Added: <tr>
Unchanged: <td class="gutter">Unchanged: <td class="gutter">
Unchanged: <div class="line number1 index0 alt2">Unchanged: <div class="line number1 index0 alt2">
Unchanged: 1Unchanged: 1
Unchanged: </div>Unchanged: </div>
Unchanged: </td>Unchanged: </td>
Deleted: <td class="code" style="width: 432.666656494141px;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;font-size: 1em !important;direction: ltr !important;background: none !important"> 
Deleted: <div class="container" style="margin: 0px !important;padding: 0px !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important;background: none !important"> 
 Added: <td class="code">
 Added: <div class="container">
Deleted: <div class="line number1 index0 alt2" style="margin: 0px !important;padding: 0px 1em !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important">Added: <div class="line number1 index0 alt2">
Deleted: <code class="php functions">DELETE</code> <code class="php plain" style="font-size: 1em !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;border: 0px !important;padding: 0px !important;margin: 0px !important;line-height: 1.1em !important;overflow: visible !important;float: none !important;height: auto !important;vertical-align: baseline !important;width: auto !important;direction: ltr !important;color: white !important;background: none !important">FROM sales_flat_quote WHERE updated_at &lt; DATE_SUB(Now(),INTERVAL 30 DAY);</code> Added: <code class="php functions">DELETE</code> <code class="php plain">FROM sales_flat_quote WHERE updated_at &lt; DATE_SUB(Now(),INTERVAL 30 DAY);</code>
Unchanged: </div>Unchanged: </div>
Unchanged: </div>Unchanged: </div>
Unchanged: </td>Unchanged: </td>
Unchanged: </tr>Unchanged: </tr>
Unchanged: </tbody>Unchanged: </tbody>
Unchanged: </table>Unchanged: </table>
Unchanged: </div>Unchanged: </div>
Unchanged: </div>Unchanged: </div>
Unchanged: <h3>Unchanged: <h3>
Unchanged: Option 2Unchanged: Option 2
Unchanged: </h3>Unchanged: </h3>
Deleted: <div style="margin: 0px;padding: 0px">Added: <div>
Unchanged: <div class="syntaxhighlighter php" id="highlighter_967194">Unchanged: <div class="syntaxhighlighter php" id="highlighter_967194">
Unchanged: <div class="toolbar">Unchanged: <div class="toolbar">
Deleted: <a class="toolbar_item command_help help" href="http:// www.learnmagento.org/magento- bug-fixes/magento- fix-sqlstate22003- numeric-value-range-1690- bigint-unsigned- value-range/#" style="color: white !important;text-decoration: none !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;margin: 0px !important;overflow: visible !important;padding: 1px 0px 0px !important;text-align: center !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important;background: none !important">?</a>Added: &nbsp;
Unchanged: </div>Unchanged: </div>
Deleted: <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse;border-spacing: 0px;width: 460px;margin: 0px !important;padding: 0px !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;font-size: 1em !important;direction: ltr !important;background: none !important"> 
Deleted: <tbody style="border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;margin: 0px !important;overflow: visible !important;padding: 0px !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important;background: none !important"> 
Deleted: <tr style="border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;margin: 0px !important;overflow: visible !important;padding: 0px !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important;background: none !important">Added: <table border="0" cellpadding="0" cellspacing="0">
 Added: <tbody>
 Added: <tr>
Unchanged: <td class="gutter">Unchanged: <td class="gutter">
Unchanged: <div class="line number1 index0 alt2">Unchanged: <div class="line number1 index0 alt2">
Unchanged: 1Unchanged: 1
Unchanged: </div>Unchanged: </div>
Unchanged: </td>Unchanged: </td>
Deleted: <td class="code" style="width: 432.666656494141px;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;font-size: 1em !important;direction: ltr !important;background: none !important"> 
Deleted: <div class="container" style="margin: 0px !important;padding: 0px !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important;background: none !important"> 
Deleted: <div class="line number1 index0 alt2" style="margin: 0px !important;padding: 0px 1em !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important"> 
 Added: <td class="code">
 Added: <div class="container">
 Added: <div class="line number1 index0 alt2">
Deleted: <code class="php functions">DELETE</code> <code class="php plain" style="font-size: 1em !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;border: 0px !important;padding: 0px !important;margin: 0px !important;line-height: 1.1em !important;overflow: visible !important;float: none !important;height: auto !important;vertical-align: baseline !important;width: auto !important;direction: ltr !important;color: white !important;background: none !important">FROM sales_flat_quote WHERE customer_is_guest = 0;</code> Added: <code class="php functions">DELETE</code> <code class="php plain">FROM sales_flat_quote WHERE customer_is_guest = 0;</code>
Unchanged: </div>Unchanged: </div>
Unchanged: </div>Unchanged: </div>
Unchanged: </td>Unchanged: </td>
Unchanged: </tr>Unchanged: </tr>
Unchanged: </tbody>Unchanged: </tbody>
Unchanged: </table>Unchanged: </table>
Unchanged: </div>Unchanged: </div>
Unchanged: </div>Unchanged: </div>
Unchanged: <h3>Unchanged: <h3>
Unchanged: Option 3Unchanged: Option 3
Unchanged: </h3>Unchanged: </h3>
Deleted: <div style="margin: 0px;padding: 0px">Added: <div>
Unchanged: <div class="syntaxhighlighter php" id="highlighter_537361">Unchanged: <div class="syntaxhighlighter php" id="highlighter_537361">
Unchanged: <div class="toolbar">Unchanged: <div class="toolbar">
Deleted: <a class="toolbar_item command_help help" href="http:// www.learnmagento.org/magento- bug-fixes/magento- fix-sqlstate22003- numeric-value-range-1690- bigint-unsigned- value-range/#" style="color: white !important;text-decoration: none !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;margin: 0px !important;overflow: visible !important;padding: 1px 0px 0px !important;text-align: center !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important;background: none !important">?</a>Added: &nbsp;
Unchanged: </div>Unchanged: </div>
Deleted: <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse;border-spacing: 0px;width: 460px;margin: 0px !important;padding: 0px !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;font-size: 1em !important;direction: ltr !important;background: none !important"> 
Deleted: <tbody style="border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;margin: 0px !important;overflow: visible !important;padding: 0px !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important;background: none !important"> 
Deleted: <tr style="border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;margin: 0px !important;overflow: visible !important;padding: 0px !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important;background: none !important">Added: <table border="0" cellpadding="0" cellspacing="0">
 Added: <tbody>
 Added: <tr>
Unchanged: <td class="gutter">Unchanged: <td class="gutter">
Unchanged: <div class="line number1 index0 alt2">Unchanged: <div class="line number1 index0 alt2">
Unchanged: 1Unchanged: 1
Unchanged: </div>Unchanged: </div>
Unchanged: <div class="line number2 index1 alt1">Unchanged: <div class="line number2 index1 alt1">
Unchanged: 2Unchanged: 2
Unchanged: </div>Unchanged: </div>
Unchanged: <div class="line number3 index2 alt2">Unchanged: <div class="line number3 index2 alt2">
Unchanged: 3Unchanged: 3
Unchanged: </div>Unchanged: </div>
Unchanged: <div class="line number4 index3 alt1">Unchanged: <div class="line number4 index3 alt1">
Unchanged: 4Unchanged: 4
Unchanged: </div>Unchanged: </div>
Unchanged: <div class="line number5 index4 alt2">Unchanged: <div class="line number5 index4 alt2">
Unchanged: 5Unchanged: 5
Unchanged: </div>Unchanged: </div>
Unchanged: <div class="line number6 index5 alt1">Unchanged: <div class="line number6 index5 alt1">
Unchanged: 6Unchanged: 6
Unchanged: </div>Unchanged: </div>
Unchanged: <div class="line number7 index6 alt2">Unchanged: <div class="line number7 index6 alt2">
Unchanged: 7Unchanged: 7
Unchanged: </div>Unchanged: </div>
Unchanged: <div class="line number8 index7 alt1">Unchanged: <div class="line number8 index7 alt1">
Unchanged: 8Unchanged: 8
Unchanged: </div>Unchanged: </div>
Unchanged: </td>Unchanged: </td>
Deleted: <td class="code" style="width: 432.666656494141px;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;font-size: 1em !important;direction: ltr !important;background: none !important"> 
Deleted: <div class="container" style="margin: 0px !important;padding: 0px !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important;background: none !important"> 
 Added: <td class="code">
 Added: <div class="container">
Deleted: <div class="line number1 index0 alt2" style="margin: 0px !important;padding: 0px 1em !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important">Added: <div class="line number1 index0 alt2">
Deleted: <code class="php plain" style="font-size: 1em !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;border: 0px !important;padding: 0px !important;margin: 0px !important;line-height: 1.1em !important;overflow: visible !important;float: none !important;height: auto !important;vertical-align: baseline !important;width: auto !important;direction: ltr !important;color: white !important;background: none !important">SET FOREIGN_KEY_CHECKS=0;</code>Added: <code class="php plain">SET FOREIGN_KEY_CHECKS=0;</code>
Unchanged: </div>Unchanged: </div>
 Added: <div class="line number2 index1 alt1">
Deleted: <div class="line number2 index1 alt1" style="margin: 0px !important;padding: 0px 1em !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important">Added: <code class="php plain">#truncate customer_sales_ flat_quote;</code>
Deleted: <code class="php plain" style="font-size: 1em !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;border: 0px !important;padding: 0px !important;margin: 0px !important;line-height: 1.1em !important;overflow: visible !important;float: none !important;height: auto !important;vertical-align: baseline !important;width: auto !important;direction: ltr !important;color: white !important;background: none !important">#truncate customer_sales_ flat_quote;</code> 
Unchanged: </div>Unchanged: </div>
 Added: <div class="line number3 index2 alt2">
Deleted: <div class="line number3 index2 alt2" style="margin: 0px !important;padding: 0px 1em !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important">Added: <code class="php plain">#truncate customer_sales_ flat_quote_address;</code>
Deleted: <code class="php plain" style="font-size: 1em !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;border: 0px !important;padding: 0px !important;margin: 0px !important;line-height: 1.1em !important;overflow: visible !important;float: none !important;height: auto !important;vertical-align: baseline !important;width: auto !important;direction: ltr !important;color: white !important;background: none !important">#truncate customer_sales_ flat_quote_address;</code> 
Unchanged: </div>Unchanged: </div>
 Added: <div class="line number4 index3 alt1">
Deleted: <div class="line number4 index3 alt1" style="margin: 0px !important;padding: 0px 1em !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important">Added: <code class="php plain">truncate flat_quote;</code>
Deleted: <code class="php plain" style="font-size: 1em !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;border: 0px !important;padding: 0px !important;margin: 0px !important;line-height: 1.1em !important;overflow: visible !important;float: none !important;height: auto !important;vertical-align: baseline !important;width: auto !important;direction: ltr !important;color: white !important;background: none !important">truncate flat_quote;</code> 
Unchanged: </div>Unchanged: </div>
 Added: <div class="line number5 index4 alt2">
Deleted: <div class="line number5 index4 alt2" style="margin: 0px !important;padding: 0px 1em !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important">Added: <code class="php plain">truncate flat_quote_item;</code>
Deleted: <code class="php plain" style="font-size: 1em !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;border: 0px !important;padding: 0px !important;margin: 0px !important;line-height: 1.1em !important;overflow: visible !important;float: none !important;height: auto !important;vertical-align: baseline !important;width: auto !important;direction: ltr !important;color: white !important;background: none !important">truncate flat_quote_item;</code> 
Unchanged: </div>Unchanged: </div>
 Added: <div class="line number6 index5 alt1">
Deleted: <div class="line number6 index5 alt1" style="margin: 0px !important;padding: 0px 1em !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important">Added: <code class="php plain">truncate flat_quote_address;</code>
Deleted: <code class="php plain" style="font-size: 1em !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;border: 0px !important;padding: 0px !important;margin: 0px !important;line-height: 1.1em !important;overflow: visible !important;float: none !important;height: auto !important;vertical-align: baseline !important;width: auto !important;direction: ltr !important;color: white !important;background: none !important">truncate flat_quote_address;</code> 
Unchanged: </div>Unchanged: </div>
 Added: <div class="line number7 index6 alt2">
Deleted: <div class="line number7 index6 alt2" style="margin: 0px !important;padding: 0px 1em !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important">Added: <code class="php plain">truncate flat_quote_shipping_ rate;</code>
Deleted: <code class="php plain" style="font-size: 1em !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;border: 0px !important;padding: 0px !important;margin: 0px !important;line-height: 1.1em !important;overflow: visible !important;float: none !important;height: auto !important;vertical-align: baseline !important;width: auto !important;direction: ltr !important;color: white !important;background: none !important">truncate flat_quote_shipping_ rate;</code> 
Unchanged: </div>Unchanged: </div>
Deleted: <div class="line number8 index7 alt1" style="margin: 0px !important;padding: 0px 1em !important;border: 0px !important;float: none !important;height: auto !important;line-height: 1.1em !important;overflow: visible !important;vertical-align: baseline !important;width: auto !important;font-size: 1em !important;direction: ltr !important">Added: <div class="line number8 index7 alt1">
Deleted: <code class="php plain" style="font-size: 1em !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;border: 0px !important;padding: 0px !important;margin: 0px !important;line-height: 1.1em !important;overflow: visible !important;float: none !important;height: auto !important;vertical-align: baseline !important;width: auto !important;direction: ltr !important;color: white !important;background: none !important">SET FOREIGN_KEY_CHECKS=1;</code>Added: <code class="php plain">SET FOREIGN_KEY_CHECKS=1;</code>
Unchanged: </div>Unchanged: </div>
Unchanged: </div>Unchanged: </div>
Unchanged: </td>Unchanged: </td>
Unchanged: </tr>Unchanged: </tr>
Unchanged: </tbody>Unchanged: </tbody>
Unchanged: </table>Unchanged: </table>
Unchanged: </div>Unchanged: </div>
Unchanged: </div>Unchanged: </div>
Deleted: </div> 
Deleted: <div class="meta-tags"> 
Deleted: &nbsp; 
Unchanged: </div>Unchanged: </div>

Note: Spaces may be added to comparison text to allow better line wrapping.

3 Responses to “[Magento Fix] SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range”

  1. Cialis generic 26/03/2018 at 6:04 pm #

    Hi! I just wanted to ask if you ever have any trouble with hackers? My last blog (wordpress) was hacked and I ended up losing months of hard work due to no backup. Do you have any solutions to protect against hackers?

  2. Dimple Wardrip 30/05/2018 at 5:03 am #

    I just got done eating a platter of spaghetti before visiting your site. It sure makes the full feeling all that much better.

Leave a Reply