Table name gotcha

[jr@omnipotent.com.au]

I guess this isn't a bug, but its a dangerous gotcha!

Sceneario: I have a site hosted with a provider. I have Fabrik in use to do some stuff on that site.
I then host a 2nd site with the same provider, and want Fabrik to do the same stuff on this site as on the 1st site. So I do a backup of the 1st site and run the restore on the 2ndsite.
Then on the 2nd site I delete the Fabrik data (keeping the table structures in place).

This resulted in the data on the 1st site being deleted because the table names are the same (they are not prefixed with the site table prefix).

The easy solution for me on this one is to get the provider to shift the 2nd hosting to a different server.

 

[troester]

You don't need a different server, you just have to edit and re-resave the fabrik default connection so fabrik will know about the new MySQL database.

 

[jr@omnipotent.com.au]

Thanks troester, I'll check that out.