Extra database tables

[kalastaja]

I have an old db copy (should be upgraded to 1.5.4) - when I compared it to a new 1.5.4 db I found the following tables only in the old:

customers_admin_notes, customers_wishlist, linkpoint_api, nochex_apc_transactions, vouchers.

[mc12345678]

I have an old db copy (should be upgraded to 1.5.4) - when I compared it to a new 1.5.4 db I found the following tables only in the old:

Very studious of you to go so far as comparing names of database tables. On one hand what's the question about it or the situation? On the other, would point out that software that is installed can create tables (as well as data in those tables and other tables) in fact if you compare the fields in the tables there is likely to be differences as well.

I wish I could tell you which modules created each of those tables, but I can not pinpoint all of them: linkpoint (payment processor), wishlist or customer wishlist something to that affect, vouchers seems like it could be a couple of things. But by investigation of the old code, more than likely the functionality to access those tables should be able to be identified.

Otherwise, if I've barked up the wrong tree, please post..

[kalastaja]

Just curious and verifying that I haven't corrupted the database. All tables are empty. I'll check with the code - thanks.

[mc12345678]

Just curious and verifying that I haven't corrupted the database. All tables are empty. I'll check with the code - thanks.

I assume that the above statement only applies to the short list of provided tables and not. All tables in the. Database.

The general implication of those tables being empty is that no action was taken to. Populate them. Ie. No wishlist generated or those generated were deleted. The next record number would need tobe reviewed to identify if even one had been applied.

It could also be that the modules were installed, but then removed without removing the database modifications. If removing these applications, there may be other database entries that are extraneous (in the configurations table for example)

[kalastaja]

I assume that the above statement only applies to the short list of provided tables and not all tables in the database.

Yes. Didn't think that some procedure would create tables "on the fly", but of course - that happens when necessary!

[DrByte]

You can safely drop these 3 if you're using v1.5.4:
customers_wishlist -- might have been from an old version of ZC. Or a plugin if you've created one.
linkpoint_api - used only if you're utilizing the Linkpoint_API payment module
nochex_apc_transactions -- used only if you're using the NoChex payment module

If you're not using these plugins, you can drop these tables:
customers_admin_notes -- is created by the Admin Notes plugin
vouchers -- no idea ... presumably a plugin?