Ticket #156 (new defect)
Opened 5 years ago
DB error msg rec. in email report - detailed error message found in the desc area
| Reported by: | Robin <tcgl@…> | Owned by: | somebody |
|---|---|---|---|
| Priority: | major | Milestone: | |
| Keywords: | Cc: |
Description
Hello, I'm receiving the following messages in through email report, hope the detailed message help to solve the problem:
Database error in NetVillage?.ca Query:
SELECT
Groups.*, GroupsCateg.Name AS categName, COUNT( GroupsMembers.memberID ) AS membersCount, Groups.thumb, GroupsGallery.ext AS thumbExt, GroupsGallery.seed
FROM Groups,GroupsCateg LEFT JOIN GroupsGallery ON Groups.thumb = GroupsGallery.ID LEFT JOIN GroupsMembers ON
GroupsMembers.groupID = 5 AND GroupsMembers.status = 'Active'
WHERE
Groups.ID = 5 AND GroupsCateg.ID = Groups.categID
GROUP BY Groups.ID
Mysql error: Unknown column 'Groups.thumb' in 'on clause'
Found error in file /removed folder path for security reason/groups.inc.php at line 167. Called db_assoc_arr function with erroneous argument #0
Debug backtrace: Array (
[1] => Array
(
[file] => /removed folder path for security reason/db.inc.php [line] => 120 [function] => db_res [args] => Array
(
[0] =>
SELECT
Groups.*, GroupsCateg.Name AS categName, COUNT( GroupsMembers.memberID ) AS membersCount, Groups.thumb, GroupsGallery.ext AS thumbExt, GroupsGallery.seed
FROM Groups,GroupsCateg LEFT JOIN GroupsGallery ON Groups.thumb = GroupsGallery.ID LEFT JOIN GroupsMembers ON
GroupsMembers.groupID = 5 AND GroupsMembers.status = 'Active'
WHERE
Groups.ID = 5 AND GroupsCateg.ID = Groups.categID
GROUP BY Groups.ID
[1] => 1
)
)
[2] => Array
(
[file] => /removed folder path for security reason/groups.inc.php [line] => 167 [function] => db_assoc_arr [args] => Array
(
[0] =>
SELECT
Groups.*, GroupsCateg.Name AS categName, COUNT( GroupsMembers.memberID ) AS membersCount, Groups.thumb, GroupsGallery.ext AS thumbExt, GroupsGallery.seed
FROM Groups,GroupsCateg LEFT JOIN GroupsGallery ON Groups.thumb = GroupsGallery.ID LEFT JOIN GroupsMembers ON
GroupsMembers.groupID = 5 AND GroupsMembers.status = 'Active'
WHERE
Groups.ID = 5 AND GroupsCateg.ID = Groups.categID
GROUP BY Groups.ID
)
)
[3] => Array
(
[file] => /removed folder path for security reason/group.php [line] => 57 [function] => getGroupInfo [args] => Array
(
[0] => 5
)
)
)
