View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
08622Bug reportsInstallationpublic2014-01-29 10:122014-02-04 13:32
Reporterdkep Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.05+ 
Fixed in Version2.05+ 
Summary08622: Inputs for username and password not appearing in login mask
Description

After a clean install of Limesurvey 2.05+, the login screen displays without input fields for username and password. The database log says

2014-01-28 20:31:53 CET ERROR: invalid input syntax for integer: "t" at character 48
2014-01-28 20:31:53 CET STATEMENT: SELECT * FROM "plugins" "t" WHERE "t"."active"='t'

This issue seems to be related to ~08614 and ~08606. I think the problem is git commit cb2bf2e "Fixed issue 08519: Error during upgrade vom 2.00 to 2.05 using PostgreSQL
Dev Also fixed non-appearing inputs for username and password in login mask when using Postgres"

It actually made the bug appear that should have been solved. While looking through the plugin code, I noticed inconsistencies with the "active" column in the plugin table. Sometimes it it is treated as boolean and sometimes it is treated as integer (0/1). PHP doesn't really differentiated between those two but it seems that Yii/PDO (at least for pdo_pgsql) mixes them up and thus causing problems.

For me the issue was resolved by reverting commit cb2bf2e, but that is only a work around and it probably will reopen issue ~8519.

Steps To Reproduce

1) Clean install Limesurvey 2.05+
2) After login screen loads, reload the page and the inputs are gone

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)0048972
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgresql 9.2.4
Server OS (if known)Debian 6.0.8
Webserver software & version (if known)lighttpd 1.5 SVN
PHP Version5.4.15

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2014-02-03 16:24

administrator   ~28455

Last edited: 2014-02-03 16:24

This should be fixed in the latest release 2.05+ build 140131
Can you check if you still have the problem there?
dkep

dkep

2014-02-04 11:57

reporter   ~28478

I still can't see the username/password input on the admin login screen. The problem is in application/library/PluginManager/PluginManager.php:296

The plugin manager tries to load all active plugins with "findAllByAttributes(array('active'=>true));". But this query doesn't work for PostgreSQL. When I change it to "findAllByAttributes(array('active'=>1));", everything works as expected (but I don't know if it breaks other DBMSs)
c_schmitz

c_schmitz

2014-02-04 12:06

administrator   ~28479

You are right. thank you!
c_schmitz

c_schmitz

2014-02-04 12:07

administrator   ~28481

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=13836
c_schmitz

c_schmitz

2014-02-04 13:32

administrator   ~28492

Version 2.05+ Build 140204 released

Related Changesets

LimeSurvey: master f81409af

2014-02-04 12:07

c_schmitz


Details Diff		 Fixed issue 08622: Inputs for username and password not appearing in login mask when using Postgres Affected Issues
08622
mod - application/libraries/PluginManager/PluginManager.php Diff File

Issue History

Date Modified Username Field Change
2014-01-29 10:12 dkep New Issue
2014-02-03 16:24 c_schmitz Note Added: 28455
2014-02-03 16:24 c_schmitz Assigned To => c_schmitz
2014-02-03 16:24 c_schmitz Status new => feedback
2014-02-03 16:24 c_schmitz Note Edited: 28455
2014-02-04 11:57 dkep Note Added: 28478
2014-02-04 11:57 dkep Status feedback => assigned
2014-02-04 12:06 c_schmitz Note Added: 28479
2014-02-04 12:07 c_schmitz Status assigned => resolved
2014-02-04 12:07 c_schmitz Fixed in Version => 2.05+
2014-02-04 12:07 c_schmitz Resolution open => fixed
2014-02-04 12:07 c_schmitz Changeset attached => LimeSurvey master f81409af
2014-02-04 12:07 c_schmitz Note Added: 28481
2014-02-04 13:32 c_schmitz Note Added: 28492
2014-02-04 13:32 c_schmitz Status resolved => closed