cancel
Showing results for 
Search instead for 
Did you mean: 

Order View error in 2.2.5 SQL Error

SOLVED

Order View error in 2.2.5 SQL Error

Hello,
 
I have upgraded from 2.24 > 2.2.5 and now am unable to view orders.
when I click on sales>orders>Action: View Order I get this:
 
Order View

Error in System Log:

 Screen Shot 2018-07-05 at 1.49.12 PM.png

 

Any ideas on what could be causing this? Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Order View error in 2.2.5 SQL Error

So I just read another thread that had a similar issue, and the resolution was to disable the "Temando Shipping" Module.

 

I just did that in this case to test it out and my magento now works. 

I disabled Temando shipping by modifying its active status in the config file under app/etc/config.php and clearing the cache afterwards.

View solution in original post

4 REPLIES 4

Re: Order View error in 2.2.5 SQL Error

Hi @joshua_carton,


Are you using some 3rd-party module or maybe a custom module to change the Order behaviors?

 

Re: Order View error in 2.2.5 SQL Error

Hi Damian,

 

I do not think I am.

 

Here is a list of all modules I have active:

List of enabled modules:
Magento_Store
Magento_Directory
Magento_Eav
Magento_Backend
Magento_Theme
Magento_Customer
Magento_AdminNotification
Magento_Indexer
Magento_Cms
Magento_AdvancedPricingImportExport
Magento_Config
Magento_Authorization
Magento_Catalog
Magento_Rule
Magento_Backup
Magento_Quote
Magento_Bundle
Magento_BundleImportExport
Magento_CacheInvalidate
Magento_SalesSequence
Magento_Payment
Magento_Security
Magento_CatalogImportExport
Magento_CatalogInventory
Magento_Cron
Magento_Msrp
Magento_Search
Magento_CatalogUrlRewrite
Magento_Widget
Magento_Sales
Magento_Checkout
Magento_Vault
Magento_CmsUrlRewrite
Magento_User
Magento_ConfigurableImportExport
Magento_ConfigurableProduct
Magento_ConfigurableProductSales
Magento_Contact
Magento_Cookie
Magento_Email
Magento_CurrencySymbol
Magento_Paypal
Magento_Integration
Magento_CustomerImportExport
Magento_Deploy
Magento_Developer
Magento_Dhl
Amazon_Core
Magento_Downloadable
Magento_ImportExport
Magento_Authorizenet
Magento_Newsletter
Magento_EncryptionKey
Magento_Fedex
Magento_GiftMessage
Magento_GoogleAdwords
Magento_GoogleAnalytics
Magento_Ui
Magento_GroupedImportExport
Magento_GroupedProduct
Magento_DownloadableImportExport
Magefan_Blog
Magento_InstantPurchase
Magento_Analytics
Magento_LayeredNavigation
Magento_Marketplace
Magento_MediaStorage
Magento_CatalogRule
Magento_Multishipping
Magento_NewRelicReporting
Magento_ProductAlert
Magento_OfflinePayments
Magento_SalesRule
Magento_PageCache
Magento_Braintree
Klarna_Core
Magento_Persistent
Magento_Reports
Magento_ProductVideo
Magento_Captcha
Magento_QuoteAnalytics
Magento_ReleaseNotification
Magento_Review
Magento_RequireJs
Magento_SendFriend
Magento_ReviewAnalytics
Magento_Robots
Magento_Rss
Magento_CatalogRuleConfigurable
Amazon_Login
Magento_SalesAnalytics
Magento_SalesInventory
Magento_OfflineShipping
Amazon_Payment
Magento_UrlRewrite
Magento_CatalogSearch
Magento_CustomerAnalytics
Magento_Shipping
Magento_Wishlist
Magento_Signifyd
Magento_Sitemap
Klarna_Ordermanagement
Magento_Swagger
Magento_Swatches
Magento_SwatchesLayeredNavigation
Magento_Tax
Magento_TaxImportExport
Magento_CheckoutAgreements
Magento_Translation
Magento_GoogleOptimizer
Magento_Ups
Magento_SampleData
Magento_CatalogAnalytics
Magento_Usps
Magento_Variable
Klarna_Kp
Magento_Version
Magento_Webapi
Magento_WebapiSecurity
Magento_Weee
Magento_CatalogWidget
Dotdigitalgroup_Email
Magento_WishlistAnalytics
Sm_BackEnd
Sm_CartQuickPro
Sm_Categories
Sm_CategoriesMenu
Sm_FilterProducts
Sm_ListingTabs
Sm_Market
Sm_MegaMenu
Sm_RecentlyViewed
Sm_SearchBox
Sm_ShopBy
Sm_SocialLogin
Temando_Shipping
Vertex_Tax

List of disabled modules:
Shopial_Facebook

Re: Order View error in 2.2.5 SQL Error

So I just read another thread that had a similar issue, and the resolution was to disable the "Temando Shipping" Module.

 

I just did that in this case to test it out and my magento now works. 

I disabled Temando shipping by modifying its active status in the config file under app/etc/config.php and clearing the cache afterwards.

Re: Order View error in 2.2.5 SQL Error

yes also for me, Upgrading to 2.2.5 I had same problem.

 

I disable the module "Temando_Shipping" inside the /app/etc/config.php by setting it to 0  and now all work fine.

Stefano