EB v3.9 Categories > Moving category with up button - An error has occurred. 1690 BIGINT UNSIGNED value is out of range in
By Randall McCallum on Wednesday, 26 March 2014
Posted in Technical Issues
Replies 3
Likes 0
Views 601
Votes 0
EasyBlog Professional
Latest Version: 3.9.15370
Joomla 3.2.3

In EasyBlog Categories I get an error moving categories up or down.

Get an Error with move category up button
An error has occurred.
1690 BIGINT UNSIGNED value is out of range in '(`chamberv_voice84`.`erufp_easyblog_category`.`ordering` - 1)' SQL=update `erufp_easyblog_category` set `ordering` = `ordering` - 1 where `id` = '4'
Return to Control Panel

Get an Error with move category down button
Error
An error has occurred.
1690 BIGINT UNSIGNED value is out of range in '(`chamberv_voice84`.`erufp_easyblog_category`.`ordering` - 1)' SQL=update `erufp_easyblog_category` set `ordering` = `ordering` - 1 where `id` = '3'
Return to Control Panel

Site is still usable so it is not a critical error for me.

Randall
Hello Randall,

For some reasons the ordering count goes beyond the limit of the column from the table but a quick fix to this is to click on the "save order" button in the table header and re-ordering works fine now
Mark
·
Wednesday, 26 March 2014 01:15
·
0 Likes
·
0 Votes
·
0 Comments
·
Mark wrote:

Hello Randall,

For some reasons the ordering count goes beyond the limit of the column from the table but a quick fix to this is to click on the "save order" button in the table header and re-ordering works fine now


Thanks Mark,

Appreciate the fix.

Randall
Randall McCallum
·
Wednesday, 26 March 2014 02:30
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome
Mark
·
Wednesday, 26 March 2014 12:13
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post