problems with upgrading and year change

Questions on subjects not related to other forums (installing on other hostings, etc.). DigitaldDruid.Net staff will not answer here.

Moderator: marco

Post Reply
brittasa
Posts: 2
Joined: Mon Jun 22, 2009 5:50 pm

problems with upgrading and year change

Post by brittasa »

Hi,
I am using php-residence 1.1 since two years and I have got the following problem:
when I try to upgrade the program, all the reservations in the overview table would disappear. All other data like client data stays undamaged.
The same happend last year when the systems changed from 2009 to 2010.
Last year it was a lot of work to reconstruct all the future reservations of 2010, now I would like to avoid this to happen again.
Do you have any idea why this problem occured?
Thank you for help!
Kind regards,
Britta
brittasa
Posts: 2
Joined: Mon Jun 22, 2009 5:50 pm

Re: problems with upgrading and year change

Post by brittasa »

this is the errormessage with upgrading to the actual version:

ERROR IN: alter table clienti add column soprannome varchar(70)
1060: Duplicate column name 'soprannome'

ERROR IN: alter table clienti add column partita_iva varchar(50)
1060: Duplicate column name 'partita_iva'

ERROR IN: alter table clienti add column doc_inviati text
1060: Duplicate column name 'doc_inviati'

ERROR IN: create table relclienti (idclienti integer, numero integer, tipo varchar(12), testo1 text, testo2 text, testo3 text, testo4 text, testo5 text, testo6 text, testo7 text, testo8 text, datainserimento datetime, hostinserimento varchar(50), utente_inserimento integer )
1050: Table 'relclienti' already exists

ERROR IN: alter table regole2008 add column motivazione2 text
1060: Duplicate column name 'motivazione2'

ERROR IN: alter table regole2009 add column motivazione2 text
1060: Duplicate column name 'motivazione2'

ERROR IN: alter table messaggi add column stato varchar(8)
1060: Duplicate column name 'stato'

ERROR IN: create table cache (numero integer, tipo varchar(8), testo mediumtext )
1050: Table 'cache' already exists

ERROR IN: insert into prenota2010 select idprenota,idclienti,idappartamenti,iddatainizio,iddatafine,assegnazioneapp,app_assegnabili,num_persone,idprenota_compagna,tariffa,tariffesettimanali,incompatibilita,sconto,tariffa_tot,caparra,commissioni,tasseperc,pagato,metodo_pagamento,codice,origine,commento,conferma,checkin,checkout,id_anni_prec,datainserimento,hostinserimento,data_modifica,utente_inserimento from pren2010
1054: Unknown column 'incompatibilita' in 'field list'
Post Reply