Zen Cart Logo
Forums / Addon Admin Tools / Super Orders v4.0 Support Thread for ZC v1.5.x

Super Orders v4.0 Support Thread for ZC v1.5.x

Sticky

Views: 172,102

Results 361 to 380 of 816
12 Jun 2014, 7:06 PM
#361
divavocals avatar

divavocals

Totally Zenned

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

Super Orders v4.0 Support Thread for ZC v1.5.x

Carbonless:

Diva

Been racking my brain trying to figure this one out. Just before I installed super orders, I backed up the database and file structure. If I roll it back, everything works as it suppose to (minus having the SO mod installed.) I have one other mad installed, Master Password.

I thought if anyone had experienced this same issue and it was a known fix, it would save me from having to roll back and reinstall...

Thank you for attention to this post!
Wish I had an answer, but since Super Orders doesn't touch the file that is coughing up the error (includes/classes/shopping_cart.php), it's difficult for me to offer any insight..

8 Jul 2014, 1:05 AM
#362
retched avatar

retched

Totally Zenned

Join Date:
Jun 2007
Location:
Bronx, New York, United States
Posts:
944
Plugin Contributions:
3

Re: Super Orders v4.0 Support Thread for ZC v1.5.x

I'm using:
PHP Version 5.4.16
ZenCart Version 1.5.3
Super Orders Version 4.0.9

So after I performed the upgrades to ZenCart 1.5.3 and later upgraded to PHP 5.4.16, I started to get the following "warning" notices in my logs folder:

[07-Jul-2014 20:59:38 America/New_York] PHP Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\Program Files (x86)\wampserver\www\zencart\admin\orders.php on line 1218

I tracked the down the code to the following lines and noticed that no currency value was being returned in the Amount Applied and Balance Due values:

<!-- BOF added to get currency type and value for totals -->
                <?php $dbc="select currency, currency_value from " . TABLE_ORDERS . " where orders_id ='" . $_GET['oID'] . "'";
                $result = mysql_query($dbc);
                $row = mysql_fetch_array ($result, MYSQL_NUM);
                $cu = $row[0];
                $cv = $row[1];
                ?>
<!-- EOF added to get currency type and value for totals -->

I know it's not a ground breaking error, but I absolutely despise Warning messages in my log folder. So I made an edit to the file as follows:

<!-- BOF added to get currency type and value for totals -->
                <?php
                 $dbc= $db->execute("select currency, currency_value from " . TABLE_ORDERS . " where orders_id ='" . $_GET['oID'] . "'");
                $cu = $dbc->fields['currency'];
                $cv = $dbc->fields['currency_value'];
                ?>
<!-- EOF added to get currency type and value for totals -->

I hope this helps anyone.

8 Jul 2014, 4:23 PM
#363
sweatingitout avatar

sweatingitout

New Zenner

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

Re: Super Orders v4.0 Support Thread for ZC v1.5.x

I am using Zen vs. 1.5.1 and the very latest super orders plugin.
PHP Version: 5.2.17 (Zend: 2.2.0) PHP Memory Limit: 18M
Database: MySQL 5.5.32-log
URL: bahamaschequeservices.com/orders

Everything is working great but now customers can't view their past invoices by clicking the View button in the "my account" page.
They get the message "WARNING: An Error occurred, please refresh the page and try again."
Refreshing doesn't work.

It was a new install of the plugin and very little about the shopping cart is customized.

I have found an error in the logs:

[08-Jul-2014 10:48:53] PHP Fatal error:  1054:Unknown column 'COWOA_order' in 'field list' :: select customers_name, customers_email_address, orders_status,
                                      date_purchased, COWOA_order from orders
                                      where orders_id = '10907' in /hermes/waloraweb033/b41/as.bahamaschequeservice/orders/includes/classes/db/mysql/query_factory.php on line 120

which is baffling because we never installed the plugin COWOA.

Thanks for any help to resolve this issue.

Thanks for any help on this.

8 Jul 2014, 4:47 PM
#364
divavocals avatar

divavocals

Totally Zenned

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

Re: Super Orders v4.0 Support Thread for ZC v1.5.x

SweatingItOut:

I am using Zen vs. 1.5.1 and the very latest super orders plugin.
PHP Version: 5.2.17 (Zend: 2.2.0) PHP Memory Limit: 18M
Database: MySQL 5.5.32-log
URL: bahamaschequeservices.com/orders

Everything is working great but now customers can't view their past invoices by clicking the View button in the "my account" page.
They get the message "WARNING: An Error occurred, please refresh the page and try again."
Refreshing doesn't work.

It was a new install of the plugin and very little about the shopping cart is customized.

I have found an error in the logs:

[08-Jul-2014 10:48:53] PHP Fatal error: 1054:Unknown column 'COWOA_order' in 'field list' :: select customers_name, customers_email_address, orders_status,
date_purchased, COWOA_order from orders
where orders_id = '10907' in /hermes/waloraweb033/b41/as.bahamaschequeservice/orders/includes/classes/db/mysql/query_factory.php on line 120

> 
> which is baffling because we never installed the plugin COWOA.
> 
> Thanks for any help to resolve this issue.
> 
> Thanks for any help on this.
Whoever installed this for you installed the files which are meant for stores who have Super Orders and COWOA installed.. (they are CLEARLY marked in the fileset..)
11 Jul 2014, 5:41 PM
#365
jeking avatar

jeking

Totally Zenned

Join Date:
Oct 2005
Location:
Chicago, IL USA
Posts:
1,592
Plugin Contributions:
0

Re: Super Orders v4.0 Support Thread for ZC v1.5.x

Is there an update of this for Zen 1.5.3? If not, I'd be willing to help create and/or test one. I need it for myself anyway.

13 Jul 2014, 1:54 PM
#366
divavocals avatar

divavocals

Totally Zenned

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

Re: Super Orders v4.0 Support Thread for ZC v1.5.x

jeking:

Is there an update of this for Zen 1.5.3? If not, I'd be willing to help create and/or test one. I need it for myself anyway.

There isn't.. I'd started working on it before I left for vacation.. won't be back for a week.. if you want to tackle it feel free..

14 Jul 2014, 11:13 AM
#367
digitalshadow avatar

digitalshadow

Totally Zenned

Join Date:
Mar 2009
Posts:
616
Plugin Contributions:
0

Re: Super Orders v4.0 Support Thread for ZC v1.5.x

batch status update and batch form print are not working in 1.5.3, check all is not working, if you manually edit the url it will work, but the "check all" button does not work.

in batch form print, if you manually select, it does not pass the batch through to print preview.

16 Jul 2014, 4:38 PM
#368
digitalshadow avatar

digitalshadow

Totally Zenned

Join Date:
Mar 2009
Posts:
616
Plugin Contributions:
0

Re: Super Orders v4.0 Support Thread for ZC v1.5.x

the button creates this link....

/super_batch_forms.php?status=2&ot_sign=1&checked=0'

which doesn't work, but if i type this url into the browser

/super_batch_forms.php?start_date=&end_date=&status=2&products=&customers=&countries=&payments=&ot_sign=1&order_total=&search=&oid_range_first=&oid_range_last=&checked=1

it works, exactly the same is true for batch status update

18 Jul 2014, 11:53 PM
#369
retched avatar

retched

Totally Zenned

Join Date:
Jun 2007
Location:
Bronx, New York, United States
Posts:
944
Plugin Contributions:
3

Re: Super Orders v4.0 Support Thread for ZC v1.5.x

DigitalShadow:

batch status update and batch form print are not working in 1.5.3, check all is not working, if you manually edit the url it will work, but the "check all" button does not work.

in batch form print, if you manually select, it does not pass the batch through to print preview.

I made the following changes on a ZenCart 1.5.3 installation running PHP 5.3.27. (In this change, you're moving away from a page refresh to using JavaScript.) You can use this as a temporary fix until DivaVocals or someone releases a full update.

=== OPEN /admin/super_batch_forms.php ===

=== FIND AT (OR NEAR) LINE 117 ===

<?php /* END addition */ ?> 

=== BEFORE, ADD ===

    function checkByParent(aId) {
        var collection = document.getElementById(aId).getElementsByTagName('INPUT');
        for (var x=0; x<collection.length; x++) {
            if (collection[x].type.toUpperCase()=='CHECKBOX') {
                if (collection[x].checked == true)


                {
                    collection[x].checked = false;
                }
                else { collection[x].checked = true; }
            }
        }
    }

=== FIND AT (OR NEAR) LINE 412 ===

              if ($checked) {
                echo '<INPUT class="normal_button button" TYPE="BUTTON" VALUE="' . BUTTON_UNCHECK_ALL . '" ONCLICK="window.location.href=\'' . zen_href_link(FILENAME_SUPER_BATCH_FORMS, zen_get_all_get_params(array('checked')) . 'checked=0', 'NONSSL') . '\'">';
              } else {
                echo '<INPUT class="normal_button button" TYPE="BUTTON" VALUE="' . BUTTON_CHECK_ALL . '" ONCLICK="window.location.href=\'' . zen_href_link(FILENAME_SUPER_BATCH_FORMS, zen_get_all_get_params(array('checked')) . 'checked=1', 'NONSSL') . '\'">';
              }

=== REPLACE WITH ===

         echo '<INPUT class="normal_button button" TYPE="BUTTON" VALUE="' . BUTTON_CHECK_ALL . '" ONCLICK="checkByParent(\'ordersList\');">';

=== FIND AT (OR NEAR) LINE 428 ===
(Careful this may appear multiple times....)

                  <td valign="top">

        <table border="0" width="100%" cellspacing="0" cellpadding="2">
                      <tr class="dataTableHeadingRow">
                    <td class="dataTableHeadingContent" align="left" colspan="2">  <?php echo TABLE_HEADING_ORDERS_ID; ?></td>
                        <td class="dataTableHeadingContent" align="left"><?php echo TABLE_HEADING_CUSTOMERS; ?></td>
                        <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td>
                        <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_DATE_PURCHASED; ?></td>
                        <td class="dataTableHeadingContent" align="left"><?php echo TABLE_HEADING_PAYMENT_METHOD; ?></td>
                    <td class="dataTableHeadingContent" align="left" colspan="2"><?php echo TABLE_HEADING_ORDER_STATUS; ?></td>
                      </tr>
<?php
    while (!$orders->EOF) {
?> 
        <tr class="dataTableRow" onMouseOver="rowOverEffect(this);this.style.cursor='default'" onMouseOut="rowOutEffect(this)">
                        <td class="dataTableContent" align="left"><?php 
            echo zen_draw_checkbox_field('batch_order_numbers[' . $orders->fields['orders_id'] . ']', 'yes', $checked);
                  echo $orders->fields['orders_id'];
                ?></td>
                        <td class="dataTableContent" align="right"><?php echo '[' . $orders->fields['customers_id'] . ']'; ?></td>
                        <td class="dataTableContent" align="left"><?php echo $orders->fields['customers_name']; ?></td>
                        <td class="dataTableContent" align="right"><?php echo $currencies->format($orders->fields['order_total']); ?></td>
                        <td class="dataTableContent" align="center"><?php echo zen_datetime_short($orders->fields['date_purchased']); ?></td>
                        <td class="dataTableContent" align="left"><?php echo $orders->fields['payment_method']; ?></td>
                        <td class="dataTableContent" align="left"><?php echo $orders->fields['orders_status_name']; ?></td>
                        
                        <td class="dataTableContent" align="right"><?php echo '<a href="' . zen_href_link(FILENAME_ORDERS, 'oID=' . $orders->fields['orders_id'] . '&action=edit', 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_details.gif', ICON_ORDER_DETAILS) . '</a>&nbsp'; ?></td>
                      </tr>
 
<?php
      $orders->MoveNext();
    }
  }  // END if ($orders->RecordCount() > 0)
?>
                </form>
                  </table></td>

=== WITHIN THIS BLOCK, FIND ===

                  <td valign="top">

=== AFTER, ADD ===

<div id="ordersList">

=== WITHIN THIS BLOCK, FIND ===

</form></table></td>

=== REPLACE WITH ===

</form></table></div></td>

=== SAVE CHANGES ===

19 Jul 2014, 12:00 AM
#370
retched avatar

retched

Totally Zenned

Join Date:
Jun 2007
Location:
Bronx, New York, United States
Posts:
944
Plugin Contributions:
3

Re: Super Orders v4.0 Support Thread for ZC v1.5.x

Here are the changes for Super Batch Status (Update):

=== OPEN /admin/super_batch_status.php ===

=== FIND AT (OR NEAR) LINE 104 ===

// -->

=== BEFORE, ADD ===

    function checkByParent(aId) {
        var collection = document.getElementById(aId).getElementsByTagName('INPUT');
        for (var x=0; x<collection.length; x++) {
            if (collection[x].type.toUpperCase()=='CHECKBOX') {
                if (collection[x].checked == true)


                {
                    collection[x].checked = false;
                }
                else { collection[x].checked = true; }
            }
        }
    }

=== FIND AT (OR NEAR) LINE 333 ===

              if ($checked) {
                echo '<INPUT class="normal_button button" TYPE="BUTTON" VALUE="' . BUTTON_UNCHECK_ALL . '" ONCLICK="window.location.href=\'' . zen_href_link(FILENAME_SUPER_BATCH_STATUS, zen_get_all_get_params(array('checked')) . 'checked=0', 'NONSSL') . '\'">';
              } else {
                echo '<INPUT class="normal_button button" TYPE="BUTTON" VALUE="' . BUTTON_CHECK_ALL . '" ONCLICK="window.location.href=\'' . zen_href_link(FILENAME_SUPER_BATCH_STATUS, zen_get_all_get_params(array('checked')) . 'checked=1', 'NONSSL') . '\'">';
              }

=== REPLACE WITH ===

           echo '<INPUT class="normal_button button" TYPE="BUTTON" VALUE="' . BUTTON_CHECK_ALL . '" ONCLICK="checkByParent(\'ordersList\');">';

=== FIND AT (OR NEAR) LINE 344 ===

        <td><table border="0" cellpadding="0" cellspacing="0" width="100%">

=== REPLACE WITH ===

        <td><div id="ordersList"><table border="0" cellpadding="0" cellspacing="0" width="100%">

=== FIND AT (OR NEAR) LINE 384 ===

            </table></td>

=== REPLACE WITH ===

            </table></div></td>

=== SAVE CHANGES ===

I'm also attaching both files as a Zip File. You should only have to upload these and overwrite them in your /admin/ directory.

19 Jul 2014, 3:03 PM
#371
divavocals avatar

divavocals

Totally Zenned

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

Re: Super Orders v4.0 Support Thread for ZC v1.5.x

When I return, I'll finish creating the Super orders Github repo.. Would love if you could fork it and submit your changes to the repo..

19 Jul 2014, 4:34 PM
#372
retched avatar

retched

Totally Zenned

Join Date:
Jun 2007
Location:
Bronx, New York, United States
Posts:
944
Plugin Contributions:
3

Re: Super Orders v4.0 Support Thread for ZC v1.5.x

When it's ready, please post it up here and I'll fork it and make my change.

19 Jul 2014, 5:10 PM
#373
divavocals avatar

divavocals

Totally Zenned

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

Re: Super Orders v4.0 Support Thread for ZC v1.5.x

retched:

When it's ready, please post it up here and I'll fork it and make my change.

Awesome!

21 Jul 2014, 1:13 AM
#374
divavocals avatar

divavocals

Totally Zenned

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

Re: Super Orders v4.0 Support Thread for ZC v1.5.x

retched:

When it's ready, please post it up here and I'll fork it and make my change.

Super Orders Github repo: https://github.com/DivaVocals/zen_SuperOrders

21 Jul 2014, 10:23 PM
#375
digitalshadow avatar

digitalshadow

Totally Zenned

Join Date:
Mar 2009
Posts:
616
Plugin Contributions:
0

Re: Super Orders v4.0 Support Thread for ZC v1.5.x

Is it just me or is batch form print still not showing the multiple frames for printing multiple orders at once?

21 Jul 2014, 11:05 PM
#376
retched avatar

retched

Totally Zenned

Join Date:
Jun 2007
Location:
Bronx, New York, United States
Posts:
944
Plugin Contributions:
3

Re: Super Orders v4.0 Support Thread for ZC v1.5.x

DigitalShadow:

Is it just me or is batch form print still not showing the multiple frames for printing multiple orders at once?

I'm not seeing any problems on my side with my changes and I'm running 1.5.3. All checkboxes and the three buttons above the order listing work for me.

21 Jul 2014, 11:10 PM
#378
divavocals avatar

divavocals

Totally Zenned

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

Re: Super Orders v4.0 Support Thread for ZC v1.5.x

retched:

Forked and pull request made. Cool!!!

retched:

I'm not too sure about one file. You'll see that in the comments. https://github.com/DivaVocals/zen_SuperOrders/pull/1

I'll take a look, test and pray..:laugh:

22 Jul 2014, 1:39 AM
#379
retched avatar

retched

Totally Zenned

Join Date:
Jun 2007
Location:
Bronx, New York, United States
Posts:
944
Plugin Contributions:
3

Re: Super Orders v4.0 Support Thread for ZC v1.5.x

DivaVocals:

Cool!!!

I'll take a look, test and pray..:laugh:

There was about one or two more pages update to that fork, just to warn.

22 Jul 2014, 7:00 AM
#380
divavocals avatar

divavocals

Totally Zenned

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

Re: Super Orders v4.0 Support Thread for ZC v1.5.x

retched:

There was about one or two more pages update to that fork, just to warn.

No worries.. Gonna take a look tomorrow.. (TIRED AS HELL right now!!)