How to sort group categories when the number exceeds 127
By Abi on Wednesday, 21 October 2015
Posted in General Issues
Replies 5
Likes 0
Views 721
Votes 0
Hello,

My groups categories will be between 200 - 220 and I want to be able to sort them easily.

(1) Currently it is difficult to sort properly after the 126th category. How can I fix this?
(2) I want to be able to move categories using their 'ordering' number. e.g swap Peru and Pakistan (see my pictures).

(3) If it is not possible using the backend, how can I achieve my aim via the database?
Hello Abi,

Can you provide us your backend and FTP access so we can have a better look on your issue here?
Nik Faris
·
Wednesday, 21 October 2015 10:21
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Nick,

The site information is added. Please let me know what you do to fix the problem.

Thanks,


Abi
Abi
·
Thursday, 22 October 2015 02:49
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Abi,

I've checked your issue and seems like datatype for our column ordering in categories table is too small. Can you provide us your phpmyadmin access so we can change the datatype of that column?
Nik Faris
·
Thursday, 22 October 2015 16:23
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Nick,

I'm not sure how to give you access to phpmyadmin. It might be easier if you just tell me what to do and how to do it (I have a little experience with phpmyadmin).

Thanks,


Abi
Abi
·
Thursday, 22 October 2015 17:18
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Abi,

You can go to table #_social_clusters_categories and change the data type for ordering column to SMALLINT: http://screencast.com/t/fDe6xDIN72Uu . Then you will be able to set the ordering number for your categories more than 127. Hope this helps.
Nik Faris
·
Thursday, 22 October 2015 17:43
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post