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

[DivaVocals]

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..

[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.

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

[DivaVocals]

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/showpo...&postcount=481
http://www.zen-cart.com/forum/showpo...9&postcount=26

[Get Em Fast]

A search in this thread for a match on your error message would have turned up these threads:
http://www.zen-cart.com/forum/showpo...&postcount=481
http://www.zen-cart.com/forum/showpo...9&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?

[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..

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?

[Get Em Fast]

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..

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..

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

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.............

[Get Em Fast]

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

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

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.

[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.

[DivaVocals]

Nah.. you didn't ignore me.. Just preparing you for ME taking you up on your offer.. 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.. So we use it on each other when we think one of us isn't paying attention to the other one..

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

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.