Errormessage Error 1690 BIGINT UNSIGNED
By Volker Glienke on Monday, 16 December 2013
Posted in Technical Issues
Likes 0
Views 1.5K
Votes 0
Hello!

I am getting error message: 1690 BIGINT UNSIGNED value is out of range in '(`d01807ba`.`kasjos_easyblog_category`.`ordering` - 1)' SQL=update `kasjos_easyblog_category` set `ordering` = `ordering` - 1 where `id` = '4'

I tryed to sort the categories new and clicked on the arrow in the categories overview at the backend. I got this error message and a button to go back to the control center of Joomla. When I go to the categories overview again the catogories are in the order I wanted to have.
Hello Volker,

You are most welcome. Glad that your issue is solved.

Thanks!
Adelene
·
Wednesday, 18 December 2013 01:10
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Volker,

Can you please provide us with the Joomla back end access as well as the FTP access so that I can check on the issues on your site?
We actually need these information so that we can debug on your issues quickly.

Thanks:)
Khairul
·
Monday, 16 December 2013 10:47
·
0 Likes
·
0 Votes
·
0 Comments
·
Here is the account information.
Volker Glienke
·
Monday, 16 December 2013 14:38
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Volker,

I had already fix your issue.
You are hitting that error is because you did not save the value by pressing this button on the screenshot.
Screenshot --> http://screencast.com/t/c6qiPOsYYL
Make sure to save it after you had arrange your category position to reset the numbering in the database.

Thanks
Khairul
·
Monday, 16 December 2013 16:15
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for the help. It now works fine here
Volker Glienke
·
Wednesday, 18 December 2013 01:05
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post