Are you installing SUPER Orders or EDIT orders?? If this is an EDIT Orders issue, you are in the wrong support thread..
Printable View
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!:smile:
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)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??Quote:
Run the edit_orders_install.sql using the "SQL Query Executor" tool in the Admin (Tools > Install SQL Patches).
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?
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. :P 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
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. ;)
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.