1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

db schema 7.5.3 v 7.5.4

Discussion in 'Plesk for Linux - 8.x and Older' started by bluejohn, Nov 22, 2005.

  1. bluejohn

    bluejohn Guest

    0
     
    Can anybody tell me what the difference is between a v7.5.3 and v7.5.4 psa database?
    Can anybody send me his v7.5.4 schema?

    The problem is that after an upgrade the statistics are not working anymore: I get a unknown column configs in field list.
     
  2. rhekeren

    rhekeren Guest

    0
     
    Hi bluejohn,

    me too! :(
    "Unknown column 'configs' in 'field list'"

    Is anybody here who can tell me how to re-install the last (failed) update?

    Thx Ralf
     
  3. paco

    paco Guest

    0
     
    Same here...

    Same problem here, but started directly with 7.5.4 (w/o upgrading before). BTW: this happens only to one domain, all others are fine.

    Cheers,
    Paco
     
  4. rhekeren

    rhekeren Guest

    0
     
    Ok, here comes the solution for this problem:
    You have to add two columns in the table "disk_usage" (Database: psa)

    Update your table so that it looks like this:
    [​IMG]

    Regards, Ralf

    BTW: I cant believe, that nobody from SWSoft could help us to fix this Problem :(
     
  5. jcg76

    jcg76 Guest

    0
     
    alter table disk_usage isert column chroots bigint(20) unsigned null default "0";
    alter table disk_usage isert column configs bigint(20) unsigned null default "0";
     
  6. DiedX

    DiedX Guest

    0
     
    Via PHPMyAdmin it gave me the following query:

    ALTER TABLE `disk_usage` ADD `chroots` BIGINT( 20 ) UNSIGNED NULL DEFAULT '0',
    ADD `configs` BIGINT( 20 ) UNSIGNED NULL DEFAULT '0';
     
  7. Laurent Bauer

    Laurent Bauer Guest

    0
     
    Hello,

    Thanks for your help, I had the same problem.

    However, there is no 'S' in 'chroot', which gives the following alter command :

    ALTER TABLE `disk_usage` ADD `chroot` BIGINT( 20 ) UNSIGNED NULL DEFAULT '0',
    ADD `configs` BIGINT( 20 ) UNSIGNED NULL DEFAULT '0';

    Hope it helps.

    Laurent
     
  8. YetAnotherUser

    YetAnotherUser Guest

    0
     
    Hey guys,

    thank you so much for that hint. It works. I want to add some information for those not using phpMyAdmin like me and give them a quick summary.

    - log into your server via SSH
    - log into MySQL (and go to the database "psa")
    Code:
    mysql -u admin -p psa
    - view the table structure before doing changes
    Code:
    describe disk_usage;
    - table looks probably like this:
    Code:
    +-------------+---------------------+------+-----+---------+-------+
    | Field       | Type                | Null | Key | Default | Extra |
    +-------------+---------------------+------+-----+---------+-------+
    | dom_id      | int(10) unsigned    |      | PRI | 0       |       |
    | httpdocs    | bigint(20) unsigned | YES  |     | 0       |       |
    | httpsdocs   | bigint(20) unsigned | YES  |     | 0       |       |
    | subdomains  | bigint(20) unsigned | YES  |     | 0       |       |
    | web_users   | bigint(20) unsigned | YES  |     | 0       |       |
    | anonftp     | bigint(20) unsigned | YES  |     | 0       |       |
    | logs        | bigint(20) unsigned | YES  |     | 0       |       |
    | dbases      | bigint(20) unsigned | YES  |     | 0       |       |
    | mailboxes   | bigint(20) unsigned | YES  |     | 0       |       |
    | webapps     | bigint(20) unsigned | YES  |     | 0       |       |
    | maillists   | bigint(20) unsigned | YES  |     | 0       |       |
    | domaindumps | bigint(20) unsigned | YES  |     | 0       |       |
    +-------------+---------------------+------+-----+---------+-------+
    
    - now apply the changes by entering exactly:
    Code:
    ALTER TABLE `disk_usage` ADD `chroot` BIGINT(20) UNSIGNED NULL DEFAULT '0', ADD `configs` BIGINT(20) UNSIGNED NULL DEFAULT '0';
    - check the changes by entering again:
    Code:
    describe disk_usage;
    - table should now look like this (watch the last two lines)
    Code:
    +-------------+---------------------+------+-----+---------+-------+
    | Field       | Type                | Null | Key | Default | Extra |
    +-------------+---------------------+------+-----+---------+-------+
    | dom_id      | int(10) unsigned    |      | PRI | 0       |       |
    | httpdocs    | bigint(20) unsigned | YES  |     | 0       |       |
    | httpsdocs   | bigint(20) unsigned | YES  |     | 0       |       |
    | subdomains  | bigint(20) unsigned | YES  |     | 0       |       |
    | web_users   | bigint(20) unsigned | YES  |     | 0       |       |
    | anonftp     | bigint(20) unsigned | YES  |     | 0       |       |
    | logs        | bigint(20) unsigned | YES  |     | 0       |       |
    | dbases      | bigint(20) unsigned | YES  |     | 0       |       |
    | mailboxes   | bigint(20) unsigned | YES  |     | 0       |       |
    | webapps     | bigint(20) unsigned | YES  |     | 0       |       |
    | maillists   | bigint(20) unsigned | YES  |     | 0       |       |
    | domaindumps | bigint(20) unsigned | YES  |     | 0       |       |
    | chroot      | bigint(20) unsigned | YES  |     | 0       |       |
    | configs     | bigint(20) unsigned | YES  |     | 0       |       |
    +-------------+---------------------+------+-----+---------+-------+
    
    - now leave mysql (quit) and enter the following to run the statistics manually:
    Code:
    /usr/local/psa/admin/sbin/statistics
     
Loading...