Error number 1054

I just found ChronoConnectivity tonight. I think it is just what I need. We were about to write some custom code to all our church secretary to be able to update a table of our classes and small groups. This looks like it will fill the need, and we won't have to write the custom code.

The install and a first, very quick attempt at a simple display worked fine. The problem comes when we click on "show data" in the back end. The following error is displayed.

DB function failed with error number 1054
Unknown column 'id' in 'order clause' SQL=SELECT * FROM jos_ctsmallgroups ORDER BY id LIMIT 0,20

I do not have an ID field in the table we are using, and I can not find where to eliminate it from the ORDER BY clause in the back end. (I haven't looked at the code yet.) Could the ORDER BY clause be made configurable like there WHERE BY clause?

George

Hi,

I guess there is some bug, overwrite the 2 files you have with the 2 attached and let me know if this fixes it!

No change.

well, does your table has a primary key ?

No primary key or index.

Ok, you must have a primary key for the table, maybe at the next release I will have a workaround for this issue but at this one you should have a primary key!

I added a primary key and that did solve the problem. Now for some more testing before putting this on the live system.

Thanks,
George

Great! Thanks George for letting us know!🙂