1. Forum
  2. Usenet
  3. LINUX.DEBIAN.BUGS.DIST

  • Bug#265210: drupal: db structure not updated (missing throttle in syste

    From Erik Steffl@1:229/2 to All on Thu Aug 12 09:30:10 2004
    From: [email protected]

    Package: drupal
    Version: 4.4.2-1
    Severity: important

    after upgrading drupal (several times, I didn't check) it ended up with outdated database even though I asked it to update db automatically (no errors).

    I've got following errors:

    user error: Unknown column 'throttle' in 'field list'
    query: UPDATE blocks ...

    this was fixed by following the drupal upgrade instructions:

    http://enzyme.org.nz/update.php

    ALTER TABLE system ADD throttle tinyint(1) NOT NULL DEFAULT '0';
    ALTER TABLE system ADD bootstrap int(2);

    user error: Unknown column 'headers' in 'field list'
    query: SELECT data, created, headers FROM cache WHERE ...

    didn't find any info about this one ((yet).

    erik


    -- System Information:
    Debian Release: 3.1
    APT prefers unstable
    APT policy: (500, 'unstable')
    Architecture: i386 (i686)
    Kernel: Linux 2.6.5
    Locale: LANG=C, LC_CTYPE=C

    Versions of packages drupal depends on:
    ii apache2 2.0.50-7 Next generation, scalable, extenda ii apache2-mpm-prefork [apache2] 2.0.50-8 Traditional model for Apache2
    ii debconf 1.4.30 Debian configuration management sy ii makepasswd 1.10-2 Generate and encrypt passwords
    ii mysql-client 4.0.20-9 mysql database client binaries
    ii php4-cgi 4:4.3.8-3 A server-side, HTML-embedded scrip ii php4-mysql 4:4.3.8-5 MySQL module for php4
    ii php4-pear 4:4.3.8-4 PEAR - PHP Extension and Applicati ii postfix [mail-transport-agent 2.1.4-4 A high-performance mail transport ii postgresql-client 7.4.3-3 Front-end programs for PostgreSQL ii wwwconfig-common 0.0.36 Debian web auto configuration

    -- debconf information:
    drupal/createuser_failed:
    * drupal/db_auto_update: true
    drupal/dropdb_failed:
    drupal/upgradedb_impossible:
    * drupal/dbgeneration: false
    * drupal/dbtype: MySQL
    * drupal/database_doremove: false
    drupal/upgradedb_failed:
    * drupal/dbuser: drupal
    drupal/conffile_failed:
    * drupal/remove_backups: true
    drupal/createdb_failed:
    * drupal/dbserver: localhost
    * drupal/webserver: apache-ssl, apache2
    * drupal/dbname: drupal
    drupal/dbadmin: root
    drupal/initdb_failed:


    --
    To UNSUBSCRIBE, email to [email protected]
    with a subject of "unsubscribe". Trouble? Contact [email protected]

    --- SoupGate-Win32 v1.05
    * Origin: you cannot sedate... all the things you hate (1:229/2)
  • From Hilko Bengen@1:229/2 to Erik Steffl on Thu Aug 12 17:00:13 2004
    From: [email protected]

    Erik Steffl <[email protected]> writes:

    Package: drupal
    Version: 4.4.2-1
    Severity: important

    after upgrading drupal (several times, I didn't check) it ended up
    with outdated database even though I asked it to update db
    automatically (no errors).

    Can you reproduce the problem? What database are you using? MySQL or PostgreSQL?

    -Hilko


    --
    To UNSUBSCRIBE, email to [email protected]
    with a subject of "unsubscribe". Trouble? Contact [email protected]

    --- SoupGate-Win32 v1.05
    * Origin: you cannot sedate... all the things you hate (1:229/2)
  • From Erik Steffl@1:229/2 to Hilko Bengen on Thu Aug 12 18:30:17 2004
    From: [email protected]

    Hilko Bengen wrote:
    Erik Steffl <[email protected]> writes:


    Package: drupal
    Version: 4.4.2-1
    Severity: important

    after upgrading drupal (several times, I didn't check) it ended up
    with outdated database even though I asked it to update db
    automatically (no errors).


    Can you reproduce the problem? What database are you using? MySQL or PostgreSQL?

    mysql,

    I cannot reproduce it anymore because I fixed it (I compared the
    database structure to the one in file
    /usr/share/drupal/database/database.mysql and changed mine to match that
    file), there were few other changes. I saved the old db structure so I
    can provide that if you want (it's fairly big so I don't want to send it
    to bug, I guess you can get that from previous version of drupal package).

    To reproduce the problem one would have to install old drupal, not
    sure which version, I installed drupal on 2004/04/24 and at that time it
    worked so I guess my old db structure was from the version that was in
    unstable at that time.

    erik


    --
    To UNSUBSCRIBE, email to [email protected]
    with a subject of "unsubscribe". Trouble? Contact [email protected]

    --- SoupGate-Win32 v1.05
    * Origin: you cannot sedate... all the things you hate (1:229/2)