schnackel Posted February 10, 2018 Share Posted February 10, 2018 Hello, I get the following error by update to 0.9.39. Can you help me please 42S21 SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'fpmsettingid' File: /lib/classes/database/class.Database.php:181 My installed version is 0.9.38.8 Link to comment Share on other sites More sharing options...
d00p Posted February 10, 2018 Share Posted February 10, 2018 Well seems you have done the Database Updates already...how did you Update? Link to comment Share on other sites More sharing options...
schnackel Posted February 10, 2018 Author Share Posted February 10, 2018 I took this guide. https://github.com/Froxlor/Froxlor/wiki/Updating-Froxlor But i don't come into the admin panel. I have to do the update again and again. Link to comment Share on other sites More sharing options...
d00p Posted February 10, 2018 Share Posted February 10, 2018 well of course, due to the sql error you cannot finish the update. If you really followed the guide, then just restore your DB backup and and try again. Are you sure you were on 0.9.38.8 stable before? Link to comment Share on other sites More sharing options...
schnackel Posted February 10, 2018 Author Share Posted February 10, 2018 Now i restored the database and update again. I currently have installed 0.9.24 The update is sucess to 0.9.38.8 Updating Log Spoiler Updating from 0.9.24 to 0.9.25-rc1[OK] Updating from 0.9.25-rc1 to 0.9.25[OK] Updating from 0.9.25 to 0.9.26-svn1[OK] Updating from 0.9.26-svn1 to 0.9.26-rc1[OK] Updating from 0.9.26-rc1 to 0.9.26[OK] Updating from 0.9.26 to 0.9.27-svn1[OK] Updating from 0.9.27-svn1 to 0.9.27-svn2[OK] Updating from 0.9.27-svn2 to 0.9.27-rc1[OK] Updating from 0.9.27-rc1 to 0.9.27[OK] Updating from 0.9.27 to 0.9.28-svn1[OK] Updating from 0.9.28-svn1 to 0.9.28-svn2[OK] Sorry, but I don't know the ISO-639 language code for Array. Please update the entry in `panel_languages` manually. Sorry, but I don't know the ISO-639 language code for Array. Please update the entry in `panel_languages` manually. Sorry, but I don't know the ISO-639 language code for Array. Please update the entry in `panel_languages` manually. Sorry, but I don't know the ISO-639 language code for Array. Please update the entry in `panel_languages` manually. Sorry, but I don't know the ISO-639 language code for Array. Please update the entry in `panel_languages` manually. Sorry, but I don't know the ISO-639 language code for Array. Please update the entry in `panel_languages` manually. Sorry, but I don't know the ISO-639 language code for Array. Please update the entry in `panel_languages` manually. Sorry, but I don't know the ISO-639 language code for Array. Please update the entry in `panel_languages` manually. Sorry, but I don't know the ISO-639 language code for Array. Please update the entry in `panel_languages` manually. Sorry, but I don't know the ISO-639 language code for Array. Please update the entry in `panel_languages` manually. Sorry, but I don't know the ISO-639 language code for Array. Please update the entry in `panel_languages` manually. Sorry, but I don't know the ISO-639 language code for Array. Please update the entry in `panel_languages` manually. Sorry, but I don't know the ISO-639 language code for Array. Please update the entry in `panel_languages` manually. Sorry, but I don't know the ISO-639 language code for Array. Please update the entry in `panel_languages` manually. Sorry, but I don't know the ISO-639 language code for Array. Please update the entry in `panel_languages` manually. Sorry, but I don't know the ISO-639 language code for Array. Please update the entry in `panel_languages` manually. Sorry, but I don't know the ISO-639 language code for Array. Please update the entry in `panel_languages` manually. Updating from 0.9.28-svn2 to 0.9.28-svn3[OK] Adding default Maildir value into Mailserver settings.Updating from 0.9.28-svn3 to 0.9.28-svn4[OK] Setting replacement for the discontinued and removed Classic theme (if active)[OK] Altering Froxlor database and tables to use UTF-8. This may take a while..[OK] Updating from 0.9.28-svn4 to 0.9.28-svn5Enabling catchall by default[OK] Updating from 0.9.28-svn5 to 0.9.28-svn6[OK] Setting value for apache-2.4 modification[OK] Inserting new tickets-see-all field to panel_admins[OK] Updating main admin entry[OK] Inserting new panel webfont-settings (default: off)[OK] Inserting settings for nginx fastcgi-params file[OK] Updating from 0.9.28-svn6 to 0.9.28 release candidate 1[OK] Updating from 0.9.28-rc1 to 0.9.28-rc2[OK] Adding new settings for using domain name as default value for DocumentRoot path[OK] Updating from 0.9.28-rc2 to 0.9.28 final[OK] Updating from 0.9.28 final to 0.9.28.1[OK] Updating from 0.9.28.1 to 0.9.29-dev1[OK] Setting value for "hide standard subdomains"[OK] Updating from 0.9.29-dev1 to 0.9.29-dev2[OK] Inserting new setting to allow/disallow theme changes (default: on)[OK] Updating from 0.9.29-dev2 to 0.9.29-dev3[OK] Inserting new setting for AXFR server[OK] Updating from 0.9.29-dev3 to 0.9.29-dev4[OK] Adding new tables to database[OK] Updating from 0.9.29-dev4 to 0.9.29-rc1[OK] correcting Maildir setting database-field-name (if needed).[OK] setting default php-configuration for php-fpm[OK] Updating from 0.9.29-rc1 to 0.9.29 final[OK] Updating from 0.9.29 to 0.9.29.1-dev1[OK] Adding new ip to domain - mapping-table[OK] Convert old domain to ip - mappings[OK] Updating table layouts[OK] Updating from 0.9.29.1-dev1 to 0.9.29.1-dev2[OK] Updating table layouts and contents[OK] Updating from 0.9.29.1-dev2 to 0.9.29.1-dev3[OK] Removing old logrotate settings[OK] Updating from 0.9.29.1-dev3 to 0.9.29.1-dev4[OK] Removing old billing-field from admin-users[OK] Updating from 0.9.29.1-dev4 to 0.9.30-dev1[OK] Updating from 0.9.30-dev1 to 0.9.30-rc1[OK] Updating from 0.9.30-rc1 to 0.9.30 final[OK] Adding ssl-cipher-list setting[OK] Updating from 0.9.30 to 0.9.31-dev1[OK] Removing unsused tables[OK] Updating from 0.9.31-dev1 to 0.9.31-dev2[OK] Adding new phpfpm-ipcdir setting[OK] Updating from 0.9.31-dev2 to 0.9.31-dev3[OK] Updating from 0.9.31-dev3 to 0.9.31-dev4[OK] Adding new panel_activation table[OK] Updating from 0.9.31-dev4 to 0.9.31-dev5[OK] Adding new error-reporting options[OK] Updating from 0.9.31-dev5 to 0.9.31-dev6[OK] Adding new fpm-configuration options (slowlog)[OK] Updating from 0.9.31-dev6 to 0.9.31-rc1[OK] Updating from 0.9.31-rc1 to 0.9.31-rc2[OK] Adding new news-feed option[OK] Updating from 0.9.31-rc2 to 0.9.31-rc3[OK] Adding new php-config for froxlor-vhost[OK] Updating from 0.9.31-rc3 to 0.9.31 final[OK] Updating from 0.9.31 to 0.9.31.1 final[OK] Updating from 0.9.31.1 to 0.9.31.2 final[OK] Updating from 0.9.31.2 to 0.9.32-dev1[OK] Removing APS-module (deprecated)[OK] Removing backup-module (deprecated)[OK] Removing autoresponder-module (deprecated)[OK] Updating ftp-groups entries[OK] Updating from 0.9.32-dev1 to 0.9.32-dev2[OK] Adding mailserver - settings for traffic analysis[OK] Updating from 0.9.32-dev2 to 0.9.32-dev3[OK] Updating froxlor - theme[OK] Updating from 0.9.32-dev3 to 0.9.32-dev4[OK] Adding new FTP-description field[OK] Updating from 0.9.32-dev4 to 0.9.32-dev5[OK] Updating cronjob table[OK] Adding new settings for cron[OK]Updating from 0.9.32-dev5 to 0.9.32-dev6 Adding new settings for cron-daemon reload command[OK]Updating from 0.9.32-dev6 to 0.9.32-rc1 Enhancing tasks-table[OK]Updating from 0.9.32-rc1 to 0.9.32-rc2 Removing autoresponder-cronjob (deprecated)[OK] Adding new settings for cron[OK] Removing backup-module ftp-users (deprecated)[OK]Updating from 0.9.32-rc2 to 0.9.32-rc3 Removing outdated languages[OK]Updating from 0.9.32-rc3 to 0.9.32 finalUpdating from 0.9.32 to 0.9.33-dev1 Adding settings for custom newsfeed on customer-dashboard[OK]Updating from 0.9.33-dev1 to 0.9.33-dev2 Adding settings for hostname-dns-entry[OK]Updating from 0.9.33-dev2 to 0.9.33-dev3 Adding settings for password-generation options[OK] Adding settings for fpm-apache2.4-mod_proxy integration[OK]Updating from 0.9.33-dev3 to 0.9.33-rc1 Updating database-scheme[OK] Removing old settings[OK] Adding local froxlor group to customer groups[not needed]Updating from 0.9.33-rc1 to 0.9.33-rc2 Add new setting for sending cron-errors via mail[OK] Add new custom-notes field for admins and customer[OK] Updating table structure of admins and customers[OK] Updating from 0.9.33-rc2 to 0.9.33-rc3[OK] Updating from 0.9.33-rc3 to 0.9.33 final[OK] Updating from 0.9.33 to 0.9.33.1[OK] Updating from 0.9.33.1 to 0.9.33.2[OK]Updating from 0.9.33.2 to 0.9.34-dev1 Updating table structure of domains[OK] Updating stored email-templates[not needed] Updating language descriptions to be in the native language[OK]Updating from 0.9.34-dev1 to 0.9.34-dev2 Adding new settings for apache-itk-mpm[OK] Increase text-field size of domain-ssl table[OK]Updating from 0.9.34-dev2 to 0.9.34-dev3 Checking for required PHP mbstring-extension[OK]Updating from 0.9.34-dev3 to 0.9.34-dev4 Adding field umask to phpconfig table[OK] Updating from 0.9.34-dev4 to 0.9.34 final[OK] Updating from 0.9.34 to 0.9.34.1[OK] Updating from 0.9.34.1 to 0.9.34.2[OK]Updating from 0.9.34.2 to 0.9.35-dev1 Adding Let's Encrypt - certificate fieldsAdding new cron-module for Let's encrypt[OK]Updating from 0.9.35-dev1 to 0.9.35-dev2 Adding Let's Encrypt - settings[OK]Updating from 0.9.35-dev2 to 0.9.35-dev3 Adding new domain fields for Let's Encrypt[OK]Updating from 0.9.35-dev3 to 0.9.35-dev4 Removing unused setting "Send cron-errors to froxlor-admin via e-mail"[OK]Updating from 0.9.35-dev4 to 0.9.35-dev5 Adding more Let's Encrypt settings[OK]Updating from 0.9.35-dev5 to 0.9.35-dev6 Adding new panel_vhostconfigs table[OK] Adding new fields to panel_domains table[OK]Updating from 0.9.35-dev6 to 0.9.35-dev7 Adding a new field to the panel_vhostconfigs table[OK] Updating from 0.9.35-dev7 to 0.9.35-rc1[OK] Removing unused table and fields from database[OK] Adding new setting to enable/disable Let's Encrypt[OK] Adding new php.ini directive to php-configurations: opcache.restrict_api[OK] Updating from 0.9.35-rc1 to 0.9.35 final[OK] Updating from 0.9.35 to 0.9.35.1[OK] Adding new backup settings and cron[OK] Updating from 0.9.35.1 to 0.9.36 final[OK] Adding new dns related tables and settings[OK] Adjusting SPF record setting[OK] Adding new dns-server setting[OK] Adding new dns-editor setting for customers[OK] Changing tables to be more mysql strict-mode compatible[OK] Adding new setting for mod_php users to specify content of the global directory options file[OK]Updating from 0.9.36 to 0.9.37-rc1 Adding new setting to hide certain options in customer panel[OK]Updating from 0.9.37-rc1 to 0.9.37 final Adding new settings for customer shell option[OK] Adding new settings to use Let's Encrypt for froxlor[OK] Adding new settings for acme.conf (Let's Encrypt)[OK] Adding new SMTP settings for emails sent by froxlor[OK] Changing tables to be more mysql strict-mode compatible[OK] Add HSTS settings for froxlor-vhost[OK] Settings HSTS default values for all domains (deactivated)[OK]Updating from 0.9.37 to 0.9.38-rc1Updating from 0.9.38-rc1 to 0.9.38-rc2Updating from 0.9.38-rc2 to 0.9.38 final Add Nginx http2 setting[OK]Updating from 0.9.38 to 0.9.38.1Updating from 0.9.38.1 to 0.9.38.2Updating from 0.9.38.2 to 0.9.38.3Updating from 0.9.38.3 to 0.9.38.4 Updating database table definition for panel_domains[OK] Adding field for let's-encrypt registration status[OK] Adding system setting for let's-encrypt registration status[OK] Adding unique key to ipsandports table[OK]Updating from 0.9.38.4 to 0.9.38.5Updating from 0.9.38.5 to 0.9.38.6Updating from 0.9.38.6 to 0.9.38.7 Adding field for OCSP stapling[OK] Adding default setting for Apache 2.4 OCSP cache path[OK] Adding new setting for libnss-extrausers[OK] Updating HTTP2 setting[OK] Adding domain field for HTTP2 stapling[OK] Adding new 'disable LE self-check' setting[OK]Updating from 0.9.38.7 to 0.9.38.8 Adding field for fpm-daemon configs[OK] Adding new fpm-daemons table[OK] Converting php-fpm settings to new layout A database error occurred SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'idle_timeout' cannot be null Link to comment Share on other sites More sharing options...
d00p Posted February 10, 2018 Share Posted February 10, 2018 hm, question is why is your setting phpfpm.idle_timeout null, this cannot be. This setting surely did not exist on 0.9.24 and i just checked and it gets added for 0.9.27-svn1 and is definetly not null. I'm not sure how to be able to help you there now... Link to comment Share on other sites More sharing options...
schnackel Posted February 10, 2018 Author Share Posted February 10, 2018 ok if you say it is not in 24 included and comes with 27. In the update prozess i update to 27 and higher to 38 Can i make any changes in the database manually ? I can now press back and run it again the i get the error from post 1 Link to comment Share on other sites More sharing options...
d00p Posted February 10, 2018 Share Posted February 10, 2018 Nonono, froxlor does all the Updates. Thats Not the Problem. And dont Press Back and try again, you will have a broken Database - half updated. I really cant understand why the value of the setting should ne null...works for.many Other people. Just to be Sure, can you Check whether your MySQL Runs ins Strictmode ans deactivate that? Link to comment Share on other sites More sharing options...
schnackel Posted February 10, 2018 Author Share Posted February 10, 2018 how to check that? Link to comment Share on other sites More sharing options...
d00p Posted February 10, 2018 Share Posted February 10, 2018 Please Just Google it Link to comment Share on other sites More sharing options...
schnackel Posted February 10, 2018 Author Share Posted February 10, 2018 please look at the screen Link to comment Share on other sites More sharing options...
d00p Posted February 10, 2018 Share Posted February 10, 2018 Sorry, no idea then. as said, the value IS SET, why it reads it as NULL is pretty weird. If you want I can offer to fix that for you temporarily so you can update, if you want to PM me your server details Link to comment Share on other sites More sharing options...
schnackel Posted February 10, 2018 Author Share Posted February 10, 2018 Sorry i can not give you my server details. Can u give me an how to to fix it by myself? Or can i update to 38 stable ? Edit: I sucessfully update now to 0.9.38.1 Now i try to update to the latest Link to comment Share on other sites More sharing options...
d00p Posted February 10, 2018 Share Posted February 10, 2018 No I cannot give you a howto, If it was that simple i couldve told you Here already. Link to comment Share on other sites More sharing options...
schnackel Posted February 10, 2018 Author Share Posted February 10, 2018 From 0.9.38.1 i could successfully update to 0.9.39.1 Link to comment Share on other sites More sharing options...
d00p Posted February 11, 2018 Share Posted February 11, 2018 weird, but great have fun with the latest froxlor Link to comment Share on other sites More sharing options...
Question
schnackel
Hello,
I get the following error by update to 0.9.39.
Can you help me please
42S21 SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'fpmsettingid'
File: /lib/classes/database/class.Database.php:181
My installed version is 0.9.38.8
Link to comment
Share on other sites
15 answers to this question
Recommended Posts
Archived
This topic is now archived and is closed to further replies.