Post by andydunion » Sat Dec 14, 2019 4:05 am

I have a website with OC 3.0.3.2 and Journal 3 installed when i try to go to my orders on the filter options my order statuses I have created do not show correctly. It is only on the orders page on any other page the order statuses are correct
Here is a screen shot of my sales order status section:
Image

And this is my report section:
Image

The reports sections shows as it should the orders section does not can anyone tell me how to fix this I have a backup of the database but dont know which tables i need to delete and import to fix.

Thanks in advance for any help.

Newbie

Posts

Joined
Sat Dec 14, 2019 3:40 am

User avatar
Legendary Member

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by andydunion » Mon Dec 16, 2019 7:15 pm

Yes ive tried clearing caches its as if in my sales section it does not see the newly created statuses it only shows the old ones. there must be somewhere in the database that can be edited to fix this.

Thanks for your reply.

Newbie

Posts

Joined
Sat Dec 14, 2019 3:40 am

Post by letxobnav » Mon Dec 16, 2019 8:24 pm

as far as I can tell both use the same function, are you browser caching perhaps?

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


User avatar
Expert Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan

Post by andydunion » Mon Dec 16, 2019 10:31 pm

I've tried clearing caches and tried several different browsers i'm at a complete loss.

Newbie

Posts

Joined
Sat Dec 14, 2019 3:40 am

Post by letxobnav » Mon Dec 16, 2019 10:46 pm

well, the order stati are cached in the OC object cache file order_status.LANGUAGE_ID in your cache directory.
You could check the contents of that file.

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


User avatar
Expert Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan

Post by andydunion » Wed Dec 18, 2019 12:25 am

Well guys i got to the bottom of it eventually and it wasn't anything to do with the order status database. I have a second copy on a server wth no template installed so I copied my full database to the other site and surprisingly it worked perfectly which says it has something to do with the journal 3 template I had installed. So ive taken that template off and replaced with the Antropy template recommended in the Jounal post above and everything is working as expected. Shame Journal was the cause but my support ran out and to pay for support every 6 months is just a joke so looks like i wont be using again.

Thanks for the input.

Andy

Newbie

Posts

Joined
Sat Dec 14, 2019 3:40 am

Post by xxvirusxx » Wed Dec 18, 2019 1:01 am

Journal 3 has nothing to do with order statuses from Admin.
And yes, you need to pay to renew for support, but at least you can download when a new version is out.

And not like some developers: Isense...for example :laugh: when you need to renew the licence every year.

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by letxobnav » Wed Dec 18, 2019 8:55 am

I do think it is because of a journal 3 cache issue though.

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


User avatar
Expert Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan

Post by andydunion » Wed Dec 18, 2019 9:23 pm

There is no other explanation if I took my database and exported to a new site with no template installed and suddenly it worked as it should that clearly shows the problem was journal template Maybe theres another cache in journal.i didn't find we will never know.

Newbie

Posts

Joined
Sat Dec 14, 2019 3:40 am

Post by xxvirusxx » Wed Dec 18, 2019 10:50 pm

In the store where order statuses doesn't work you use ocmod/vqmod extension?
But on new site?

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by andydunion » Wed Dec 18, 2019 11:04 pm

Every module was transferred, the site is an exact duplicate with the exception of Journal 3 as i thought i'd get the site working then add the template at the end.

Newbie

Posts

Joined
Sat Dec 14, 2019 3:40 am

Post by xxvirusxx » Wed Dec 18, 2019 11:13 pm

Make a temporary admin account on the store with journal3 and send me to PM.
I can take a look for free just for curiosity.

Only if you want.

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România
Who is online

Users browsing this forum: No registered users and 7 guests