Yetiforcecrm: Error Upgrade 4.3.0 to 4.4.0

[rezeyle1]

When trying to install 4.3.0_to_4.4.0_PreInstall.zip I get the following error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'shareduserid' in 'field list' Failed to prepare SQL: INSERT INTO vtiger_tmp_read_group_sharing_per (userid, tabid, shareduserid) VALUES (:qp0, :qp1, :qp2)

[vovpff]

@rezeyle1 what php ver?

[rezeyle1]

:~# php -v
PHP 7.1.20-1+0~20180725103315.2+stretch~1.gbpd5b650 (cli) (built: Jul 25 2018 10:33:20) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.1.0, Copyright (c) 1998-2018 Zend Technologies
with Zend OPcache v7.1.20-1+0~20180725103315.2+stretch~1.gbpd5b650, Copyright (c) 1999-2018, by Zend Technologies

[rezeyle1]

php -v

PHP 7.1.20

[rezeyle1]

There now appears ERROR 500

[rezeyle1]

I searched the Yetiforce logs and found the following error:

[06-Sep-2018 11:12:12 America/Sao_Paulo] PHP Notice: Undefined index: ldap in /var/www/html/.../modules/Users/authmethods/Ldap.php on line 37
[06-Sep-2018 11:12:13 America/Sao_Paulo] PHP Notice: Undefined index: sectorField in /var/www/html/.../modules/Vtiger/models/ChartFilter.php on line 230
[06-Sep-2018 11:12:18 America/Sao_Paulo] PHP Notice: Undefined index: X-POWERED-BY in /var/www/html/.../Settings/ConfReport/models/Module.php on line 383
[06-Sep-2018 11:12:18 America/Sao_Paulo] PHP Notice: Undefined index: X-POWERED-BY in /var/www/html/.../Settings/ConfReport/models/Module.php on line 389
[06-Sep-2018 11:12:18 America/Sao_Paulo] PHP Notice: Undefined index: SERVER in /var/www/html/.../modules/Settings/ConfReport/models/Module.php on line 391
[06-Sep-2018 11:12:35 America/Sao_Paulo] PHP Warning: unlink(/var/www/html/.../cache/templates_c): Is a directory in /var/www/html/.../.../.../vtlib/Vtiger/Functions.php on line 620
[06-Sep-2018 11:12:47 America/Sao_Paulo] PHP Notice: Undefined index: sectorField in /var/www/html/.../modules/Vtiger/models/ChartFilter.php on line 230

The part that is /.../ was a change I made for security reasons. The rest is exactly as shown in the logs.

[rezeyle1]

Would anyone have any idea what that might be ?
@vovpff @vctrin @majkel89 @joebordes @Raggazzoo

[mariuszkrzaczkowski]

Check the table structure if it matches the one in the file:
https://github.com/YetiForceCompany/YetiForceCRM/blob/22601181e761ff8d35b584da982e35d06c415e86/install/install_schema/scheme.sql#L8858-L8865
If it is not, it means that you have to manually improve it, you will have to check the whole database or something is missing.

[rezeyle1]

I apologize for my ignorance, but how do I do this? Where do I start? Any tips?

I use phpmyadmin to open the db ... if you can give me a light on how I make this adjustment?

[rezeyle1]

Yes, as you asked me to check ... everything is correct.

And now what could it be?

I'd love to be able to make this update

@vovpff @mariuszkrzaczkowski @vctrin @majkel89

[rezeyle1]

Check the table structure if it matches the one in the file:
YetiForceCRM/install/install_schema/scheme.sql

Lines 8858 to 8865 in 2260118

CREATE TABLE vtiger_tmp_read_group_sharing_per (
userid int(10) NOT NULL,
tabid smallint(5) NOT NULL,
sharedgroupid int(10) NOT NULL,
PRIMARY KEY (userid,tabid,sharedgroupid),
KEY tmp_read_group_sharing_per_userid_sharedgroupid_idx (userid,sharedgroupid),
CONSTRAINT fk_3_vtiger_tmp_read_group_sharing_per FOREIGN KEY (userid) REFERENCES vtiger_users (id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

If it is not, it means that you have to manually improve it, you will have to check the whole database or something is missing.

What to do to solve ???

[vovpff]

Run sql code what published by @mariuszkrzaczkowski

[rezeyle1]

Run sql code what published by @mariuszkrzaczkowski

I already did this, the problem continues

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'shareduserid' in 'field list' Failed to prepare SQL: INSERT INTO vtiger_tmp_read_group_sharing_per (userid, tabid, shareduserid) VALUES (:qp0, :qp1, :qp2)

[rezeyle1]

Can someone help me please?

[mariuszkrzaczkowski]

before the update remove the advanced rules in the configuration of permissions and after the update add them
https://gitdeveloper.yetiforce.com/index.php?module=SharingAccess&parent=Settings&view=Index&block=1&fieldid=5

[rezeyle1]

@mariuszkrzaczkowski you are a genius! It was assertive ... on the fly! Problem solved!!! I am extremely grateful to you, @bpabiszczak, @vovpff, and to the whole community ... in what I can do also to help ... I make myself available. Hug.