CVV2 once again

[juliatrops]

Hi everyone - I have searched the forum for discussion on the cvv2, and did not find anything specifically addressing this error -

 

I am trying to install the FAQ1004, requiring the CVV to be completed as well -

 

Here is the 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 'wherec.customers_id = '3' and ab.customers_id = '3' and c.custom

 

select c.customers_firstname,c.customers_lastname, c.customers_telephone, c.customers_email_address,ab.entry_company, ab.entry_street_address, ab.entry_suburb,ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name,co.countries_id, co.countries_name, co.countries_iso_code_2,co.countries_iso_code_3, co.address_format_id, ab.entry_state from customers c, address_book ab left join zones z on (ab.entry_zone_id = z.zone_id) left join countries co on (ab.entry_country_id = co.countries_id) wherec.customers_id = '3' and ab.customers_id = '3' and c.customers_default_address_id =ab.address_book_id

 

[TEP STOP]

 

I have gone through the .php's that I adjusted, and re-did them a number of times! I think the problem is with the file located at ../catalog/includes/classes/order.php ... but I cant figure out what is wrong!

 

When I run the script

 

ALTER TABLE `orders` ADD `cc_cvv2` VARCHAR( 4 )

 

MySQL said:

 

Duplicate column name 'cc_cvv2'

 

So I am thinking there are two errors.

 

Any thoughts where I can find them?

 

Thank you all for any help!

[juliatrops]

I just deleted the entire store and recreated, and re-installed this module again.

 

The sql process ran no problem...

The same 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 'wherec.customers_id = '3' and ab.customers_id = '3' and c.custom

 

select c.customers_firstname,c.customers_lastname, c.customers_telephone, c.customers_email_address,ab.entry_company, ab.entry_street_address, ab.entry_suburb,ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name,co.countries_id, co.countries_name, co.countries_iso_code_2,co.countries_iso_code_3, co.address_format_id, ab.entry_state from customers c, address_book ab left join zones z on (ab.entry_zone_id = z.zone_id) left join countries co on (ab.entry_country_id = co.countries_id) wherec.customers_id = '3' and ab.customers_id = '3' and c.customers_default_address_id =ab.address_book_id

 

[TEP STOP]

 

 

Can someone please help!

[juliatrops]

Could it be as simple as a space between "where" and "c"?

 

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 'wherec.customers_id = '3' and ab.customers_id = '3' and c.custom

 

wherec.customers_id = '3' and ab.customers_id = '3' and c.customers_default_address_id =ab.address_book_id

 

[TEP STOP]

[juliatrops]

I put in the space between where and c, and now the error reads:

 

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 '(ab.entry_country_id = c.countries_id) where ab.customers_id = '

 

select ab.entry_firstname,ab.entry_lastname, ab.entry_company, ab.entry_street_address,ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id,z.zone_name, ab.entry_country_id, c.countries_id, c.countries_name,c.countries_iso_code_2, c.countries_iso_code_3, c.address_format_id,ab.entry_state from address_book ab left join zones z on (ab.entry_zone_id = z.zone_id) left join countries con (ab.entry_country_id = c.countries_id) where ab.customers_id = '3' and ab.address_book_id = '3'

 

[TEP STOP]

 

Can you help?

[rabbitseffort]

Hi everyone - I have searched the forum for discussion on the cvv2, and did not find anything specifically addressing this error -

 

I am trying to install the FAQ1004, requiring the CVV to be completed as well -

 

Here is the 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 'wherec.customers_id = '3' and ab.customers_id = '3' and c.custom

 

select c.customers_firstname,c.customers_lastname, c.customers_telephone, c.customers_email_address,ab.entry_company, ab.entry_street_address, ab.entry_suburb,ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name,co.countries_id, co.countries_name, co.countries_iso_code_2,co.countries_iso_code_3, co.address_format_id, ab.entry_state from customers c, address_book ab left join zones z on (ab.entry_zone_id = z.zone_id) left join countries co on (ab.entry_country_id = co.countries_id) wherec.customers_id = '3' and ab.customers_id = '3' and c.customers_default_address_id =ab.address_book_id

 

[TEP STOP]

 

I have gone through the .php's that I adjusted, and re-did them a number of times! I think the problem is with the file located at ../catalog/includes/classes/order.php ... but I cant figure out what is wrong!

 

When I run the script

 

ALTER TABLE `orders` ADD `cc_cvv2` VARCHAR( 4 )

 

MySQL said:

 

Duplicate column name 'cc_cvv2'

 

So I am thinking there are two errors.

 

Any thoughts where I can find them?

 

Thank you all for any help!

the query you are running is wrong, what you are running is this

ALTER TABLE `orders` ADD `cc_cvv2` VARCHAR( 4 )

it should be this

ALTER TABLE `orders` ADD `cc_cvv2` VARCHAR(4) AFTER `cc_number`;

 

I hope this helps...I installed cvv2 by using cvv2 for entire order and then the files fromcredit card with cvv2, good luck...this should solve your issue, if not PM me and I will help walk you thru it :thumbsup:

[selectronics4u]

go to the forums news and announcements there is an 1064 error there with a fix i think may work for you.

[selectronics4u]

sorry see if this may helpread this it may help

[Guest]

The problem is here in the query:

 

 wherec.customers_id = '3' and ab.customers_id = '3'

 

should be:

 

 

where c.customers_id = '3' and ab.customers_id = '3'

 

 

Notice the space between 'where' and c.customers_id' :-"

 

Matti

[juliatrops]

Hi Matti, thank you for your response - I did that in post 3, and then another error popped up.

 

Hi Selectronics4u, I did see that post by Vger, the one you are referring to, but did not know where to put it. My ability to program on my own is very limited though I can read it somewhat - I didnt know where to put it, so thought it best to leave it til I knew what I was doing.

 

I installed the contribution that allows a customer to just buy something without creating an account, successfully a number of times, and a few of the other modules as well.... and I deleted the store once again last night to start fresh. At least I am learning a lot by having to redo a lot!

 

Hi Rabbitseffort, thank you for your response too - I will try that this morning.

 

The thing that I am confused about is, has no one else run that FAQ and come up with these errors? One would think the FAQ would be fixed and working!

 

Thank you again!

[juliatrops]

I re-did the FAQ, and ran the adjust query as suggested...

 

Same error..

 

Here is the offending file (I think - I could be wrong)...

 

You can see the cut and paste from the FAQ because it is a big blob... I really think it is a matter of a few spaces between the words, but I dont know where....

 

 

 

<?php

/*

$Id: order.php,v 1.33 2003/06/09 22:25:35 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

class order {

var $info, $totals, $products, $customer, $delivery, $content_type;

 

function order($order_id = '') {

$this->info = array();

$this->totals = array();

$this->products = array();

$this->customer = array();

$this->delivery = array();

 

if (tep_not_null($order_id)) {

$this->query($order_id);

} else {

$this->cart();

}

}

 

function query($order_id) { global $languages_id; $order_id = tep_db_prepare_input($order_id); $order_query = tep_db_query("select customers_id, customers_name,customers_company, customers_street_address, customers_suburb,customers_city, customers_postcode, customers_state, customers_country,customers_telephone, customers_email_address, customers_address_format_id,delivery_name, delivery_company, delivery_street_address, delivery_suburb,delivery_city, delivery_postcode, delivery_state, delivery_country,delivery_address_format_id, billing_name, billing_company,billing_street_address, billing_suburb, billing_city, billing_postcode,billing_state, billing_country, billing_address_format_id, payment_method,cc_type, cc_owner, cc_number, cc_expires, currency, currency_value,date_purchased, orders_status, last_modified, cc_cvv2 from " . TABLE_ORDERS. " where orders_id = '" . (int)$order_id . "'"); $order = tep_db_fetch_array($order_query); $totals_query = tep_db_query("select title, text from " .TABLE_ORDERS_TOTAL . " where orders_id = '" . (int)$order_id . "' order bysort_order"); while ($totals = tep_db_fetch_array($totals_query)) { $this->totals[] = array('title' => $totals['title'], 'text' => $totals['text']); } $order_total_query = tep_db_query("select text from " .TABLE_ORDERS_TOTAL . " where orders_id = '" . (int)$order_id . "' and class= 'ot_total'"); $order_total = tep_db_fetch_array($order_total_query); $shipping_method_query = tep_db_query("select title from " .TABLE_ORDERS_TOTAL . " where orders_id = '" . (int)$order_id . "' and class= 'ot_shipping'"); $shipping_method = tep_db_fetch_array($shipping_method_query); $order_status_query = tep_db_query("select orders_status_name from " .TABLE_ORDERS_STATUS . " where orders_status_id = '" .$order['orders_status'] . "' and language_id = '" . (int)$languages_id ."'"); $order_status = tep_db_fetch_array($order_status_query); $this->info = array('currency' => $order['currency'], 'currency_value' => $order['currency_value'], 'payment_method' => $order['payment_method'], 'cc_type' => $order['cc_type'], 'cc_owner' => $order['cc_owner'], 'cc_number' => $order['cc_number'], 'cc_expires' => $order['cc_expires'], 'cc_cvv2' => $order['cc_cvv2'], 'date_purchased' => $order['date_purchased'], 'orders_status' =>$order_status['orders_status_name'], 'last_modified' => $order['last_modified'], 'total' => strip_tags($order_total['text']), 'shipping_method' =>((substr($shipping_method['title'], -1) == ':') ?substr(strip_tags($shipping_method['title']), 0, -1) :strip_tags($shipping_method['title'])));

 

$this->customer = array('id' => $order['customers_id'],

'name' => $order['customers_name'],

'company' => $order['customers_company'],

'street_address' => $order['customers_street_address'],

'suburb' => $order['customers_suburb'],

'city' => $order['customers_city'],

'postcode' => $order['customers_postcode'],

'state' => $order['customers_state'],

'country' => $order['customers_country'],

'format_id' => $order['customers_address_format_id'],

'telephone' => $order['customers_telephone'],

'email_address' => $order['customers_email_address']);

 

$this->delivery = array('name' => $order['delivery_name'],

'company' => $order['delivery_company'],

'street_address' => $order['delivery_street_address'],

'suburb' => $order['delivery_suburb'],

'city' => $order['delivery_city'],

'postcode' => $order['delivery_postcode'],

'state' => $order['delivery_state'],

'country' => $order['delivery_country'],

'format_id' => $order['delivery_address_format_id']);

 

if (empty($this->delivery['name']) && empty($this->delivery['street_address'])) {

$this->delivery = false;

}

 

$this->billing = array('name' => $order['billing_name'],

'company' => $order['billing_company'],

'street_address' => $order['billing_street_address'],

'suburb' => $order['billing_suburb'],

'city' => $order['billing_city'],

'postcode' => $order['billing_postcode'],

'state' => $order['billing_state'],

'country' => $order['billing_country'],

'format_id' => $order['billing_address_format_id']);

 

$index = 0;

$orders_products_query = tep_db_query("select orders_products_id, products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'");

while ($orders_products = tep_db_fetch_array($orders_products_query)) {

$this->products[$index] = array('qty' => $orders_products['products_quantity'],

'id' => $orders_products['products_id'],

'name' => $orders_products['products_name'],

'model' => $orders_products['products_model'],

'tax' => $orders_products['products_tax'],

'price' => $orders_products['products_price'],

'final_price' => $orders_products['final_price']);

 

$subindex = 0;

$attributes_query = tep_db_query("select products_options, products_options_values, options_values_price, price_prefix from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int)$order_id . "' and orders_products_id = '" . (int)$orders_products['orders_products_id'] . "'");

if (tep_db_num_rows($attributes_query)) {

while ($attributes = tep_db_fetch_array($attributes_query)) {

$this->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options'],

'value' => $attributes['products_options_values'],

'prefix' => $attributes['price_prefix'],

'price' => $attributes['options_values_price']);

 

$subindex++;

}

}

 

$this->info['tax_groups']["{$this->products[$index]['tax']}"] = '1';

 

$index++;

}

}

 

function cart() { global $customer_id, $sendto, $billto, $cart, $languages_id,$currency, $currencies, $shipping, $payment; $this->content_type = $cart->get_content_type(); $customer_address_query = tep_db_query("select c.customers_firstname,c.customers_lastname, c.customers_telephone, c.customers_email_address,ab.entry_company, ab.entry_street_address, ab.entry_suburb,ab.entry_postcode, ab.entry_city, ab.entry_zone_id, z.zone_name,co.countries_id, co.countries_name, co.countries_iso_code_2,co.countries_iso_code_3, co.address_format_id, ab.entry_state from " .TABLE_CUSTOMERS . " c, " . TABLE_ADDRESS_BOOK . " ab left join " .TABLE_ZONES . " z on (ab.entry_zone_id = z.zone_id) left join " .TABLE_COUNTRIES . " co on (ab.entry_country_id = co.countries_id) where c.customers_id = '" . (int)$customer_id . "' and ab.customers_id = '" .(int)$customer_id . "' and c.customers_default_address_id =ab.address_book_id"); $customer_address = tep_db_fetch_array($customer_address_query); $shipping_address_query = tep_db_query("select ab.entry_firstname,ab.entry_lastname, ab.entry_company, ab.entry_street_address,ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id,z.zone_name, ab.entry_country_id, c.countries_id, c.countries_name,c.countries_iso_code_2, c.countries_iso_code_3, c.address_format_id,ab.entry_state from " . TABLE_ADDRESS_BOOK . " ab left join " . TABLE_ZONES. " z on (ab.entry_zone_id = z.zone_id) left join " . TABLE_COUNTRIES . " con (ab.entry_country_id = c.countries_id) where ab.customers_id = '" .(int)$customer_id . "' and ab.address_book_id = '" . (int)$sendto . "'"); $shipping_address = tep_db_fetch_array($shipping_address_query); $billing_address_query = tep_db_query("select ab.entry_firstname,ab.entry_lastname, ab.entry_company, ab.entry_street_address,ab.entry_suburb, ab.entry_postcode, ab.entry_city, ab.entry_zone_id,z.zone_name, ab.entry_country_id, c.countries_id, c.countries_name,c.countries_iso_code_2, c.countries_iso_code_3, c.address_format_id,ab.entry_state from " . TABLE_ADDRESS_BOOK . " ab left join " . TABLE_ZONES. " z on (ab.entry_zone_id = z.zone_id) left join " . TABLE_COUNTRIES . " con (ab.entry_country_id = c.countries_id) where ab.customers_id = '" .(int)$customer_id . "' and ab.address_book_id = '" . (int)$billto . "'"); $billing_address = tep_db_fetch_array($billing_address_query); $tax_address_query = tep_db_query("select ab.entry_country_id,ab.entry_zone_id from " . TABLE_ADDRESS_BOOK . " ab left join " .TABLE_ZONES . " z on (ab.entry_zone_id = z.zone_id) where ab.customers_id ='" . (int)$customer_id . "' and ab.address_book_id = '" .(int)($this->content_type == 'virtual' ? $billto : $sendto) . "'"); $tax_address = tep_db_fetch_array($tax_address_query); $this->info = array('order_status' => DEFAULT_ORDERS_STATUS_ID, 'currency' => $currency, 'currency_value' =>$currencies->currencies[$currency]['value'], 'payment_method' => $payment, 'cc_type' => (isset($GLOBALS['cc_type']) ?$GLOBALS['cc_type'] : ''), 'cc_owner' => (isset($GLOBALS['cc_owner']) ?$GLOBALS['cc_owner'] : ''), 'cc_number' => (isset($GLOBALS['cc_number']) ?$GLOBALS['cc_number'] : ''), 'cc_expires' => (isset($GLOBALS['cc_expires']) ?$GLOBALS['cc_expires'] : ''), 'cc_cvv2' => (isset($GLOBALS['cc_cvv2']) ? $GLOBALS['cc_cvv2'] : ''), 'shipping_method' => $shipping['title'], 'shipping_cost' => $shipping['cost'], 'subtotal' => 0, 'tax' => 0, 'tax_groups' => array(), 'comments' => (isset($GLOBALS['comments']) ?$GLOBALS['comments'] : ''));

 

 

if (isset($GLOBALS[$payment]) && is_object($GLOBALS[$payment])) {

$this->info['payment_method'] = $GLOBALS[$payment]->title;

 

if ( isset($GLOBALS[$payment]->order_status) && is_numeric($GLOBALS[$payment]->order_status) && ($GLOBALS[$payment]->order_status > 0) ) {

$this->info['order_status'] = $GLOBALS[$payment]->order_status;

}

}

 

$this->customer = array('firstname' => $customer_address['customers_firstname'],

'lastname' => $customer_address['customers_lastname'],

'company' => $customer_address['entry_company'],

'street_address' => $customer_address['entry_street_address'],

'suburb' => $customer_address['entry_suburb'],

'city' => $customer_address['entry_city'],

'postcode' => $customer_address['entry_postcode'],

'state' => ((tep_not_null($customer_address['entry_state'])) ? $customer_address['entry_state'] : $customer_address['zone_name']),

'zone_id' => $customer_address['entry_zone_id'],

'country' => array('id' => $customer_address['countries_id'], 'title' => $customer_address['countries_name'], 'iso_code_2' => $customer_address['countries_iso_code_2'], 'iso_code_3' => $customer_address['countries_iso_code_3']),

'format_id' => $customer_address['address_format_id'],

'telephone' => $customer_address['customers_telephone'],

'email_address' => $customer_address['customers_email_address']);

 

$this->delivery = array('firstname' => $shipping_address['entry_firstname'],

'lastname' => $shipping_address['entry_lastname'],

'company' => $shipping_address['entry_company'],

'street_address' => $shipping_address['entry_street_address'],

'suburb' => $shipping_address['entry_suburb'],

'city' => $shipping_address['entry_city'],

'postcode' => $shipping_address['entry_postcode'],

'state' => ((tep_not_null($shipping_address['entry_state'])) ? $shipping_address['entry_state'] : $shipping_address['zone_name']),

'zone_id' => $shipping_address['entry_zone_id'],

'country' => array('id' => $shipping_address['countries_id'], 'title' => $shipping_address['countries_name'], 'iso_code_2' => $shipping_address['countries_iso_code_2'], 'iso_code_3' => $shipping_address['countries_iso_code_3']),

'country_id' => $shipping_address['entry_country_id'],

'format_id' => $shipping_address['address_format_id']);

 

$this->billing = array('firstname' => $billing_address['entry_firstname'],

'lastname' => $billing_address['entry_lastname'],

'company' => $billing_address['entry_company'],

'street_address' => $billing_address['entry_street_address'],

'suburb' => $billing_address['entry_suburb'],

'city' => $billing_address['entry_city'],

'postcode' => $billing_address['entry_postcode'],

'state' => ((tep_not_null($billing_address['entry_state'])) ? $billing_address['entry_state'] : $billing_address['zone_name']),

'zone_id' => $billing_address['entry_zone_id'],

'country' => array('id' => $billing_address['countries_id'], 'title' => $billing_address['countries_name'], 'iso_code_2' => $billing_address['countries_iso_code_2'], 'iso_code_3' => $billing_address['countries_iso_code_3']),

'country_id' => $billing_address['entry_country_id'],

'format_id' => $billing_address['address_format_id']);

 

$index = 0;

$products = $cart->get_products();

for ($i=0, $n=sizeof($products); $i<$n; $i++) {

$this->products[$index] = array('qty' => $products[$i]['quantity'],

'name' => $products[$i]['name'],

'model' => $products[$i]['model'],

'tax' => tep_get_tax_rate($products[$i]['tax_class_id'], $tax_address['entry_country_id'], $tax_address['entry_zone_id']),

'tax_description' => tep_get_tax_description($products[$i]['tax_class_id'], $tax_address['entry_country_id'], $tax_address['entry_zone_id']),

'price' => $products[$i]['price'],

'final_price' => $products[$i]['price'] + $cart->attributes_price($products[$i]['id']),

'weight' => $products[$i]['weight'],

'id' => $products[$i]['id']);

 

if ($products[$i]['attributes']) {

$subindex = 0;

reset($products[$i]['attributes']);

while (list($option, $value) = each($products[$i]['attributes'])) {

$attributes_query = tep_db_query("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa where pa.products_id = '" . (int)$products[$i]['id'] . "' and pa.options_id = '" . (int)$option . "' and pa.options_id = popt.products_options_id and pa.options_values_id = '" . (int)$value . "' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '" . (int)$languages_id . "' and poval.language_id = '" . (int)$languages_id . "'");

$attributes = tep_db_fetch_array($attributes_query);

 

$this->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options_name'],

'value' => $attributes['products_options_values_name'],

'option_id' => $option,

'value_id' => $value,

'prefix' => $attributes['price_prefix'],

'price' => $attributes['options_values_price']);

 

$subindex++;

}

}

 

$shown_price = tep_add_tax($this->products[$index]['final_price'], $this->products[$index]['tax']) * $this->products[$index]['qty'];

$this->info['subtotal'] += $shown_price;

 

$products_tax = $this->products[$index]['tax'];

$products_tax_description = $this->products[$index]['tax_description'];

if (DISPLAY_PRICE_WITH_TAX == 'true') {

$this->info['tax'] += $shown_price - ($shown_price / (($products_tax < 10) ? "1.0" . str_replace('.', '', $products_tax) : "1." . str_replace('.', '', $products_tax)));

if (isset($this->info['tax_groups']["$products_tax_description"])) {

$this->info['tax_groups']["$products_tax_description"] += $shown_price - ($shown_price / (($products_tax < 10) ? "1.0" . str_replace('.', '', $products_tax) : "1." . str_replace('.', '', $products_tax)));

} else {

$this->info['tax_groups']["$products_tax_description"] = $shown_price - ($shown_price / (($products_tax < 10) ? "1.0" . str_replace('.', '', $products_tax) : "1." . str_replace('.', '', $products_tax)));

}

} else {

$this->info['tax'] += ($products_tax / 100) * $shown_price;

if (isset($this->info['tax_groups']["$products_tax_description"])) {

$this->info['tax_groups']["$products_tax_description"] += ($products_tax / 100) * $shown_price;

} else {

$this->info['tax_groups']["$products_tax_description"] = ($products_tax / 100) * $shown_price;

}

}

 

$index++;

}

 

if (DISPLAY_PRICE_WITH_TAX == 'true') {

$this->info['total'] = $this->info['subtotal'] + $this->info['shipping_cost'];

} else {

$this->info['total'] = $this->info['subtotal'] + $this->info['tax'] + $this->info['shipping_cost'];

}

}

}

?>

[selectronics4u]

i was getting a 1064 error like yours everytime i went to admin to check my paypal ipn orders. all i did was send up the new cat/admin/inc/classes/split_page_results and the new one for catalog and it fixed it there is a bug in the syntax in those files.got the files from the new update that is out.as long as you have not modified those files or you will need to modify manually.if you get the new update from oscommerce.com there are instructions in there to do manual editing.

this may help but cant be sure without trying it.

 

have a great holiday Don

[juliatrops]

I just got a response from netfirms support... the FAQ has another error in it ...

the word con is used instead of "c on" - I believe it is in the above file...

two places...

 

TABLE_COUNTRIES section...

 

Hope they fix that FAQ!

 

Hi Don, thank you for your response... I havent done anything with Paypal yet... I will bookmark this page, for when I do -

 

eventually I hope to have a store similar to my ebay one! The goal is to have it in place for the new year!!

 

Hope you all have a terrific holiday season, and thank you so much for your help!