TOPIC: [SOLVED] Categories not saving with new events - site broken

Hi,

I was nervous about upgrading since the script was working, but I did it anyway...

I upgraded to the latest version and now when I copy an event, change the date, choose a category and it does not save the event category. I can see the event on the front end master list (with the event in the wrong category) but I cannot see it on the back end at all.

I submitted a ticket... and the nervousness continues. Hopefully the chatter about about lack of support is not true..

My site is non-functioning.. and I am at the mercy of the ticket.... pray for me.

Update.. I can see it on the back end, but the category says "None" and it will not save the category changes.

Ticket # TECH-6300M6ZPJU

Anyone have a suggestion?

I think it has something to do with the index for the dtregister_category table.

After comparing my table in J25(broken) and j30(working), I noticed I had a missing 'root' category entry.

I've re added it and reset the appropriate rgt/lft, parentid etc but still doesn't work as it should. When I go back into categories in UI and save on a category it jumps back to 'top' position (without parent)

I then noticed that there was a missing index on that table, so I tried adding that but still no fix.

This issue was reported as being fixed in the 2.8.7 release but I think whatever was done, it was NOT rolled out to the J2.5 version.

Thank you.

I ended up hiring a freelancer to go in and fix it up.