Wishlist Database error - unable to get it to work

[Guest]

Hi all - here is the error I get:

 

1146 - Table 'mgsv2.TABLE_WISHLIST' doesn't exist

 

insert into TABLE_WISHLIST (customers_id, products_id, products_model, products_name, products_price) values ('2', '3', 'MSIMPRO', 'Microsoft IntelliMouse Pro', '49.9900' )

 

[TEP STOP]

 

I have made the changes as requested but this error seems far too weird - any suggestions - I am using the phesis.co.uk loaded 3 version on it (if that helps - its the latest one :-)

[blueline]

Sounds to me like you need to double check and make sure that the table 'TABLE_WISHLIST' is an actual talbe in your db.

 

Make sure that it is not simply called 'WISHLIST'.

 

-Chris

[Guest]

Chris - course it's in the database :) Geez I aint that dumb

 

The only thing I can see which is different is that the error is Table_wishlist

and the one I have is customers_wishlist

 

Anyone know what I am doing wrong or am I that dumb?

[Guest]

This is my table result if it helps

 

CREATE TABLE customers_wishlist (



 products_id int(13) NOT NULL default '0',



 customers_id int(13) NOT NULL default '0',



 products_model varchar(13) default NULL,



 products_name varchar(64) NOT NULL default '',



 products_price decimal(8,2) NOT NULL default '0.00',



 final_price decimal(8,2) NOT NULL default '0.00',



 products_quantity int(2) NOT NULL default '0',



 wishlist_name varchar(64) default NULL



) TYPE=MyISAM

[dreamscape]

hey I will be installing the wishlist later today... I'll let ya know if I run into the same problem

[blueline]

Geek,

 

I didn't mean to imply that you were. I am still very new to php and mySQL. The only thing that caught my eye, and I do not know if I am correct in thinking this or not, but you say you created the table 'customer_wishlist'. It looks to me that the error is saying that it is looking for a table called 'TABLE_WISHLIST' and not 'CUSTOMER_WISHLIST'. Like I said, I don't know if I am even close to the problem, but what I would do is go into the wishlist.php file, or whatever file it is, and change the name form 'TABLE_WISHLIST' to 'CUSTOMER_WISHLIST'.

 

Also, due to the fact that you are getting a [TEP STOP] error, I would tell you to make sure that you aren't missing a <? or a ?> anywhere in the file. That can cause major problems.

 

Hope this helps, even just a little.

 

-Chris

[mattice]

Now now kids... I'm sure a

 

define('TABLE_WISHLIST', 'customers_wishlist');

 

 

in application_top.php will help ;)

[Aodhan]

Now now kids... I'm sure a

 

define('TABLE_WISHLIST', 'customers_wishlist');

 

 

in application_top.php will help ;)

 

Heh...you beat me to it! :lol:

 

Aodhan

[Guest]

Yep - all working - thanks boys!

 

However now that it is the question is - is there an administrator side of things or a specific section that people can go to to view there wishlist - make changes/add remove from there cart.

 

May be a good idea once this is part of the CVS to include it as part of the adminstration tool

[dreamscape]

Yep - all working - thanks boys!  

 

However now that it is the question is - is there an administrator side of things or a specific section that people can go to to view there wishlist - make changes/add remove from there cart.

 

May be a good idea once this is part of the CVS to include it as part of the adminstration tool

 

Hey I just got done installing this wishlist mod... wasn't exactly what I thought it would be, but hey it works... no there is no "page" that customers can goto to view their wishlists, but if they are logged in, they should see a "wishlist" column box and from there they can add to their cart or delete... or click the right arrow and be taken to a wishlist "FAQ" that gives them all that info and more...

 

should look similar to this:

[Guest]

Dreamscape! Well done!

 

Yes I have it working, and have changed the icons in modules/wishlist/wishlist.php

 

Only one question now - how can we edit the icons to say "Wishlist to cart" and "delete from wishlist?" instead of In Cart and Delete as is?

 

Let me know if you can (will have to be an languages file somewhere) :idea:

[dreamscape]

thats pretty easy...

 

1st open /includes/modules/wishlist/wishlist.php and near the end of lines 39 and 40, you will see ICON_CART and ICON_DELETE... change them to ICON_WISHLIST_CART and ICON_WISHLIST_DELETE...

 

now in /includes/languages/english.php down pretty far around line 290 on mine, add the following lines:

define('ICON_WISHLIST_CART', 'Wishlist to Cart');

define('ICON_WISHLIST_DELETE', 'Delete from Wishlist');

or change them to whatever you want the little ALT to say...

[vikkic]

1st open /includes/modules/wishlist/wishlist.php and near the end of lines 39 and 40, you will see ICON_CART and ICON_DELETE... change them to ICON_WISHLIST_CART and ICON_WISHLIST_DELETE...

 

now in /includes/languages/english.php down pretty far around line 290 on mine, add the following lines:

define('ICON_WISHLIST_CART', 'Wishlist to Cart');

define('ICON_WISHLIST_DELETE', 'Delete from Wishlist');

or change them to whatever you want the little ALT to say...

 

I'm very new to php but can't see the icons in the wishlist (the cart, or the red x). I have them in the wishlist module I downloaded, but can't tell where they're supposed to go.

I added them to catalog/images on the http and the https directories and to catalog/images/icons. I've put them in catalog/includes/languages/english/images both sides.

I've run out of places to put them!!

Do I need to do the above or make new ones??

 

Vikki

[vikkic]

I managed to get the images working by editing the wishlist.php to look for the icons in

WS_DIR_IMAGES instead of the WS_DIR_ICONS where it was looking for them.

 

Vikki

[Guest]

Im having a similar problem with the wishlist. Im using OSC Loaded 3 and installed wishlist. Everything seems to work perfectly until you add a product to the wishlist. when you add a product you are taken directly to the "shopping_cart.php" page and nothing is entered in your gift list.

 

Any ideas?

 

Thanks

Craig

[Guest]

Same problem I had - but have fixed

 

Questions for you:

1) Have you imported the wishlist.sql into the database?

2) Have you followed all the instructions perfectly? (if you check other posts on this thread you will have the exact right info)

 

If you have further questions, email me ([email protected])

 

On another note - the only problem I have is the placement of the code and how it screws up the layout of product_info.php

 

We mayneed to play around with it :-)

[Guest]

Geekshop,

 

I have followed the instructions to the letter and still have no luck in getting this module to work.

 

Can you offer me any other suggestions?

 

Thanks

Craig

[Guest]

Sorry about the delay in response - let me know what version your using and the quickest way is to send you the files :-)

 

Let me know!

[Guest]

Geekshop,

 

Im using OSC Loaded 3.

 

Thanks for your help.

Craig