I
Inaba
Guest
I'm having the same problem as the above poster ... anyone have an idea?
Originally posted by vesterman
Ok now I get an error in plesk
"MySQL query failed: Unknown column 'ownership' in 'field list'"
Can I use the same command but change to
mysql> ALTER TABLE clients ADD ownership VARCHAR(36);
Went ahead and did that and Horray! it works now!
thanks again for your excellent help on my issue phoenix!
Originally posted by eugenevdm
Be carefull vesterman. I did the same modification and yes sure now my Plesk is accessible. But I did a field comparison on a healthy Plesk upgrade and I found that 'ownership' is:
ENUM field, not VARCHAR, which takes 'true' and 'false' values. The default is 'true' and it is NOT NULL.
I'm not sure if you will ever experience a problem with this, unless you maybe start using Expand or some other integration product. Who Knows.
Originally posted by vesterman
mysql> ALTER TABLE clients DROP COLUMN uid;
Query OK, 3 rows affected (0.04 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql>
mysql> ALTER TABLE clients DROP COLUMN ownership;
Query OK, 3 rows affected (0.23 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> ALTER TABLE clients DROP COLUMN server_version;
Query OK, 3 rows affected (0.05 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql>
etc
Originally posted by eugenevdm
Just in case anyone else reads this post. I did some research and either vesterman is misquoting SWSoft or the SWSoft engineer was a bit sloppy. The fact:
The table clients does not contain a field server_version. The field server_version belongs to the table DatabaseServers.