paypal buy now buttons wont upload

**skunkworx** · 7 Nov 2006, 10:00 AM

hi all,

im trying to upload osme buy now buttons within the description text of my showcase.

it is a showcase with prices and as such has no shipping module or payment modules either.

customers generally email us and we invoice them, as alot of consulting is required before finalising a selection.

i create a button via paypal, upload the code, paste it into the descritpion field and it previews fine.

however it wont update, hence i cant put it up via the product interface. i could probably do it externally but i am wodnering why i cant do it through the normal means....

any ideas?

thanks..

**DrByte** · 7 Nov 2006, 10:05 AM

if you turn off the HTML editor and just paste raw HTML into the product descriptions, does it work any differently?

**skunkworx** · 7 Nov 2006, 10:26 AM

hi DB. thats actually what im already doing.

i already list all my products with pure html.

ive tried it in FP and dreamweaver coz occassionally only DW works.

weird huh?

does it do the same in your software?

thanks so much for the reply!

'love this site.

Tim

**DrByte** · 7 Nov 2006, 11:16 AM

aha ... the "preview" window works, but you can't "save" from the preview window?

Which version of Zen Cart?
Have you installed any contributions?
Are these "Product-General" products, or did you create a new product-type for them?

I suspect there's a nested form-field conflict occurring due to the embedded form objects you're creating. Just need to know what you're working with before suggesting fixes.

**skunkworx** · 7 Nov 2006, 08:43 PM

Originally Posted by DrByte

aha ... the "preview" window works, but you can't "save" from the preview window?

Which version of Zen Cart?
Have you installed any contributions?
Are these "Product-General" products, or did you create a new product-type for them?

I suspect there's a nested form-field conflict occurring due to the embedded form objects you're creating. Just need to know what you're working with before suggesting fixes.

thanks for the reply. i have installed contributions, but i tried it from a clean install, as i didnt work in my previous version 1.2.7 that i was upgrading from (im running that site in parallel). It is in products general.

i wonder if you can try it in your version? it doesnt break anything, just refuses to submit after preview.

thanks again for the help on this- its a bit of a showstopper for me as i dont use any of the built in shipping/purchasing modules due to our sales process.

Tim

**DrByte** · 8 Nov 2006, 01:46 AM

Tim,

Try this edit:

/admin/includes/modules/product/preview_info.php
move line 37, which contains this:

Code:

      echo zen_draw_form($form_action, $type_admin_handler, 'cPath=' . $cPath . (isset($_GET['product_type']) ? '&product_type=' . $_GET['product_type'] : '') . (isset($_GET['pID']) ? '&pID=' . $_GET['pID'] : '') . '&action=' . $form_action . (isset($_GET['page']) ? '&page=' . $_GET['page'] : ''), 'post', 'enctype="multipart/form-data"');

... down to about line 135, so it appears like this:

Code:

<?php
    } else {
      echo zen_draw_form($form_action, $type_admin_handler, 'cPath=' . $cPath . (isset($_GET['product_type']) ? '&product_type=' . $_GET['product_type'] : '') . (isset($_GET['pID']) ? '&pID=' . $_GET['pID'] : '') . '&action=' . $form_action . (isset($_GET['page']) ? '&page=' . $_GET['page'] : ''), 'post', 'enctype="multipart/form-data"');
?>
      <tr>
        <td align="right" class="smallText">
<?php
/* Re-Post all POST'ed variables */

**skunkworx** · 8 Nov 2006, 07:01 AM

you're a genius...however....

maybe i should pose this question from the other angle.

i have people visiting my site and i'd like to allow them to just click on a button to purchase something without having to register and create an account and so on.

this is why i want to do this.

the problem is now it seems to take me straight to zen-cart's shopping cart and gives me an SQL error

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQL_SHOW_SHOPPING_CART_EMPTY' at line 1
in:
[SQL_SHOW_SHOPPING_CART_EMPTY]

is this going to be bigger than ben hur?

**DrByte** · 8 Nov 2006, 07:14 AM

Originally Posted by skunkworx

the problem is now it seems to take me straight to zen-cart's shopping cart and gives me an SQL error

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQL_SHOW_SHOPPING_CART_EMPTY' at line 1
in:
[SQL_SHOW_SHOPPING_CART_EMPTY]

This suggests that you did an upgrade to v1.3.6 but missed at least one file:
/includes/classes/db/mysql/define_queries.php