Internal or External IP settings?

May 16, 2004

Hi everyone,

Well, had it all working but paypal check-out. Fixed that then the new user form didn't work correctly. My fiance' took a look at it and now the outgoing e-mails from the admin work but the new user form and the paypal check-out are broke. No clue what he's done, crossing my fingers he has some idea of what the heck he's doing since he's a network admin for a living.

Anyway, on the oscommerce server info page, the server address and the mysql server address - do they have to be internal? external? the same? Need some clarification on this please.

Also, another weird error, in the event log security log on Windows 2000 we're getting a set tcb priveledge error. Does this have anything to do with oscommerce?

Thank you.

May 16, 2004

Hello? Any suggestions? I've been posting here for a week only 1 person has responded to my questions. I apologize if I'm not wording them correctly. Am I not following forum ettiquette or something? If not, please accept my apologies. This is the only forum for oscommerce and I'm having oscommerce problems and could really use some help, pretty please?

May 16, 2004

Ok, installed my back-up of the database and catalog files that I created before adding the paypal module 2 days ago. Did this to try to correct whatever changes the fiance' made.

When I initially installed the paypal module I was able to get through the check-out (which I hadn't previously been able to do). So since that module wasn't installed before my back-up, I reinstalled it and followed it word for word.

This time, I still can't get through the check-out. :( When I click the check-out button I get a "cannot find server" error again (like I did before I installed the module 2 days ago).

Help, please!

May 16, 2004

Found the shopping cart problem, the https instead of http so that's fixed. Now when I go through the cart and try to add a new customer, I get:

Warning: mail(): SMTP server response: 501 5.5.4 Invalid Address in U:\www\sunsetwebdesign\html\catalog\includes\classes\email.php on line 502

Warning: Cannot modify header information - headers already sent by (output started at U:\www\sunsetwebdesign\html\catalog\includes\classes\email.php:502) in U:\www\sunsetwebdesign\html\catalog\includes\functions\general.php on line 29

This has been my major hurdle for 2 days. I can't seem to get past this point. The customer is listed in the database but they see this error and can't finish checking out. Has anyone else had this problem?

My site is at: http://www.sunsetwebdesign.com/catalog

May 16, 2004

While trying to test the paypal module installation I received the following error:

Parse error: parse error, unexpected ';', expecting ')' in U:\www\sunsetwebdesign\html\catalog\admin\includes\classes\order.php on line 61

I checked line 61 but found nothing. Here's line 61 with surrounding text:

$this->customer = array('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']);

What is a parse error? What am I missing?

OceanRanch · May 16, 2004

On the modify header error message see

http://wiki.oscommerce.com/WarnHeader

On the parse error (programming term for code not correct. i.e missing ; etc.), post the entire file for review here, it may be before or after line 61.

Tom

May 16, 2004

Thank you for responding Tom. :)

Will look over the header msg right now.

Here's the order.php file:

<?php
/*

$Id: order.php,v 1.7 2003/06/20 16:23:08 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;

function order($order_id) {

$this->info = array();

$this->totals = array();

$this->products = array();

$this->customer = array();

$this->delivery = array();

$this->query($order_id);

}

function query($order_id) {

$//begin PayPal_Shopping_Cart_IPN

$order_query = tep_db_query("select 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,

paypal_ipn_id from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'");

//end PayPal_Shopping_Cart_IPN

$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 by sort_order");

while ($totals = tep_db_fetch_array($totals_query)) {

$this->totals[] = array('title' => $totals['title'],

'text' => $totals['text']);

}

$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'],

'date_purchased' => $order['date_purchased'],

'orders_status' => $order['orders_status'],

//begin PayPal_Shopping_Cart_IPN

'paypal_ipn_id' => $order['paypal_ipn_id'],

//end PayPal_Shopping_Cart_IPN 'last_modified' =>

$order['last_modified']);

$this->customer = array('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']);

$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_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'],

//begin PayPal_Shopping_Cart_IPN

'orders_products_id' => $orders_products['orders_products_id'],

//end PayPal_Shopping_Cart_IPN

'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++;

}

}

$index++;

}

}

}

?>

Thank you so much for taking the time to respond and for your advice. :)

OceanRanch · May 16, 2004

Try changing

//begin PayPal_Shopping_Cart_IPN
'paypal_ipn_id' => $order['paypal_ipn_id'],

//end PayPal_Shopping_Cart_IPN 'last_modified' =>

$order['last_modified']);

To

//begin PayPal_Shopping_Cart_IPN
'paypal_ipn_id' => $order['paypal_ipn_id'],

//end PayPal_Shopping_Cart_IPN

'last_modified' =>$order['last_modified']);

Looks like the Paypal install was munged a bit.

HTH

Tom

Signing off for weekend......good luck

May 16, 2004

Made changes and now that page is appearing. Thank you! :)

Now test order is not showing with John Doe test from paypal module.

Just 2 or 3 steps in a row without a problem would be nice. <sigh> Did so well installing it, now I am just lost.

Moving over to the paypal module thread.

thank you for your help.

Internal or External IP settings?

Recommended Posts

Guest

Guest

Guest

Guest

Guest

OceanRanch

Guest

OceanRanch

Guest

Archived

Browse

Activity