• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

db schema 7.5.3 v 7.5.4

B

bluejohn

Guest
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.
 
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
 
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
 
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:
disk_usage.jpg


Regards, Ralf

BTW: I cant believe, that nobody from SWSoft could help us to fix this Problem :(
 
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";
 
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';
 
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
 
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
 
Back
Top