WebSite X5Help Center

 
Vladimir A.
Vladimir A.
User

Connection error: it is not possible to complete the operation  en

Autor: Vladimir A.
Visited 952, Followers 1, Udostępniony 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!

Posted on the
14 ODPOWIEDZI - 1 PRAWIDłOWA ODPOWIEDź
Vladimir A.
Vladimir A.
User
Autor

The user obviously has All Privileges to the database.

Czytaj więcej
Posted on the from Vladimir A.
Vladimir A.
Vladimir A.
User
Autor

The WEBSITE X5 MANAGER is showing MySql Db PASS. 

Czytaj więcej
Posted on the from Vladimir A.
Aleksej H.
Aleksej H.
Moderator

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.

Czytaj więcej
Posted on the from Aleksej H.
Vladimir A.
Vladimir A.
User
Autor

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 :(

Czytaj więcej
Posted on the from Vladimir A.
Vladimir A.
Vladimir A.
User
Autor

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!

Czytaj więcej
Posted on the from Vladimir A.
Aleksej H.
Aleksej H.
Moderator

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

Czytaj więcej
Posted on the from Aleksej H.
Vladimir A.
Vladimir A.
User
Autor

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

Czytaj więcej
Posted on the from Vladimir A.
Aleksej H.
Aleksej H.
Moderator

It seems that you have something with styles.Have you added additional styles or any third-party scripts to the site?

Czytaj więcej
Posted on the from Aleksej H.
Vladimir A.
Vladimir A.
User
Autor

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>

Czytaj więcej
Posted on the from Vladimir A.
Vladimir A.
Vladimir A.
User
Autor

I meant how can I change the style of the Product Search page. Thx.

Czytaj więcej
Posted on the from Vladimir A.
Vladimir A.
Vladimir A.
User
Autor

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.   

Czytaj więcej
Posted on the from Vladimir A.
Incomedia
Stefano G.
Incomedia

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

Czytaj więcej
Posted on the from Stefano G.
Vladimir A.
Vladimir A.
User
Autor

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>

Czytaj więcej
Posted on the from Vladimir A.
Incomedia
Stefano G.
Incomedia

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

Czytaj więcej
Posted on the from Stefano G.