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

Blank screen = Errors

Zen Cart captures errors in error log files which are stored in the "cache" folder. Need to know what the error logs say before anyone can offer any kind of help or answer your questions..

Cheepnis:

I installed both order edit and super orders and then uninstalled Super Orders and now all I get in the admin is a blank screen (store side works fine).

I deleted all new SO new files and restored backups of edited core files. I ran the uninstall sql which broke at the point of "comment out the fax info...". I reran the sql at the point past that error, leaving the fax define in place.

This is very troubling because without any error messages, I can't troubleshoot. I have no idea why restoring my files to a pre-superorder/edit order configuration shouldn't fix the problem. Any ideas or thoughts? When I try to log into the admin from a fresh browser window and a cleared cache, it's still the same whit screen. Not even asking for my zencart admin id and password.

I'm stumped.

Nevermind - it turns out that I left a couple files in place that generated fatal redeclaration errors. I forgot to look in my error log files before posting here - I'm still rather new to this.. mea culpa.

Cheepnis:

Nevermind - it turns out that I left a couple files in place that generated fatal redeclaration errors. I forgot to look in my error log files before posting here - I'm still rather new to this.. mea culpa.Which is kinda what I suspected would be the issue.. Thanks for coming back and letting us know what the problem was..

I've been happily using Super Orders 3.0 on 1.3.9h for a month now - I installed it in order to use the batch form printing function.

I just tried to view cash reports, and now realize that it is not working at all and hasn't been for a month. Each order displays "No Order Payment Data Available" and this is for both Paypal orders and Authorize.net.

Any idea where I went wrong? Everything else seems to be working ok. I do have my PDT token installed.

Not sure if this applies to authorize net but this was posted regarding PayPal

That said, if what you are ACTUALLY referring to is auto-generation of Super Order payment records for orders paid via PayPal (when the PayPal payment status -- not the order status -- is "Completed"), then YES this will be addressed in the next release.. In the meantime, you can simply add a manual payment, and the message will be replaced.

While waiting for the next release I just make manual payments to have accurate tracking.

--Rob--

Thanks, Rob. I thought I did something wrong with the install.

This is why I always suggest searching the support threads before posting questions.. Often the answers are already here..

I searched for over an hour and read every post in this topic! I saw the thing about Paypal but not the authorize.net part. Doesn't mean I understand it all, though. I appreciate those that take the time to respond.

DivaVocals, can we have an update on how the testing is going, with the up and coming new release of Super Orders?

Joseph_Greely:

DivaVocals, can we have an update on how the testing is going, with the up and coming new release of Super Orders?
Sure..

See: http://www.zen-cart.com/forum/showpost.php?p=1026350&postcount=461

Treece:

I searched for over an hour and read every post in this topic! I saw the thing about Paypal but not the authorize.net part. Doesn't mean I understand it all, though. I appreciate those that take the time to respond.You shouldn't have to manually enter Super Orders payments for orders paid via Authorize.net..

Hi - I have Zencart 1.3.9h, plus Purchase Orders 6 and Ty Package tracker as well as several other mods.

This is the error I'm getting after trying to put a comment in that has a ' in it.

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 'test hi there blah blah blah')' at line 7
in:
[INSERT INTO zen_orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) VALUES ('76', '2', now(), '-1', 'test ' test hi there blah blah blah')]
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.

This started occurring after SuperOrders 3.0 was installed...anyone know how to fix it or where to find the file that's causing the trouble. I tried to find it through the developer's toolkit but no luck. I also get a similar error when trying to run scripts through the "Install SQL Patch" tool

ikernbecauseicare:

Hi - I have Zencart 1.3.9h, plus Purchase Orders 6 and Ty Package tracker as well as several other mods.

This is the error I'm getting after trying to put a comment in that has a ' in it.

This started occurring after SuperOrders 3.0 was installed...anyone know how to fix it or where to find the file that's causing the trouble. I tried to find it through the developer's toolkit but no luck. I also get a similar error when trying to run scripts through the "Install SQL Patch" tool
A search in this thread for a match on your error message would have turned up these threads:
http://www.zen-cart.com/forum/showpost.php?p=1027778&postcount=481
http://www.zen-cart.com/forum/showpost.php?p=974769&postcount=26

DivaVocals:

A search in this thread for a match on your error message would have turned up these threads:
http://www.zen-cart.com/forum/showpost.php?p=1027778&postcount=481
http://www.zen-cart.com/forum/showpost.php?p=974769&postcount=26

Well, it seems that in Admin/includes/functions/extra_functions/common_orders_functions.php, starting at around line 101, I found this:

function update_status($oID, $new_status, $customer_notified, $comments = '') {
  global $db;

  $db->Execute("INSERT INTO " . TABLE_ORDERS_STATUS_HISTORY . "
                (orders_id, orders_status_id, date_added, customer_notified, comments)
                VALUES ('" . (int)$oID . "',
                '" . $new_status . "',
                now(),
                '" . $customer_notified . "',
                '" . $comments . "')");

  $db->Execute("UPDATE " . TABLE_ORDERS . " SET
                orders_status = '" . $new_status . "'
                WHERE orders_id = '" . (int)$oID . "'");
}  

and changed the comments from:
'" . $comments . "')");
To:
'" . $comments . "");
making that look like:

function update_status($oID, $new_status, $customer_notified, $comments = '') {
  global $db;

  $db->Execute("INSERT INTO " . TABLE_ORDERS_STATUS_HISTORY . "
                (orders_id, orders_status_id, date_added, customer_notified, comments)
                VALUES ('" . (int)$oID . "',
                '" . $new_status . "',
                now(),
                '" . $customer_notified . "',
                '" . $comments . "");

  $db->Execute("UPDATE " . TABLE_ORDERS . " SET
                orders_status = '" . $new_status . "'
                WHERE orders_id = '" . (int)$oID . "'");
}  
```That took out the: ') but it's still showing the error with the ] as being the culprit.

I know that's got to be close, as it's taking out the other unwanted characters.................I just can't find where that stupid little bracket is coming from.

Anybody else have more any ideas?

In case anyone is wondering why I don't simply post the "fix", the answer is simple.. I made a BOATLOAD of changes to fix this and a few other things with regards to comments in Super Orders.. (key among these changes is the elimination of the common_orders_functions.php file) So the answer is that the changes I made are too numerous to post here.. (Which is why I suggested the easy workaround of not using single or double quotes in comments)

Trying to free some time to finish this and submit it, but well heck you know.. Life obligations come before free modules..:smile:

Get Em Fast:

Well, it seems that in Admin/includes/functions/extra_functions/common_orders_functions.php, starting at around line 101, I found this:

function update_status($oID, $new_status, $customer_notified, $comments = '') {
global $db;

$db->Execute("INSERT INTO " . TABLE_ORDERS_STATUS_HISTORY . "
(orders_id, orders_status_id, date_added, customer_notified, comments)
VALUES ('" . (int)$oID . "',
'" . $new_status . "',
now(),
'" . $customer_notified . "',
'" . $comments . "')");

$db->Execute("UPDATE " . TABLE_ORDERS . " SET
orders_status = '" . $new_status . "'
WHERE orders_id = '" . (int)$oID . "'");
}

> '" . $comments . "')");
> To:
> '" . $comments . "");
> making that look like:
> 
> ```
function update_status($oID, $new_status, $customer_notified, $comments = '') {
  global $db;

  $db->Execute("INSERT INTO " . TABLE_ORDERS_STATUS_HISTORY . "
                (orders_id, orders_status_id, date_added, customer_notified, comments)
                VALUES ('" . (int)$oID . "',
                '" . $new_status . "',
                now(),
                '" . $customer_notified . "',
                '" . $comments . "");

  $db->Execute("UPDATE " . TABLE_ORDERS . " SET
                orders_status = '" . $new_status . "'
                WHERE orders_id = '" . (int)$oID . "'");
}  
```That took out the: ') but it's still showing the error with the ] as being the culprit.
> 
> I know that's got to be close, as it's taking out the other unwanted characters.................I just can't find where that stupid little bracket is coming from.
> 
> Anybody else have more any ideas?

DivaVocals:

In case anyone is wondering why I don't simply post the "fix", the answer is simple.. I made a BOATLOAD of changes to fix this and a few other things with regards to comments in Super Orders.. (key among these changes is the elimination of the common_orders_functions.php file) So the answer is that the changes I made are too numerous to post here.. (Which is why I suggested the easy workaround of not using single or double quotes in comments)

Trying to free some time to finish this and submit it, but well heck you know.. Life obligations come before free modules..:smile:

Oh, I know what you mean, Diva.......sometimes life gets in the way of life.......
It's good to know that you've on top of it, as I've got a customer who needs this on like 9 different sites.
I've been working my fanny off trying to either find or help find the 'bug', but so far, the above is all I've found...................which after further investigation...............I'm not even sure is going to end up being relevant.
Anyway Diva, If there's anything I can do to help, you know where the pm buttons' at, and you've got my email addy......................

..............looking forward to seeing your........uh-hmm......OUR......headache(s) go away...........

P.S. You never know just how hard it is to write a whole paragraph in the comments section without using even one single quote, until you HAVE to do it. It can be more challenging that one might think.............

Okay now that you've offered don't ignore my messages when I take you up on your offer..:laugh:

To quote Glenn Close in Fatal Attraction, "I will not be ignored Dan":laugh:

Get Em Fast:

Oh, I know what you mean, Diva.......sometimes life gets in the way of life.......
It's good to know that you've on top of it, as I've got a customer who needs this on like 9 different sites.
I've been working my fanny off trying to either find or help find the 'bug', but so far, the above is all I've found...................which after further investigation...............I'm not even sure is going to end up being relevant.
Anyway Diva, If there's anything I can do to help, you know where the pm buttons' at, and you've got my email addy......................

..............looking forward to seeing your........uh-hmm......OUR......headache(s) go away...........

P.S. You never know just how hard it is to write a whole paragraph in the comments section without using even one single quote, until you HAVE to do it. It can be more challenging that one might think.............

DivaVocals:

Okay now that you've offered don't ignore my messages when I take you up on your offer..:laugh:

To quote Glenn Close in Fatal Attraction, "I will not be ignored Dan":laugh:

Uh-oh! Did I ignore you at some time or another? If I did, I sure didn't mean to.

Anyway..............I'll be here.

Hmm..........too slow to edit last post, so here's a couple of additional thoughts I had............

Uh-oh! Did I ignore you at some time or another? If I did, I sure didn't mean to. Also, if I did, I bet it was last month, huh?

May was a VERY hectic month for me with a hack, sick for almost a week, and of course..................the mean old Joplin tornado was 3 blocks from our home, leaving us without utilities, forcing us to go out of town with a $700 price tag that wasn't in the plans. So all-in-all............16 days downtime in May!

I'm sure proud it's over. So far, this month is been pretty good...............other than this little 'bug' that's driving us all crazy.

Anyway..............I'll be here.

Nah.. you didn't ignore me.. Just preparing you for ME taking you up on your offer.. :laugh: My nephew and I like that line from Fatal Attraction.. He's never seen the movie (he's 11.. it'll be a while before he gets to see it..) but he's seen the clip with the line I quoted.. He was amused.. I was amused by his amusement..:laugh: So we use it on each other when we think one of us isn't paying attention to the other one..:laugh:

Didn't realize you were in tornado alley.. Sounds like you fared better than others in the region.. Thank goodness for that!!!

Get Em Fast:

Hmm..........too slow to edit last post, so here's a couple of additional thoughts I had............

Uh-oh! Did I ignore you at some time or another? If I did, I sure didn't mean to. Also, if I did, I bet it was last month, huh?

May was a VERY hectic month for me with a hack, sick for almost a week, and of course..................the mean old Joplin tornado was 3 blocks from our home, leaving us without utilities, forcing us to go out of town with a $700 price tag that wasn't in the plans. So all-in-all............16 days downtime in May!

I'm sure proud it's over. So far, this month is been pretty good...............other than this little 'bug' that's driving us all crazy.

Anyway..............I'll be here.