Welcome, Guest
Username: Password: Remember me

TOPIC: [SOLVED] Fields reorder fails

Fields reorder fails 8 years 8 months ago #25791

  • nathan.dth
  • nathan.dth's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 1857
  • Karma: 19
  • Thank you received: 218
The reason why you can't order beyond 255 is due to the database field type. We are modifying the DT Register package so with the next update, it will make this change for everyone when you upgrade. For now, you can manually make this change in your database.

Go to the _dtregister_fields table and change the TYPE for "ordering" from TINYINT(3) to SMALLINT(3). Then the 255 limit will be gone.

Please Log in or Create an account to join the conversation.

Nathan is no longer affiliated with DTH since the recent acquisition. You can connect with him and get any type of Joomla website help at www.JoomlaEmployee.com .

Fields reorder fails 8 years 8 months ago #25795

  • shootfast
  • shootfast's Avatar
  • Offline
  • Gold Boarder
  • Gold Boarder
  • Posts: 169
  • Thank you received: 1
Thanks Nathan, is there another limit at some point (500, 600?) or will this remove all limits?

Please Log in or Create an account to join the conversation.

[SOLVED] Fields reorder fails 8 years 8 months ago #25796

  • nathan.dth
  • nathan.dth's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 1857
  • Karma: 19
  • Thank you received: 218
Yes there will still be a limit... 65,535. I think you should be good. :)

Please Log in or Create an account to join the conversation.

Nathan is no longer affiliated with DTH since the recent acquisition. You can connect with him and get any type of Joomla website help at www.JoomlaEmployee.com .

[SOLVED] Fields reorder fails 8 years 8 months ago #25797

  • shootfast
  • shootfast's Avatar
  • Offline
  • Gold Boarder
  • Gold Boarder
  • Posts: 169
  • Thank you received: 1
lol, yup, that should keep us going for the next couple of weeks...

Please Log in or Create an account to join the conversation.

[SOLVED] Fields reorder fails 8 years 8 months ago #25799

  • samsmom
  • samsmom's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 11
  • Thank you received: 0
I actually dealt with this issue today. I had a bunch of editing and reorganizing to do so I downloaded a csv file, edited in excel, reordered, renumbered my ordering, deleted all of the fields from the database and uploaded the new.

Please Log in or Create an account to join the conversation.

Fields reorder fails 8 years 8 months ago #25806

  • shootfast
  • shootfast's Avatar
  • Offline
  • Gold Boarder
  • Gold Boarder
  • Posts: 169
  • Thank you received: 1
Nathan, one last question. I'm preparing to update to the current version of DTRegister next week. Is it safe to assume that this variable change is safe? As in it will not get reversed when I update? Or will I need to go back in and redo it after I do the update?

Thanks for the input,

Shootfast

Please Log in or Create an account to join the conversation.

Time to create page: 0.468 seconds