db schema 7.5.3 v 7.5.4

[bluejohn]

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.

 

[rhekeren]

Originally posted by bluejohn
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.

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

 

[paco]

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

 

[rhekeren]

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:

Regards, Ralf

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

 

[jcg76]

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";

 

[DiedX]

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';

 

[Laurent Bauer]

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

 

[YetAnotherUser]

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")

mysql -u admin -p psa

- view the table structure before doing changes

describe disk_usage;

- table looks probably like this:

+-------------+---------------------+------+-----+---------+-------+
| 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:

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:

describe disk_usage;

- table should now look like this (watch the last two lines)

+-------------+---------------------+------+-----+---------+-------+
| 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:

/usr/local/psa/admin/sbin/statistics