Categories
View Replies (25)

Resolved Google Shopping Export - couldn't connect to host

  1. batetim
    batetim
  2. RO CSVI
  3. Monday, 27 February 2017
  4.  Subscribe via email
Hi Tharuna/Roland

We have the below error message occuring which i wonder if you could point us in the direction of solving.

"Error - couldn't connect to host" when running export but i cant see that anything is wrong with template setup

I have attached a log file.

I am guessing this bit is the issue?

[QUERY] SELECT c.* FROM hal3m_virtuemart_calcs as c LEFT JOIN hal3m_virtuemart_calc_shoppergroups as cs ON cs.virtuemart_calc_id=c.virtuemart_calc_id WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' ) AND `published`="1" AND (`virtuemart_vendor_id`="1" OR `shared`="1" ) AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2017-02-27 17:46:00" ) AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2017-02-27 17:46:00" ) AND ( virtuemart_shoppergroup_id = 2 OR (virtuemart_shoppergroup_id) IS NULL)

Kind regards

Tim com_csvi.log.16.zip
0
Responses (25)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Tim,

Would you mind posting a screenshot of how the error shows itself?

Are you using the MySQLi driver as set in the global Joomla configuration?

My previous remark also still stands, does the hosting provider see any reason why this error shows? CSVI is not retrieving a large dataset at once but rather looping through them and requesting one record after the other.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 21
batetim
batetim
Accepted Answer Pending Moderation
Hi Roland

Yes same error with exporting just 5 lines.

VM product imports working fine though so imports connecting no problem with csvi.

Error come up pretty much straight away, but say three seconds in on an export with 500 lines on

Kind regards

Tim
  1. more than a month ago
  2. RO CSVI
  3. # 22
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Tim,

Assuming you get this error while running the export then it could be one of two reasons. Either it cannot connect to the server or it cannot connect to the database. My guess is that it loses the connection to the database. To verify that, do you get the same error when you export for example 5 products?

If there is no error, it would be something to check with the hosting provider if they can see any more details on why the connection would be lost. The other thing I wonder is, when it happens. Does it happen immediately or after running for a while?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 23
batetim
batetim
Accepted Answer Pending Moderation
Hi Tharuna

Unfortunately if you set template to download it produces same cannot connect to host error as attached log

Kind regards

Tim com_csvi.log.17.zip
Attachments (1)
com_csvi.log.17.zip
  1. more than a month ago
  2. RO CSVI
  3. # 24
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Tim,
The query should not be the problem. What i am thinking is you have set the file to Save on server path. That must be causing the issue. What if you set the Destination to Download, can you download the file?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 25
  • Page :
  • 1
  • 2


There are no replies made for this post yet.
Be one of the first to reply to this post!