UN_Wishlist Module

[Lian]

Hi, I am trying to do this, but cant for the life of me figure out what to do.

I get the message

1146 Table 'myusername_zc4.un_wishlists' doesn't exist
in:
[SELECT w.id, w.customers_id, w.created, w.modified, w.name, w.comment, w.default_status, w.public_status, count(p.products_id) as items_count, c.customers_email_address, c.customers_firstname, c.customers_lastname FROM lian123_zc4.un_wishlists w LEFT JOIN lian123_zc4.un_products_to_wishlists p2w ON w.id=p2w.un_wishlists_id LEFT JOIN zen_products p ON p2w.products_id=p.products_id LEFT JOIN zen_customers c ON w.customers_id=c.customers_id GROUP BY w.id ]
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.

I changed the file so it looks like this now

<?php

// Wishlist
define('UN_TABLE_WISHLISTS', 'myusername_zc4.un_wishlists');
define('UN_TABLE_PRODUCTS_TO_WISHLISTS', 'myusername_zc4.un_products_to_wishlists');

?>

But still get the same error. I was unsure about the . as the above post has a _ instead.

It says to edit the sql file on line 9, 10, 28 & 29 which i did, so it now looks like this


# --------------------------------------------------------
#
# Table structure for table un_wishlists
#

DROP TABLE IF EXISTS `myusername_zc4.un_wishlists`;
CREATE TABLE `myusername_zc4.un_wishlists` (

But i now get the following error

1142 DROP command denied to user 'myusername_zc4'@'localhost' for table 'un_wishlists'
in:
[DROP TABLE IF EXISTS zen_myusername_zc4.un_wishlists;]

Any advise as i have no idea?

[Lian]

Sorry me again, ok, i got this to work by adding the tables again via phpMyAdmin and adding them straight to the correct database.

I can get the sidebox to show up now, but not actually on the product pages.

Any ideas what im missing?