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

I had a similar issue upon upgrading. The fix was to simply eliminate the common_orders_functions file. The coding is, basically, repeated in the new SO ver. 4 files elsewhere.

Hi again, just curious if this change will affect any future installs of sql plug-ins?

Thanks!

DivaVocals:

When you see the error message there should be an error log file in the Zen Cart cache folder.. What does that error log file say??

Great ! I didn't know that I could see the log there. Here is the error message :

PHP Fatal error:  1054:Unknown column 'split_from_order' in 'field list' :: select split_from_order, is_parent from orders	where orders_id = '2595' in /catalog/includes/classes/db/mysql/query_factory.php on line 101

hubert:

Great ! I didn't know that I could see the log there. Here is the error message :

PHP Fatal error: 1054:Unknown column 'split_from_order' in 'field list' :: select split_from_order, is_parent from orders where orders_id = '2595' in /catalog/includes/classes/db/mysql/query_factory.php on line 101

You have an incomplete install.. Suggest re-installing.. You don't need to re-upload all the files, but will need to login to the admin, re-upload the **1_Base_Files/YOUR_ADMIN_FOLDER/includes/auto_loaders** folder, and then click any link in the admin to re-execute the auto-installer. 

Are you by chance upgrading a Super Orders version older than v3.0??

Zadris:

Hi again, just curious if this change will affect any future installs of sql plug-ins?

Thanks!Not sure which post you are responding to.. What change are you referring to?? Explain what you mean by "sql plugin-ins"??

richardtuttle:

I had a similar issue upon upgrading. The fix was to simply eliminate the common_orders_functions file. The coding is, basically, repeated in the new SO ver. 4 files elsewhere.

Thank You sir, that worked perfectly. Now we will install edit orders and see how that goes.

DivaVocals:

Not sure which post you are responding to.. What change are you referring to?? Explain what you mean by "sql plugin-ins"??

Go to your SQL and change

TYPE=MyISAM ;

to

ENGINE=MyISAM ;

I am just curious by changing the sql will it create any future problems or does this modification just benefit Super Orders...I hope I made myself clear...Thanks again

Zadris:

Go to your SQL and change

TYPE=MyISAM ;

to

ENGINE=MyISAM ;

I am just curious by changing the sql will it create any future problems or does this modification just benefit Super Orders...I hope I made myself clear...Thanks againIt simply allowed your Super Order SQL install to work..

You have an incomplete install.. Suggest re-installing.. You don't need to re-upload all the files, but will need to login to the admin, re-upload the 1_Base_Files/YOUR_ADMIN_FOLDER/includes/auto_loaders folder, and then click any link in the admin to re-execute the auto-installer.

Are you by chance upgrading a Super Orders version older than v3.0??

Yes and no, I'm upgrading from 1.3.7 with SO 3.0 but keeping the previous database upgraded by install scripts.

In fact the error log was right :-), some fields were missing so I reviewed the SO 4 SQL file, removed all that already exists in the MySQL tables and did the remaining SQL request.

No more errors.

Thanks you very much.

hubert:

Yes and no, I'm upgrading from 1.3.7 with SO 3.0 but keeping the previous database upgraded by install scripts.

In fact the error log was right :-), some fields were missing so I reviewed the SO 4 SQL file, removed all that already exists in the MySQL tables and did the remaining SQL request.

No more errors.

Thanks you very much.Not sure what you mean by "removed all that already exists in the MySQL tables and did the remaining SQL request", but glad it worked out.

If you were indeed missing the "split_from_order" column as stated in the error, then you MUST be upgrading from a version of Super Orders Older than 3.0.. Given that you were upgrading a 1.3.7 store this would have to be the case as Super Orders v3.0 was not backwards compatible (would be UNLIKELY to work on a Zen Cart v1.3.7 store)

I mean I reviewed all the SQL statements and removed the CREATE or INSERT statements when the column or table already exists.
Then I executed the remainings SQL statements.

hubert:

I mean I reviewed all the SQL statements and removed the CREATE or INSERT statements when the column or table already exists.
Then I executed the remainings SQL statements.
Are you using Super Orders 3.0 (available in the Zen Cart downloads section) or v4.0 (only available right now on my website)??

I'l using SO4, the one on your website.

hubert:

I'l using SO4, the one on your website.Well glad it worked out, but the installer should have done what you did manually.. shrugs

DivaVocals, I read through the Super Orders readme file and it says that I may have tracker, USPS and edit orders installed first prior to installing Super Orders...just want to make double sure so I have all working. Arghh..this is my 3rd attempt...

Thank you for your help..:)

Ack! I am feeling incompetent. This is my fourth attempt to add Super Orders. This time I was meticulously careful. Here is the message I got:

Hello. Thank you for loading Zen Cart®.
You are seeing this page for one or more reasons:

This is your first time using Zen Cart® and you haven't yet completed the normal Installation procedure.
If this is the case for you, you will need to upload the "zc_install" folder using your FTP program, and then run zc_install/index.php via your browser (or reload this page to see a link to it).

Your /includes/configure.php and/or /admin/includes/configure.php file contains invalid path information and/or invalid database-connection information.
If you recently edited your configure.php files for any reason, or maybe moved your site to a different folder or different server, then you'll need to review and update all your settings to the correct values for your server.
See the Online FAQ and Tutorials area on the Zen Cart® website for assistance.
Additional Details: includes/configure.php file empty or file not found, OR wrong DB_TYPE set, OR cannot find includes/autoload_func.php which suggests paths are wrong or files were not uploaded correctly

Now the whole site is down!

What am I doing wrong? There seems to be a fundamental error in what I am doing. Edit Orders went up fine yesterday.
I have ZC1.5, EO4.0, tried to get SO4.0.2final.

Zadris:

DivaVocals, I read through the Super Orders readme file and it says that I may have tracker, USPS and edit orders installed first prior to installing Super Orders...just want to make double sure so I have all working. Arghh..this is my 3rd attempt...

Thank you for your help..:)It's exactly what the readme says..

Are you referring to Super Orders 3.0 for Zen Cart v1.3.9 or Super Orders v4.0 for Zen Cart v1.5??

DivaVocals:

It's exactly what the readme says..

Are you referring to Super Orders 3.0 for Zen Cart v1.3.9 or Super Orders v4.0 for Zen Cart v1.5??

That would 1.3.9

This time I will do it right! :)

I have followed all the instructions to install in my zc 1.5 site, upgrading from the 1.3 version of super orders. After I copy all the files, then delete the common_orders_functions.php file because it was causing errors, I then get a sql error when trying to view any link in the admin site:

[11-Jul-2012 02:59:24 UTC] PHP Fatal error: 1366:Incorrect string value: '\x92t hav...' for column 'configuration_description' at row 1 :: INSERT INTO configuration VALUES (NULL, 'PDF Packing Slip - Enable Shipping Label', 'LCSD_SHOW_SHIPPING_LABEL', 'False', 'Determines whether or not a pre-printed shipping label is included in a customer address block on the packing slip so you don\’t have to process a separate label report. If you are using a preprinted packing slips with a peel off label – set this to true.', '32', 90, now(), now(), NULL, 'zen_cfg_select_option(array(''True'', ''False''),') in C:\Websites\Insert Insanity\includes\classes\db\mysql\query_factory.php on line 101

My entire admin site is down now. Any ideas how to fix this?

HI!

I'm new to ZenCart 1.5, and I'm requiring to print all invoices, which is the version compatible with 1.5?

Regards