the database problem
This post is for the people that have allready installed an older version and are having (or had) trouble with the database tables used in this module.
Basicly the original module did not anticipate for the DB_PREFIX to be used and this has created the problem, according to the changelog this was fixed in v0.41 but apparently reintroduced in v0.5.
Depending on whatever post you have read on this forum you may have gone 2 ways: add the DB_PREFIX var to your define_tables file, or you may have removed the prefix from your actual tables by doing some hard work in your phpadmin.
depending on what you want you may go 2 ways:
- accept to start over with empty tables and let your customers create wishlists from scratch
- copy the data from the old tables to the new <correcly named> tables
First you need to see if you are using new tables or correct ones: Go in admin-->extras-->wishlists and see if it lists any.
If the page is empty you will know you need to make the decision outlined above.
copy data from old to new tables
You will need to work in phpadmin for this as running this via the sql patch tool is simply not possible.
Login to phpmyadmin and select your database, now check the table names on the left side, you will see 4 tables related to the wishlist module:
whatever your dbprefix is, that will need to be used in the statements that you need to execute, for this example i will assume your prefix is zen_
so you have four tables related to the wishlist:
un_wishlists
un_products_to_wishlists
zen_un_wishlists
zen_un_products_to_wishlists
to copy the info from the old tables into the correct new ones execute this code for the above example:
Code:
---insert data into <correct tables>
insert into zen_un_wishlists select * from un_wishlists;
insert into zen_un_products_to_wishlists select * from un_products_to_wishlists;
thats it. verify your customer data has been transferred succesful and you are good to go.
You may optionally delete the incorrect tables with the drop statement if you like to have a clean house.
Bookmarks