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

[DivaVocals]

Hello!

I am trying to install. However, I am not smart enough for it. The last step is

Run the edit_orders_install.sql using the "SQL Query Executor" tool in the Admin (Tools > Install SQL Patches).

However, I never uploaded the edit_orders_install.sql. I uploaded the install and required core files. Where/how do I upload that sql file?

Thanks!

Frank

Are you installing SUPER Orders or EDIT orders?? If this is an EDIT Orders issue, you are in the wrong support thread..

[FrankinWV]

I know... sorry. I was referring to the wrong sql filename... I figured it out, though... On the sql query executor, after you upload all the files (and after I changed the YOUR_ADMIN to my admin's name - you pick the RIGHT sql file in the "Upload File" window, click upload - and voila - it works.

THAT"S what' I couldn't figure out to do. I knew I needed the sql file on the site, but never saw it in the directions of HOW to get it there, so I manually uploaded it and tried to use it in the large "Enter the query" field above.. which -obviously - didn't work.

Thanks for your help and pointing me the right way!

[DivaVocals]

Glad you worked it out, but the readme files does say WHERE to upload this SQL file.. That's part of the reason why the SQL files needed for Super Orders are in a separate location than the rest of the install files.. (so people don't "accidentally" upload this file)

Run the edit_orders_install.sql using the "SQL Query Executor" tool in the Admin (Tools > Install SQL Patches).

Are you saying that this instruction wasn't clear?? If this wasn't clear to you do you have a suggestion on how we could make it clearer for the next SO update??

I know... sorry. I was referring to the wrong sql filename... I figured it out, though... On the sql query executor, after you upload all the files (and after I changed the YOUR_ADMIN to my admin's name - you pick the RIGHT sql file in the "Upload File" window, click upload - and voila - it works.

THAT"S what' I couldn't figure out to do. I knew I needed the sql file on the site, but never saw it in the directions of HOW to get it there, so I manually uploaded it and tried to use it in the large "Enter the query" field above.. which -obviously - didn't work.

Thanks for your help and pointing me the right way!

[apogeerockets]

Hello! I am getting that "strcasecmp()" error that nagelkruid got as well. this happens when i try to use batch-update to change orders from pending to processed and use the "check all" button. it works fine when i select individual boxes.

the page hangs, then ends in blank, so i hit back, refresh the page and get the message stack saying the orders were updated (which they were).

any thoughts?

[DivaVocals]

Hello! I am getting that "strcasecmp()" error that nagelkruid got as well. this happens when i try to use batch-update to change orders from pending to processed and use the "check all" button. it works fine when i select individual boxes.

the page hangs, then ends in blank, so i hit back, refresh the page and get the message stack saying the orders were updated (which they were).

any thoughts?

Nope.. and I'm not familiar with this issue.. What post by nagelkruid speaks about this issue??

[apogeerockets]

Nope.. and I'm not familiar with this issue.. What post by nagelkruid speaks about this issue??

About a year ago, #195
http://www.zen-cart.com/forum/showpo...&postcount=195

Sorry, I hadn't realized it'd been that long, so it's not as fresh in ppls minds. The error i'm getting:

PHP Warning: strcasecmp() expects parameter 1 to be string, array given in *****\apogeeadmin\includes\functions\extra_functions\common_orders_functions.php on line 61

[DivaVocals]

About a year ago, #195
http://www.zen-cart.com/forum/showpo...&postcount=195

Sorry, I hadn't realized it'd been that long, so it's not as fresh in ppls minds. The error i'm getting:

PHP Warning: strcasecmp() expects parameter 1 to be string, array given in *****\apogeeadmin\includes\functions\extra_functions\common_orders_functions.php on line 61

And my answer is the same today as it was over a year ago.. Can't reproduce the error..

[apogeerockets]

Wow, ok. Just tried again and it went fine this time. I haven't changed anything, so wonder why it worked now...

Perhaps if you DO hit the button enough times something else will happen. ;)

[DivaVocals]

Wow, ok. Just tried again and it went fine this time. I haven't changed anything, so wonder why it worked now...

Perhaps if you DO hit the button enough times something else will happen. ;)

Without knowing how the error happened to begin with it's hard to say. Since I cannot reproduce the error.. well you get the point..

[elninomago]

Hello. Super Orders is finally installed. However, when we do a batch status update we get:

1366 Incorrect integer value: 'on' for column 'customer_notified' at row 1
in:
[INSERT INTO orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) VALUES ('22559', '3', now(), 'on', '')]
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.

I know we could try and get MYSQL out of Strict Mode. But our web server holds the my.ini file so we cant edit. Is there another way around this?

Thanks in advance to anyone that can help.