Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: [SOLVED] 3.0.9a - Error when trying to view records back-end

[SOLVED] 3.0.9a - Error when trying to view records back-end 10 years 7 months ago #23334

  • andybon
  • andybon's Avatar Topic Author
  • Offline
  • Gold Boarder
  • Gold Boarder
  • Posts: 239
  • Thank you received: 0
Since upgrading from 3.0.9 to 3.0.9a I get this error message as soon as I try and follow the 'RECORDS' link at DT Reg back-end admin....

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 '' at line 1 SQL=select * from jos2_dtregister_permissions where aro_id in(8) and aco_id =

Above seems to get converted to a smiley in part.. it should be... aro_id in ( 8 ) and....

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

Last Edit: by andybon.

3.0.9a - Error when trying to view records back-end 10 years 7 months ago #23335

  • nathan.dth
  • nathan.dth's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 1857
  • Karma: 19
  • Thank you received: 218
As stated in the package readme file, when upgrading to the 3.0.9 package, you must go to DT Register -> Permissions and re-save. There were some adjustments there, so make sure all is set as desired and re-save.
The following user(s) said Thank You: andybon

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 .

3.0.9a - Error when trying to view records back-end 10 years 7 months ago #23338

  • andybon
  • andybon's Avatar Topic Author
  • Offline
  • Gold Boarder
  • Gold Boarder
  • Posts: 239
  • Thank you received: 0
Ah yes - perfect now. Thanks

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

[SOLVED] 3.0.9a - Error when trying to view records back-end 10 years 7 months ago #23346

  • confidant
  • confidant's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 5
  • Thank you received: 0
This took me a couple tries before it worked. I think it was necessary to make a permissions change, save, then change it back and save.

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

  • Page:
  • 1
Time to create page: 0.302 seconds