S
sfgreenwood
Guest
Hi -
We have a client running Plesk on an AWS instance. This may or may not relevant but it was originally set up with the internal domain name, which caused SSL to stop working properly. I have changed that to the external domain name using server_pref and I could then log in and create a initial user and domain, again using the external domain. However, when I added the details I got the following error:
Internal error: Specified column "role" is not in the row
in the /smb/ URL
In the error log, I get this:
2011-10-24T06:02:39-04:00 CRIT (2): Zend_Db_Table_Row_Exception: Specified column "role" is not in the row
file: /mnt/usr/local/psa/admin/plib/Zend/Db/Table/Row/Abstract.php
line: 182
code: 0
I found a post here from someone who had a similiar but not the same problem, and created the field in the smb_users table using
alter table smb_users add role longtext null;
which was pretty much guesswork. However I now get a 500 error from the page. The correct value in the field might fix it, so what should it be? I've also run /usr/local/psa/admin/sbin/autoinstaller --select-release-id PLESK_10_3_1 --upgrade-installed-components and that didn't make any difference.
I'm asking here because I can't find the exact same problem anywhere else. You'll notice that psa is on an /mnt partition which is an EBS device so I know it's a bit of odd installation but I can't see any reason why it shouldn't work.
TIA
Simon
We have a client running Plesk on an AWS instance. This may or may not relevant but it was originally set up with the internal domain name, which caused SSL to stop working properly. I have changed that to the external domain name using server_pref and I could then log in and create a initial user and domain, again using the external domain. However, when I added the details I got the following error:
Internal error: Specified column "role" is not in the row
in the /smb/ URL
In the error log, I get this:
2011-10-24T06:02:39-04:00 CRIT (2): Zend_Db_Table_Row_Exception: Specified column "role" is not in the row
file: /mnt/usr/local/psa/admin/plib/Zend/Db/Table/Row/Abstract.php
line: 182
code: 0
I found a post here from someone who had a similiar but not the same problem, and created the field in the smb_users table using
alter table smb_users add role longtext null;
which was pretty much guesswork. However I now get a 500 error from the page. The correct value in the field might fix it, so what should it be? I've also run /usr/local/psa/admin/sbin/autoinstaller --select-release-id PLESK_10_3_1 --upgrade-installed-components and that didn't make any difference.
I'm asking here because I can't find the exact same problem anywhere else. You'll notice that psa is on an /mnt partition which is an EBS device so I know it's a bit of odd installation but I can't see any reason why it shouldn't work.
TIA
Simon