Problem with billing module after update rev-9 to rev-27 "Unknown column 'gender' in 'field list"

Discussion in 'ISPConfig 3 Priority Support' started by radim_h, Mar 14, 2017.

  1. radim_h

    radim_h Member HowtoForge Supporter

    Hello,
    i have updated clients ISPconfig to 3.1 and also billingmodule to rev-27
    Now when i want change proforma into regular invoice
    - menu proforma invoices
    - selecting proforma
    - clicked on green arrow
    - Make new invoice based on proforma invoice
    -Next Save & Finalize Invoice

    im getting error "Unknown column 'gender' in 'field list'" as here
    https://www.dropbox.com/s/f1ubutzw0sko230/Screenshot 2017-03-14 20.12.28.png?dl=0

    Can you help me fix this please ?
    Regards
    R.Hejc
     
    radim_h, Mar 14, 2017
    #1
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Seems as if one of the ispconfig sql updates or a billing sql update could not be applied. Take a look into the ispconfig database with phpmyadmin. Is there are column named "gender" in the table 'client' and is there a column named 'gender' in the table 'invoice'?
     
    till, Mar 15, 2017
    #2
  3. radim_h

    radim_h Member HowtoForge Supporter

    radim_h, Mar 15, 2017
    #3
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Ok, so the gender field in client table is there and it is just missing in the invoice table?

    In the billing module zip file is a file:

    sql/incremental/upd_0018.sql

    Please import this sql file with phpmyadmin into the dbispconfig database.
     
    till, Mar 15, 2017
    #4
  5. radim_h

    radim_h Member HowtoForge Supporter

    Hello,
    it seems thay have fu*ked their db in past.
    Now i'm getting
    ALTER TABLE `invoice_item_template_custom_field` ADD `plugin` VARCHAR(255) NOT NULL AFTER `type`;
    Table 'dbispconfig.invoice_item_template_custom_field' doesn't exist
     
    radim_h, Mar 15, 2017
    #5
  6. radim_h

    radim_h Member HowtoForge Supporter

    Now when i try to create invoice i'm getting
    Unknown column 'status_irrecoverable' in 'field list'
     
    radim_h, Mar 15, 2017
    #6
  7. radim_h

    radim_h Member HowtoForge Supporter

    What about install clean plugin somehow and import existing data ?
     
    radim_h, Mar 15, 2017
    #7
  8. radim_h

    radim_h Member HowtoForge Supporter

    dont i have to apply all updates after 018 ?
     
    radim_h, Mar 15, 2017
    #8
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    Please import the increemental files from upd_0019.sql to upd_0028.sql with phpmyadmin. Maybe the mysql root password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf was not correct at the time the billing update was installed so that the database update failed.
     
    till, Mar 15, 2017
    #9
  10. radim_h

    radim_h Member HowtoForge Supporter

    Thank you for help.
    As there was invoice_settings revnum = 9 , i had to go manually with all updates from upd_0010.sql
    It seems working Ok now.
     
    radim_h, Mar 15, 2017
    #10

Share This Page