blueriver/MuraCMS — pull request #501 by sparky300 (2012-08-07 22:43:55+00:00)
Title: fixed key error [GROUPID] not found in query, columns are [UserID] on my...

fixed key error [GROUPID] not found in query, columns are [UserID] on mysql

mura was giving an error on mysql new installs when access the admin. resolved.

Catch
Entries:17
additional
Struct
SQL
string Select tusers.userID AS groupID from tusers inner join tusersmemb on tusers.userid=tusersmemb.groupid left join tfiles on tusers.photoFileId=tfiles.fileid where tusersmemb.userid='22FC551F-FABE-EA01-C6EDD0885DDC1682' order by tusers.groupname
cause
Struct
Entries:14
additional
Struct
SQL
string Select tusers.userID AS groupID from tusers inner join tusersmemb on tusers.userid=tusersmemb.groupid left join tfiles on tusers.photoFileId=tfiles.fileid where tusersmemb.userid='22FC551F-FABE-EA01-C6EDD0885DDC1682' order by tusers.groupname
DataSource
string
Detail
string
ErrorCode
string 0
ExtendedInfo
string
Message
string key [GROUPID] not found in query, columns are [UserID]
NativeErrorCode
number -1
queryError
string Select tusers.userID AS groupID from tusers inner join tusersmemb on tusers.userid=tusersmemb.groupid left join tfiles on tusers.photoFileId=tfiles.fileid where tusersmemb.userid='22FC551F-FABE-EA01-C6EDD0885DDC1682' order by tusers.groupname
Sql
string Select tusers.userID AS groupID from tusers inner join tusersmemb on tusers.userid=tusersmemb.groupid left join tfiles on tusers.photoFileId=tfiles.fileid where tusersmemb.userid='22FC551F-FABE-EA01-C6EDD0885DDC1682' order by tusers.groupname
SQLState