Copying List creates test Joins

[linomsai]

I tried to copy a List (with forms/groups/repeat groups), i observed that in the copied list an additional Joins "left JOIN ON test1.="

Due to this all the elements gets copied to a different table. And this gives an error:
[[ 500 - An error has occurred.

alter structure: Table 'ps_db.test1_63_repeat' doesn't exist SQL=ALTER TABLE `test1_63_repeat` ADD COLUMN `parent_id` VARCHAR(255) AFTER `` ]]


Pls refer to the screenshot. Seems to be a severe problem.

http://screencast.com/t/kAoItX8RO4

And this is what happened when i deleted the joins
http://screencast.com/t/J4dh8jLL

 

[troester]

Which fabrik version?
Did you use the "Copy" button in the list listing or the "Save as copy" when editing the list?

 

[cheesegrits]

Can you give me a screenshot of the join setup on the original list?

I've tried copying a few lists with a variety of join setups, but haven't managed to replicate this yet. Need to try on a list configured the same as yours.

-- hugh

 

[linomsai]

To check further, i have updated to the latest from the github "Fabrik-fabrik-3.0.5-509-g2f6a725.zip" today. But strange things happened. Observed different things in IE and Mozilla Firefox:

1) Video of the steps how I copy the list
http://screencast.com/t/3SrBS4G522

2) Screenshot of the original list of which i made the copy:
http://screencast.com/t/p94sjkAfas

3) When copied list using the IE browser
http://screencast.com/t/eUCxxPEy

4) When copied list using the Mozilla Browser
http://screencast.com/t/uTsJa7Sog

In Iceweasel, I saw the combination of both IE and Mozilla browser. Though not sure, but again seems to be a browser issue or some code conflict with browser.

 

[cheesegrits]

OK, i'll try and find some time this weekend to look at this, but I have a busy music schedule this weekend, so may not have time. Bump this thread on Monday if I haven't responded by then.

-- hugh

 

[linomsai]

Thanks Hugh....have a nice weekend!!!

 

[linomsai]

*friendly bump*

 

[linomsai]

*friendly bump*

 

[cheesegrits]

I've tried a dozen different configurations of varying join complexity, and have yet to be able to duplicate this issue.

The only thing I can think of is that you may have some damage in either your fabrik_groups or fabrik_joins table which is causing this effect. Which is not impossible - there was a window of about a week a few months ago in github where we had a nasty buried bug whereby creating join elements or table joins was leaving "orphaned" rows in those tables, and/or deleting random rows.

I'll need to lay hands on your site in order to debug this one. Can you catch me on Skype ('cheesegrits', remember to add a note when you send a contact request), and we'll take a look? I'll be needing (at least) backend superadmin and phpMyAdmin access, and probably ftp access (or exTplorer installed on you backend).

-- hugh

 

[linomsai]

Probably you are correct. When checked the thrash of the Elements, i saw few elements without a label and a name along with the named one and could not be deleted, even though it shows deleted when clicking on Empty thrash.