WishList v0.4 -- v1.3.7 compatible

[jackie.taferner]

manojlo,

then there is an error in your SQL. please post it so I can look at it.

[brushwoodnursery]

Just having a quick go at this since a good customer asked. Nice bit of codework! I'll be tweaking it to fit my store. Something I'll add in tpl_account_default.php is this:

<h2>Wishlist</h2>
<ul id="myAccountGen" class="list">
<a href="<?php echo zen_href_link(UN_FILENAME_WISHLIST, '', 'SSL'); ?>"><?php echo UN_HEADER_TITLE_WISHLIST; ?></a>
</ul>

Seems like a better place than the header to me. I'll also place the Add to Wishlist link by the Add to Cart button instead of the sidebox. Seems more logical. Thanks for giving the code bit for that!

Thanks, JT! I'll be donating!

[jackie.taferner]

brushwoodnursery, glad you are enjoying the mod and customizing to your needs! I will keep your ideas in mind for the next release of Wishlist. Thanks for the donation :)

[manojlo_bg]

This is the error I am having:

1146 Table 'internet_co_rs.un_wishlists' doesn't exist
in:
[SELECT id FROM un_wishlists w WHERE w.customers_id=1 and w.default_status=1 ]

This is part from configure.php file:

// define our database connection
  define('DB_TYPE', 'mysql');
  define('DB_PREFIX', 'zc_testshop_cors');

And this is un_whislist.sql:

# WishList v0.5 SQL Load for MySQL databases


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

DROP TABLE IF EXISTS `zc_testshop_cors_un_wishlists`;
CREATE TABLE `zc_testshop_cors_un_wishlists` (
  `id` int(11) NOT NULL auto_increment,
  `customers_id` int(11) NOT NULL default '0',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `name` varchar(255) default NULL,
  `comment` varchar(255) default NULL,
  `default_status` tinyint(1) NOT NULL default '0',
  `public_status` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;


# --------------------------------------------------------
#
# Table structure for table un_products_to_wishlists
#

DROP TABLE IF EXISTS `zc_testshop_cors_un_products_to_wishlists`;
CREATE TABLE `zc_testshop_cors_un_products_to_wishlists` (
  `products_id` int(11) NOT NULL default '0',
  `un_wishlists_id` int(11) NOT NULL default '0',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `quantity` int(2) NOT NULL default '1',
  `priority` int(1) NOT NULL default '2',
  `comment` varchar(255) default NULL,
  PRIMARY KEY  (`products_id`,`un_wishlists_id`)
) TYPE=MyISAM;

This is the URL of my test website where I have promlems:
http://testshop.internet.co.rs

I have done everything from installation instructions and still nothjng... I have ‘Add to WhisList’ button, I also see the wishlist sidebox, but when I click on ‘Add to WhisList’ it breaks...

Please, I WILL KILL MY SELF!

[jackie.taferner]

manojlo_bg, ok, here are a couple items to check:

1. check your mysql database. does the database "internet_co_rs" exist? does the table "un_wishlists" exist?
2. Did you change the db prefix in the includes/extra_datafiles/un_database_tables.php?

Also, I noticed the graphic is missing for your Wishlist button. Make sure you upload it to includes/templates/YOUR_TEMPLATE/buttons/LANGUAGE/wishlist_add.gif

where
YOUR_TEMPLATE = the name of your template (looks like you're using template_default)
LANGUAGE = your default language (english or other)

[manojlo_bg]

Yeah, here it is

define('DB_DATABASE', 'internet_co_rs');
  define('USE_PCONNECT', 'false');
  define('STORE_SESSIONS', 'db');

Table un_whishlist exist when I checked in PhpMyAdmin, and it was with db prefix...

I also added that prefix in include/extra_datafiles/un_database_tables.php

It breaks when I click 'Add to whishlist'...

What am I doing wrong?!@$#$@

[jackie.taferner]

ok, please check spelling make sure it's "wishlist" and not "whishlist"

your code appears to be from a different file. Please make sure you checked this file for proper table prefixes.

includes/extra_datafiles/un_database_tables.php

define('UN_TABLE_WISHLISTS', 'un_wishlists');
define('UN_TABLE_PRODUCTS_TO_WISHLISTS', 'un_products_to_wishlists');

[manojlo_bg]

<?php

// Wishlist
define('ZC_TESTSHOP_CORS_UN_TABLE_WISHLISTS', 'zc_testshop_cors_un_wishlists');
define('ZC_TESTSHOP_CORS_UN_TABLE_PRODUCTS_TO_WISHLISTS', 'zc_testshop_cors_un_products_to_wishlists');

?>

or like this:

<?php

// Wishlist
define('UN_TABLE_WISHLISTS', 'zc_testshop_cors_un_wishlists');
define('UN_TABLE_PRODUCTS_TO_WISHLISTS', 'zc_testshop_cors_un_products_to_wishlists');

?>

I have tried both, and still nothing... It keeps telling me that table does not exist in the database.

Ok, can we go from the beginning, again?

1. Run 'un_whishlist.sql' with added prefixes:
lines 9 and 10:

DROP TABLE IF EXISTS `zc_testshop_cors_un_wishlists`;
CREATE TABLE `zc_testshop_cors_un_wishlists` (

and lines 28 and 29:

DROP TABLE IF EXISTS `zc_testshop_cors_un_products_to_wishlists`;
CREATE TABLE `zc_testshop_cors_un_products_to_wishlists` (

2. Upload all files - done!

3. Activated sidebox - done!

?

[jackie.taferner]

Yes, it should be like the second code example.

Try clearing your browser cache and test again to see if it helps?

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.

[manojlo_bg]

There is a little problem with that... This is the e shop I am planing to install wish list: http://www.legoshop.co.rs, so I have already my Zen Cart, but I am testing every module on my test shop to see does it works and how it works... Maybe I could try to install it on my live e shop website, maybe it will work there?

I don't know what to do man... I am so