Forums / All Other Contributions/Addons / Super Orders v3.0 Support Thread (for ZC v1.3.9)

Super Orders v3.0 Support Thread (for ZC v1.3.9)

Views: 176,938

Results 121 to 140 of 1,018
10 Jan 2011, 5:08 PM
#121
leilanddale avatar

leilanddale

New Zenner

Join Date:
Jan 2010
Posts:
69
Plugin Contributions:
0

Super Orders v3.0 Support Thread (for ZC v1.3.9)

DivaVocals:

It may be a bit before you see anything updated.. Remember Hem is a busy man (as am I).. We'll get it out as soon as we can... provided we figure out the problem, apply the fix, test it, find free time to update documents/files and upload it.. (you get the poit right:laugh:)

Yip. hehehe...I totally understand. Same my end. LOL

10 Jan 2011, 9:31 PM
#122
supersnow avatar

supersnow

Zen Follower

Join Date:
Apr 2007
Location:
California, USA
Posts:
233
Plugin Contributions:
0

Re: Super Orders v3.0 Support Thread (for ZC v1.3.9)

I currently use pdf Order center ty tracker and now put super order on our site. I have kept PDF order center as it doesn't interfer and I really like the pdf output etc.

Also I really love that when you update a order and send an email you can have the email subject reflect the new status i.e instead of

Order updated #5555

you get:

**Your order #5555 has been sent
**
Plus you can customise this via the language file and add any additional order status and text etc.

Before I put on super orders I was able to move over this ability to ty tracker and it worked great but I am having trouble with super orders with ty tracker integrated.

For it to work with ty tracker I copied over the definitions from the pdfoc.php lanuage file into the tracker.php lanage file

$pdfoc_subject[1] = 'Your order #%d has been received';
$pdfoc_subject[2] = 'Payment for your order #%d has been received';
$pdfoc_subject[3] = 'Your order #%d has been sent';
$pdfoc_subject[4] = 'Here is an update on your order #%d';
$pdfoc_subject[5] = 'Your order #%d has been cancelled';
```Plus updated it to suit my needs then I made the changes to the email section of ty tracker: (admin/tracker.php)

Found:

$html_msg['EMAIL_TEXT_STATUS_PLEASE_REPLY'] = str_replace('\n','<br />', EMAIL_TEXT_STATUS_PLEASE_REPLY);

//For zencart 1.3.0 and earlier (uncomment next 3 lines)
//$html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = $notify_comments;
//$html_msg['EMAIL_TEXT_STATUS_UPDATED'] = str_replace('\n','', EMAIL_TEXT_STATUS_UPDATED);
//$html_msg['EMAIL_TEXT_STATUS_LABEL'] = '<strong>New status:</strong>';

        zen_mail($check_status->fields['customers_name'], $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status');
        
        $customer_notified = '1';

//send extra emails
if (SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_STATUS == '1' and SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO != '') {
zen_mail('', SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO, SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_SUBJECT . ' ' . EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status_extra');

$html_msg['EMAIL_TEXT_STATUS_PLEASE_REPLY'] = str_replace('\n','<br />', EMAIL_TEXT_STATUS_PLEASE_REPLY);
$email_text_subject = sprintf($pdfoc_subject[(int)$status], $oID); // $pdfoc_subject[] is defined in admin/includes/languages/<language>/tracker.php

//For zencart 1.3.0 and earlier (uncomment next 3 lines)
//$html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = $notify_comments;
//$html_msg['EMAIL_TEXT_STATUS_UPDATED'] = str_replace('\n','', EMAIL_TEXT_STATUS_UPDATED);
//$html_msg['EMAIL_TEXT_STATUS_LABEL'] = '<strong>New status:</strong>';

        //zen_mail($check_status->fields['customers_name'], $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status');
        zen_mail($check_status->fields['customers_name'], $check_status->fields['customers_email_address'],  $email_text_subject, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status');

        $customer_notified = '1';

//send extra emails
if (SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_STATUS == '1' and SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO != '') {
//zen_mail('', SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO, SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_SUBJECT . ' ' . EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status_extra');
zen_mail('', SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO, SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_SUBJECT . ' ' . $email_text_subject, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status_extra');
A similar edit to the admin/funcations/extra_functions/common_order_functions.php is not working. Do you have any ideas. One thing I did notice in the common_orders_functions.php there isn't a line
zen_mail($check_status->fields['customers_name'], $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status');
but rather
zen_mail($customer_info->fields['customers_name'], $customer_info->fields['customers_email_address'], EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status');


Am I in the right file? What am I missing?

Thanks
Supersnow

10 Jan 2011, 9:52 PM
#123
supersnow avatar

supersnow

Zen Follower

Join Date:
Apr 2007
Location:
California, USA
Posts:
233
Plugin Contributions:
0

Re: Super Orders v3.0 Support Thread (for ZC v1.3.9)

Quote:
Originally Posted by supersnow [IMG]http://www.zen-cart.com/forum/images/zc2010/buttons/viewpost.gif[/IMG]
*Thanks for the great upgrade.

1.I am currently using COWOA and any orders that are COWOA orders I get this at the top of the superorder detail page:

Is this normal or should I be seeing something else?*

It's a minor error and I believe I fixed it in the next upgrade (I'm waiting for feedback on the PDF packingslip..
Great - look forward to the update

PayPal auto payments is already a part of the v3.0 code.. It will not go back and update any PayPal paid orders that were already in place before you installed Super Orders, but the code should capture any PayPal payments after Super Orders is installed.. If it's not working please let me know and I will take a look at that..
I understand that it will not go back but all new paypal orders are still coming through unpaid with balance due - I am using the Paypal express (with Express Checkout Shortcut Button turned off - i.e. pay with payapl only available on payment page).

Thanks
Supersnow

11 Jan 2011, 12:53 AM
#124
supersnow avatar

supersnow

Zen Follower

Join Date:
Apr 2007
Location:
California, USA
Posts:
233
Plugin Contributions:
0

Re: Super Orders v3.0 Support Thread (for ZC v1.3.9)

Sorry I have another question in regards to COWOA and super orders. I understand that you are doing an update with the bug fix but I was wondering how to incorporate the email function that COWOA has - this is the code from admin/orders.php:

//send emails

// BOF COWOA SEND ORDER_STATUS EMAIL
if (COWOA_ORDER_STATUS == 'true') {
    if ($check_status->fields['COWOA_order'] == 1)  {
  
            $message =
            EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n\n" .
            EMAIL_TEXT_INVOICE_URL . ' ' . zen_catalog_href_link(FILENAME_ORDER_STATUS, 'order_id=' . $oID, 'SSL') . "\n\n" .
            EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']) . "\n\n" .
      strip_tags($notify_comments) .
      EMAIL_TEXT_STATUS_UPDATED . sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ) .
      EMAIL_TEXT_STATUS_PLEASE_REPLY;

          $html_msg['EMAIL_CUSTOMERS_NAME']    = $check_status->fields['customers_name'];
          $html_msg['EMAIL_TEXT_ORDER_NUMBER'] = EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID;
          $html_msg['EMAIL_TEXT_INVOICE_URL']  = '<a href="' . zen_catalog_href_link(FILENAME_ORDER_STATUS, 'order_id=' . $oID, 'SSL') .'">'.str_replace(':','','Click here to check the status of your order:').'</a>';
          $html_msg['EMAIL_TEXT_DATE_ORDERED'] = EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']);
          $html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = nl2br($notify_comments);
          $html_msg['EMAIL_TEXT_STATUS_UPDATED'] = str_replace('\n','', EMAIL_TEXT_STATUS_UPDATED);
          $html_msg['EMAIL_TEXT_STATUS_LABEL'] = str_replace('\n','', sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ));
          $html_msg['EMAIL_TEXT_NEW_STATUS'] = $orders_status_array[$status];
          $html_msg['EMAIL_TEXT_STATUS_PLEASE_REPLY'] = str_replace('\n','', EMAIL_TEXT_STATUS_PLEASE_REPLY);

            zen_mail($check_status->fields['customers_name'], $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status');
            $customer_notified = '1';
          }
    } 
if (COWOA_ORDER_STATUS == 'false') {
      if ($check_status->fields['COWOA_order'] == 1)  {

          $htmlInvoiceURL='';
          $htmlInvoiceValue='';
          $message =
          EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n\n" .
          EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']) . "\n\n" .
          strip_tags($notify_comments) .
          EMAIL_TEXT_STATUS_UPDATED . sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ) .
          EMAIL_TEXT_STATUS_PLEASE_REPLY;
          $html_msg['EMAIL_CUSTOMERS_NAME']    = $check_status->fields['customers_name'];
          $html_msg['EMAIL_TEXT_ORDER_NUMBER'] = EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID;
          $html_msg['INTRO_URL_TEXT']        = '';
          $html_msg['INTRO_URL_VALUE']       = '';
          $html_msg['EMAIL_TEXT_DATE_ORDERED'] = EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']);
          $html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = nl2br($notify_comments);
          $html_msg['EMAIL_TEXT_STATUS_UPDATED'] = str_replace('\n','', EMAIL_TEXT_STATUS_UPDATED);
          $html_msg['EMAIL_TEXT_STATUS_LABEL'] = str_replace('\n','', sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ));
          $html_msg['EMAIL_TEXT_NEW_STATUS'] = $orders_status_array[$status];
          $html_msg['EMAIL_TEXT_STATUS_PLEASE_REPLY'] = str_replace('\n','', EMAIL_TEXT_STATUS_PLEASE_REPLY);

            zen_mail($check_status->fields['customers_name'], $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status');
            $customer_notified = '1';
          }    
    }
// EOF COWOA SEND ORDER_STATUS EMAIL    
    if ($check_status->fields['COWOA_order'] != 1)  {
            $message =
            EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n\n" .
            EMAIL_TEXT_INVOICE_URL . ' ' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n\n" .
            EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']) . "\n\n" .
            strip_tags($notify_comments) .
            EMAIL_TEXT_STATUS_UPDATED . sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ) .
            EMAIL_TEXT_STATUS_PLEASE_REPLY;

            $html_msg['EMAIL_CUSTOMERS_NAME']    = $check_status->fields['customers_name'];
            $html_msg['EMAIL_TEXT_ORDER_NUMBER'] = EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID;
            $html_msg['EMAIL_TEXT_INVOICE_URL']  = '<a href="' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') .'">'.str_replace(':','',EMAIL_TEXT_INVOICE_URL).'</a>';
            $html_msg['EMAIL_TEXT_DATE_ORDERED'] = EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']);
            $html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = nl2br($notify_comments);
            $html_msg['EMAIL_TEXT_STATUS_UPDATED'] = str_replace('\n','', EMAIL_TEXT_STATUS_UPDATED);
            $html_msg['EMAIL_TEXT_STATUS_LABEL'] = str_replace('\n','', sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ));
            $html_msg['EMAIL_TEXT_NEW_STATUS'] = $orders_status_array[$status];
            $html_msg['EMAIL_TEXT_STATUS_PLEASE_REPLY'] = str_replace('\n','', EMAIL_TEXT_STATUS_PLEASE_REPLY);

            zen_mail($check_status->fields['customers_name'], $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status');
            $customer_notified = '1';
    }
            //send extra emails
            if (SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_STATUS == '1' and SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO != '') {
              zen_mail('', SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO, SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_SUBJECT . ' ' . EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status_extra');
            }
          } elseif (isset($_POST['notify']) && ($_POST['notify'] == '-1')) {
            // hide comment
            $customer_notified = '-1';
          }

          $db->Execute("insert into " . TABLE_ORDERS_STATUS_HISTORY . "
                      (orders_id, orders_status_id, date_added, customer_notified, comments)
                      values ('" . (int)$oID . "',
                      '" . zen_db_input($status) . "',
                      now(),
                      '" . zen_db_input($customer_notified) . "',
                      '" . zen_db_input($comments)  . "')");
          $order_updated = true;
        }
```What would be the code so that I can incorporate into super orders in admin/includes/functions/extra_functions/common_order_functions.php??

As this code sends out a different email for COWOA accounts and normal accounts due to the fact that COWOA orders they do not have access to order history etc

Thanks
Supersnow

11 Jan 2011, 2:36 AM
#125
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Super Orders v3.0 Support Thread (for ZC v1.3.9)

And if you are happy with those features you absolutely should continue to use PDF Order Center.. PDF Order Center from what I've seen is a little different than Super Orders..

supersnow:

I currently use pdf Order center ty tracker and now put super order on our site. I have kept PDF order center as it doesn't interfer and I really like the pdf output etc.

Also I really love that when you update a order and send an email you can have the email subject reflect the new status i.e instead of

Order updated #5555

you get:

Your order #5555 has been sent

Plus you can customise this via the language file and add any additional order status and text etc.

As for your customizations I'm afraid I can't offer much in the way of suggestions.. I've only taken but a cursory look at the PDF Order Center, and I'm afraid I never really looked into how to incorporate any of it's features into Super Orders.

supersnow:

Before I put on super orders I was able to move over this ability to ty tracker and it worked great but I am having trouble with super orders with ty tracker integrated.

For it to work with ty tracker I copied over the definitions from the pdfoc.php lanuage file into the tracker.php lanage file

$pdfoc_subject[1] = 'Your order #%d has been received';
$pdfoc_subject[2] = 'Payment for your order #%d has been received';
$pdfoc_subject[3] = 'Your order #%d has been sent';
$pdfoc_subject[4] = 'Here is an update on your order #%d';
$pdfoc_subject[5] = 'Your order #%d has been cancelled';

> 
> Found:
> ```
$html_msg['EMAIL_TEXT_STATUS_PLEASE_REPLY'] = str_replace('\n','<br />', EMAIL_TEXT_STATUS_PLEASE_REPLY);
     


//For zencart 1.3.0 and earlier (uncomment next 3 lines)
//$html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = $notify_comments;
//$html_msg['EMAIL_TEXT_STATUS_UPDATED'] = str_replace('\n','', EMAIL_TEXT_STATUS_UPDATED);
//$html_msg['EMAIL_TEXT_STATUS_LABEL'] = '<strong>New status:</strong>';

            zen_mail($check_status->fields['customers_name'],  $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT .  ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg,  'order_status');
            
            $customer_notified = '1';
//send extra emails
            if (SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_STATUS == '1' and SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO != '') {
              zen_mail('', SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO,  SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_SUBJECT . ' ' .  EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM,  $html_msg, 'order_status_extra');
               
```Replaced with:
> ```
$html_msg['EMAIL_TEXT_STATUS_PLEASE_REPLY'] = str_replace('\n','<br />', EMAIL_TEXT_STATUS_PLEASE_REPLY);
      $email_text_subject =  sprintf($pdfoc_subject[(int)$status],  $oID);  // $pdfoc_subject[] is defined in  admin/includes/languages/<language>/tracker.php


//For zencart 1.3.0 and earlier (uncomment next 3 lines)
//$html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = $notify_comments;
//$html_msg['EMAIL_TEXT_STATUS_UPDATED'] = str_replace('\n','', EMAIL_TEXT_STATUS_UPDATED);
//$html_msg['EMAIL_TEXT_STATUS_LABEL'] = '<strong>New status:</strong>';

            //zen_mail($check_status->fields['customers_name'],  $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT .  ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg,  'order_status');
            zen_mail($check_status->fields['customers_name'],  $check_status->fields['customers_email_address'],   $email_text_subject, $message, STORE_NAME, EMAIL_FROM, $html_msg,  'order_status');

            $customer_notified = '1';
//send extra emails
            if (SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_STATUS == '1' and SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO != '') {
              //zen_mail('', SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO,  SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_SUBJECT . ' ' .  EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM,  $html_msg, 'order_status_extra');
               zen_mail('', SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO,  SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_SUBJECT . ' ' .   $email_text_subject, $message, STORE_NAME, EMAIL_FROM, $html_msg,  'order_status_extra');
```A similar edit to the  admin/funcations/extra_functions/common_order_functions.php is not  working. Do you have any ideas. One thing I did notice in the   common_orders_functions.php there isn't a line  ```
zen_mail($check_status->fields['customers_name'],   $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT  .  ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg,   'order_status');
``` but rather  ```
zen_mail($customer_info->fields['customers_name'],  $customer_info->fields['customers_email_address'], EMAIL_TEXT_SUBJECT  . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg,  'order_status');
```Am I in the right file? What am I  missing?

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

11 Jan 2011, 2:38 AM
#126
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Super Orders v3.0 Support Thread (for ZC v1.3.9)

I'm hoping JTheed will chime in as I am not familiar enough with COWOA to say..

supersnow:

Sorry I have another question in regards to COWOA and super orders. I understand that you are doing an update with the bug fix but I was wondering how to incorporate the email function that COWOA has - this is the code from admin/orders.php:

//send emails

// BOF COWOA SEND ORDER_STATUS EMAIL
if (COWOA_ORDER_STATUS == 'true') {
if ($check_status->fields['COWOA_order'] == 1) {

        $message =
        EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n\n" .
        EMAIL_TEXT_INVOICE_URL . ' ' . zen_catalog_href_link(FILENAME_ORDER_STATUS, 'order_id=' . $oID, 'SSL') . "\n\n" .
        EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']) . "\n\n" .
  strip_tags($notify_comments) .
  EMAIL_TEXT_STATUS_UPDATED . sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ) .
  EMAIL_TEXT_STATUS_PLEASE_REPLY;

      $html_msg['EMAIL_CUSTOMERS_NAME']    = $check_status->fields['customers_name'];
      $html_msg['EMAIL_TEXT_ORDER_NUMBER'] = EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID;
      $html_msg['EMAIL_TEXT_INVOICE_URL']  = '<a href="' . zen_catalog_href_link(FILENAME_ORDER_STATUS, 'order_id=' . $oID, 'SSL') .'">'.str_replace(':','','Click here to check the status of your order:').'</a>';
      $html_msg['EMAIL_TEXT_DATE_ORDERED'] = EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']);
      $html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = nl2br($notify_comments);
      $html_msg['EMAIL_TEXT_STATUS_UPDATED'] = str_replace('\n','', EMAIL_TEXT_STATUS_UPDATED);
      $html_msg['EMAIL_TEXT_STATUS_LABEL'] = str_replace('\n','', sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ));
      $html_msg['EMAIL_TEXT_NEW_STATUS'] = $orders_status_array[$status];
      $html_msg['EMAIL_TEXT_STATUS_PLEASE_REPLY'] = str_replace('\n','', EMAIL_TEXT_STATUS_PLEASE_REPLY);

        zen_mail($check_status->fields['customers_name'], $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status');
        $customer_notified = '1';
      }
} 

if (COWOA_ORDER_STATUS == 'false') {
if ($check_status->fields['COWOA_order'] == 1) {

      $htmlInvoiceURL='';
      $htmlInvoiceValue='';
      $message =
      EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n\n" .
      EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']) . "\n\n" .
      strip_tags($notify_comments) .
      EMAIL_TEXT_STATUS_UPDATED . sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ) .
      EMAIL_TEXT_STATUS_PLEASE_REPLY;
      $html_msg['EMAIL_CUSTOMERS_NAME']    = $check_status->fields['customers_name'];
      $html_msg['EMAIL_TEXT_ORDER_NUMBER'] = EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID;
      $html_msg['INTRO_URL_TEXT']        = '';
      $html_msg['INTRO_URL_VALUE']       = '';
      $html_msg['EMAIL_TEXT_DATE_ORDERED'] = EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']);
      $html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = nl2br($notify_comments);
      $html_msg['EMAIL_TEXT_STATUS_UPDATED'] = str_replace('\n','', EMAIL_TEXT_STATUS_UPDATED);
      $html_msg['EMAIL_TEXT_STATUS_LABEL'] = str_replace('\n','', sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ));
      $html_msg['EMAIL_TEXT_NEW_STATUS'] = $orders_status_array[$status];
      $html_msg['EMAIL_TEXT_STATUS_PLEASE_REPLY'] = str_replace('\n','', EMAIL_TEXT_STATUS_PLEASE_REPLY);

        zen_mail($check_status->fields['customers_name'], $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status');
        $customer_notified = '1';
      }    
}

// EOF COWOA SEND ORDER_STATUS EMAIL
if ($check_status->fields['COWOA_order'] != 1) {
$message =
EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n\n" .
EMAIL_TEXT_INVOICE_URL . ' ' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n\n" .
EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']) . "\n\n" .
strip_tags($notify_comments) .
EMAIL_TEXT_STATUS_UPDATED . sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ) .
EMAIL_TEXT_STATUS_PLEASE_REPLY;

        $html_msg['EMAIL_CUSTOMERS_NAME']    = $check_status->fields['customers_name'];
        $html_msg['EMAIL_TEXT_ORDER_NUMBER'] = EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID;
        $html_msg['EMAIL_TEXT_INVOICE_URL']  = '<a href="' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') .'">'.str_replace(':','',EMAIL_TEXT_INVOICE_URL).'</a>';
        $html_msg['EMAIL_TEXT_DATE_ORDERED'] = EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']);
        $html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = nl2br($notify_comments);
        $html_msg['EMAIL_TEXT_STATUS_UPDATED'] = str_replace('\n','', EMAIL_TEXT_STATUS_UPDATED);
        $html_msg['EMAIL_TEXT_STATUS_LABEL'] = str_replace('\n','', sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ));
        $html_msg['EMAIL_TEXT_NEW_STATUS'] = $orders_status_array[$status];
        $html_msg['EMAIL_TEXT_STATUS_PLEASE_REPLY'] = str_replace('\n','', EMAIL_TEXT_STATUS_PLEASE_REPLY);

        zen_mail($check_status->fields['customers_name'], $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status');
        $customer_notified = '1';
}
        //send extra emails
        if (SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_STATUS == '1' and SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO != '') {
          zen_mail('', SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO, SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_SUBJECT . ' ' . EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status_extra');
        }
      } elseif (isset($_POST['notify']) && ($_POST['notify'] == '-1')) {
        // hide comment
        $customer_notified = '-1';
      }

      $db->Execute("insert into " . TABLE_ORDERS_STATUS_HISTORY . "
                  (orders_id, orders_status_id, date_added, customer_notified, comments)
                  values ('" . (int)$oID . "',
                  '" . zen_db_input($status) . "',
                  now(),
                  '" . zen_db_input($customer_notified) . "',
                  '" . zen_db_input($comments)  . "')");
      $order_updated = true;
    }
> 
> As this code sends out a different email for COWOA accounts and normal accounts due to the fact that COWOA orders they do not have access to order history etc

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

11 Jan 2011, 2:39 AM
#127
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Super Orders v3.0 Support Thread (for ZC v1.3.9)

supersnow:

I understand that it will not go back but all new paypal orders are still coming through unpaid with balance due - I am using the Paypal express (with Express Checkout Shortcut Button turned off - i.e. pay with payapl only available on payment page)**.**So confirm for me.. are you saying in fact it (auto payments) doesn't work for orders paid via PayPal AFTER you installed Super Orders??? (sorry if this sounds dense, but I need confirmation one way or another and I'm not sure I have it)

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

11 Jan 2011, 2:01 PM
#128
musicfreer avatar

musicfreer

Zen Follower

Join Date:
Jul 2008
Posts:
155
Plugin Contributions:
0

Re: Super Orders v3.0 Support Thread (for ZC v1.3.9)

Hi,

I just have a fresh install of zencart 1.3.9h, with a new and clean database mysql 5.0 but the same problem still exist.

I have NOT installed any other mod. I just installed Super Order 3.0

However, when I uploaded all core folders and files, my admin page becomes blank. Log file shows a message:
[11-Jan-2011 06:57:27] PHP Parse error: syntax error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /home/content/l/o/c/xxx/html/xxx/xxx/includes/functions/extra_functions/lcsd_merged_packing_slips.php on line 35

Please help!!

11 Jan 2011, 2:45 PM
#129
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Super Orders v3.0 Support Thread (for ZC v1.3.9)

Okay so I found something that will help guide me through the merges needed.. Gimme a minute to incorporate them for you and I'll post the file here.. I thought this was included in the SO fileset.. (if it wasn't my bad! sorry..) I will make sure this is included in the next update.. (should be posting it this week)

PM me and I can give you instructions on getting the next release this week if you like..

supersnow:

Sorry I have another question in regards to COWOA and super orders. I understand that you are doing an update with the bug fix but I was wondering how to incorporate the email function that COWOA has - this is the code from admin/orders.php:

//send emails

// BOF COWOA SEND ORDER_STATUS EMAIL
if (COWOA_ORDER_STATUS == 'true') {
if ($check_status->fields['COWOA_order'] == 1) {

        $message =
        EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n\n" .
        EMAIL_TEXT_INVOICE_URL . ' ' . zen_catalog_href_link(FILENAME_ORDER_STATUS, 'order_id=' . $oID, 'SSL') . "\n\n" .
        EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']) . "\n\n" .
  strip_tags($notify_comments) .
  EMAIL_TEXT_STATUS_UPDATED . sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ) .
  EMAIL_TEXT_STATUS_PLEASE_REPLY;

      $html_msg['EMAIL_CUSTOMERS_NAME']    = $check_status->fields['customers_name'];
      $html_msg['EMAIL_TEXT_ORDER_NUMBER'] = EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID;
      $html_msg['EMAIL_TEXT_INVOICE_URL']  = '<a href="' . zen_catalog_href_link(FILENAME_ORDER_STATUS, 'order_id=' . $oID, 'SSL') .'">'.str_replace(':','','Click here to check the status of your order:').'</a>';
      $html_msg['EMAIL_TEXT_DATE_ORDERED'] = EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']);
      $html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = nl2br($notify_comments);
      $html_msg['EMAIL_TEXT_STATUS_UPDATED'] = str_replace('\n','', EMAIL_TEXT_STATUS_UPDATED);
      $html_msg['EMAIL_TEXT_STATUS_LABEL'] = str_replace('\n','', sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ));
      $html_msg['EMAIL_TEXT_NEW_STATUS'] = $orders_status_array[$status];
      $html_msg['EMAIL_TEXT_STATUS_PLEASE_REPLY'] = str_replace('\n','', EMAIL_TEXT_STATUS_PLEASE_REPLY);

        zen_mail($check_status->fields['customers_name'], $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status');
        $customer_notified = '1';
      }
} 

if (COWOA_ORDER_STATUS == 'false') {
if ($check_status->fields['COWOA_order'] == 1) {

      $htmlInvoiceURL='';
      $htmlInvoiceValue='';
      $message =
      EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n\n" .
      EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']) . "\n\n" .
      strip_tags($notify_comments) .
      EMAIL_TEXT_STATUS_UPDATED . sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ) .
      EMAIL_TEXT_STATUS_PLEASE_REPLY;
      $html_msg['EMAIL_CUSTOMERS_NAME']    = $check_status->fields['customers_name'];
      $html_msg['EMAIL_TEXT_ORDER_NUMBER'] = EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID;
      $html_msg['INTRO_URL_TEXT']        = '';
      $html_msg['INTRO_URL_VALUE']       = '';
      $html_msg['EMAIL_TEXT_DATE_ORDERED'] = EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']);
      $html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = nl2br($notify_comments);
      $html_msg['EMAIL_TEXT_STATUS_UPDATED'] = str_replace('\n','', EMAIL_TEXT_STATUS_UPDATED);
      $html_msg['EMAIL_TEXT_STATUS_LABEL'] = str_replace('\n','', sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ));
      $html_msg['EMAIL_TEXT_NEW_STATUS'] = $orders_status_array[$status];
      $html_msg['EMAIL_TEXT_STATUS_PLEASE_REPLY'] = str_replace('\n','', EMAIL_TEXT_STATUS_PLEASE_REPLY);

        zen_mail($check_status->fields['customers_name'], $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status');
        $customer_notified = '1';
      }    
}

// EOF COWOA SEND ORDER_STATUS EMAIL
if ($check_status->fields['COWOA_order'] != 1) {
$message =
EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n\n" .
EMAIL_TEXT_INVOICE_URL . ' ' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n\n" .
EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']) . "\n\n" .
strip_tags($notify_comments) .
EMAIL_TEXT_STATUS_UPDATED . sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ) .
EMAIL_TEXT_STATUS_PLEASE_REPLY;

        $html_msg['EMAIL_CUSTOMERS_NAME']    = $check_status->fields['customers_name'];
        $html_msg['EMAIL_TEXT_ORDER_NUMBER'] = EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID;
        $html_msg['EMAIL_TEXT_INVOICE_URL']  = '<a href="' . zen_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') .'">'.str_replace(':','',EMAIL_TEXT_INVOICE_URL).'</a>';
        $html_msg['EMAIL_TEXT_DATE_ORDERED'] = EMAIL_TEXT_DATE_ORDERED . ' ' . zen_date_long($check_status->fields['date_purchased']);
        $html_msg['EMAIL_TEXT_STATUS_COMMENTS'] = nl2br($notify_comments);
        $html_msg['EMAIL_TEXT_STATUS_UPDATED'] = str_replace('\n','', EMAIL_TEXT_STATUS_UPDATED);
        $html_msg['EMAIL_TEXT_STATUS_LABEL'] = str_replace('\n','', sprintf(EMAIL_TEXT_STATUS_LABEL, $orders_status_array[$status] ));
        $html_msg['EMAIL_TEXT_NEW_STATUS'] = $orders_status_array[$status];
        $html_msg['EMAIL_TEXT_STATUS_PLEASE_REPLY'] = str_replace('\n','', EMAIL_TEXT_STATUS_PLEASE_REPLY);

        zen_mail($check_status->fields['customers_name'], $check_status->fields['customers_email_address'], EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status');
        $customer_notified = '1';
}
        //send extra emails
        if (SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_STATUS == '1' and SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO != '') {
          zen_mail('', SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO, SEND_EXTRA_ORDERS_STATUS_ADMIN_EMAILS_TO_SUBJECT . ' ' . EMAIL_TEXT_SUBJECT . ' #' . $oID, $message, STORE_NAME, EMAIL_FROM, $html_msg, 'order_status_extra');
        }
      } elseif (isset($_POST['notify']) && ($_POST['notify'] == '-1')) {
        // hide comment
        $customer_notified = '-1';
      }

      $db->Execute("insert into " . TABLE_ORDERS_STATUS_HISTORY . "
                  (orders_id, orders_status_id, date_added, customer_notified, comments)
                  values ('" . (int)$oID . "',
                  '" . zen_db_input($status) . "',
                  now(),
                  '" . zen_db_input($customer_notified) . "',
                  '" . zen_db_input($comments)  . "')");
      $order_updated = true;
    }
>  
> As this code sends out a different email for COWOA accounts and normal accounts due to the fact that COWOA orders they do not have access to order history etc

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

11 Jan 2011, 2:47 PM
#130
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Super Orders v3.0 Support Thread (for ZC v1.3.9)

I can't replicate this error at all.. Did you double check that your install was correct and that all the files are in the right place??

Also try re-downloading the Super Orders files again.. It's possible that there was some file corruption in your download or even when the files were uploaded..

musicfreer:

Hi,

I just have a fresh install of zencart 1.3.9h, with a new and clean database mysql 5.0 but the same problem still exist.

I have NOT installed any other mod. I just installed Super Order 3.0

However, when I uploaded all core folders and files, my admin page becomes blank. Log file shows a message:
[11-Jan-2011 06:57:27] PHP Parse error: syntax error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /home/content/l/o/c/xxx/html/xxx/xxx/includes/functions/extra_functions/lcsd_merged_packing_slips.php on line 35

Please help!!

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

11 Jan 2011, 3:02 PM
#131
musicfreer avatar

musicfreer

Zen Follower

Join Date:
Jul 2008
Posts:
155
Plugin Contributions:
0

Re: Super Orders v3.0 Support Thread (for ZC v1.3.9)

DivaVocals:

I can't replicate this error at all.. Did you double check that your install was correct and that all the files are in the right place??

Also try re-downloading the Super Orders files again.. It's possible that there was some file corruption in your download or even when the files were uploaded..

I am quite sure that the zencart installation is correct, I have installed other mods in my previous installation without problem. I also tried to redownload and reupload the SO3 files again. All I need is the 2 core folders rite? and sure I have rename the admin folder. Anything that I would miss?

Will there be any conflict with other database in mysql? I have an orignal database which is live, and 2-3 database created these 2 days for testing.

11 Jan 2011, 3:03 PM
#132
musicfreer avatar

musicfreer

Zen Follower

Join Date:
Jul 2008
Posts:
155
Plugin Contributions:
0

Re: Super Orders v3.0 Support Thread (for ZC v1.3.9)

1 more point, even the admin/login.php returns blank page

11 Jan 2011, 3:26 PM
#133
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Super Orders v3.0 Support Thread (for ZC v1.3.9)

There is NOTHING in the PDF packingslip file that should cause the error you are describing...

**UNLESS **

You are not running PHP 5..

:huh:Doh!!! I was tired and busy as heck on Saturday when you first posted.. Don't know why I didn't PAY ATTENTION.. :laugh: I sorta just generally assumed that mosts hosts no longer supported PHP 4.. My bad..

In the testing environments of ALL of the beta testers and developers of this mod we were all running SQL 5.2 or better and PHP 5.2.x or better.

This mod was specifically tested to make sure that it was not only PHP 5.3 compatible, but backwards compatible for those hosts still running PHP 5.2.x. If your hosting environment is running a version of PHP lower than 5.2.x than THAT would be the reason you are getting this error.

Your server is probably currently running version 4.x of php. Do you have the ability to upgrade? Who is your hosting through? Most of the major hosting providers (Godaddy, ipower, gator, etc) have some form of 5 running. Sometimes you can switch between version 4 and 5.

musicfreer:

I am quite sure that the zencart installation is correct, I have installed other mods in my previous installation without problem. I also tried to redownload and reupload the SO3 files again. All I need is the 2 core folders rite? and sure I have rename the admin folder. Anything that I would miss?

Will there be any conflict with other database in mysql? I have an orignal database which is live, and 2-3 database created these 2 days for testing.

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

11 Jan 2011, 3:37 PM
#134
musicfreer avatar

musicfreer

Zen Follower

Join Date:
Jul 2008
Posts:
155
Plugin Contributions:
0

Re: Super Orders v3.0 Support Thread (for ZC v1.3.9)

DivaVocals:

There is NOTHING in the PDF packingslip file that should cause the error you are describing...

**UNLESS **

You are not running PHP 5..

:huh:Doh!!! I was tired and busy as heck on Saturday when you first posted.. Don't know why I didn't PAY ATTENTION.. :laugh: I sorta just generally assumed that mosts hosts no longer supported PHP 4.. My bad..

In the testing environments of ALL of the beta testers and developers of this mod we were all running SQL 5.2 or better and PHP 5.2.x or better.

This mod was specifically tested to make sure that it was not only PHP 5.3 compatible, but backwards compatible for those hosts still running PHP 5.2.x. If your hosting environment is running a version of PHP lower than 5.2.x than THAT would be the reason you are getting this error.

Your server is probably currently running version 4.x of php. Do you have the ability to upgrade? Who is your hosting through? Most of the major hosting providers (Godaddy, ipower, gator, etc) have some form of 5 running. Sometimes you can switch between version 4 and 5.

I appreciate your help a lot, thanks!

I am using godaddy hosting. Any idea where I can check and change the php version? I am very green about it.

thanks!

11 Jan 2011, 3:42 PM
#135
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Super Orders v3.0 Support Thread (for ZC v1.3.9)

Ahhh GoDaddy.. Dunno why they still allow PHP 4 on their servers.. But that is why they aren't a favorite hosting company 'round these parts..

Contact GoDaddy.. They'll be able to walk you through it.. I'm afraid I don't host with them so I don't know what their upgrade procedure is.. PLUS.. a detailed discussion on how to update your hosting environment is off topic for this support thread..:smile: (I hope you understand..)

Once your hosting envoronment is updated to PHP 5, you should find that this error goes away.. :smile:

musicfreer:

I appreciate your help a lot, thanks!

I am using godaddy hosting. Any idea where I can check and change the php version? I am very green about it.

thanks!

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

11 Jan 2011, 3:45 PM
#136
musicfreer avatar

musicfreer

Zen Follower

Join Date:
Jul 2008
Posts:
155
Plugin Contributions:
0

Re: Super Orders v3.0 Support Thread (for ZC v1.3.9)

Thanks for your reply.

I just log in godaddy and checked that the php version is PHP 4.x

I knew it maybe off topic, but would you let me know, if I upgrade it to PHP5, will it probably matter to other mods? Besdies, does the PHP version has anything related to the database?

I am going to contact godaddy for upgrading the PHP

Thanks!

11 Jan 2011, 3:53 PM
#137
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Super Orders v3.0 Support Thread (for ZC v1.3.9)

musicfreer:

Thanks for your reply.

I just log in godaddy and checked that the php version is PHP 4.x
You're welcome.. Upgrade to PHP5 and Super Orders will work just fine..

musicfreer:

I knew it maybe off topic, but would you let me know, if I upgrade it to PHP5, will it probably matter to other mods? Besdies, does the PHP version has anything related to the database?
Dunno:wacko:.. I will be happy to discuss how a PHP5 upgrade will affect Super Orders (though you have already seen that 1st hand). However, a full blown discussion on how PHP5 will affect your other mods is off-topic and is really a subject for the support threads for those other mods you are running..

OR

you can create a seperate thread on JUST that topic with details of the mods you have questions about.

Contact GoDaddy.. They are the best folks to help you upgrade..

In the meantime, I will be updating the Super Orders documentation for the next release to to include information on which version of PHP and mySQL are supported..

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

11 Jan 2011, 4:42 PM
#138
musicfreer avatar

musicfreer

Zen Follower

Join Date:
Jul 2008
Posts:
155
Plugin Contributions:
0

Re: Super Orders v3.0 Support Thread (for ZC v1.3.9)

DivaVocals:

You're welcome.. Upgrade to PHP5 and Super Orders will work just fine..

Dunno:wacko:.. I will be happy to discuss how a PHP5 upgrade will affect Super Orders (though you have already seen that 1st hand). However, a full blown discussion on how PHP5 will affect your other mods is off-topic and is really a subject for the support threads for those other mods you are running..

OR

you can create a seperate thread on JUST that topic with details of the mods you have questions about.

Contact GoDaddy.. They are the best folks to help you upgrade..

In the meantime, I will be updating the Super Orders documentation for the next release to to include information on which version of PHP and mySQL are supported..

I have upgraded to PHP5.x and the admin page is working normally now! great thanks!

however, when I run super_orders_install_v30.sql, there is an error message

1060 Duplicate column name 'split_from_order'
in:
[ALTER TABLE orders ADD split_from_order INT DEFAULT '0' NOT NULL, ADD is_parent TINYINT (1) DEFAULT '1' NOT NULL;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

It maybe due to I have tried installing SO2.0 for testing before. But I am sure I have already run uninstall_super_orders_prior_versions.sql, I also run super_orders_uninstall_v30.sql

but there is still error message. Thanks in advance for your time

11 Jan 2011, 4:53 PM
#139
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Super Orders v3.0 Support Thread (for ZC v1.3.9)

You have three options:1. Re-Run the uninstall SQL again (please note any errors you receive) and then re-run the install script again..
2. Run the install script again and skip the code that is causing errors
3. Using your database admin tool (most hosts use phpMyAdmin) go in and reverse all the changes made to the database to support Super Orders and re-run the install script
(sorry I cannot provide detailed instructions on how to use phpMyAdmin - if you are not familiar with working directly with the database, you should get someone who does to help you with this or you can seek a professional and pay them to do this work for you)Now that said, this is only a test store, and we could spend A LOT of time figuring out how to fix this error (it is exactly as it reads.. the column already exists - proably a result of your previous install efforts) and why you can't get the install or uninstall scripts to work, but I think for a test store this is a waste of your time.. TRULY what i sugest is that you rolll this entire test store back to a vanilla Zen Cart install. Start over with your Super Orders install and then you can move forward (finally).

musicfreer:

I have upgraded to PHP5.x and the admin page is working normally now! great thanks!

however, when I run super_orders_install_v30.sql, there is an error message

1060 Duplicate column name 'split_from_order'
in:
[ALTER TABLE orders ADD split_from_order INT DEFAULT '0' NOT NULL, ADD is_parent TINYINT (1) DEFAULT '1' NOT NULL;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

It maybe due to I have tried installing SO2.0 for testing before. But I am sure I have already run uninstall_super_orders_prior_versions.sql, I also run super_orders_uninstall_v30.sql

but there is still error message. Thanks in advance for your time

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

11 Jan 2011, 4:57 PM
#140
musicfreer avatar

musicfreer

Zen Follower

Join Date:
Jul 2008
Posts:
155
Plugin Contributions:
0

Re: Super Orders v3.0 Support Thread (for ZC v1.3.9)

DivaVocals:

You have three options:1. >

  1. Re-Run the uninstall SQL again (please note any errors you receive) and then re-run the install script again..
  1. Run the install script again and skip the code that is causing errors
  1. Using your database admin tool (most hosts use phpMyAdmin) go in and reverse all the changes made to the database to support Super Orders and re-run the install script

(sorry I cannot provide detailed instructions on how to use phpMyAdmin - if you are not familiar with working directly with the database, you should get someone who does to help you with this or you can seek a professional and pay them to do this work for you)
Now that said, this is only a test store, and we could spend A LOT of time figuring out how to fix this error (it is exactly as it reads.. the column already exists - proably a result of your previous install efforts) and why you can't get the install or uninstall scripts to work, but I think for a test store this is a waste of your time.. TRULY what i sugest is that you rolll this entire test store back to a vanilla Zen Cart install. Start over with your Super Orders install and then you can move forward (finally).

That's right, I will choose to have a clean install again! Thank you very much for your time! You have been very helpful!