Jump to content
Sign in to follow this  
totallybaffled

Wishlist Database Error

Recommended Posts

Hi All

 

Creating a wishlist, but got a database error

 

 

 

1146 - Table 'wishlist_products' doesn't exist

 

select * from wishlist_products WHERE customers_id=2

 

Any clues anybody

Share this post


Link to post
Share on other sites

I assume that you have verified that the table exists?


-------------------------------------------------------------------------------------------------------------------------

NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Share this post


Link to post
Share on other sites
Hi All

 

Creating a wishlist, but got a database error

 

 

 

1146 - Table 'wishlist_products' doesn't exist

 

select * from wishlist_products WHERE customers_id=2

 

Any clues anybody

 

Are you running version 1.1b?

 

http://www.oscommerce.com/downloads.php/co...ions,647/type,3

 

Evidently there were some typos causing database errors in 1.1

 

Aodhan

Share this post


Link to post
Share on other sites

Totally,

 

I had the same problem.

There is an error on the install instruction :

 

In catalog/includes/application_top.php add the following

 

//added for wishlist

define('FILENAME_WISHLIST', 'wishlist.php'); //(found in odules/wishlist)

define('FILENAME_WISHLIST_HELP', 'wishlist_help.php'); //(found in modules/wishlist)

define('TABLE_WISHLIST', 'wishlist_products');

 

Actually the table should be : 'customers_wishlist' and not 'wishlist_products'

 

Hope this helps

 

On the other hand I'm getting an error when trying to insert the wishlist box into the column_right page:

 

Parse error: parse error in /home/tomcat/public_html/catalog_new/catalog/includes/column_right.php on line 18

 

Any hints ?

 

Thanks

Franco


Outside links in signatures are not allowed!

Share this post


Link to post
Share on other sites

Actually the error message that I get is :

 

Warning: Failed opening 'includes/modules/wishlist/FILENAME_WISHLIST' for inclusion (include_path='') in /home/tomcat/public_html/catalog_new/catalog/includes/boxes/wishlist.php on line 14

 

 

Anyone can help ?

 

Franco


Outside links in signatures are not allowed!

Share this post


Link to post
Share on other sites

I did finally get the thing working, though only a kind of working. As i got alsorts of errors. The finall straw was i got it working but had no display.

 

Sorry but dont ask me how i got it working as i haven't a clue. lol

 

After all that Wishlist was not really what i needed.

 

However i have put a plug in idea in the contribution.

 

Have a look and as what you think.

 

http://forums.oscommerce.com/viewtopic.php?t=27973

 

Duncan

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×