renaming DB tables for compatibility?

Hi MZimmers,

I have run into similar sounding issues, looking for a clear directive. This happened to me while installing lightbox, I received the same errors, even ended up with bad lightbox menu options on the dropdown for configuration.

Running the uninstall.sql resolved the erroneous menu option. But why did that script work when the install did not?

I have a suspicion that the problem might reside with the SQL Query Executor.

Why? Because if you were able to install after you removed the prefix, the the install.sql was good. The screwup had to occur with the executor.

I wonder if you can sum up the results of your situation? Did the removal of your zen_ prefix resolve the problems? Did you every figure out the cause?

Anyway, I'd be very interested in an update if you would be so kind as to oblige.

Thanks,
Mike

Hey, Mike –

Yes, removing the zen_ prefix from the tables did the trick. No adverse side effects seen yet.

That's good news... I suppose.

Glad it worked for you. I'm off to do the same.

Hi,

Before you start hacking at your database, there is a much simpler solution. In the SQL patch for Zen Lightbox find the line that says...

SELECT @cgi := `configuration_group_id` FROM `configuration_group` WHERE `configuration_group_title` = 'Zen Lightbox';
```...and change it to...

SELECT (@cgi := configuration_group_id) FROM configuration_group WHERE configuration_group_title = 'Zen Lightbox';

Regards,
Christian.