1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    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...