TOPIC: SQL errors - frontend control panels

I set up a menu link to the control panel, and it works, but when I click on some of the icons I get errors.

For example,

when I click on "Categories" I get:

1054 - Unknown column 'ordering' in 'order clause' SQL=select * from gugbz_dtregister_categories where 1=1 order by ordering


when I click on "Records" I get:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and aco_id = 1' at line 1 SQL=select * from gugbz_dtregister_permissions where aro_id in() and aco_id = 1

You can see my site here

Please download the updated DT Register package as it now includes 3.0.9a. This should address your permissions related error for the control panel.

Now, that category error looks to me like your database is not complete. What versions have you upgraded FROM? What version were you running in the previous Joomla when you migrated it to Joomla 3?

Thanks Nathan, as you indicated, the new version fixed some of the errors. I still can't access "Records" though. This is a fresh install of Joomla and DTRegister so I'm not sure why the database would be incomplete. How do I fix?

Go to DT Register Permissions and re-save. Make sure that Super User does NOT have "Edit Own Items Only" checked. Also, make sure your user is assigned ONLY to the Super User group. If assigned to other groups, un-assign them (not necessary anyway) and re-save the user. Then Joomla will require you to logout and login again for any user group changes to be applied.

If you can't get it sorted out, submit a ticket with admin access so we can take a look.

Super user did not have "Edit own items only" checked, but also did not have "Edit Events" checked. I checked that box, saved, and then looked at the assigned user groups, which was only "Super User". Still no joy. I'll provide my admin access info in the already open ticket...

Hi Nathan, I've updated my open ticket with admin info. Do you need anything else from me?