Save For Later Support Thread

[techextreme]

Ok. This is from the biggest log I have and I've removed a bit of the cache_data = "info".

[03-May-2012 05:18:27] PHP Fatal error: 1062uplicate entry 'zc_3d63152cab3e001e45db0f8214ae796d' for key 'PRIMARY' :: insert into znc_db_cache set cache_entry_name = 'zc_3d63152cab3e001e45db0f8214ae796d',
cache_data = ( removed from here )
cache_entry_created = '1336043907' in /home3/username/public_html/domain_name.com/includes/classes/db/mysql/query_factory.php on line 101

Now, I've removed the files and have done a restore of the database and here's what I see now.

[03-May-2012 06:24:56] PHP Fatal error: 1146:Table 'theburg2_znc1.znc_customers_basket_later' doesn't exist :: select products_id, customers_basket_quantity
from znc_customers_basket_later
where customers_id = '2' in /home3/username/public_html/domain_name.com/includes/classes/db/mysql/query_factory.php on line 101


Now, I'm no sql programmer nor do I know much about php but if you hum a few lines I can follow along.

Thanks for your help.

[swguy]

The second one is the relevant log. You forgot to create the tables. See step 3 in the instructions.

[techextreme]

I did create the tables and we have a prefix on the table structure of znc_ so i prepended that to the mysql_slf.sql file here:

DROP TABLE IF EXISTS znc_customers_basket_later;
CREATE TABLE znc_customers_basket_later

and here:

DROP TABLE IF EXISTS znc_customers_basket_later_attributes;
CREATE TABLE znc_customers_basket_later_attributes (

Now, those are the only 2 places I put that in and I copied and pasted the entire statement into the "Install SQL Patch" window and sent it. I was given a ( 4 lines processed ) message and then things didn't work.

So, I restored the database that I had backed up approximately 10 minutes before and removed all the files I copied in.

So Doc, what's the prognosis?

[swguy]

If you use the Install SQL Patches facility under Tools, you should *not* manually add your own prefix. Install SQL Patches does this for you.

[techextreme]

Then should I try just adding the mysql_sfl.sql ( the unchanged version ) again and retry the files?

[techextreme]

I got it to work properly and thanks for your help.

But I have one more question. Is there a way for the Save for Later to Total what is in there? For Example, I have 1 item at 2.00 and 1 item at 4.00 and so on. Can it be made to total what is in the saved cart?

Thanks again for your help.

[swguy]

No. There's no easy mechanism to arrive at a total for items which are not in the cart.

[techextreme]

Q: How can I find how many people are using Save For Later?
A: Run the following query against your database in phpMyAdmin:

SELECT count(DISTINCT customers_id), count(distinct products_id) from customers_basket_later;

Is there a way to do this from install SQL Patches?

[swguy]

Is there a way to do this from install SQL Patches?

No. Install SQL Patches is for running SQL patches, not getting query results.

[techextreme]

Ok. I have one more question.

I'm wondering if it's possible to add a "Save For Later" button next to each product somewhere near the "Add To Cart" Button.

The only reason I'm asking is this would make it simpler for logged in customers to create their "wish list" or "Save for Later" list instead of having to add them to the cart first.

Thanks in advance.