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

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

[Zadris]

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

Thanks!

[hubert]

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

[DivaVocals]

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

[DivaVocals]

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"??

[sharpchain]

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.

[Zadris]

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

[DivaVocals]

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

It simply allowed your Super Order SQL install to work..

[hubert]

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.

[DivaVocals]

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)