magento–Numeric value out of range: 1690 BIGINT UN

the SOLUTION is to remove ‘UNSIGNED’ attribute from `time_end` and `time_start` columns in MySQL table structure.

To do this
I’m using the example of the error location (the one it showed when you got the error) in the form of dbName:tableName:fieldName so if your data base is called “mage”, your table is called “tag_summary” and the field it has a problem with is called “products”
1) go into your phpMyAdmin,
2) select the database for your Magento installation (mage in our example) from the left column,
3) Select the table name in the left column (“tag_summary”)
4) Select structure from the top menu
5) Select “change” to the right the field name from the list (products)
6) find the “attributes” drop down and change from “unsigned” to the very top one (it is blank)
7) hit “save”
8) go back to your Magento store and refresh the page, the error will be gone and you can delete the products!

In the first post he used “‘(`bargain2_magento`.`q`.`items_count` – 1)’” that is dbName = “bargain2_magento” tableName = “q” fieldName = “items_count” just thought I would add an actual example for clarity.

此条目发表在php与mysql参考, 杂文分类目录。将固定链接加入收藏夹。

发表评论

邮箱地址不会被公开。 必填项已用*标注

您可以使用这些HTML标签和属性: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>