cancel
Showing results for 
Search instead for 
Did you mean: 

SQLSTATE[22003]: Numeric value out of range

SOLVED

SQLSTATE[22003]: Numeric value out of range

Hello Dears

Magento ver. 2.3.4

 

i get error when i try to add new Product. :

 

SQLSTATE[22003]: Numeric value out of range: 167 Out of range value for column 'Id' at row 1, query was: insert into fme_nofollowindex (nofollowindex_itemid, nofollowindex_itemtype, nofollowindex_itemfollowvalue, nofollowindex_itemindexvalue, nofollowindex_itemenablevalue) VALUES ('80989','product','1','1','0')

 

anyone could assist how to fixed ? and why this error coming?

 

Thanks and Regards,

Gabriel

1 ACCEPTED SOLUTION

Accepted Solutions

Re: SQLSTATE[22003]: Numeric value out of range

Hello Gabriel,

 

It maybe has something to do with the FME noindex nofollw tags extension. Disable this extension in your admin panel and try again.

 

View solution in original post

3 REPLIES 3

Re: SQLSTATE[22003]: Numeric value out of range

Hi @gabriel_helle,

 

Can you check and confirm table fme_nofollowindex columns details or if possible to share the screenshot of the table structure with all the details(data type) 

 

Hope this helps you!

Problem Solved! Click Kudos & Accept as Solution!

Re: SQLSTATE[22003]: Numeric value out of range

Hello Gabriel,

 

It maybe has something to do with the FME noindex nofollw tags extension. Disable this extension in your admin panel and try again.

 

Re: SQLSTATE[22003]: Numeric value out of range

Hello @speerio 

exactly at target. Bravo.

 

Thanks and regards,

Gabriel