Semi-failed sites import,
| Project: | Hosting |
| Version: | 5.x-0.2 |
| Component: | User interface |
| Category: | support request |
| Priority: | normal |
| Assigned: | hexag |
| Status: | postponed (maintainer needs more info) |
Jump to:
Hi,
For long & not very interesting reasons, I have a fresh install of Aegir 0.2 & want to import the sites from an earlier installation of 0.1. I copy the platform over and that installs fine into 0.2 & it also sees the sites which are to be imported, it puts them into the queue & then I get this error message...
warning: Invalid argument supplied for foreach() in /var/hostface/drupal-5/modules/node/node.module on line 561.
warning: implode(): Bad arguments. in /var/hostface/drupal-5/modules/node/node.module on line 565.
user warning: You have an error in your SQL syntax; check the manual that c... (Expand)user warning: 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 '' at line 1 query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in /var/hostface/drupal-5/includes/database.mysqli.inc on line 156.
An error occurred at function : drush_hosting_web_server_pre_hosting_task
The strange thing is that the vhost files are created & the sites work fine, but Aegir refuses to deal with them. Another clue is that the sites are not attached to either a database server or platform, those field are left blank. I can find no way of editing these fields to include the correct information.
System information...
Database schema Up to date
File system Writable (public download method)
GD library 2.0 or higher
MySQL database 5.0.51a
PHP 5.2.4-2ubuntu5.6
PHP register globals Disabled
Unicode library PHP Mbstring Extension
Web server Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.6 with Suhosin-Patch mod_ssl/2.2.8 OpenSSL/0.9.8g mod_perl/2.0.3 Perl/v5.8.8
cheers,
nick,

#1
Where is the error from? Can you paste the full task log please? See also http://groups.drupal.org/node/21890