Jump to content

roca.perez

Members
  • Posts

    2
  • Joined

  • Last visited

Posts posted by roca.perez

  1. Here is the fix:

     

    1. Replace entries NULL to integers (like 1 or 2) in foreignkey column in phplist database prefix_user_user

     

    2. in file phplistsync.php line 213 change from

        self::_PHPLIST_DB_.self::_PHPLIST_PREFIX_.'user_user'
    

    to

     self::_PHPLIST_DB_.'.'.self::_PHPLIST_PREFIX_.'user_user'
    

    3. in file phplistsync.php line 98 change from

    SELECT c.`id_customer`, c.`lastname`, c.`firstname`, c.`email`, c.`newsletter`
    	        FROM `'._DB_PREFIX_.'customer` c WHERE c.id_customer not in (SELECT p.foreignkey from '.self::_PHPLIST_DB_.'.'.self::_PHPLIST_PREFIX_.'user_user p)');
    	
    

    to

    SELECT c.`id_customer`, c.`lastname`, c.`firstname`, c.`email`, c.`newsletter`
            FROM `'._DB_PREFIX_.'customer` c WHERE c.id_customer not in (SELECT p.foreignkey from '.self::_PHPLIST_DB_.'.'.self::_PHPLIST_PREFIX_.'user_user p) AND c.email not in (SELECT p.email FROM '.self::_PHPLIST_DB_.'.'.self::_PHPLIST_PREFIX_.'user_user p)');
    

    All done.

     

     

    Hi,

     

    I'dont understand the first step: 

     

    1. Replace entries NULL to integers (like 1 or 2) in foreignkey column in phplist database prefix_user_user

     

    Thank you

  2. Hi,

     

    Let me explain my case. I'm using an external payment gateway, so before to go to make the payment I want to save or insert the order  for avoid missing it,  If the payment fails the customer is returned to my website but the shopping cart is NOW empty. 

     

    I want to use the same cart to place a new order, but I got the message: 'Cart cannot be loaded or an order has already been placed using this cart'.

     

    In other words I want to insert many orders with the same customer's  cart, 

     

    Please help

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More