Zen Follower
- Join Date:
- Nov 2006
- Posts:
- 284
- Plugin Contributions:
- 0
WishList v0.4 -- v1.3.7 compatible
jackie.taferner:
I dont know what else the problem could be... perhaps you may find it easier to install your zen cart without table prefixes and use the Wishlist with no table modifications.
first off, thanks for the mod, it needs some work but very nice setup.
I would recommend a code fix to address this issue.
The fix is actually pretty simple to address this issue to be compatible with whatever each shop has decided to use or not use a table_prefix.
For the SQL install file, this is perfectly fine if it is pasted in the "install SQL patch" option under "tools" in the admin section.
The patch tool will add the proper db_table_prefix if it is in use and it wil end up as <table_prefix>un_wishlists & <table_prefix>un_products_to_wishlists. If no prefix is used it will be present as un_wishlists & un_products_to_wishlists.
only when it used directly in sqladmin you will need to add the prefixes manually, but why would you... just use the sql patch tool for this.
The coding in both files: includes\extra_datafiles\un_database_tables.php AND <admin_folder>includes\extra_datafiles\un_database_tables.php needs to be adjusted to add the <table_prefix> if it has a value.
For this both files should be recoded like so:
define('UN_TABLE_WISHLISTS', DB_PREFIX . 'un_wishlists');
define('UN_TABLE_PRODUCTS_TO_WISHLISTS', DB_PREFIX . 'un_products_to_wishlists');
```That should stop any table prefix related questions appearing in this thread :cool:
