View Issue Details

This bug affects 1 person(s).
 8
IDProjectCategoryView StatusLast Update
12732Bug reportsComfortUpdatepublic2017-10-23 16:26
Reporterartol Assigned Toollehar  
PrioritynoneSeveritycrash 
Status closedResolutionno change required 
Product Version2.7x.x 
Summary12732: After updating from 2.5x to 2.71 I got Property "UniqueNotification.hash" is not defined
Description

Logging in or any kind of usage of Limesurvey is not possible.

Steps To Reproduce

I did Comfort update twice. First there were some problem geting new package. Then I tried again and everything went smoothly. I refreshed browser cache and then got the error.

Additional Information

I just purchased new comfort update key.

TagsNo tags attached.
Bug heat8
Complete LimeSurvey version number (& build)2.71.1
I will donate to the project if issue is resolvedNo
BrowserSafari on OSX
Database type & versionMysql 5.5.57
Server OS (if known)Linux version 2.6.32-696.1.1.el6.x86_64 (mockbuild@c1bm.rdu2.centos.org) (gcc version 4.4.7 20120313 (Red Hat 4.4.7-18) (GCC) )
Webserver software & version (if known)Apache/2.2.15 (Unix)
PHP VersionPHP 5.6.31

Users monitoring this issue

ollehar

Activities

ollehar

ollehar

2017-09-28 14:37

administrator   ~44513

Hi. Sorry to hear about your problem. Can you enable debug = 2 in config.php and then attach the complete error message, please?

ollehar

ollehar

2017-09-28 14:38

administrator   ~44514

An easy fix would be to add the "hash" column to the notifications table:

ALTER TABLE <prefix>_notifications ADD COLUMN hash VARCHAR(64) DEFAULT NULL;

artol

artol

2017-09-28 15:03

reporter   ~44515

ALTER TABLE <prefix>_notifications ADD COLUMN hash VARCHAR(64) DEFAULT NULL;

result

16:01:07 ALTER TABLE notifications ADD COLUMN hash VARCHAR(64) DEFAULT NULL Error Code: 1060. Duplicate column name 'hash' 0.012 sec

select * from notifications:
1 user 1 Database update The database has been updated from version 258 to version 260. read 1 default 2016-09-01 14:04:35 2016-09-01 14:05:01
2 user 2 Database update The database has been updated from version 258 to version 260. new 1 default 2016-09-01 14:04:35
3 user 1 Database update The database has been updated from version 260 to version 263. new 1 default 2017-09-28 14:33:31
4 user 2 Database update The database has been updated from version 260 to version 263. new 1 default 2017-09-28 14:33:31

artol

artol

2017-09-28 15:13

reporter   ~44516

It looks, that Limesurvey has started to work. Is it possible, that browser has not cleared cache properly?

c_schmitz

c_schmitz

2017-09-28 15:31

administrator   ~44517

No, LimeSurvey still had the old database scheme cached. Most of the time this resolves itself after a few minutes but it would be nice if it did not happen in the first place.

Issue History

Date Modified Username Field Change
2017-09-28 13:47 artol New Issue
2017-09-28 13:47 artol Status new => assigned
2017-09-28 13:47 artol Assigned To => LouisGac
2017-09-28 14:37 ollehar Note Added: 44513
2017-09-28 14:37 ollehar Issue Monitored: ollehar
2017-09-28 14:38 ollehar Note Added: 44514
2017-09-28 14:52 LouisGac Assigned To LouisGac => ollehar
2017-09-28 15:03 artol Note Added: 44515
2017-09-28 15:13 artol Note Added: 44516
2017-09-28 15:31 c_schmitz Note Added: 44517
2017-10-23 16:26 ollehar Status assigned => closed
2017-10-23 16:26 ollehar Resolution open => no change required