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

TOPIC: What is this "Error: 0 SQL=SELECT . . ."

What is this "Error: 0 SQL=SELECT . . ." 11 years 2 months ago #20046

  • nekamo2
  • nekamo2's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
Can some one please help me?
I have followed what I think are all the appropriate instructions, but everytime I try to save my configuration within the DTRegister module I get the following error screen.

An error has occurred.

0 SQL=SELECT a. * FROM nkm_dtregister_group_event as a LEFT JOIN nkm_dtregister_categories as c ON a.category = c.categoryId order by c.ordering , a.title asc


What does this mean? How can I fix it? And does it have anything to do with why I can't reorder my fields and have them stay in the order designated?

Kevin
Website Manager
http://www.NeKaMo.com/test1965

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

What is this "Error: 0 SQL=SELECT . . ." 11 years 2 months ago #20204

  • robspangolin
  • robspangolin's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 0
I had the same problem. Turns out that the #__dtregister_categories entry in the database doesn't have an 'ordering' column. I just added one manually with phpmyadmin.

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

What is this "Error: 0 SQL=SELECT . . ." 11 years 2 months ago #20205

  • nekamo2
  • nekamo2's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
I should have responded sooner.
My problem is fixed now. There was a tiny, incremental change to the download file for the Joomla 3 update. I did have to delete the extension on my site and then re-install the new file.

I do believe that the ordering column was the issue fixed in the incremental update. I was having no luck ordering my fields before the update.

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

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