Upgrade from 1.8 to 16.1.0.5

[grochap]

Hello,

I am trying to upgrade an older version with version 1.6, to the new
16.1.0.5.

We can perform the download and extract f new files, but while in
EGW/SETUP, the update of SQL data is giving this messages:

process->pass(): #1 for upgrade processing
process->upgrade(): Incoming : appname: api, version: 14.3.907, status: U
process->upgrade(): api(14.3.907 --> 16.1.005): running
api_upgrade14_3_907() --> 16.1
process->upgrade(): api(16.1 --> 16.1.005): running api_upgrade16_1()

AlterColumnSQL(‘egw_ea_accounts’,‘acc_folder_archive’,Array ( [type] =>
varchar [precision] => 128 [comment] => archive folder ) ) sql=Array ( [0]
=> ALTER TABLE egw_ea_accounts ADD acc_folder_archive VARCHAR(128) )

Duplicate column name ‘acc_folder_archive’
–> 16.1.001
process->upgrade(): api(16.1.001 --> 16.1.005): running
api_upgrade16_1_001() --> 16.1.002
process->upgrade(): api(16.1.002 --> 16.1.005): running
api_upgrade16_1_002() --> 16.1.003
process->upgrade(): api(16.1.003 --> 16.1.005): running
api_upgrade16_1_003() --> 16.1.004
process->upgrade(): api(16.1.004 --> 16.1.005): running
api_upgrade16_1_004()

Invalid SQL: SELECT fs_id,prop_namespace,prop_name,MAX(prop_id) AS prop_id
FROM egw_sqlfs_props
GROUP BY fs_id,prop_namespace,prop_name
HAVING COUNT(*) > 1
Unknown column ‘prop_id’ in ‘field list’ (1054)

May I need to adjust the SQL scripts?

best

• Guilherme Rocha*
  Research & Development
  Mobile: +55 71 99279 0829
  Phone: +55 11 4063 7533
  Web: http://gf7brasil.net

https://gf7brasil.net

https://br.linkedin.com/in/grochap

[RalfBecker]

Hi Guilherme,

Hello,

I am trying to upgrade an older version with version 1.6, to the new
16.1.0.5.

We can perform the download and extract f new files, but while in
EGW/SETUP, the update of SQL data is giving this messages:

process->pass(): #1 for upgrade processing
process->upgrade(): Incoming : appname: api, version: 14.3.907, status: U
process->upgrade(): api(14.3.907 --> 16.1.005): running
api_upgrade14_3_907() --> 16.1
process->upgrade(): api(16.1 --> 16.1.005): running api_upgrade16_1()

AlterColumnSQL(‘egw_ea_accounts’,‘acc_folder_archive’,Array ( [type]
=> varchar [precision] => 128 [comment] => archive folder ) )
sql=Array ( [0] => ALTER TABLE egw_ea_accounts ADD
acc_folder_archive VARCHAR(128) )

Duplicate column name ‘acc_folder_archive’

That one should be no problem, it means you already have the column and
can NOT create it therefore.*

–> 16.1.001
process->upgrade(): api(16.1.001 --> 16.1.005): running
api_upgrade16_1_001() --> 16.1.002
process->upgrade(): api(16.1.002 --> 16.1.005): running
api_upgrade16_1_002() --> 16.1.003
process->upgrade(): api(16.1.003 --> 16.1.005): running
api_upgrade16_1_003() --> 16.1.004
process->upgrade(): api(16.1.004 --> 16.1.005): running
api_upgrade16_1_004()
Invalid SQL: SELECT fs_id,prop_namespace,prop_name,MAX(prop_id) AS prop_id
FROM egw_sqlfs_props
GROUP BY fs_id,prop_namespace,prop_name
HAVING COUNT(*) > 1
Unknown column ‘prop_id’ in ‘field list’ (1054)

Same problem as an other one here on the list reported, see my comments
to thread “Upgrade to 16.1.005 prop_id”.

Ralf

May I need to adjust the SQL scripts?

best

Guilherme Rocha
Research & Development
Mobile: +55 71 99279 0829
Phone: +55 11 4063 7533
Web: http://gf7brasil.net

–
Ralf Becker
EGroupware GmbH [www.egroupware.org]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 631 31657-0