View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
08606Bug reportsAuthenticationpublic2014-01-26 17:052014-01-31 17:32
Reporterbetelgeuse Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.05+ 
Fixed in Version2.05+ 
Summary08606: Column name must be either a string or an array. when trying to login
Description

After update to Changes from 2.05+ (build 140116) to 2.05+ (build 140125) Jan 25, 2014 it was no longer possible to login as admin. The error message was:

"Column name must be either a string or an array"

Additional Information

I looked at the source

    (
        [file] => /home/ubuntu/limesurvey/framework/db/schema/CDbCommandBuilder.php
        [line] => 621

It seemed to be trying to mark the Authdb plugin as active but failing to find a primary key in the lime_plugins table.

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)140116
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgresql 9.1
Server OS (if known)Ubuntu 13.10
Webserver software & version (if known)Apache 2
PHP VersionPHP 5.5.3-1ubuntu2.

Users monitoring this issue

c_schmitz

Activities

betelgeuse

betelgeuse

2014-01-26 18:15

reporter   ~28221

Mocking around the database with the primary keys I managed to get the login screen to show up. However there was no field for username and password. I managed to solve this by modifying authentication.php else branch at line 49 to also include the plugin loading code:

App()->getPluginManager()->loadPlugin('Authdb', $plugin->id);
c_schmitz

c_schmitz

2014-01-31 14:09

administrator   ~28318

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

c_schmitz

2014-01-31 17:32

administrator   ~28336

LimeSurvey 2-05+ Build 140131 released

Related Changesets

LimeSurvey: master 974cf1f2

2014-01-31 14:10

c_schmitz


Details Diff		 Fixed issue 08606: Unable to login using Postgres Affected Issues
08606
mod - application/controllers/admin/authentication.php Diff File

Issue History

Date Modified Username Field Change
2014-01-26 17:05 betelgeuse New Issue
2014-01-26 18:15 betelgeuse Note Added: 28221
2014-01-27 09:40 Mazi Assigned To => sammousa
2014-01-27 09:40 Mazi Status new => assigned
2014-01-27 09:40 Mazi Issue Monitored: c_schmitz
2014-01-27 10:00 c_schmitz Assigned To sammousa =>
2014-01-27 10:00 c_schmitz Status assigned => new
2014-01-31 14:09 c_schmitz Assigned To => c_schmitz
2014-01-31 14:09 c_schmitz Status new => assigned
2014-01-31 14:09 c_schmitz Changeset attached => LimeSurvey master 974cf1f2
2014-01-31 14:09 c_schmitz Note Added: 28318
2014-01-31 14:09 c_schmitz Resolution open => fixed
2014-01-31 14:09 c_schmitz Status assigned => resolved
2014-01-31 14:09 c_schmitz Fixed in Version => 2.05+
2014-01-31 17:32 c_schmitz Note Added: 28336
2014-01-31 17:32 c_schmitz Status resolved => closed
2021-08-03 23:19 guest Bug heat 4 => 6