Connection error: it is not possible to complete the operation
Auteur : Vladimir A.
Visité 1220,
Followers 1,
Partagé 0
Hello, I just started new e-commerce website and added some prodcuts to the shopping cart. However, I cannot update the qty at the Host by clicking on Update. The popup is "Connection error: it is not possible to complete the operation". I double check the url, the database settings etc. and it look all right. Moreover, after the website deploymment I see the tables created in MySql Db, but still cannot Update the products qty. Please advise!
Posté le
Auteur
The user obviously has All Privileges to the database.
Auteur
The WEBSITE X5 MANAGER is showing MySql Db PASS.
Hello. Try disabling your antivirus, firewall, and any other protection. Don't use VPN. Contact your hosting provider and ask if they are blocking you.
Auteur
Hello Aleksej, I already did what you suggested and it's still the same. However, the situation is that I'm able to connect to that database from MySql Workbench with the same URL and credentials, but not from W5. Browsing the the forums I've seen a few other possible troubles and how folks resolved it - yet nothing works fo rme :(
Auteur
Hello again, after talking to my hosting provider, the issue with the connectivity resolved. It was something with the White List at their side. Sorry for bothering you!
There's one more problem with the shopping cart : the Search... box is greyed out. I can filter by price or availability, but not by product name. Is there anything else I have to check? Thank you for you assistance!
"Hello again, after talking to my hosting provider, the issue with the connectivity resolved. It was something with the White List at their side. Sorry for bothering you!" - I'm glad your problem has been resolved.
"There's one more problem..." - Please link to the page with the problem. You can try different versions of PHP from 7.1 to 8.0.
Auteur
Hello Aleksej, here's the link to the product page of the website I'm trying to build using one of W5 templates. I was trying different browsers and still the Search... is disabled. Aloso, if you look at the Options checkboxes, the left sides are going too far beyond the left border and are partially cut off (see file attached). This wierd look appears on Chrome or Yandex, but it is all right if I use Firefox. It seems that I cannot change this shopping card layout, can I?
Thank you for your help!
https://cacticorner.ca/cartsearch/index.php?rootCategory=5xezfhao
It seems that you have something with styles.Have you added additional styles or any third-party scripts to the site?
Auteur
Hello Aleksej,
The only change I made for those pages was adding the script to hide the sticky bar because it was overlapping with the products listings. And you are right that it seems there's the problem with the style because once I unchecked "Use Template" the Search... starts working, but obviously the entire looks bad. Wierd!
Could you please advise how to change the style of the shopping cart other than editting the css directly? Many thanks!
<style>
#imStickyBarGraphics {
visibility: hidden;
overflow: hidden;
}
#imStickyBar {
visibility: hidden;
overflow: hidden;
}
</style>
Auteur
I meant how can I change the style of the Product Search page. Thx.
Auteur
If go to the Browser console and disable either the Inline Styled then the Product Seach... is ok. Where can I change the e-commerce style in W5? Also, if I hide the sticky bar then the Search box is working.
Hello Vladimir
All custom code, including the one that operates on the cart pages, can be inserted in the software in different places.
Step 1 -> Statistics and Code or Step 3 -> Page Properties. You can do so for the cart pages as well
Give it a try and let me know if it works
Thank you
Stefano
Auteur
Hello Stephano,
Nope, it doesn't help either way. The origin of the problem is that if the sticky bar is present, it overlaps the top of the e-commerce page(s) and partially hides the contents of the top of the page. I was searching your forums and found the advice to hide the sticky bar for the commerce pages only using style scripts as below. What happends in this is that the Search cursor position appears way down from the actual Field's x,y (see scrennshot attached).
So far it looks to me that hiding the sticky bar on the page not affecting the layout or the position of top of the Search box. Worse case scenario, I'll have rid of the sticky bar on the entire website. Obviously I don't want to do it. Any other suggestion? Thank you!
BTW, another trick I found is that my Header height was set to 0. Once I changed it to a greater than 0 the Search appeared working and I don't need this hiding the sticky bar script!
<style>
#imStickyBarGraphics {
visibility: hidden;
overflow: hidden;
}
#imStickyBar {
visibility: hidden;
overflow: hidden;
}
</style>
Hello Vladimir
I think the "tricks" you're using are currently your best choice. Hiding the stickybar would be the only alternative but I get that you do not want that
As of now, I believe the solution you adopted is the best in your case
Thank you
Stefano