The following error appears only for one user member, registered in my site as below: 1264 error out of range value column timeonline row 1 UPDATE No11GGUsers SET lastactive=1612022704 Timeonline+timeonline +24 where uid 206 Code (markup): I'm not an SQL expert but I can make the necessary changes in that user table and use available boxes options. Such us changing the value type to int, charvar, ...etc So what i need to do to stop this error showing up in my website?
When asking for MYSQL/SQL Help, it's always advisable to provide people with your table definition (Each Column and it's datatype). From the error, I would guess datatype for 'lastactive' is int. And 1612022704 is too large for an int datatype. So try to change the datatype of lastactive to varchar.
Timeonline column has INT 10 datatype. Lastactive column has INT 10 datatype too. Also as i say im NOT a sql expert.I need exactly what i must do.For example when i changed INT to Charvar via boxes options i receive other syntax errors.So you must tell me exactly what i must do. Like this: Choose charvar option,then set value 0,then choose unsigned value like this i want you to guide me.
Try changing it to "bigint" type, with 18 length. You can do this with a query Alter table No11GGUsers MODIFY Timeonline BIGINT(18); Alter table No11GGUsers MODIFY Lastactive BIGINT(18); You can copy paste those queries in your phpmyadmin. But if the table is too large, then do not use phpmyadmin. In that case, put the query in a .sql file and run via shell. or run via php script which has set_time_limit(0) execution timelimit.
To fix the error, change your datatype to VARCHAR. Phone and Fax numbers should be stored as strings.
Any "number" like phone numbers, ID numbers, house numbers, bank numbers, post codes, and so on should ALWAYS be stored as strings. The ONLY numbers that should be stored as integers, etc are those numbers that are used in MATHEMATICAL operations.