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

I installed the Quickbooks add on after Super Orders and now I can't access the Super Orders in the dropdown for Customers. I get a blank screen. I was very careful when adding Quickbooks add on not to overwrite any files and did not.

I just went back and readded all of the Superorder files but still nothing.

Any ideas?
Not sure if a link helps but I'm at ddandlamber dot com

Zen Cart 1.3.9

ddandlamber:

I installed the Quickbooks add on after Super Orders and now I can't access the Super Orders in the dropdown for Customers. I get a blank screen. I was very careful when adding Quickbooks add on not to overwrite any files and did not.

I just went back and readded all of the Superorder files but still nothing.

Any ideas?
Not sure if a link helps but I'm at ddandlamber dot com

Zen Cart 1.3.9
What error message is in your cache folder?? Blank page = Error message...

Doesn't sound like a Super Orders issue at all.. The Quickbook mod shares no files in common with Super Orders.. I'm afraid that issues related to the other mod can't be resolved in this support thread..

The only thing I can suggest is comparing the Quickbooks mod to Super Orders.. If there are any files these mods share in common you'll need to use a file comparison tool like Winmerge or Beyond Compare to merge those modifications together..

If that doesn't work, then you need to carefully check your Super Orders install and/or rollback to a copy of your store before you installed BOTH mods, and start by re-installing Super Orders and making sure it works before re-installing the Quickbooks mod..

fo0bar:

...i'm pretty keen to know how it tests - i'm slightly limited when it comes to testing this multiple attribute stuff in a live store :P

I sent you an email with feedback after I completed testing. Just a few more tweaks needed and we should be good to go :)

ScriptJunkie:

I sent you an email with feedback after I completed testing. Just a few more tweaks needed and we should be good to go :)
Just got back from the hospital.. Could you keep me in the loop too??:smile:

DivaVocals:

Just got back from the hospital.. Could you keep me in the loop too??:smile:

Check your email girl :wink:

ScriptJunkie:

Check your email girl :wink:
Just did.. thanks!! :smile: Looks like you are on top of this..:smile:

So I'll continue with testing the rest of the module, updating the readme and wait for you and foobar to work out this part.. I'll merge your final result with the code I have and send out the "final beta" for you to test..

DivaVocals:

Just did.. thanks!! :smile: Looks like you are on top of this..:smile:

So I'll continue with testing the rest of the module, updating the readme and wait for you and foobar to work out this part.. I'll merge your final result with the code I have and send out the "final beta" for you to test..

Sounds great! If you have a chance, shoot me an email or give me a buzz and let me know how your bff is doing :smile:

So I figured out why I was getting the blank screen when selecting SO from the Customer drop down. I didn't upload the Edit Orders batch for Super Orders.

Now I have a different problem. When I installed the patch I got this message when uploading the SQL:
1 statment ignored. See "upgrade_exceptions" table for additional details.

Now I get the SO screen; however if I click on the details of an order I get this message:
1146 Table 'ddandlam_znc1.TABLE_CUSTOMERS_ADMIN_NOTES' doesn't exist
in:
[select * from TABLE_CUSTOMERS_ADMIN_NOTES where customers_id = '8']
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.

Please help!

ScriptJunkie:

I sent you an email with feedback after I completed testing. Just a few more tweaks needed and we should be good to go :)

applied fixes to my shonky code - sent an email with the new file. Sorry about the novel - just explaining some technicalities.

i'm not going to post the code here until i know it tests out ok :)

Short answer, you've got a version of the super_orders.php that is NOT included with the Super Orders v3.0 fileset..

ddandlamber:

So I figured out why I was getting the blank screen when selecting SO from the Customer drop down. I didn't upload the Edit Orders batch for Super Orders.

Now I have a different problem. When I installed the patch I got this message when uploading the SQL:
1 statment ignored. See "upgrade_exceptions" table for additional details.

Now I get the SO screen; however if I click on the details of an order I get this message:
1146 Table 'ddandlam_znc1.TABLE_CUSTOMERS_ADMIN_NOTES' doesn't exist
in:
[select * from TABLE_CUSTOMERS_ADMIN_NOTES where customers_id = '8']
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.

Please help!

Quick search of this support thread turned up this information:

**Search:** Keyword(s):
TABLE_CUSTOMERS_ADMIN_NOTES

Forum: All Other Contributions/Addons 23rd April 2011, 08:47 PM Replies: 408
Sticky: **Super Orders v3.0 Support Thread**
Views: 13,986
Posted By ddandlamber
* Re: Super Orders v3.0 Support Thread

            So I figured out why I was getting the blank screen when selecting  SO from the Customer drop down.  I didn't upload the Edit Orders batch  for Super Orders.   

Now I have a different problem. When... *

                                                            Forum: [All Other Contributions/Addons](http://www.zen-cart.com/forum/forumdisplay.php?f=44)                          4th March 2011, 09:01 AM                                            Replies: **408**         
                               Sticky:   [\*\*Super Orders v3.0 Support Thread\*\*](http://www.zen-cart.com/forum/showthread.php?t=170525&highlight=TABLE_CUSTOMERS_ADMIN_NOTES)         
                  Views: **13,986**         
                  Posted By             [DivaVocals](http://www.zen-cart.com/forum/member.php?u=34939)         
                   *                                  [Re: Super Orders v3.0 Support Thread](http://www.zen-cart.com/forum/showthread.php?p=1002925&highlight=TABLE_CUSTOMERS_ADMIN_NOTES#post1002925)
            
            Was busy last night.. Didn't get your PM until this morning.. I'm at  work and I can't look at this here.. but I do have a few  observations/suggestions: 

The files in the SO3 fileset DO NOT contain... *

                                                            Forum: [All Other Contributions/Addons](http://www.zen-cart.com/forum/forumdisplay.php?f=44)                           4th March 2011, 07:58 AM                                            Replies: **408**         
                               Sticky:   [\*\*Super Orders v3.0 Support Thread\*\*](http://www.zen-cart.com/forum/showthread.php?t=170525&highlight=TABLE_CUSTOMERS_ADMIN_NOTES)         
                  Views: **13,986**         
                  Posted By             [Rizla](http://www.zen-cart.com/forum/member.php?u=98355)         
                   *                                  [Re: Super Orders v3.0 Support Thread](http://www.zen-cart.com/forum/showthread.php?p=1002896&highlight=TABLE_CUSTOMERS_ADMIN_NOTES#post1002896)
            
            The call for TABLE_CUSTOMERS_ADMIN_NOTES is comming from the  admin/super_orders.php that is INCLUDED with the FEC module from the  Numinix site. 

How should I proceed with this as my PHP is... *

                                                            Forum: [All Other Contributions/Addons](http://www.zen-cart.com/forum/forumdisplay.php?f=44)                           3rd March 2011, 09:13 AM                                            Replies: **408**         
                               Sticky:   [\*\*Super Orders v3.0 Support Thread\*\*](http://www.zen-cart.com/forum/showthread.php?t=170525&highlight=TABLE_CUSTOMERS_ADMIN_NOTES)         
                  Views: **13,986**         
                  Posted By             [DivaVocals](http://www.zen-cart.com/forum/member.php?u=34939)         
                   *                                  [Re: Super Orders v3.0 Support Thread](http://www.zen-cart.com/forum/showthread.php?p=1002451&highlight=TABLE_CUSTOMERS_ADMIN_NOTES#post1002451)
            
            I'm at work so I can't look at the fileset from here.. But all of  that admin notes code was removed from SO3. So I'll have to take a look  when I get home and see if there is a remnant I'm unaware of...             *
     
                                                            Forum: [All Other Contributions/Addons](http://www.zen-cart.com/forum/forumdisplay.php?f=44)                           3rd March 2011, 08:18 AM                                            Replies: **408**         
                               Sticky:   [\*\*Super Orders v3.0 Support Thread\*\*](http://www.zen-cart.com/forum/showthread.php?t=170525&highlight=TABLE_CUSTOMERS_ADMIN_NOTES)         
                  Views: **13,986**         
                  Posted By             [Rizla](http://www.zen-cart.com/forum/member.php?u=98355)         
                   *                                  [Re: Super Orders v3.0 Support Thread](http://www.zen-cart.com/forum/showthread.php?p=1002421&highlight=TABLE_CUSTOMERS_ADMIN_NOTES#post1002421)
            
            Arrrgh HELP! 

SO3 was working great on my live site with test customers.

Just got my first real LIVE order and going into SO I got the following:

1146 Table... *

fo0bar:

applied fixes to my shonky code - sent an email with the new file. Sorry about the novel - just explaining some technicalities.

i'm not going to post the code here until i know it tests out ok :)
and actually if it tests okay we'll add it to the codebase so no need to post at all!!:smile:

fo0bar:

applied fixes to my shonky code - sent an email with the new file. Sorry about the novel - just explaining some technicalities.

i'm not going to post the code here until i know it tests out ok :)

No worries about a long email - detail is very much appreciated :)

Looking forward to testing these latest changes :)

Once again, thank you for your hard work! I believe that your changes will benefit everyone in the community who uses this mod :)

Hey again, just noticed this a moment ago. But, is there something I'm missing from HTML Emails where no line breaks are?

Running 1.3.9h Just installed Super Orders 3.0. Ran the SQL code. All of my customers are intact, however all old orders are 'missing' One New one shows up, but no old orders are there. What did/didn't I do and how do I fix it??

Thank you!

-Andrew
[email protected]

https://www.burkesfinemeats.com

andrewbrk1:

Running 1.3.9h Just installed Super Orders 3.0. Ran the SQL code. All of my customers are intact, however all old orders are 'missing' One New one shows up, but no old orders are there. What did/didn't I do and how do I fix it??

Thank you!

-Andrew
[email protected]

www.burkesfinemeats.com
Don't know what you did.. SO3 adds two new columns to the orders table, but it wouldn't "remove" orders from the orders table.. Though that said I'm not entirely sure what you mean by orders missing..

As suggested on page 1 of this support thread, it might help if you provided some details on HOW you installed SO.. it's not enough to know that you "copied the files over and ran the SQL" -- need to know WHICH files you copied over, WHICH SQL file you ran, and is this a NEW install or an UPGRADE.. If it is an upgrade from which version are you upgrading??

Sorry for the vagueness.

By missing I mean they do not show up under orders. The only one that shows up is one that came in AFTER I updated. HOWEVER, I CAN click back and see the others if I 'start' from the one that shows up and click to previous orders (Under Super Orders:Details: Jump to order).

I renamed to match my admin folder the folders in '1_Install_Files' , '2_Required_Core_Edits' and '3_Optional_Files'. I ftp/overwrote them to my store directory. I then copied, and pasted into Admin:Tools:Install Sql Patches the code from 'super_orders_install_v30.sql' and executed it. There were no errors.

It seems to work fine with the one order that is there, i.e.; print, edit, etc. Just don't see the previous orders.

Example, When I click on one of the 'New Orders:' from the main Admin screen, no matter which customer I click on, it takes me only to the one new one.

I can provide ftp/login access if that would help you in any way. I appreciate any help you can give... I have reviewed the install directions repeatedly and can't see what I did incorrectly...
Thank you

-Andrew Burke

Running 1.3.9h Just installed Super Orders 3.0. Ran the SQL code. All of my customers are intact, however all old orders are 'missing' One New one shows up, but no old orders are there. What did/didn't I do and how do I fix it??

Thank you!

-Andrew
[email protected]

https://www.burkesfinemeats.com

Sorry for the vagueness.

It was a fresh install.

By missing I mean they do not show up under orders. The only one that shows up is one that came in AFTER I Installed. HOWEVER, I CAN click back and see the others if I 'start' from the one that shows up and click to previous orders (Under Super Ordersetails: Jump to order).

I renamed to match my admin folder the folders in '1_Install_Files' , '2_Required_Core_Edits' and '3_Optional_Files'. I ftp/overwrote them to my store directory. I then copied, and pasted into Admin:Tools:Install Sql Patches the code from 'super_orders_install_v30.sql' and executed it. There were no errors.

It seems to work fine with the one order that is there, i.e.; print, edit, etc. Just don't see the previous orders.

Example, When I click on one of the 'New Orders:' from the main Admin screen, no matter which customer I click on, it takes me only to the one new one.

I can provide ftp/login access if that would help you in any way. I appreciate any help you can give... I have reviewed the install directions repeatedly and can't see what I did incorrectly...
Thank you

-Andrew Burke

andrewbrk1:

Running 1.3.9h Just installed Super Orders 3.0. Ran the SQL code. All of my customers are intact, however all old orders are 'missing' One New one shows up, but no old orders are there. What did/didn't I do and how do I fix it??

Thank you!

-Andrew
[email protected]

www.burkesfinemeats.com

Sorry for the vagueness.

It was a fresh install.

By missing I mean they do not show up under orders. The only one that shows up is one that came in AFTER I Installed. HOWEVER, I CAN click back and see the others if I 'start' from the one that shows up and click to previous orders (Under Super Ordersetails: Jump to order).

I renamed to match my admin folder the folders in '1_Install_Files' , '2_Required_Core_Edits' and '3_Optional_Files'. I ftp/overwrote them to my store directory. I then copied, and pasted into Admin:Tools:Install Sql Patches the code from 'super_orders_install_v30.sql' and executed it. There were no errors.

It seems to work fine with the one order that is there, i.e.; print, edit, etc. Just don't see the previous orders.

Example, When I click on one of the 'New Orders:' from the main Admin screen, no matter which customer I click on, it takes me only to the one new one.

I can provide ftp/login access if that would help you in any way. I appreciate any help you can give... I have reviewed the install directions repeatedly and can't see what I did incorrectly...
Thank you

-Andrew Burke

What you need to do is do a backup of your store before you installed SO. After that check to make sure your old orders are there. Re-install SO making sure you do not over write any other files that this module is using with core files. Use a program like WinMerge to compare files with the core file that SO is using. See what happens after that. Take your time a lot of misstates happen when people rush to install a module.:yes:

I did a backup of the entire store and the SQL. As I stated, the orders ARE there... If I look at the one order that came in AFTER I installed, I can browse back and see/edit/print the others. That is from the Super Orders Side. If I click on a customer from the main Admin page, they do not show up.

I am on a Mac, so I can't use WinMerge, However I DID use Apple File Merge and do not see anywhere that I overwrote a key file/function/issue.

Stumped.

-Andrew Burke
burkesfinemeats.com

I think this should be a fairly easy one.................Okay, in /MyCustomAdminFolder/super_packingslip.php, line 222:

<td class="dataTableContent" valign="middle">' . $order->products[$i]['model'] . '</td>' . "\n" .

....displays the Model Numbers in their column.

What I need to know is, can this line also be manipulated to "Order by model ASC", to make these list alphabetically by model number.

Any ideas?