Hello, I decided to upgrade my production ISPconfig. Before upgarde I had 3.0.5.4p9 version and I got a notification to make update. My server is Debian 8 and I write in shell command: ispconfig_update.sh. Update successfully but I have error on my ISP panel: Unknown column 'client.contact_firstname' in 'field list' and when I enter on site configuration I see: Unknown column 'ssl_letsencrypt' in 'field list'. Whats wrong? What Can I do? Best Regards
That's not how you update to 3.1.x. Download the latest version, unarchive it, cd to the install dir's. run: php -q update.php Follow the instructions that it prints.
Hello, I did as you wrote, it is the same. Strange situation because the main page does not even have the logo. From console: >> Update Operating System: Debian 8.0 (Jessie) or compatible This application will update ISPConfig 3 on your server. Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]: Creating backup of "/usr/local/ispconfig" directory... Creating backup of "/etc" directory... Checking ISPConfig database .. OK Starting incremental database update. Loading SQL patch file: /tmp/ISPConfig-3.1.1p1/ispconfig3_install/install/sql/incremental/upd_dev_collection.sql Reconfigure Permissions in master database? (yes,no) [no]: yes Service 'mail_server' has been detected (currently disabled) do you want to enable and configure it? (yes,no) [no]: Service 'web_server' has been detected (currently disabled) do you want to enable and configure it? (yes,no) [no]: yes Service 'firewall_server' has been detected (currently disabled) do you want to enable and configure it? (yes,no) [no]: Service 'db_server' has been detected (currently disabled) do you want to enable and configure it? (yes,no) [no]: Reconfigure Services? (yes,no,selected) [yes]: Configuring Pureftpd Configuring Apache Configuring vlogger Configuring Apps vhost Configuring Jailkit Configuring Database Updating ISPConfig ISPConfig Port [7992]: Create new ISPConfig SSL certificate (yes,no) [no]: Reconfigure Crontab? (yes,no) [yes]: Updating Crontab Restarting services ... Update finished. BTW I compare database with my other ISP and in my ISPconfig where is error I don't see 7 column on web_domain table and other table example xmpp. In my opinion update isp database not executed correctly. How rapair this?
I agree, it sounds like your database didn't get updated with new columns; I don't know why that'd happen. You can look at the schema in https://git.ispconfig.org/ispconfig/ispconfig3/blob/stable-3.1/install/sql/ispconfig3.sql and try to add the missing columns, or find the incremental updates under https://git.ispconfig.org/ispconfig/ispconfig3/tree/stable-3.1/install/sql/incremental and apply those (I think that is what the updater is supposed to do), or maybe try dumping the old database (without create table commands), recreate with correct schema, then load the sql dump.
I don't have the skills at the database level yet (Can hack them though). But have you also flushed your "browser cache" as Till keeps on saying after doing the upgrade?
