Yetiforcecrm: [Question] Upgrade guide from 5.3 to 6.0

[ciberfox]

Hello,
I am having several problems updating from version 5.3 to version 6.0.

Specifically, I get several errors in updating some tables on the database.
is it possible to have a guide to update?

I downloaded the zip package and uploaded it to the admin interface. After the first checks the system freezes giving a problem on the management of autoincrements on a table.

Thanks a lot

[rioshaz]

@ciberfox i wont suggest you to upgrade as of now..

as 6.0 has serious issues.... scanners stops, workflows dont work, frequent log outs (6.1 updates fixes it but then edit fields dont work then u have to search forum & find a fix) .. leads status dont change in record preview list ,,, these are some which i have noticed... yet to find many more i guess...

does gives few new improvements but if scanner n wf dont work its no use...

[mariuszkrzaczkowski]

[ciberfox]

I get the following error, using the system update procedure. By uploading the 5.3.0_to_6.0.0_v3.zip file, after accepting the license you get the following

current installed version is 5.3.0 SP4 security update v1

SQLSTATE[HY000]: General error: 3780 Referencing column 'attachmentsid' and referenced column 'crmid' in foreign key constraint 'fk_1_vtiger_attachments' are incompatible. The SQL being executed was: ALTER TABLE vtiger_attachments CHANGE attachmentsid attachmentsid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;

[mariuszkrzaczkowski]

attach full update logs

[Andrew-W-Robinson]

I have the same error.

[mariuszkrzaczkowski]

You don't submit the required information so how we are supposed to help?

[ciberfox]

I will provide the log this evening so that I can snap the machine and perform the update procedure again.
Thanks for support

[Andrew-W-Robinson]

Upload Log.txt

I have uploaded version 6.0 and proceeded to accept terms, closed off all running crons and the update fails with the above error

[Andr198]

I have the same problem

updateLogsTrace.log
Importer.log
system.log

[ciberfox]

Hi I am attaching the log for the v5 update of the package.
I get the same error

updateLogsTrace.log
Importer.log
Thanks for support
Best Reguards

[ciberfox]

Hi, I tried using the v6 update. The same error always occurs

[Maxpeg]

SQLSTATE[HY000]: General error: 3780 Referencing column 'attachmentsid' and referenced column 'crmid' in foreign key constraint 'fk_1_vtiger_attachments' are incompatible. The SQL being executed was: ALTER TABLE vtiger_attachments CHANGE attachmentsid attachmentsid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;.

update.log
updateLogsTrace.log
errors.log

[rohanjhanepal]

@ciberfox i wont suggest you to upgrade as of now..

as 6.0 has serious issues.... scanners stops, workflows dont work, frequent log outs (6.1 updates fixes it but then edit fields dont work then u have to search forum & find a fix) .. leads status dont change in record preview list ,,, these are some which i have noticed... yet to find many more i guess...

does gives few new improvements but if scanner n wf dont work its no use...

how do i fix edit fields not working issue

[ciberfox]

@rohanjhanepal
yes, i know version 6.0 has several bugs, but it is possible to upgrade an environment in production.
The fix could be, delete the query from the update file but not then run into further problems.
I'm not the only one with this update error.

[Andr198]

Problem because we use Mysql
Foreing keys must be the same typr as the id they are referencing.

Еhere will be fixes or need to migrate to MariaDb ???

[mariuszkrzaczkowski]

@rohanjhanepal
The fix could be, delete the query from the update file but not then run into further problems.

I do not recommend

All your issues result from incorrect updates that YOU HAVEN'T FIXED but you keep using the CRM and keep blaming us!!!

[ERROR] SQLSTATE[HY000]: General error: 1833 Cannot change column 'attachmentsid': used in a foreign key constraint 'fk_2_vtiger_salesmanattachmentsrel' of table 'buco_crm1.vtiger_salesmanattachmentsrel'
The SQL being executed was: ALTER TABLE vtiger_attachments CHANGE attachmentsid attachmentsid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;|#0 /home/buco/domains/british-utilities.co.uk/public_html/crm1/vendor/yetiforce/yii2/db/Command.php(1295): yii\db\Schema->convertException(Object(PDOException), 'ALTER TABLE `vt...')

This issue only appears when the vtiger_salesmanattachmentsrel table exists. This table was removed in version 4.4.0, which means that the update from 4.3 to 4.4 was unsuccessful.

Another issue from the logs:

E_WARNING: file_put_contents(/home/yetiforce/html/cache/security/dependency.json): failed to open stream: Permission denied in /home/yetiforce/html/app/Security/Dependency.php, line 71

The error results from incorrect server configuration, not all parameters can be verified in Server configuration (ConfReport), we're trying to develop it but not everything is possible to verify.

Show me a screenshot from Software configuration > Logs > Updates

[ciberfox]

Hi, my system was installed starting from version 5.2. I am attaching the screen

[rskrzypczak]

YetiForce version 5.3 is not fully compatible with MySQL 8 (mainly because of yii2, which is not compatible with it.) and PHP7.4.
I advise against performing the update on this configuration.
If you insist, upload this patch https://github.com/yiisoft/yii2/commit/f1aaa0de89c017d58afbd565d3ec3529fad6b4ea which should fix the problem https://github.com/YetiForceCompany/YetiForceCRM/issues/13862#issuecomment-737387345, but take it at your own risk.

[Andr198]

Thank you. Рatch worked.

[Maxpeg]

Patch is really working!
Replace Schema.php in vendor/yetiforce/yii2/db/mysql with patched one.