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
)
)
)
