Solution to missing database field UniqueNotification.hash in 2.59.0

More
10 months 3 weeks ago - 10 months 3 weeks ago #147200 by olle
olle created the topic: Solution to missing database field UniqueNotification.hash in 2.59.0
Hi,

I'm sorry to say a bug crept in in version 2.59.0, where a missing database field UniqueNotification.hash can't be found. This problem is fixed in 2.59.1.

If you have a clean install, you can just download the latest release: www.limesurvey.org/downloads/category/25-latest-stable-release

Regards
Olle
Last Edit: 10 months 3 weeks ago by olle.
The following user(s) said Thank You: mutandon

Please Log in to join the conversation.

More
10 months 3 weeks ago - 10 months 3 weeks ago #147201 by olle
olle replied the topic: Solution to missing database field UniqueNotification.hash in 2.59.0
If you need to apply a manual patch, you can copy these two files from master to upgrade to 2.59.1:

application/helpers/update/updatedb_helper.php: raw.githubusercontent.com/LimeSurvey/Lim.../updatedb_helper.php

application/config/version.php: raw.githubusercontent.com/LimeSurvey/Lim...n/config/version.php

Please let me know if you need any further assistance.
Last Edit: 10 months 3 weeks ago by olle.

Please Log in to join the conversation.

More
10 months 3 weeks ago #147202 by LouisGac
LouisGac replied the topic: Solution to missing database field UniqueNotification.hash in 2.59.0
olle, maybe you should provide a patch: a zip file that users just have to extract in the root of their installation.

Please Log in to join the conversation.

More
10 months 3 weeks ago #147208 by jck
jck replied the topic: Solution to missing database field UniqueNotification.hash in 2.59.0
Thanks Olle for this solution. Only problem that I now have is that the system says there is a new security update available but when i use ComfortUpdate it gives the error that it didn't find a build-version. How can i solve this. Thank you for the help!

Machiel

Please Log in to join the conversation.

More
10 months 3 weeks ago #147210 by olle
olle replied the topic: Solution to missing database field UniqueNotification.hash in 2.59.0
Hi Machiel,

We will provide a second version of the patch that will fix this.

Olle
The following user(s) said Thank You: mutandon

Please Log in to join the conversation.

More
10 months 3 weeks ago #147214 by olle
olle replied the topic: Solution to missing database field UniqueNotification.hash in 2.59.0
Hi,

Here's a patch that lets you manually update from 2.59.0 to 2.59.1. It might be necessary to apply if you have problems. Just extract it in your root folder.

NOTE: THIS PATCH WILL ONLY WORK FROM VERSION 2.59.0 TO 2.59.1.

File Attachment:

File Name: limesurvey...0116.zip
File Size:1,009 KB


Regards
Olle
Attachments:

Please Log in to join the conversation.

More
10 months 3 weeks ago #147292 by jck
jck replied the topic: Solution to missing database field UniqueNotification.hash in 2.59.0
Thank you so much! It worked!

Please Log in to join the conversation.

More
5 months 4 weeks ago #155902 by bonanza
bonanza replied the topic: Solution to missing database field UniqueNotification.hash in 2.59.0
I just updated to "limesurvey2.65.5+170613.tar.gz" and I'm also facing the error. Is there are similar solution?

Please Log in to join the conversation.

More
5 months 4 weeks ago #155903 by olle
olle replied the topic: Solution to missing database field UniqueNotification.hash in 2.59.0
Hi bonanza. What did you update from?

Please Log in to join the conversation.

More
5 months 4 weeks ago #155905 by bonanza
bonanza replied the topic: Solution to missing database field UniqueNotification.hash in 2.59.0
Thanks for your fast response. I made a new installation (using my custom Dockerfile script).

Please Log in to join the conversation.

More
5 months 4 weeks ago #155906 by olle
olle replied the topic: Solution to missing database field UniqueNotification.hash in 2.59.0
And that solved your problem?

Please Log in to join the conversation.

More
5 months 4 weeks ago - 5 months 4 weeks ago #155907 by bonanza
bonanza replied the topic: Solution to missing database field UniqueNotification.hash in 2.59.0
No, the clean install of the limesurvey container (while keeping the database container) lead to the problem. In my previous docker image (with 252+20160920) everything was fine.
Last Edit: 5 months 4 weeks ago by bonanza.

Please Log in to join the conversation.

More
5 months 4 weeks ago #155908 by olle
olle replied the topic: Solution to missing database field UniqueNotification.hash in 2.59.0
It's not a clean installation if the database is old.

Anyway, just create the hash column in the notifications table and you should be fine.

Please Log in to join the conversation.

More
5 months 4 weeks ago - 5 months 4 weeks ago #155909 by bonanza
bonanza replied the topic: Solution to missing database field UniqueNotification.hash in 2.59.0
you're right, sorry for the confusion.

Can you give me some hints how to add the column to the table?
As my database is called 'lime', I tried:
mysql> ALTER TABLE lime_notifications ADD hash VARCHAR( 64 );

but without success.
Last Edit: 5 months 4 weeks ago by bonanza.

Please Log in to join the conversation.

More
5 months 4 weeks ago #155911 by olle
olle replied the topic: Solution to missing database field UniqueNotification.hash in 2.59.0
Sure. Which database are you using?

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!