WishList v0.4 -- v1.3.7 compatible

I'm hoping someone can give me a little insight on an issue I'm having. I'm trying to figure out how to add the 'move product to another wishlist' drop down menu to all the products listed in a wishlist. I don't like the way it's set up now having to go to another page just to move products, especially since you can only move products from the wishlist that is currently selected.

If anyone has any ideas on how to combine the un_wishlist_move page with un_wishlist_default please let me know.

Hi!

I have installed wish list from readme.txt file, but still I have this error:

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 ]

What is going on????!!!

manojlo,

did you run the un_wishlist.sql file in your admin area?

Also, if you have a prefix on your tables, you'll need to follow instructions as noted in the readme file.

-----[ 1. Create tables ]-----

Run 'un_wishlist.sql' in the Install SQL patches in the Zen Cart admin.

Important: If in your implementation of ZenCart you defined a database table prefix (see file "includes/configure.php", line 52), add that prefix to the table names in the sql file before running in the admin. ("un_wishlist.sql", lines 9, 10, 28 and 29).

shakes,

you can try copying and pasting the code from the un_wishlist_move page into the un_wishlist_default page. It's a long shot, but see if it works?

If not, you'll want to hire a developer to customize the module for you. Try posting in the "commercial help wanted" section on this forum.

jackie.taferner:

manojlo,

did you run the un_wishlist.sql file in your admin area?

Also, if you have a prefix on your tables, you'll need to follow instructions as noted in the readme file.

-----[ 1. Create tables ]-----

Run 'un_wishlist.sql' in the Install SQL patches in the Zen Cart admin.

Important: If in your implementation of ZenCart you defined a database table prefix (see file "includes/configure.php", line 52), add that prefix to the table names in the sql file before running in the admin. ("un_wishlist.sql", lines 9, 10, 28 and 29).

Yeah, I did that...
I have added database prefix in those lines of code and - nothing... I have Wish list in my Admin backend, but when I click on it - it crashes! Also, I have sidebox wish list in front end - same thing.....

manojlo,

Can you post the SQL so i can review? Also, what version of Zen Cart are you running - and is it highly customized?

Here is SQL:

# WishList v0.4 SQL Load for MySQL databases


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

DROP TABLE IF EXISTS `un_wishlists`;
CREATE TABLE `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 `un_products_to_wishlists`;
CREATE TABLE `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;

I am using 1.3.8a zen cart version. I have tried to install this module on classic template - nothin'... Also, I have another demo website with free template I have downloaded - also nothing...

manojlo,

I don't see any prefixes in the SQL you've posted. you would want to look in your phpMyAdmin and find out what your prefixes are, then add them like so:

prefix_un_wishlists

oh, sorry :)
zc_testshop_internet is my prefix. Maybe it is too long???

ok, try adding that into the SQL and run it inside your admin. if it's not working, post the actual code you've used in the admin so I can review

hm... when I add my prefix to SQL it wont work... when I upload SQL as it is, it is OK?!?!?!

:blink:

manojlo,

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

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!

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 :)

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! :D

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)

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?!@$#$@ :censored:

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');

<?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!

? :lamo:

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.