WebsiteBaker Community Forum
WebsiteBaker Support (2.8.x) => Bakery Shop => Topic started by: arttut02 on November 20, 2013, 01:58:49 PM
-
Just updated Bakery 1.3.x to 1.7. Now I have huge problems when trying to get continue shopping url. I tried to figure this thing out. I (think I) know what is the problem. SQL query does not return p.link value, but why? If i set continue shopping url from admin page settings, why does it not return it back to me?
I'm totally newbie when it comes to using WebsiteBaker and bakery so please bear with me :wink:.
Here is the SQL query that i tested and there comes no value.
SELECT p.link
FROM pages p
INNER JOIN mod_bakery_page_set tings ps
ON p.page_id = ps.page_id
WHERE p.page_id = ps.continue_url AND ps.section_id = '260'
-
Hi arttut02
We can provide better help if you…
- tell us about any mySQL errors?
- export the involved table rows and post them.
And maybe:
Did you copy&paste the query? Your posted query did not work in my db. There is something odd between the two t of set[]tings. Delete the word "setting" and retype it. Try it again.
Regards Christoph
-
I just copy-pasted it from code (without the section id number), because i thought that would give me the continue shopping link. I thought $setting_continue_url is coming from that query.
I'll simplify my question.
I have created own payment method based on paypal. In post_data i have line:
'RETURN_ADDRESS' => $setting_continue_url.'?pm='.$payment_method.'&status=success'
Should I use $setting_continue_url or something else? This gives me empty string sometimes.
I thought this variable gets the value which is set from Admin panel -> pages -> (select shop page) -> page settings -> store settings -> continue shopping url.