Creating Categories

halmaclean

Got a really odd one here - I have been using OST for a while now and have upgraded to v1.7 before now. I have recently upgraded to 1.9.6 and now 1.9.8. In all that time I have never seen the option to add a category - it just doesn't appear where it should. I have about 2 years worth of data I absolutely must keep in the system, and users are asking for a knowledge base they can search... I just can't set one up because I can't add a category!I set up a clean install and the category option was there from the outset... it just isn't there in the upgraded versions.I attempted to migrate the data manually from one DB to another, putting all the records into the clean install, but as soon as I did the 'Category' link disappeared. If I remove the data and go back to the clean install it is there again.What do I need to do to get the category feature running and still retain all my data? This is so infuriatingly elusive for me!Thanks!

peter

Make sure your assigned group has access to manage FAQ. It's that simple.PS: The upcoming version will revamp how the access & permission setup to make it more intuitive.

halmaclean

Hi Peter - thanks for that... the group was *not* allowed to manage the FAQ, which explains it (I'd never have found that!!)However, when I do enable that, I get an error: Unable to update this group. Internal error occurredAny ideas?

halmaclean

Aha!Attempting to update the group threw an error, and the system very helpfully emailed me the backtrace and SQL it was using. Fab!So it seems there is an unknown column in the sql - however, I logged in to the database directly and edited the field for can_manage_faq manually... and voila!The error probably needs looking at -

Unknown column 'can_post_ticket_reply' in 'field list'

---- Backtrace ----

#0 (root)/include/mysqli.php(177): osTicket->logDBError('DB Error #1054', '[UPDATE ostnew_...')

#1 (root)/include/class.group.php(218): db_query('UPDATE ostnew_g...')

#2 (root)/include/class.group.php(140): Group->save('1', Array, Array)

#3 (root)/scp/groups.php(27): Group->update(Array, Array)

#4 {main}

From a quick glance at the field names, it should be 'can_postnew_ticket_reply'Could this be because I reset the prefix for the new version to use 'ostnew_' in the config.php and db? Hope this helps!

ntozier

"Could this be because I reset the prefix for the new version to use 'ostnew_' in the config.php and db? "So... you didn't run the upgrader?Or you installed to a different set of tables?

halmaclean

Absolutely my fault - got it sorted.The upgrader didn't run correctly, I then installed a fresh version using a different table prefix. The categories were present, but when I imported the old data the ability disappeared - clearly there was a config setting to find... In my haste I did a find and replace for ost_ (the default prefix) to become ostnew_. When doing so I inadvertently renamed the field heading 'can_post_ticket_reply' to be can_postnew_ticket_reply'... makes sense when you do a blunt 'find and replace'...! All I needed to do was assign the permission to the group. Now I see it, it's an easy thing to achieve... but looking for it was just not as simple - until I got the original replay above!Feeling rather silly about it now - I'll retire gracefully :)