[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Dolibarr-dev] Travis upgrade 3.6.0 to 3.7.0
From: |
Frédéric FRANCE |
Subject: |
Re: [Dolibarr-dev] Travis upgrade 3.6.0 to 3.7.0 |
Date: |
Mon, 30 Jun 2014 18:45:24 +0200 |
User-agent: |
Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.6.0 |
Hello
In file 3.6.0-3.7.0 I suggest these corrections
this line
ALTER TABLE llx_accountingaccount add column tms timestamp DEFAULT NULL
AFTER datec;
replace with
ALTER TABLE llx_accountingaccount add column tms timestamp AFTER datec;
add this line (field name changed in 3.6)
ALTER TABLE llx_accountingdebcred CHANGE COLUMN fk_account
account_number varchar(32)
before
ALTER TABLE llx_accountingdebcred MODIFY COLUMN account_number varchar(32);
these 2 lines
ALTER TABLE llx_c_product MODIFY COLUMN accountancy_code_sell varchar(32);
ALTER TABLE llx_c_product MODIFY COLUMN accountancy_code_buy varchar(32);
replace with:
ALTER TABLE llx_product MODIFY COLUMN accountancy_code_sell varchar(32);
ALTER TABLE llx_product MODIFY COLUMN accountancy_code_buy varchar(32);
Fred
Le 30/06/2014 11:01, Frédéric FRANCE a écrit :
> Hello
> And my problem in upgrade 3.6.0.to 3.7.0 is :
>
> <!-- Start of log output
>
> 2014-06-30 08:21:14 upgrade: Entering upgrade.php page<br>
>
> 2014-06-30 08:21:14 DoliDBMysqli::connect host=localhost, port=,
> login=travis, passwd=--hidden--, name=<br>
>
> 2014-06-30 08:21:14 DoliDBMysqli::select_db database=myapp_test<br>
>
> 2014-06-30 08:21:14 upgrade: Server connection : localhost OK<br>
>
> 2014-06-30 08:21:14 upgrade: Database connection successfull : myapp_test<br>
>
> 2014-06-30 08:21:14 upgrade: Database server version :
> 5.5.35-0ubuntu0.12.04.2-log<br>
>
> 2014-06-30 08:21:14 DoliDBMysqli::DDLDescTable DESC llx_categorie_association
> <br>
>
> 2014-06-30 08:21:14 upgrade: search duplicate sql=SELECT fk_categorie_mere,
> fk_categorie_fille FROM llx_categorie_association<br>
>
> 2014-06-30 08:21:14 upgrade: result is num=2 count(couples)=2<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql run sql file
> mysql/migration/3.6.0-3.7.0.sql silent=0 entity= usesavepoint=1 handler=
> okerror=default<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 1 sql=ALTER TABLE
> llx_c_paiement ADD COLUMN accountancy_code varchar(32) DEFAULT NULL AFTER
> active;<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 2 sql=ALTER TABLE llx_propal
> ADD COLUMN currency_rate double(24,8) DEFAULT 1 AFTER fk_currency;<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 3 sql=ALTER TABLE llx_commande
> ADD COLUMN currency_rate double(24,8) DEFAULT 1 AFTER fk_currency;<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 4 sql=ALTER TABLE llx_facture
> ADD COLUMN currency_rate double(24,8) DEFAULT 1 AFTER fk_currency;<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 5 sql=ALTER TABLE
> llx_commande_fournisseur ADD COLUMN fk_account integer AFTER
> date_livraison;<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 6 sql=ALTER TABLE
> llx_commande_fournisseur ADD COLUMN fk_currency varchar(3) AFTER
> fk_account;<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 7 sql=ALTER TABLE
> llx_commande_fournisseur ADD COLUMN currency_rate double(24,8) DEFAULT 1
> AFTER fk_currency;<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 8 sql=ALTER TABLE
> llx_facture_fourn ADD COLUMN fk_account integer AFTER fk_projet;<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 9 sql=ALTER TABLE
> llx_facture_fourn ADD COLUMN fk_currency varchar(3) AFTER fk_account;<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 10 sql=ALTER TABLE
> llx_facture_fourn ADD COLUMN currency_rate double(24,8) DEFAULT 1 AFTER
> fk_currency;<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 11 sql=ALTER TABLE
> llx_accountingaccount add column entity integer DEFAULT 1 NOT NULL AFTER
> rowid;<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 12 sql=ALTER TABLE
> llx_accountingaccount add column datec datetime NOT NULL AFTER entity;<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 13 sql=ALTER TABLE
> llx_accountingaccount add column tms timestamp DEFAULT NULL AFTER datec;<br>
>
> 2014-06-30 08:21:14 DoliDBMysqli::query SQL error: ALTER TABLE
> llx_accountingaccount add column tms timestamp DEFAULT NULL AFTER datec;
> DB_ERROR_1067<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 13 Error DB_ERROR_1067 ALTER
> TABLE llx_accountingaccount add column tms timestamp DEFAULT NULL AFTER
> datec;<br>Invalid default value for 'tms'<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 14 sql=ALTER TABLE
> llx_accountingaccount add column fk_user_author integer DEFAULT NULL AFTER
> label;<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 15 sql=ALTER TABLE
> llx_accountingaccount add column fk_user_modif integer DEFAULT NULL AFTER
> fk_user_author;<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 16 sql=DROP TABLE
> llx_compta;<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 17 sql=DROP TABLE
> llx_compta_account;<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 18 sql=DROP TABLE
> llx_compta_compte_generaux;<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 19 sql=ALTER TABLE
> llx_accountingaccount MODIFY COLUMN account_number varchar(32);<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 20 sql=ALTER TABLE
> llx_accountingaccount MODIFY COLUMN account_parent varchar(32);<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 21 sql=ALTER TABLE
> llx_accountingdebcred MODIFY COLUMN account_number varchar(32);<br>
>
> 2014-06-30 08:21:14 DoliDBMysqli::query SQL error: ALTER TABLE
> llx_accountingdebcred MODIFY COLUMN account_number varchar(32);
> DB_ERROR_NOSUCHFIELD<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 22 sql=ALTER TABLE
> llx_bank_account MODIFY COLUMN account_number varchar(32);<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 23 sql=ALTER TABLE
> llx_c_chargesociales MODIFY COLUMN accountancy_code varchar(32);<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 24 sql=ALTER TABLE
> llx_c_revenuestamp MODIFY COLUMN accountancy_code_sell varchar(32);<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 25 sql=ALTER TABLE
> llx_c_revenuestamp MODIFY COLUMN accountancy_code_buy varchar(32);<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 26 sql=ALTER TABLE llx_c_tva
> MODIFY COLUMN accountancy_code_sell varchar(32);<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 27 sql=ALTER TABLE llx_c_tva
> MODIFY COLUMN accountancy_code_buy varchar(32);<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 28 sql=ALTER TABLE
> llx_c_product MODIFY COLUMN accountancy_code_sell varchar(32);<br>
>
> 2014-06-30 08:21:14 DoliDBMysqli::query SQL error: ALTER TABLE llx_c_product
> MODIFY COLUMN accountancy_code_sell varchar(32); DB_ERROR_NOSUCHTABLE<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 29 sql=ALTER TABLE
> llx_c_product MODIFY COLUMN accountancy_code_buy varchar(32);<br>
>
> 2014-06-30 08:21:14 DoliDBMysqli::query SQL error: ALTER TABLE llx_c_product
> MODIFY COLUMN accountancy_code_buy varchar(32); DB_ERROR_NOSUCHTABLE<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 30 sql=ALTER TABLE llx_user
> MODIFY COLUMN accountancy_code varchar(32);<br>
>
> 2014-06-30 08:21:14 Admin.lib::run_sql Request 31 sql=ALTER TABLE
> llx_bank_account ADD COLUMN accountancy_journal varchar(3) DEFAULT NULL AFTER
> account_number;<br>
>
> 2014-06-30 08:21:14 Exit 1<br>
>
> End of log output -->
>
>
> With best regards
> Fred
>
>
> Le 30/06/2014 10:53, Frédéric FRANCE a écrit :
>> Hello all
>> Can someone add in .travis.yml :
>> - php upgrade.php 3.6.0 3.7.0 >> upgrade.log
>> - php upgrade2.php 3.6.0 3.7.0 >> upgrade2.log
>> and modify the line with phphcs to:
>> - phpcs --warning-severity=0 -s -p --extensions=php --report-checkstyle
>> --report-summary --standard=dev/codesniffer/ruleset.xml --tab-width=4
>> --ignore=/build/html/,/documents/,/includes/,/test/report/ .
>>
>> With -p phphcs sends log output and if it take more than 10min it will
>> continue
>>
>> Thank's
>> Fred
>>
>> _______________________________________________
>> Dolibarr-dev mailing list
>> address@hidden
>> https://lists.nongnu.org/mailman/listinfo/dolibarr-dev
>
> _______________________________________________
> Dolibarr-dev mailing list
> address@hidden
> https://lists.nongnu.org/mailman/listinfo/dolibarr-dev