WebSite X5Help Center

 
Vladimir A.
Vladimir A.
User

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

Autor: Vladimir A.
Visitado 939, Followers 1, Compartido 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!

Publicado en
14 RESPUESTAS - 1 CORRECTO
Vladimir A.
Vladimir A.
User
Autor

The user obviously has All Privileges to the database.

Leer más
Publicado en de Vladimir A.
Vladimir A.
Vladimir A.
User
Autor

The WEBSITE X5 MANAGER is showing MySql Db PASS. 

Leer más
Publicado en de 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.

Leer más
Publicado en de 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 :(

Leer más
Publicado en de 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!

Leer más
Publicado en de 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.

Leer más
Publicado en de 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

Leer más
Publicado en de 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?

Leer más
Publicado en de 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>

Leer más
Publicado en de Vladimir A.
Vladimir A.
Vladimir A.
User
Autor

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

Leer más
Publicado en de 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.   

Leer más
Publicado en de 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

Leer más
Publicado en de 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>

Leer más
Publicado en de 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

Leer más
Publicado en de Stefano G.