Solution to missing database field UniqueNotification.hash in 2.59.0

More
1 year 6 months ago - 1 year 6 months ago #147200 by ollehar
ollehar 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: 1 year 6 months ago by ollehar.
The following user(s) said Thank You: mutandon

Please Log in or Create an account to join the conversation.

More
1 year 6 months ago - 1 year 6 months ago #147201 by ollehar
ollehar 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: 1 year 6 months ago by ollehar.

Please Log in or Create an account to join the conversation.

More
1 year 6 months 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 or Create an account to join the conversation.

More
1 year 6 months 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 or Create an account to join the conversation.

More
1 year 6 months ago #147210 by ollehar
ollehar 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 or Create an account to join the conversation.

More
1 year 6 months ago #147214 by ollehar
ollehar 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 or Create an account to join the conversation.

More
1 year 6 months 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 or Create an account to join the conversation.

More
1 year 1 month 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 or Create an account to join the conversation.

More
1 year 1 month ago #155903 by ollehar
ollehar replied the topic: Solution to missing database field UniqueNotification.hash in 2.59.0
Hi bonanza. What did you update from?

Please Log in or Create an account to join the conversation.

More
1 year 1 month 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 or Create an account to join the conversation.

More
1 year 1 month ago #155906 by ollehar
ollehar replied the topic: Solution to missing database field UniqueNotification.hash in 2.59.0
And that solved your problem?

Please Log in or Create an account to join the conversation.

More
1 year 1 month ago - 1 year 1 month 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: 1 year 1 month ago by bonanza.

Please Log in or Create an account to join the conversation.

More
1 year 1 month ago #155908 by ollehar
ollehar 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 or Create an account to join the conversation.

More
1 year 1 month ago - 1 year 1 month 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: 1 year 1 month ago by bonanza.

Please Log in or Create an account to join the conversation.

More
1 year 1 month ago #155911 by ollehar
ollehar replied the topic: Solution to missing database field UniqueNotification.hash in 2.59.0
Sure. Which database are you using?

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!