Forums

Hi,

I can view list my records, but when cliking edit, it gives a page wtih 0 at first, then sql-statement printed - and in that sql-statement WHERE like where = ""

I made another one, from the documentary to testi it out (the one dealing with articles), and that worked OK. So I thought there was some error I just missed.

But I realized in there in the article example, it was adding "&gcb=1" to the end of URL, which was not added to my own connectivity "thing" (whatever it would be called, its not a form, but.. ).

It connects to database fine as it can read and display the information, but for some reason it is not adding that gcp to end of url and I guess that's why it is somehow not working when going to edit mode. But what is affecting, that what am I missing?

Thanks in advance! 😀

Hi seppo,

How did you create the edit link in your connection then ? it should always add the gcb parameter if you are doing it the same way as in the tutorial!

Regards,
Max

I added:
Article.id:ID
_EDIT_:Edit
to columns list in Front list. To edit actions code, I put just one word to see if it goes there, but it doesn't.
Actually, at first I had more in those fields, but reduced them to those trying to find what's wrong.

After that message, I tested it so that I changed the table name at models -tab to another database - and it worked with that another database. So it must be some problem with the database table (it is copied from old database, not one of joomlas).
However that database has id-field, and everything is shown nicely when viewed. Only when pressing edit-link, it gives that error (and that must be due to that missing gcb -part of url). What does the gcb need to be added?

-Seppo

Hi Seppo,

So with one db table the "gcb" is added, but not with another table ? that would be very strange, the url building is independent of tables!

Please try to click the "clear cache" button under the Connectivity admin home page ?

Regards,
Max

Update, through some miracle it started working. I changed NOTHING, not at the database nore at the site. Yesterday it did not work, today it does.
Actually, same happened to another similar situation earlier (same problem and miracle cure), but I wanted to know what was causing the problem as it happened again.

So, problem solved 😀
Anyway, in case someone else has similar problem or if I run into it again in future, is there some special thing that the adding of gcb -value to url is debendent of?

Ah, just saw your answer too. Maybe it was the cache-issue, sounds like that🙂

Great!🙂

If your table didn't have a primary key then you updated it, that might have been the reason, as the gcb has to use the value of a table primary key, can't think of anything else!

Regards,
Max

Sounds about right. It didn't have primary key, and I was thinking the same and updated the table, but it didn't help the situation. But maybe what I was missing afer that was to clear the cache.. 😑

Anyway thans for good extension and fast help!😉