Define new db tables

I'm making some improvements to the Dangling Carrot mod as it overwrites several core files at the moment. The problem i'm faced with is that i added a declare to the original database_tables file. I now want to move this to includes/extra_datafiles, which is where i think it is supposed to be. I put it into this folder with a name of free_gift_database_tables but it does not seem to get read when the cart is loaded as i get an error stating Table 'zentest.table_carrot' doesn't exist.

Am i putting this in the right place, or does it need to be declared somewhere before it will function.

Thanks.

Steve

Try adding the .php extension to the file?
/includes/extra_datafiles/free_gift_database_tables**.php**

Dr Byte,

I'm not a total novice...it is saved with the .php extension :P

I've not found a solution to this, so if anyone has any more ideas, please share them.

And, can anyone explain why db tables are delared in includes, rather than admin/includes?

Regards
Steve

strelitzia:

Dr Byte,

And, can anyone explain why db tables are delared in includes, rather than admin/includes?

Regards
Steve

/admin/includes/extra_datafiles/free_gift_database_tables.php

// example
define('FREE_GIFT', DB_PREFIX . 'free_gifts');

I am not familiar with this mod but if it only needs admin thats where the table define file goes.

Looking at the error message you posted it looks like the database table is defined correctly, but the table does not exist.

The definition tells the php script what the table name is, it does not create the table.

strelitzia:

Dr Byte,

I'm not a total novice...it is saved with the .php extension :P

I've not found a solution to this, so if anyone has any more ideas, please share them.

And, can anyone explain why db tables are delared in includes, rather than admin/includes?

Regards
Steve

Your original message didn't make any mention of "admin".

If your admin area needs access to the table, you'll have to add the define for the table name in the admin side as well, as skipwater pointed out.