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
- November 11, 2014 @ 09:58:09 [Current Revision] by admin
- November 11, 2014 @ 09:58:09 by admin
- November 11, 2014 @ 09:57:48 by admin
- November 11, 2014 @ 09:57:15 by admin
- November 11, 2014 @ 09:56:26 by admin
- November 11, 2014 @ 09:55:48 by admin
Revision Differences
| November 11, 2014 @ 09:57:15 | Current Revision | ||
|---|---|---|---|
| Content | |||
| Unchanged: <div class="entry"> | Unchanged: <div class="entry"> | ||
| Deleted: <div class="entry"> | Added: <p> | ||
| Deleted: <div class="entry"> | |||
| Deleted: <p style="margin: 0px 0px 20px;padding: 0px;font-size: 14px"> | |||
| Unchanged: 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, | Unchanged: 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, | ||
| 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: | ||
| 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: 1 | Unchanged: 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 | 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">' (`magento_store`.`q`.`items_count` - 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: <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 1 | Unchanged: 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: | ||
| 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: 1 | Unchanged: 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 | Added: <code class="php functions">DELETE</code> <code class="php plain">FROM sales_flat_quote WHERE updated_at < 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 2 | Unchanged: 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: | ||
| 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: 1 | Unchanged: 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 | 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 3 | Unchanged: 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: | ||
| 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: 1 | Unchanged: 1 | ||
| Unchanged: </div> | Unchanged: </div> | ||
| Unchanged: <div class="line number2 index1 alt1"> | Unchanged: <div class="line number2 index1 alt1"> | ||
| Unchanged: 2 | Unchanged: 2 | ||
| Unchanged: </div> | Unchanged: </div> | ||
| Unchanged: <div class="line number3 index2 alt2"> | Unchanged: <div class="line number3 index2 alt2"> | ||
| Unchanged: 3 | Unchanged: 3 | ||
| Unchanged: </div> | Unchanged: </div> | ||
| Unchanged: <div class="line number4 index3 alt1"> | Unchanged: <div class="line number4 index3 alt1"> | ||
| Unchanged: 4 | Unchanged: 4 | ||
| Unchanged: </div> | Unchanged: </div> | ||
| Unchanged: <div class="line number5 index4 alt2"> | Unchanged: <div class="line number5 index4 alt2"> | ||
| Unchanged: 5 | Unchanged: 5 | ||
| Unchanged: </div> | Unchanged: </div> | ||
| Unchanged: <div class="line number6 index5 alt1"> | Unchanged: <div class="line number6 index5 alt1"> | ||
| Unchanged: 6 | Unchanged: 6 | ||
| Unchanged: </div> | Unchanged: </div> | ||
| Unchanged: <div class="line number7 index6 alt2"> | Unchanged: <div class="line number7 index6 alt2"> | ||
| Unchanged: 7 | Unchanged: 7 | ||
| Unchanged: </div> | Unchanged: </div> | ||
| Unchanged: <div class="line number8 index7 alt1"> | Unchanged: <div class="line number8 index7 alt1"> | ||
| Unchanged: 8 | Unchanged: 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: | |||
| Deleted: </div> | |||
| Deleted: </div> | |||
| Deleted: </div> | |||
| Deleted: <div class="meta-tags"> | |||
| Deleted: | |||
| Unchanged: </div> | Unchanged: </div> | ||
Note: Spaces may be added to comparison text to allow better line wrapping.
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?
Hi,
I think you can use the following ways to protect your website from hackers:
– Use CDN of Cloudflare to increase the security and speed of your website. Their service is free for personal website https://www.cloudflare.com
– Upgrade WordPress frequently.
– Use the scan tools to detect and fix the security vulnerabilities, such as this one https://hackertarget.com/wordpress-security-scan
Regards,
Han.
I just got done eating a platter of spaghetti before visiting your site. It sure makes the full feeling all that much better.