The case:

Main server: Ubuntu 14.04, Apache 2.4.7, PHP 5.5.9, MySQL 5.5.46, Drupal 7.41, Aegir 3.2, vanilla configuration with 'Remote import' module enabled.
Remote server: Debian Squeeze, Apache 2.2.16, PHP 5.3.3, MySQL 5.1.73, Drupal 6.35, Aegir 1.9, installed drush 'remote_import' module (version 6.x-1.x-dev).

When I try to list remote sites I get an error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':status' at line 1 query: SELECT sn.title as site, pn.title as platform FROM hosting_site hs INNER JOIN node sn ON hs.nid = sn.nid INNER JOIN hosting_platform hp ON hs.platform = hp.nid INNER JOIN node pn ON hp.nid = pn.nid WHERE hs.status = :status database.mysqli.inc:134

Full task log included as an attachment.

What is the problem?

CommentFileSizeAuthor
task.log_.txt7.68 KBDzieni
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Dzieni created an issue. See original summary.

Dzieni’s picture

Dzieni CreditAttribution: Dzieni commented
Issue summary: View changes

Added MySQL version.

gboudrias’s picture

gboudrias CreditAttribution: gboudrias commented

Sorry, it seems we haven't published a new version in a while, but you'll actually need either my or ergonlogic's patch on the Aegir3: https://www.drupal.org/node/2538788

Let me know if this fixes it.

Dzieni’s picture

Dzieni CreditAttribution: Dzieni commented

I have applied ergonlogic's patch and now I get this error:
Remote import only supports importing from Aegir 2 or Aegir 3 remotes. The API version received was: aegir_api: 1

Which is pretty logical when you look into the patched file.

So is it possible to import from Aegir 1.9? Should I modify the code to treat Aegir 1.9 the same way as Aegir 2?

gboudrias’s picture

gboudrias CreditAttribution: gboudrias commented

So is it possible to import from Aegir 1.9? Should I modify the code to treat Aegir 1.9 the same way as Aegir 2?

Probably worth a try, yes. If memory serves, the fundamentals used by remote import shouldn't have changed much.

helmo’s picture

helmo CreditAttribution: helmo at Initfour websolutions for Aegir Cooperative commented
Title: SQL error when trying to list remote sites » Import remote sites from 6.x-1.x
Version: 7.x-3.0 » 7.x-3.x-dev
Category: Support request » Feature request
Related issues: +#2538788: Make this module compatible with Aegir2