Update error..

[neoark]

I am getting following error:

Update failed

• 14:17:59 Can't connect to %s
• 14:16:59 Starting v3.7.1 download
• 14:16:59 Update needed, proceeding to download
• 14:16:59 Last available release is v3.7.1
• 14:16:57 Installed version is v3.7.0

 

[Rodolfo]

That means that js can't connect to your own server (/update). Try again and if keep saying that you will need to do a manual install.

 

[neoark]

Odd now i am getting:

SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'notification_trigger_user_id' doesn't exist in table

First is ask me drop triggers manually and than this error.

 

[Rodolfo]

Did you used the very first v3.7.0 which got deprecated?

 

[neoark]

Probably I updated if from a version before v.3.7.0.

 

[Rodolfo]

Nevermind, send me FTP and admin access to inbox@chevereto.com

 

[neoark]

I just followed https://chevereto.com/community/threads/v3-7-0-re-release-and-re-update-instructions.6889/ and then upgraded to 3.7.1. Is there an integrity check where to check?

 

[Rodolfo]

That is the best way to get rid of the "bad" v3.7.0 but only applies if you don't have likes, followers, etc. Basically, if you aren't in v3.7.0. In your case you will need to manually fix each missing column.

Like I said, send me access and I will do it for you.

 

[Rodolfo]

For the record, those with the index issue run this:

ALTER TABLE `chv_likes` ADD `like_content_user_id` bigint(32) DEFAULT NULL;
ALTER TABLE `chv_notifications` ADD `notification_trigger_user_id` bigint(32) DEFAULT NULL;

It happens only if you used the "bad" v3.7.0

 

[Tierri Lopes]

For the record, those with the index issue run this:

ALTER TABLE `chv_likes` ADD `like_content_user_id` bigint(32) DEFAULT NULL;
ALTER TABLE `chv_notifications` ADD `notification_trigger_user_id` bigint(32) DEFAULT NULL;

It happens only if you used the "bad" v3.7.0

Thank you alot! 100% fixed mine!