Can anyone give me a clue as to what is wrong?

I've only just started learning drush, so help from experienced users much appreciated please.

Apologies in advance if I haven't selected the right version from the list or component.

I'm moving an old Drupal 5 site to Drupal 6 with a posgreSQL database.

The database is created, but there are no tables inside.

[root@delta drupal-6]# drush version

  drush version 4.5
</code
 
<code>
# Create Drupal 6 directory.
[root@delta~]

	mkdir /var/local/drupal-6

	pushd /var/local/drupal-6
	
	  # Download latest version of Drupal 6.
	  drush dl drupal-6.x

		Project drupal (6.x-dev) downloaded to /var/local/drupal-6/drupal-6.x-dev.       [success]
		Project drupal contains:                                                 	 [success]
		 - 1 profile: default
		 - 6 themes: marvin, chameleon, bluemarine, pushbutton, minnelli, garland
		 - 33 modules: node, color, help, locale, translation, tracker, ping, 
		    upload, syslog, statistics, taxonomy, throttle, user, php, search, 
		    path, dblog, book, openid, update, aggregator, block, forum, comment, 
		    filter, blog, trigger, contact, menu, blogapi, poll, profile, system
	popd

	pushd /var/local/drupal-6/drupal-6.x-dev

	  # Install 'finigan' site.
	  drush --debug site-install standard --sites-subdir=finigan --db-url=pgsql://shamrock:notused@localhost/finigan

	popd

-----------------------------------------

drush --debug site-install standard --sites-subdir=finigan --db-url=pgsql://shamrock:notused@localhost/finigan
Bootstrap to phase 0. [0.07 sec, 2.56 MB]                                                            [bootstrap]
Drush bootstrap phase : _drush_bootstrap_drush() [0.08 sec, 2.76 MB]                                 [bootstrap]
Bootstrap to phase 1. [0.2 sec, 5.83 MB]                                                             [bootstrap]
Drush bootstrap phase : _drush_bootstrap_drupal_root() [0.2 sec, 5.84 MB]                            [bootstrap]
Initialized Drupal 6.23-dev root directory at /var/local/drupal-6/drupal-6.x-dev [0.25 sec, 6.63 MB] [notice]
Found command: site-install (commandfile=core) [0.25 sec, 6.63 MB]                                   [bootstrap]
Initializing drush commandfile: user [0.26 sec, 6.63 MB]                                             [bootstrap]
You are about to create a sites/finigan/files directory and create a 
  sites/finigan/settings.php file and DROP your 'finigan' database and then 
  CREATE a new one. Do you want to continue? (y/n): y
Calling mkdir(sites/finigan) [3.03 sec, 6.65 MB]                                                     [debug]
Calling copy(sites/default/default.settings.php, sites/finigan/settings.php) [3.03 sec, 6.65 MB]     [debug]
Calling mkdir(sites/finigan/files) [3.04 sec, 6.66 MB]                                               [debug]
Drush bootstrap phase : _drush_bootstrap_drupal_site() [3.04 sec, 6.66 MB]                           [bootstrap]
Initialized Drupal site finigan at sites/finigan [3.04 sec, 6.66 MB]                                 [notice]
Drush bootstrap phase : _drush_bootstrap_drupal_configuration() [3.07 sec, 6.67 MB]                  [bootstrap]
Calling system(psql -q  --dbname=template1 --host=localhost --port=5432 
  --username=shamrock --no-align --field-separator='	' --pset footer=off --file /tmp/phpsZ62mC);
  Executing: php -r 'error_reporting(E_ERROR);$_GET=array("profile"=>"standard", 
  "locale"=>"en", "id"=>"1"); $_REQUEST=&$_GET;define("DRUSH_SITE_INSTALL6", TRUE);
  $_SERVER["SERVER_SOFTWARE"] = NULL;$_SERVER["SCRIPT_NAME"] = "/install.php";
  $_SERVER["HTTP_HOST"] = "finigan";$_SERVER["REMOTE_ADDR"] = "127.0.0.1";
  function _cli_cookie_print(){print(serialize(array(session_name()=>session_id())));}
register_shutdown_function("_cli_cookie_print"); include("/var/local/drupal-6/drupal-6.x-dev/install.php");'
  a:1:{s:36:"SESS04de73efd1630d660efd588e00d71d38";s:0:"";}
Drush bootstrap phase : _drush_bootstrap_drupal_database() [23.88 sec, 6.75 MB]                      [bootstrap]
Successfully connected to the Drupal database. [23.88 sec, 6.75 MB]                                  [bootstrap]
pg_query(): Query failed: ERROR:  relation "variable" does not exist                                 [warning]
LINE 1: SELECT value FROM variable WHERE name = 'install_task'
                          ^ database.pgsql.inc:138 [23.94 sec, 7.1 MB]
ERROR:  relation &quot;variable&quot; does not exist                                                 [warning]
LINE 1: SELECT value FROM variable WHERE name = &#039;install_task&#039;
                          ^
query: SELECT value FROM variable WHERE name = &#039;install_task&#039; 
  database.pgsql.inc:159 [23.94 sec, 7.11MB]
Undefined variable: result site_install_6.inc:125 [23.94 sec, 7.11 MB]                               [notice]
Executing: php -r '$_GET=array("profile"=>"standard", "locale"=>"en", "id"=>"1"); 
  $_REQUEST=&$_GET;define("DRUSH_SITE_INSTALL6", TRUE);$_SERVER["SERVER_SOFTWARE"] = NULL;
  $_SERVER["SCRIPT_NAME"] = "/install.php";$_SERVER["HTTP_HOST"] = "finigan";
  $_SERVER["REMOTE_ADDR"] = "127.0.0.1";
  $_COOKIE=unserialize("a:1:{s:36:\"SESS04de73efd1630d660efd588e00d71d38\";s:0:\"\";}"); 
  $_GET["op"]="start"; include("/var/local/drupal-6/drupal-6.x-dev/install.php");'
  PHP Warning:  require_once(./profiles/standard/standard.profile): 
  failed to open stream: No such file or directory in 
  /var/local/drupal-6/drupal-6.x-dev/install.php on line 94
  PHP Fatal error:  require_once(): Failed opening required 
  './profiles/standard/standard.profile' (include_path='.:/usr/share/pear:/usr/share/php') 
  in /var/local/drupal-6/drupal-6.x-dev/install.php on line 94
pg_query(): Query failed: ERROR:  relation "variable" does not exist                                 [warning]
LINE 1: SELECT value FROM variable WHERE name = 'install_task'
                          ^ database.pgsql.inc:138 [24.29 sec, 7.11 MB]
ERROR:  relation &quot;variable&quot; does not exist                                                 [warning]
LINE 1: SELECT value FROM variable WHERE name = &#039;install_task&#039;
                          ^
query: SELECT value FROM variable WHERE name = &#039;install_task&#039; 
  database.pgsql.inc:159 [24.3 sec, 7.11 MB]
Undefined variable: result site_install_6.inc:125 [24.3 sec, 7.11 MB]                                [notice]
The site install task '' failed. [24.3 sec, 7.11 MB]                                                 [error]
Command dispatch complete [24.31 sec, 7.08 MB]                                                       [notice]
 Timer  Cum (sec)  Count  Avg (msec) 
 page   21.23      1      21229.66   

Peak memory usage was 7.15 MB [24.31 sec, 7.08 MB]                                                   [memory]
[root@delta drupal-6.x-dev]# 

Comments

crimsondryad’s picture

It looks like you're downloading the D6 dev. I assume you want the release version, in which case using drush dl drupal-6.22 would be a better idea ( that's the latest stable version). I assume what is happening here is that because D7 is the recommended release that Drush is assuming you are asking for a dev for D6?

Please be careful posting the debug log....it just told the world what your custom db port is and the db user.

roychri’s picture

The problem is that you tried to use the profile "standard" and you should have used the profile "default".
Why?
Because drupal 7 comes with the profile called "standard" but Drupal 6 comes with the profile "default".

In fact, when you downloaded drupal using drush, you even saw that your download came with only one profile:

Project drupal contains:                                                 	 [success]
		 - 1 profile: default
jonhattan’s picture

Category: task » support
Status: Active » Fixed

As @roychri said, use profile "default" instead of "standard"

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

Anonymous’s picture

Issue summary: View changes

corrected typo