Defne 'Cataract.

dfadjifal;dkfjd;lkjdfk;

fadfs

This is my textarea to be replaced with HTML editor.

testing

This is my textarea to be replaced with HTML editor.

HELP error SQLSTATE[22003]: Numeric value out of range: 167 Out of range value for column 'flag_id'

  SOLVED

Go to solution

    Did you know you can see the translated content as per your choice?

                                                         --Select Language--                                                                 (العربية) Arabic (Standard)                                                                 (中文) Chinese                                                                 (English) English                                                                 (Français) French                                                                 (Deutsch) German                                                                 (日本語) Japanese                                                                 (Português) Portuguese                                                                 (Русский) Russian                                                                 (Español) Spanish                                                     

 Tolvaisas

New Contributor

‎12-21-2017 02:14 AM

HELP error SQLSTATE[22003]: Numeric value out of range: 167 Out of range value for column 'flag_id'

I wonder how it wasn't discussed before, but i'm constantly getting this error and have no clue why it happens. Please let me know if there's anything can be done with this problem.

This shows then I am trying to edit/save any product in back-end.

After saving/editing product, it showing wrong in layered navigation in front-end catalog.

Listing by price is not working correct.

This product comes in front of other category products in list view. (I am using sorting by price).

Also I cant manage stock.

Error in backend:

SQLSTATE[22003]: Numeric value out of range: 167 Out of range value for column 'flag_id' at row 1

This is my textarea to be replaced with HTML editor.

This is my textarea to be replaced with HTML editor.

This is my textarea to be replaced with HTML editor.

eshagh commented on Dec 20, 2016

Steps to reproduce

1. upload file
2.  
3.  

Expected behaviour

file should be saved

Actual behaviour

Error noting file cannot be saved. Issue is filecache has the maximum number of entries for the INT value in fileid column. Is it possible to change fileid from INT to BIGINT? My initial attempt failed.

Server configuration

Operating system: FreeBSD

Web server: Apache24

Database: MariaDB 10

PHP version: 5.6

Nextcloud version: 11

eshagh commented on Dec 20, 2016

Steps to reproduce

1. upload file
2.  
3.  

Expected behaviour

file should be saved

Actual behaviour

Error noting file cannot be saved. Issue is filecache has the maximum number of entries for the INT value in fileid column. Is it possible to change fileid from INT to BIGINT? My initial attempt failed.

Server configuration

Operating system: FreeBSD

Web server: Apache24

Database: MariaDB 10

PHP version: 5.6

Nextcloud version: 11

eshagh commented on Dec 20, 2016

Steps to reproduce

1. upload file
2.  
3.  

Expected behaviour

file should be saved

Actual behaviour

Error noting file cannot be saved. Issue is filecache has the maximum number of entries for the INT value in fileid column. Is it possible to change fileid from INT to BIGINT? My initial attempt failed.

Server configuration

Operating system: FreeBSD

Web server: Apache24

Database: MariaDB 10

PHP version: 5.6

Nextcloud version: 11

eshagh commented on Dec 20, 2016

Steps to reproduce

1. upload file
2.  
3.  

Expected behaviour

file should be saved

Actual behaviour

Error noting file cannot be saved. Issue is filecache has the maximum number of entries for the INT value in fileid column. Is it possible to change fileid from INT to BIGINT? My initial attempt failed.

Server configuration

Operating system: FreeBSD

Web server: Apache24

Database: MariaDB 10

PHP version: 5.6

Nextcloud version: 11

eshagh commented on Dec 20, 2016

Steps to reproduce

1. upload file
2.  
3.  

Expected behaviour

file should be saved

Actual behaviour

Error noting file cannot be saved. Issue is filecache has the maximum number of entries for the INT value in fileid column. Is it possible to change fileid from INT to BIGINT? My initial attempt failed.

Server configuration

Operating system: FreeBSD

Web server: Apache24

Database: MariaDB 10

PHP version: 5.6

Nextcloud version: 11

eshagh commented on Dec 20, 2016

Steps to reproduce

1. upload file
2.  
3.  

Expected behaviour

file should be saved

Actual behaviour

Error noting file cannot be saved. Issue is filecache has the maximum number of entries for the INT value in fileid column. Is it possible to change fileid from INT to BIGINT? My initial attempt failed.

Server configuration

Operating system: FreeBSD

Web server: Apache24

Database: MariaDB 10

PHP version: 5.6

Nextcloud version: 11

eshagh commented on Dec 20, 2016

Steps to reproduce

1. upload file
2.  
3.  

Expected behaviour

file should be saved

Actual behaviour

Error noting file cannot be saved. Issue is filecache has the maximum number of entries for the INT value in fileid column. Is it possible to change fileid from INT to BIGINT? My initial attempt failed.

Server configuration

Operating system: FreeBSD

Web server: Apache24

Database: MariaDB 10

PHP version: 5.6

Nextcloud version: 11

eshagh commented on Dec 20, 2016

Steps to reproduce

1. upload file
2.  
3.  

Expected behaviour

file should be saved

Actual behaviour

Error noting file cannot be saved. Issue is filecache has the maximum number of entries for the INT value in fileid column. Is it possible to change fileid from INT to BIGINT? My initial attempt failed.

Server configuration

Operating system: FreeBSD

Web server: Apache24

Database: MariaDB 10

PHP version: 5.6

Nextcloud version: 11

eshagh commented on Dec 20, 2016

Steps to reproduce

1. upload file
2.  
3.  

Expected behaviour

file should be saved

Actual behaviour

Error noting file cannot be saved. Issue is filecache has the maximum number of entries for the INT value in fileid column. Is it possible to change fileid from INT to BIGINT? My initial attempt failed.

Server configuration

Operating system: FreeBSD

Web server: Apache24

Database: MariaDB 10

PHP version: 5.6

Nextcloud version: 11

Hi I'm using lib: https://github.com/SammyK/LaravelFacebookSdk and Laravel 5.1

When I set bigInteger for facebook_user_id:

$table->bigInteger('facebook_user_id')->unsigned()->index();

and run migration I getting error:

SQLSTATE[22003]: Numeric value out of range: 167 Out of range value for column 'id' at row 1 (SQL: insert intousers(facebook_user_id,name,email,updated_at,created_at) values (1452072323125376840, my name, my@email.com, 2017-04-18 21:53:26, 2017-04-18 21:53:26))

I checked database and field exist:

facebook_user_id Indeks bigint(20) UNSIGNED