Jump to content
Froxlor Forum
  • 0
schnackel

Error by Update

Question

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

Share this post


Link to post
Share on other sites

15 answers to this question

Recommended Posts

  • 0

Well seems you have done the Database Updates already...how did you Update? 

Share this post


Link to post
Share on other sites
  • 0

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? 

Share this post


Link to post
Share on other sites
  • 0

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 final
Updating 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-rc1
Updating from 0.9.38-rc1 to 0.9.38-rc2
Updating from 0.9.38-rc2 to 0.9.38 final
Add Nginx http2 setting[OK]
Updating from 0.9.38 to 0.9.38.1
Updating from 0.9.38.1 to 0.9.38.2
Updating from 0.9.38.2 to 0.9.38.3
Updating 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.5
Updating from 0.9.38.5 to 0.9.38.6
Updating 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

 

Share this post


Link to post
Share on other sites
  • 0

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...

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites
  • 0

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?

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites
  • 0

No I cannot give you a howto, If it was that simple i couldve told you Here already. 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now




×