OpenCart Community

• - Downloaded a fresh copy of the 2.0.3.1 package from opencart.com (i suspected incorrect file encodings or bad bytes in current copy)
• - Created a new DB / user (all rights)
• - Installed OpenCart manually entering the just created DB credentials
• - Logged into admin / created a new customer / went to front end / Logged into front end with the new customer/ made an order / returned back to admin/sales/orders / clicked edit on the new order
• - Verified that I do not get any error (opened firebug and actually saw the ajax http response - success: You changed currency)
• - Copied all files except for index.php and config.php (in admin as well) from the old (production) install over the fresh install
• - I use lots of vQmod so went to /vqmod/install to make it work again
• - Installed the lanaguage packs in admin
• - Installed the ocmods modules in admin from extension installer - these you need to have prepared
• - (x2) returned back to admin/sales/orders verified that I do not get any error (opened firebug and actually saw the ajax http response - success: You changed currency) - so its not any of the mods causing the trouble
• - Because I was using a multilingual store - I went to NEW DB phpMyadmin and checked the language_id column of my existing languages in my case German = 2 . Then went to OLD DB and checked the language_id column of my existing products in my case German = 3. This is important for the next steps.
• - Went to OLD DB - phpMyAdmin and exported the following tables. Important note here is to delete these table in the new DB before importing or to uncheck the advanced export option - IF NOT EXISTS.

  Code: Select all

  oc_address
  oc_affiliate
  oc_affiliate_activity
  oc_affiliate_login
  oc_affiliate_transaction
  oc_attribute
  oc_attribute_description
  oc_attribute_group
  oc_attribute_group_description
  oc_banner
  oc_banner_image
  oc_banner_image_description
  oc_blog
  oc_blog_category
  oc_blog_category_description
  oc_blog_category_to_layout
  oc_blog_category_to_store
  oc_blog_comment
  oc_blog_description
  oc_blog_related
  oc_blog_to_category
  oc_blog_to_layout
  oc_blog_to_store
  oc_category
  oc_category_description
  oc_category_filter
  oc_category_path
  oc_category_to_layout
  oc_category_to_store
  oc_country
  oc_coupon
  oc_coupon_category
  oc_coupon_history
  oc_coupon_product
  oc_currency
  oc_custom_field
  oc_custom_field_customer_group
  oc_custom_field_description
  oc_custom_field_value
  oc_custom_field_value_description
  oc_download
  oc_download_description
  oc_geo_zone
  oc_information
  oc_information_description
  oc_information_to_layout
  oc_information_to_store
  oc_location
  oc_manufacturer
  oc_manufacturer_to_store
  oc_marketing
  oc_option
  oc_option_description
  oc_option_value
  oc_option_value_description
  oc_product
  oc_product_attribute
  oc_product_description
  oc_product_discount
  oc_product_filter
  oc_product_image
  oc_product_option
  oc_product_option_value
  oc_product_recurring
  oc_product_related
  oc_product_reward
  oc_product_special
  oc_product_to_category
  oc_product_to_download
  oc_product_to_layout
  oc_product_to_store
  oc_recurring
  oc_recurring_description
  oc_return
  oc_return_action
  oc_return_history
  oc_return_reason
  oc_return_status
  oc_review
  oc_stock_status
  oc_tax_class
  oc_tax_rate
  oc_tax_rate_to_customer_group
  oc_tax_rule
  oc_upload
  oc_url_alias
  oc_weight_class
  oc_weight_class_description
  oc_zone
  oc_zone_to_geo_zone

• - Went to NEW DB and imported the generated SQL script. This way you will preserve 100% of your categories / products / information page / attributes / options (well i skipped the filters but I don't use them anyway you can include them as well)
• - Went to NEW DB every table and checked for column language_id when I saw it said 2 i ran a DELETE query to remove any sample data with that language. After that I repeated the process by using an UPDATE query to change 3 to 2.
• - Fine tuned MANUALLY the store settings / logo / modules settings / shipping / payment / checkout
• - (x3) returned back to admin/sales/orders verified that I do not get any error (opened firebug and actually saw the ajax http response - success: You changed currency) - so its not any of the mods causing the trouble

Randem wrote:Order Add/Edit issue resolved - http://www.randemsystems.com/support/op ... 8/#msg6218

sethioz wrote: ↑

Fri Sep 30, 2022 5:21 am

I can see it's old and known issue, but I just got same issue. I read thru the topic and nothing worked, I assure you that the issue developed on its own.
I own the server and I haven't made any changes, I don't use auto-updates on my Apache or phpmyadmin or anything. I haven't touched it for months and now all the sudden I got the issue out of the blue.

I have paypal IPN setup and orders are auto completed upon payment, but I just noticed that last couple orders are "pending" and when I try to manually change them, I get the same error (see screenshot below).

I assure you again, I have NOT made any changes and nobody else has admin access.
Furthermore, I have 2 opencarts running on same server:
one that has the issue is 2.0.1.1
other one is 1.5.6.4 and it works fine, however I noticed that last order in that one was also "pending", it could be coincidence, because sometimes paypal fails to verify with IPN when differency currency is used, but in either case, I was able to edit the order just fine and change it to "complete", but in 2.0.1.1 I can't edit order history nor order data.

I tried editing user data and that works, I don't seem to have any other issues apart from editing order history and orders. That's what makes me go crazy, because I own the entire system and I would know if any changes would have been made.

ONLY thing I can think of, is that someone said something about cloudflare enabling some "free" thing, not sure what he meant.
I use cloudflare and it's impossible to disable it, because I don't have valid certificate on my server and everything must run HTTPS only. it's not possible to disable HTTPS and without valid certificate, website would not work at all.
However I've had cloudflare enabled for almost 10 years now, NEVER had issues and I didn't change any settings in cloudflare either .. and this doesn't explain why 1.5 works and 2.0 does not. So I highly doubt it's cloudflare issue.

ONLY OTHER thing I can think of (which doesn't make much sense), is that I made some manual edits to some order history directly in database, because OC doesn't have option for those fields. I use "multimerch" module and I changed some of that data directly in database (had to change some payment amounts to correct currency conversion issues), BUT I have done that in past and it never caused this error .. so I don't see this being an issue either.

So is there any other solution? Or better yet .. how can this issue just pop out of nowhere? I also tried firefox and chrome .. just in case there's some issue, but nope, same error in both. I tried VPN and no VPN, still same. I've checked and tried everything I could think of, but what makes this bug so annoying, is that I DID NOT CHANGE ANYTHING! There haven't been any changes made to OC nor server it runs on, so what the F?

any help is appreciated, thanks.

sethioz wrote: ↑

Fri Sep 30, 2022 5:21 am

I can see it's old and known issue, but I just got same issue. I read thru the topic and nothing worked, I assure you that the issue developed on its own.
I own the server and I haven't made any changes, I don't use auto-updates on my Apache or phpmyadmin or anything. I haven't touched it for months and now all the sudden I got the issue out of the blue.

I have paypal IPN setup and orders are auto completed upon payment, but I just noticed that last couple orders are "pending" and when I try to manually change them, I get the same error (see screenshot below).

I assure you again, I have NOT made any changes and nobody else has admin access.
Furthermore, I have 2 opencarts running on same server:
one that has the issue is 2.0.1.1
other one is 1.5.6.4 and it works fine, however I noticed that last order in that one was also "pending", it could be coincidence, because sometimes paypal fails to verify with IPN when differency currency is used, but in either case, I was able to edit the order just fine and change it to "complete", but in 2.0.1.1 I can't edit order history nor order data.

I tried editing user data and that works, I don't seem to have any other issues apart from editing order history and orders. That's what makes me go crazy, because I own the entire system and I would know if any changes would have been made.

ONLY thing I can think of, is that someone said something about cloudflare enabling some "free" thing, not sure what he meant.
I use cloudflare and it's impossible to disable it, because I don't have valid certificate on my server and everything must run HTTPS only. it's not possible to disable HTTPS and without valid certificate, website would not work at all.
However I've had cloudflare enabled for almost 10 years now, NEVER had issues and I didn't change any settings in cloudflare either .. and this doesn't explain why 1.5 works and 2.0 does not. So I highly doubt it's cloudflare issue.

ONLY OTHER thing I can think of (which doesn't make much sense), is that I made some manual edits to some order history directly in database, because OC doesn't have option for those fields. I use "multimerch" module and I changed some of that data directly in database (had to change some payment amounts to correct currency conversion issues), BUT I have done that in past and it never caused this error .. so I don't see this being an issue either.

So is there any other solution? Or better yet .. how can this issue just pop out of nowhere? I also tried firefox and chrome .. just in case there's some issue, but nope, same error in both. I tried VPN and no VPN, still same. I've checked and tried everything I could think of, but what makes this bug so annoying, is that I DID NOT CHANGE ANYTHING! There haven't been any changes made to OC nor server it runs on, so what the F?

any help is appreciated, thanks.