Phantom records in fabrik_joins table cuasing SQL errors.

[dealio]

I renamed a database join id and kept getting a SQL error that it couldn't find the old name. I've done this many time without issues.

I noticed the fabrik_joins table would increase in record size but never decrease every time I renamed an element that was part a of a join.

So I deleted all the elements in fabrik, only two records were removed from the fabrik_joins table. I then deleted all lists, groups and dropped the tables.

See image... records are all still present. In the image you can see I renamed "ItemName" to "item_name3" as a test in the front end. It added but the database still show the old. I deleted all elements all lists, all forms, all groups and even their their database tables (through the front end) yet all the join data shows?



This instance has been upgraded to rc1 from the previous github update.

 

[cheesegrits]

I'm not sure what you mean by:

I renamed "ItemName" to "item_name3" as a test in the front end

... and ...

I deleted all elements all lists, all forms, all groups and even their their database tables (through the front end)

In the front end?

Can you record a Jing video showing what you are doing?

http://www.techsmith.com/jing.html

-- hugh

 

[dealio]

I ended up uninstalling fabrik and re-installing and it works. I'll try jing next time.

Thanks

 

[cheesegrits]

OK. I think this may have been a bug we fixed some time ago. You shouldn't have had to uninstall and reinstall though, a github update (or updating with the RC1 ZIP) should have fixed it.

Oh well, glad it's working for you now.

-- hugh