Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[CONTRIBUTION] Wishlist-update_MS1


Guest

Recommended Posts

Read back through this thread... you will see that the problem will be with your <form> tag.

"The price of success is perseverance. The price of failure comes much cheaper."

Link to comment
Share on other sites

  • Replies 93
  • Created
  • Last Reply

Top Posters In This Topic

Illicious

 

Check the </form>(add to cart) - <form>(add to wishlist) tag placement on product_info.php,

 

You may need place the "add to wish list form code" after the last "add to cart </form>" sounds like the two forms are being intertwined.

 

Cheers MaxiDVD

Link to comment
Share on other sites

Anyone get this contribution working on MS2?

 

I keep getting this db error in /catalog/wishlist.php

1064 - You have an error in your SQL syntax near 'select from customers_wishlist WHERE customers_id=2 order by products_name) as t' at line 1

 

select count(select from customers_wishlist WHERE customers_id=2 order by products_name) as total  

 

[TEP STOP]

 

But it works fine otherwise as a infobox.

 

Cheers Lee

Link to comment
Share on other sites

Something to do with this code, anyone see a problem there that make it incompatiable with MS2, if I comment out the line it works fine, but Im not sure if thats the wises thing to do?

 

 $wishlist_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_WISHLIST_PRODUCTS, $wishlist_query_raw, $wishlist_numrows);

 

Cheers Lee :lol:

Link to comment
Share on other sites

You saying if you comments out that line then you can add products to your wishlist just fine?

 

Hmmm well i got rid of thoes sql errors by changing this:

 

  $wishlist_query_raw = "select * from " . TABLE_WISHLIST . " WHERE customers_id=$customer_id order by products_name";

 $wishlist_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_WISHLIST_PRODUCTS, $wishlist_query_raw, $wishlist_numrows);

 $wishlist_query = tep_db_query($wishlist_query_raw);

 

To this:

 

  $wishlist_query_raw = "select * from " . TABLE_WISHLIST . " WHERE customers_id=$customer_id order by products_name";

 $wishlist_split = new splitPageResults($wishlist_query_raw, MAX_DISPLAY_WISHLIST_PRODUCTS);

 $wishlist_query = tep_db_query($wishlist_query_raw);

 $wishlist_numrows = tep_db_num_rows($wishlist_query);

 

Somehow "$HTTP_GET_VARS['page'], " isnt being liked much to i changed it to "$wishlist_query_raw" and i also defined "$wishlist_numrows" as part of the $wishlist_query.

Also, i changed all (in catalog wishlist.php) $HTTP_GET_VARS['page'], to $wishlist_query_raw,

 

That got rid of the sql errors for me and seem to be setting all the queries and functions ok.

 

Can you add products to your wishlist from the product_info.php page?

 

If yes then can you please share the that code?

Link to comment
Share on other sites

The reason your items are being add to the cart is becuase the ending </form> tag for "Add to Cart" happens after the "Add to Wishlist" form --> this means the "Add to Wishlist" is basically a "Add to Cart" button,

 

What you need to accomplish is have your "Add to Cart" button higher on the page and have the "Add to Wishlist" button below the "Add to Cart" button and placed after the last "add to cart" </form> tag. :roll: its sounds crazy but there are two forms on the page now and they need to be seperated from each other,

 

Your forms a being mixed like so:

<form=add_to_cart=lala>

 

<form=add_to_wish_list=lala>

</form></form>

 

It should be like this:

//add_to_cart  form begins -->   :lol:

 

<form=add_to_cart=lala>

</form>

 

//add_to_cart form finished.  :lol:  

 

 

 

 

// And now add_to_wishlist form begins -->  

 

<form=add_to_wishlist=lala>

</form>

 

//add_to_wishlist form finished.  :lol:  

 

This should clear it up a bit - I hope :lol: , If not I can post some code up here later today.

 

I will try your method, as it uses MAX_DISPLAY_WISHLIST_PRODUCTS, which limits the prods per page! cheers Lee :wink:

Link to comment
Share on other sites

Im sure im am inserting the wishlist code correctly.

 

Its not inserted with the add to cart form and ive tested it before and after the add to cart <TD> s.

 

Just one weird thing i found in the unmodified MS2 product_info.php file.

 

If im not mistaken i believe there is only one "</form>" which is found all the way at the bottom of the file and no "<form=" anywhere else.

Very weird. Anyone else notice this?

 

Add to cart looks like this:

 

<td class="main" align="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></td>

 

I dont see no "form" at the begining or ending anywhere except at the bottom of the file of course.

 

If anyone has a wishlist code that works in product_info.php MS2 then please share it so i may see how this is can be fixed.

Link to comment
Share on other sites

product_info.php - MS2

 

<?php

/*

 $Id: product_info.php,v 1.96 2003/06/09 23:03:55 hpdl Exp $



 osCommerce, Open Source E-Commerce Solutions

 http://www.oscommerce.com



 Copyright (c) 2003 osCommerce



 Released under the GNU General Public License

*/



 require('includes/application_top.php');



 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO);



 $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

 $product_check = tep_db_fetch_array($product_check_query);

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<title><?php echo TITLE; ?></title>

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="stylesheet.css">

<script language="javascript"><!--

function popupWindow(url) {

 window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizab
le=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,left=1
50')

}

//--></script>

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

<!-- header //-->

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<!-- header_eof //-->



<!-- body //-->

<table border="0" width="100%" cellspacing="3" cellpadding="3">

 <tr>

   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- left_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

<!-- left_navigation_eof //-->

   </table></td>

<!-- body_text //-->

   <td width="100%" valign="top"><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">

<?php

 if ($product_check['total'] < 1) {

?>

     <tr>

       <td><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?></td>

     </tr>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

     </tr>

     <tr>

       <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

         <tr class="infoBoxContents">

           <td><table border="0" width="100%" cellspacing="0" cellpadding="2">

             <tr>

               <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

               <td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td>

               <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

             </tr>

           </table></td>

         </tr>

       </table></td>

     </tr>

<?php

 } else {

   $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

   $product_info = tep_db_fetch_array($product_info_query);



   tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'");



   if ($new_price = tep_get_products_special_price($product_info['products_id'])) {

     $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>';

   } else {

     $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']));

   }



   if (tep_not_null($product_info['products_model'])) {

     $products_name = $product_info['products_name'] . '<br><span class="smallText">[' . $product_info['products_model'] . ']</span>';

   } else {

     $products_name = $product_info['products_name'];

   }

?>

     <tr>

       <td><table border="0" width="100%" cellspacing="0" cellpadding="0">

         <tr>

           <td class="pageHeading" valign="top"><?php echo $products_name; ?></td>

           <td class="pageHeading" align="right" valign="top"><?php echo $products_price; ?></td>

         </tr>

       </table></td>

     </tr>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

     </tr>

     <tr>

       <td class="main">

<?php

   if (tep_not_null($product_info['products_image'])) {

?>

         <table border="0" cellspacing="0" cellpadding="2" align="right">

           <tr>

             <td align="center" class="smallText">

<script language="javascript"><!--

document.write('<?php echo '<a href="javascript:popupWindow('' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '')">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>');

//--></script>

<noscript>

<?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>

</noscript>

             </td>

           </tr>

         </table>

<?php

   }

?>

         <p><?php echo stripslashes($product_info['products_description']); ?></p>

<?php

   $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'");

   $products_attributes = tep_db_fetch_array($products_attributes_query);

   if ($products_attributes['total'] > 0) {

?>

         <table border="0" cellspacing="0" cellpadding="2">

           <tr>

             <td class="main" colspan="2"><?php echo TEXT_PRODUCT_OPTIONS; ?></td>

           </tr>

<?php

     $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name");

     while ($products_options_name = tep_db_fetch_array($products_options_name_query)) {

       $products_options_array = array();

       $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'");

       while ($products_options = tep_db_fetch_array($products_options_query)) {

         $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']);

         if ($products_options['options_values_price'] != '0') {

           $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') ';

         }

       }



       if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) {

         $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']];

       } else {

         $selected_attribute = false;

       }

?>

           <tr>

             <td class="main"><?php echo $products_options_name['products_options_name'] . ':'; ?></td>

             <td class="main"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></td>

           </tr>

<?php

     }

?>

         </table>

<?php

   }

?>

       </td>

     </tr>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

     </tr>

<?php

   $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");

   $reviews = tep_db_fetch_array($reviews_query);

   if ($reviews['count'] > 0) {

?>

     <tr>

       <td class="main"><?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews['count']; ?></td>

     </tr>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

     </tr>

<?php

   }



   if (tep_not_null($product_info['products_url'])) {

?>

     <tr>

       <td class="main"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', true, false)); ?></td>

     </tr>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

     </tr>

<?php

   }



   if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) {

?>

     <tr>

       <td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td>

     </tr>

<?php

   } else {

?>

     <tr>

       <td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></td>

     </tr>

<?php

   }

?>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

     </tr>

     <tr>

       <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

         <tr class="infoBoxContents">

           <td><table border="0" width="100%" cellspacing="0" cellpadding="2">

             <tr>

               <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

               <td class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?></td>

               <td class="main" align="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></form></td>

               <td align="right" class="main"><?php echo tep_draw_form('wishlist_quantity', tep_href_link(FILENAME_WISHLIST, tep_get_all_get_params(array('action')) . 'action=add_wishlist')); ?> 

               <?php if (tep_session_is_registered('customer_id')) echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_wishlist.gif', IMAGE_BUTTON_ADD_WISHLIST); ?></form></td> 

               <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

             </tr>

           </table></td>

         </tr>

       </table></td>

     </tr>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

     </tr>

     <tr>

       <td>

<?php

   if ( (USE_CACHE == 'true') && !defined('SID')) {

     echo tep_cache_also_purchased(3600);

   } else {

     include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);

   }

 }

?>

       </td>

     </tr>

   </table></td>

<!-- body_text_eof //-->

   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- right_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

<!-- right_navigation_eof //-->

   </table></td>

 </tr>

</table>

<!-- body_eof //-->



<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //-->

<br>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Link to comment
Share on other sites

Ok i see what the problem was now.

 

I removed the "</form>" at the bottom of the file and placed after the cart and wishlist codes.

 

Thanks.

Link to comment
Share on other sites

I think theres another problem.

 

When trying to add a product with (Available Options) product attributes it gets added just fine to the wishlist but it wont "Move to Cart" .

 

Anyone noticed this?

Link to comment
Share on other sites

Ok i dont think theres a problem.

 

Actually its working perfectly.

If you add a product with attributes to your wishlist (or use any other to cart button except in product info) it makes perfect sense for it to be redirected to the product info screen so you may choose the actual product you are infact purchasing/checking out.

 

You cant check out a product that has many sizes and colors in one single click from anywhere else other than the product info page.

 

Very good MS2 coding work.

Link to comment
Share on other sites

Like to add:

 

Sometimes when your logged session times out and you appear to be signned in cus you have not moved anywhere but with the next click you will be signned out.

 

Get it?

 

So your logged in session is over, your in product info and you click on add to wishlist. Then you get a sql error cus you isnt logged in.

 

Would like to see some "if else" code so that if the user isnt still logged in it would redirect him or show him anything else rather than get that ugly gray sql error page.

Link to comment
Share on other sites

Getting this error when trying to add an item to the cart from product_info

 

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

 

delete from TABLE_WISHLIST WHERE customers_id=2 AND products_id=21

 

[TEP STOP]

 

running on MS2 using the new product_info.php file

 

any ideas? THANKS!

Link to comment
Share on other sites

Actually I forgot to mention that is was after adding your change there is when this problem started..before that I was getting the other SQL error. Are you running this on a MS2 site? it seems to be cause me lots of errors.

Link to comment
Share on other sites

Actually I forgot to mention that is was after adding your change there is when this problem started..before that I was getting the other SQL error. Are you running this on a MS2 site? it seems to be cause me lots of errors.

 

There is not yet an MS2 release of this contribution - TB has it running ok on MS2 - you would do well to read any of his posts on it.

 

Your table error is caused by the fact that you have not defined the table in includes/database_tables.php

Link to comment
Share on other sites

I've made a test account for my store, which you're welcome to use in testing the wishlist (and other mods).

 

My other posts should detail the problems I came across, so please look there before PMing me with 1000 messages... my inbox is constantly overflowing.

This thread here is a good start: http://www.oscommerce.com/forums/viewtopic.php?t=50005

 

Username: tester@localhost

Password: tester

 

Please respect that other people will want to test this out also... and will probably be 'playing' with the wishlist at the same time, so if products appear, it's probably because someone else has added them.

 

Clean up after you're finished... and we'll all be happy. :)

 

Cheers,

Tony

"The price of success is perseverance. The price of failure comes much cheaper."

Link to comment
Share on other sites

  • 3 weeks later...

Hi ,

 

Everything works fine until I try and delete the item out of my wishlist. either from the sidebar in or in the actual wishlist page

 

I'm running 2.2 MS1

 

1064 - You have an error in your SQL syntax near '' at line 1

 

delete from customers_wishlist WHERE customers_id=2 AND products_id=

 

[TEP STOP]

 

That's ther error. here http://www.viewvpwebsite.com/catalog

 

 

Thanks,

 

Lonny

Link to comment
Share on other sites

Is there anything us MS2 users can use for a Wishlist?
Yes, the wishlist.

 

Do any of the wishlist contributions work with MS2 yet or can they be made to work?

Any help would be greatly appreciated.  

Thanks

As per Johnsons post and my post on page 7 of this thread... I have it working on MS2.2 (Current MS3 Daily Snapshot).

 

If you have any specific questions about it... or want some info on part of the code (can't offer full files because I have over 70 other contributions installed) you'd be better to post to this thread than PM (I will read this thread anyway, so I will get it... just that my PM Inbox is always overflowing).

 

Cheers,

Tony

"The price of success is perseverance. The price of failure comes much cheaper."

Link to comment
Share on other sites

I have looked and tried various things for a couple of days to get rid of the following error. I have read every thread that I can find pertaining to this. The product doesn't seem to be recognized by the database to delete it.

 

1064 - You have an error in your SQL syntax near '' at line 1

 

delete from customers_wishlist WHERE customers_id=54 AND products_id=

 

It seems to have something to do with the remove area in application_top. It will not disappear. I apparently am doing something wrong. I am running snapshot 5/30 CVS MS2. I have deactivated the wishlist until I figure out how to fix this. Everything else worked great and I can't wait to get it working completely. This one little problem is driving me so crazy. Any suggestions would be greatly appreciated.

Mary

Link to comment
Share on other sites

Are you using the latest version of the wishlist update download?

http://www.oscommerce.com/community/contributions,1208

 

I've compared my remove_wishlist to the latest version and it's the same:

case 'remove_wishlist' :

    tep_db_query("delete from " . TABLE_WISHLIST . " WHERE customers_id=$customer_id AND products_id=$pid");

    // tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters), 'NONSSL'));

break;

 

Let me know how you go... :)

Tony

"The price of success is perseverance. The price of failure comes much cheaper."

Link to comment
Share on other sites

Hi ,

 

Everything works fine until I try and delete the item out of my wishlist. either from the sidebar in or in the actual wishlist page

 

I'm running 2.2 MS1

 

1064 - You have an error in your SQL syntax near '' at line 1

 

delete from customers_wishlist WHERE customers_id=2 AND products_id=

 

[TEP STOP]

 

That's ther error. here http://www.viewvpwebsite.com/catalog

 

 

Thanks,

 

Lonny

 

I have looked and tried various things for a couple of days to get rid of the following error. I have read every thread that I can find pertaining to this. The product doesn't seem to be recognized by the database to delete it.

 

1064 - You have an error in your SQL syntax near '' at line 1

 

delete from customers_wishlist WHERE customers_id=54 AND products_id=

 

It seems to have something to do with the remove area in application_top. It will not disappear. I apparently am doing something wrong. I am running snapshot 5/30 CVS MS2. I have deactivated the wishlist until I figure out how to fix this. Everything else worked great and I can't wait to get it working completely. This one little problem is driving me so crazy. Any suggestions would be greatly appreciated.

Mary

 

I was able to duplicate your errors by installing a copy of your application_top.php - you should download the updated files from contributions :shock:

 

The error disappeared when I pasted the following into the files - it looks exactly the same, but it cleared the error 8)

 

tep_db_query("delete from " . TABLE_WISHLIST . " WHERE customers_id=$customer_id AND products_id=$pid");

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...