search

Mibew / mibew

Mibew Messenger - open-source live support application
https://mibew.org
Other
473 stars 204 forks source link

How to use built-in update tool? #189

Closed everyx closed 7 years ago

everyx commented 7 years ago

I just follow this document in Mibew sIte: Installation and update, and when I backup, unzip new file then restore files and correct all rights, I visit http:///mibew/update/ and I got this error:

Query failed: Unknown column 'initialized' in 'field list'

and I found that:

Mibew starting from 2.0.0-beta.1 version can be updated to later versions using built-in update tool.

so how can I update 2.1.2 to 2.1.22.2.0 using built-in update tool? I can't find the tool in the dashboard.

faf commented 7 years ago

To begin with, what version of Mibew Messenger are you trying to update?

(And BTW, the actual version of Mibew Messenger is 2.2.0.)

everyx commented 7 years ago

@faf Sorry about the wrong description above, I just correct it. My current version is 2.1.2 and I want to update 2.2.0. thanks

snewell92 commented 7 years ago

Have you navigated to {{YOUR_DOMAIN_NAME_HERE}}/mibew/index.php/operator/about and clicked the "Check for available updates" link?

snewell92 commented 7 years ago

Well actually, maybe disregard my comment. It seems you tried to manually update and are now getting an error, correct? I think the built-in update tool is on that about page (correct me if I'm wrong). That error is probably related to something else, possibly a migration the built in tool may have done for you, but since you manually got new sources that new version expects the database to be in a certain state and it isn't in that state (ie, no initialized column)?

everyx commented 7 years ago

Yes, I found the link and it works correctly, but I can't find some way to click and upgrade automatically, so, the build in update tool is just a new version check tool?

2017年3月3日 下午11:05，"snewell92" notifications@github.com写道：

Have you navigated to https://blinky.charmsoffice.com/mibew/index.php/operator/about https://blinky.charmsoffice.com/mibew/index.php/operator/about and clicked the "Check for available updates" link?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/Mibew/mibew/issues/189#issuecomment-283977204, or mute the thread https://github.com/notifications/unsubscribe-auth/ABlp8m20ArSw-wnyIstcBvjOLoCQncwlks5riCwCgaJpZM4MMvwl .

snewell92 commented 7 years ago

I'll do some digging, I believe a CronJob using that CronKey is what might be needed. The code here seems to have the capacity to apply updates, but maybe it needs to be triggered by that cronjob.

I'll let you know what I find (I remember reading somewhere about how to set up this cronjob...)

everyx commented 7 years ago

Maybe the only upgrade way is manually update, I try manually update and got an error, it's looks like a database problem, but I can't sure actually. And I found the document said have a built-in upgrade tool, so I think maybe I can use it to update my current Mibew, but maybe it just a checking tool.

2017年3月3日 下午11:07，"snewell92" notifications@github.com写道：

Well actually, maybe disregard my comment. It seems you tried to manually update and are now getting an error, correct? I think the built-in update tool is on that about page (correct me if I'm wrong). That error is probably related to something else, possibly a migration the built in tool may have done for you, but now your database doesn't?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/Mibew/mibew/issues/189#issuecomment-283977899, or mute the thread https://github.com/notifications/unsubscribe-auth/ABlp8k8JqQdD2px-hRSNtrO9_EY_q8zcks5riCycgaJpZM4MMvwl .

snewell92 commented 7 years ago

I think you did it correctly. You seem to have followed the instructions from the readme.

UPDATE

  1. Backup your actual installation (i.e. code and database).
  2. Delete all items in your Mibew Messenger directory on the server.
  3. Unpack the archive with the official distrubition in that directory.
  4. Remove install.php file.
  5. Restore configuration (configs/ directory), plugins (plugins/ directory), (maybe) custom styles (if you have any), (maybe) additional locales (if you use any), and avatars (files/avatar/ directory) from the backup you've made at the step 1.
  6. Visit http:////update and follow the instructions to update the database tables (if needed).

That last step says to update the database tables if needed. I wonder how we're supposed to know what to do there? Maybe there's some information somewhere.

snewell92 commented 7 years ago

I'm not a dev of mibew, just another programmer + server-admin - so maybe wait for a mibew dev to shed some light. Sorry I couldn't be more helpful.

everyx commented 7 years ago

That last step says to update the database tables if needed. I wonder how we're supposed to know what to do there? Maybe there's some information somewhere.

Yes, I can't find how to upgrade my datebase, maybe it should update automally when I visit <MIBEW-SITE>/update.

I'm not a dev of mibew, just another programmer + server-admin - so maybe wait for a mibew dev to shed some light. Sorry I couldn't be more helpful.

Thanks @snewell92 :)

faf commented 7 years ago

At the moment Mibew Messenger can check for updates (either manually - if one uses the link 'Check for available updates' on the 'About' page, or automatically - by cron), and upgrade your database if needed (once you've visited <MIBEW-SITE>/update page and confirm the upgrade as it is written in documentation).

However, it can not automatically download and apply updates to your code. At least for now.

@everyx , Are you sure you've visited the <MIBEW-SITE>/update page and have got the error?

everyx commented 7 years ago

@faf Yes, I use SSL over my site, and vist https://<MIBEW-SITE>/update got the error bellow:

Query failed: Unknown column 'initialized' in 'field list'

but the version 2.1.2 is works as expected.

My server environment:

user@host$ mysql -V
mysql  Ver 14.14 Distrib 5.5.53, for debian-linux-gnu (x86_64) using readline 6.3

user@host$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 14.04.5 LTS
Release:        14.04
Codename:       trusty
faf commented 7 years ago

@everyx I have one suspicion... Do you have any plugins installed? And if so, could you disable all of them before replacing the code and trying to update the database?

everyx commented 7 years ago

@faf Yes, I have installed some plugin, and I'll have a try, thanks :)

faf commented 7 years ago

@everyx Please, provide feedback afterwards. It's really important issue.

everyx commented 7 years ago

@faf OK, I'll have a try in this sunday and will leave the result in here, thanks :)

everyx commented 7 years ago

@faf I just have a test with this follow steps:

  1. disable all plugins
  2. backup files and database
  3. remove all mibew files
  4. download and unzip mibew
  5. change owner and permission
  6. restore all files and data
  7. visit /mibew/update and follow the instructions in the page
  8. everything is works ok

so, I think we should improve the document, add disable all plugin before update