1

Topic: Unable to update from spider-v1.1.0 to v2.2.0

spider-v1.1.0-linux-amd64

when updating to v2.2.0  from v1.1.0 I get no error on the update script but unable to load the web ui after update
check the log file and get

2023-05-03 15:53:14 ERROR [SQL] Failed in updating sql schema: 2, SQL logic error: no such table: smtp (1)
2023-05-03 15:53:14 ERROR failed in initializing events db: failed in initializing event database: SQL logic error: no such table: smtp (1)

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Stable release is out.

2

Re: Unable to update from spider-v1.1.0 to v2.2.0

Hi JamesBon,

Could you please try the latest v2.3.0 instead?
We will check the v2.2.0 issue and come back later.

3

Re: Unable to update from spider-v1.1.0 to v2.2.0

Turns out it's a bug of jumping upgrade. If you upgrade to each newer release, e.g. v1.1.0 -> 2.0.0 -> 2.1.0 -> 2.2.0 -> 2.3.0, then no such error. But it should work fine if you restart spiderd service.

We have to re-think about automatic SQL update. Stay tuned.