Help cloning table module

[Ajeh]

You are most welcome ... thanks for posting back the results ...

[Twin]

I'm using the above code and have managed to clone table once successfully.

I'd like to clone it again, so that I have 3 table shipping modules. However trying the 3rd clone gives me the following error message:

1062 Duplicate entry 'MODULE_SHIPPING_TABLE_TAX2_BASIS' for key 2
in:
[insert into zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Tax Basis', 'MODULE_SHIPPING_TABLE_TAX2_BASIS', 'Shipping', 'On what basis is Shipping Tax calculated. Options are
Shipping - Based on customers Shipping Address
Billing Based on customers Billing address
Store - Based on Store address if Billing/Shipping Zone equals Store zone', '6', '0', 'zen_cfg_select_option(array(\'Shipping\', \'Billing\', \'Store\'), ', now())]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

This appears after I click "Install" in the admin page on the new cloned table module.

Help?????

[Ajeh]

The constants are named as:
MODULE_SHIPPING_TABLE_TEXT_TITLE

The clone needs to use:
MODULE_SHIPPING_TABLESOMETHING_TEXT_TITLE

You are using:
MODULE_SHIPPING_TABLE_SOMETHING_TEXT_TITLE

So what happens is there is a conflict on table vs table_something as the table is within table_table

but ...

tablesomething is not within table_table

or TABLESOMETHING_ is not within TABLE_

So ... you need to use a naming convention without the conflict ...

Just as if you cloned flat.php ...

flatsomething not flat_something
FLATSOMETHING not FLAT_SOMETHING

Got all that?

[Twin]

Dammit!

It's so obvious when I look at it, I don't know why I didn't fix it on my own. Its the only place I didn't use the right naming convention.

Thanks!

[Ajeh]

Most welcome ... glad that this could help you ...

[bgourmet]

I'm dumb apparently. I made sure the case sensitive thing was ok and now it loads the shipping mods table, until it gets to the new one. Now I get this:

1146 Table 'lecart.OVERNIGHT_CONFIGURATION' doesn't exist
in:
[select configuration_value from OVERNIGHT_CONFIGURATION where configuration_key = 'MODULE_SHIPPING_OVERNIGHT_STATUS']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any help would be appreciated.

[Ajeh]

Looks like you replaced a few too many TABLE ...

There are also references to the database tables which use the word TABLE in them ... and those do not get changed ...