WishList v0.4 -- v1.3.7 compatible

[manojlo_bg]

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

[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).

[jackie.taferner]

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.

[manojlo_bg]

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.....

[jackie.taferner]

manojlo,

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

[manojlo_bg]

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...

[jackie.taferner]

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

[manojlo_bg]

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

[jackie.taferner]

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

[manojlo_bg]

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