Plesk 12.x / Linux :: Specified Column Name Is Not In The Row
Jun 14, 2014
When calling the new Wordpress Management Option from the 'Websites&Domains' page in Plesk (Version: 12.0.18 Update #4, OS: Ubuntu 12.04.4 LTS), the page that is supposed to show the list of Wordpress installations (/smb/wordpress/list) shows an error "Specified column "name" is not in the row".
Exact output:
Internal error: Specified column "name" is not in the row
MessageSpecified column "name" is not in the row
FileAbstract.php
Line179
TypeZend_Db_Table_Row_Exception​
I already tried bootstrapper repair without success. Other functions in Plesk seem to work, there are at least two Wordpress installation on the server (one through Plesk, one manual installation). How can I get rid of this error without risking my Plesk settings?
While accessing plesk it says "ERROR: PleskMainDBException: DB query failed: Unknown column 'description' in 'field list' (db.php:61)" , Plesk 12 windows server.
I am trying to install Magento on my apache server. I am running into the dreaded mcrypt issue as Magento needs it to run. I have now been googling for the past few hours and have gotten nowhere.
Here are my details:
Linux Centos 5.5 PHP 5.3.3 x86_64 Plesk 12
I have tried installing all sorts of different repos and it just isn't working.
When I try to install using # yum install php-mcrypt I get the following:
Loaded plugins: fastestmirror Package php-mysql is obsoleted by php-mysqlnd, trying to install php-mysqlnd-5.5.13-3.el5.remi.x86_64 instead --> Processing Dependency: php53-gd for package: psa-php53-configurator --> Processing Dependency: php53-imap for package: psa-php53-configurator
I always managed RHE/CentOS/Fedora servers with cPanel or just withouth any control panel, plain boxes. Now one of my customers need to have Plesk panel on a RHE 5 box.
My questions:
1.- Should I secure a Plesk server in the same way I do it for plain RHE servers?
2.- Where can I get optimization guides for plesk specific?
SymLinks are not possible in standard.I've opened Webserver settings and put into the fields "Additional directives for HTTP(S)" the following code:
Code:
<Directory /> Options FollowSymLinks </Directory> Does not work.
Code: Options +FollowSymLinks Does not work.
The settings were saved in the vhost.conf file, this file is included in the httpd.conf. I have manually restarted the httpd service, but no change. I cannot access my Symlink (403 forbidden).BUT, whats really misleading: When I create a .htaccess and put "Options +FollowSymLinks" in it, it works!Why I cannot enable it with these webserver options I made in /smb/web/web-server-settings/ -> Additional Apache directives ?
I have installed a version of php (v5.4). My Web run correctly before and now not. My web is Joomla 2.5. I recived this error:Fatal error: Class 'JConfig' not found in /var/www/vhosts/*********/httpdocs/includes/framework.php on line 56.
I've checked the firewall and FTP is allowed incoming, I added the passive ports to the firewall. Plesk shows the user in active connections, but when I connect to any domain I get an error that its not able to retrieve the directory. I am not sure if plesk just doesn't know what the directory is or if the main config messed up on the domain or sites level. I am running Plesk 12 on CentOS7.
I have a Plesk host that I am tasked with upgrading. It started with openSUSE 11.4 on Plesk 10.4 and I have upgraded it all the way to openSUSE 12.2 on Plesk 11.09 (fixed minor issues with pop3d and mysql locking on the way). The next upgrade was supposed to be 11.5, but the option to upgrade it never shows up. I have re-instated our support license so I know the license is OK, and also checked that 11.5 supports openSUSE 12.2. The update log doesn't really tell me much either:
Code:
Release PLESK_12_1_18 contains no any build for this OS Release PLESK_12_1_17 contains no any build for this OS Release PLESK_12_1_16 contains no any build for this OS Release PLESK_12_1_15 contains no any build for this OS Release PLESK_12_1_14 contains no any build for this OS
After installing a separate SSL to domain.com and www.domain.com, for some reason host.domain.com, which is the subdomain for plesk login, isn't being secured by FTP when choosing "Secure Plesk" after choosing the correct SSL. No error occurs, nor does the dashboard respond to it. It stays the same and unsecured. I tried rebooting server, restart services, etc.
I am unable to connect over TLS/SSL using my FTP client. I have ports 989 & 990 enabled in my server's firewall. My FTP client is attempting connection on port 990, but times out waiting for the server to respond. I also tried adding "TLSProtocol TLSv1" or "TLSProtocol SSLv3" to /etc/proftpd.conf, but get the same result, except that a non-TLS/SSL connection attempt then returns "server closed the connection".
Since yesterday I can't connect to any of my ftp clients.For months I could login to my FTP using Coda and Filezilla and everything worked until yesterday.
Coda gives me this message: Error -203: miscellaneous error occurred while trying to login to the host
Filezilla gives me this message: Antwoord:220 ProFTPD 1.3.5 Server (ProFTPD) [MYSERVERIP] Opdracht:USER username (username is my ftp username) Antwoord:550 SSL/TLS required on the control channel
I have not changed anything on my server. Just out of the blue this errors appears and now my customers and I can't login anymore.I tried to restart the server, made a new ftp account..I don't know if I can reinstall the ProFTPD or need to open port 21?
I can not connect to the server with using "Require explicit FTP over TLS"
In /etc/proftpd.conf I have added from here [URL] ....:
<IfModule mod_tls.c> TLSEngine on TLSLog /var/log/tls.log TLSProtocol SSLv23
[Code]....
PS: in Tools & Settings ->SSL Certificates ->I created a new self-signed certificate, set as default. In Tools & Settings ->IP Adress bind new certificate to IP
For each domain is created own certificate, but when try to connect, will be ascked to confirm a default certificate from Plesk I have create a new certificate (using SSH)
Service restarted too with: service sw-cp-server restart
Moving sites from other servers into a Plesk 12 environment (Centos 6.5) I cannot see a way to set cgi-bin in the webspace root directory instead of document root (httpdocs). In previous Plesk CGI support allowed selection of cgi-bin location.
Code: mysql> SELECT * FROM dom_param WHERE dom_id=x; (where x is the dom_id of my domain) shows the cgi_bin_mode param has val www-root but no change to system/<domain>/httpd.conf.
Relocating cgi-bin to httpdocs/cgi-bin is not an option - some of these sites are development environments where I cannot move cgi-bin on the live environment and some of the scripts use relative paths.
I set a new Plesk 12 server (Debian 7.8) and migrate some domains from a plesk 11.0.9 server.After this, FTP does not work. I can connect but I receive this error:
Error:The data connection could not be established: ETIMEDOUT - Connection attempt timed out..And no list of folder or files found. Not one domain, any domain.I restart xinetd and fil2ban but still same problem. Via control panel I can see the files but not via FTP.
Recently I configured parallels 12.x on Linode Cloud with cent OS. Using DNS Settings I added 'A' record (abc.example.com) as abc and point to IP. But the record is not propagated after 24-48hrs.
