Error
Database query error
Query:
SELECT
`ID`,
`ItemUri`,
`Title`,
`Description`,
UNIX_TIMESTAMP( `Added` ) AS `PostDate`
FROM `ShopperEvents`
LEFT JOIN `CmtsShopperEvent` AS `tc` ON
`ShopperEvents`.`ID` = `tc`.`cmt_object_id`
LEFT JOIN `shopper_store_rating` AS `rate` ON
`ShopperEvents`.`ID` = `rate`.`gal_id`
WHERE `ShopperEvents`.`City` = '' AND `ShopperEvents`.`Approved` = 1 GROUP BY `ShopperEvents`.`ID` ORDER BY `ShopperEvents`.`Added` DESC
Mysql error:
Unknown column 'ShopperEvents.City' in 'where clause'
Found error in file
/home/contexto/public_html/nutricionistas-online/inc/classes/BxDolShopper.php
at line
1273. Called
db_res function
with erroneous argument #
0
Debug backtrace:Array
(
[1] => Array
(
[file] => /home/contexto/public_html/nutricionistas-online/inc/classes/BxDolShopper.php
[line] => 1273
[function] => db_res
[args] => Array
(
[0] => SELECT
`ID`,
`ItemUri`,
`Title`,
`Description`,
UNIX_TIMESTAMP( `Added` ) AS `PostDate`
FROM `ShopperEvents`
LEFT JOIN `CmtsShopperEvent` AS `tc` ON
`ShopperEvents`.`ID` = `tc`.`cmt_object_id`
LEFT JOIN `shopper_store_rating` AS `rate` ON
`ShopperEvents`.`ID` = `rate`.`gal_id`
WHERE `ShopperEvents`.`City` = '' AND `ShopperEvents`.`Approved` = 1 GROUP BY `ShopperEvents`.`ID` ORDER BY `ShopperEvents`.`Added` DESC
)
)
[2] => Array
(
[file] => /home/contexto/public_html/nutricionistas-online/inc/classes/BxDolShopper.php
[line] => 1148
[function] => getRssListings
[class] => BxDolShopper
[object] => BxDolShopper Object
(
[iViewer] => 0
[aConverter] => Array
(
)
[arrError] => Array
(
)
[iShopper] => 0
[titleLength] => 100
[descLength] => 300
[bAdminMode] =>
[rssTitleLength] => 150
[rssDescLength] => 400
[aMainActions] => Array
(
[Like] => Array
(
[icon] => shopper_like.png
[link] => javascript:void(0);
[onClick] => action=like__itemID____itemUrl__
)
[Dislike] => Array
(
[icon] => shopper_dislike.png
[link] => javascript:void(0);
[onClick] => action=dislike__itemID____itemUrl__
)
[Shopper Email Friend] => Array
(
[icon] => action_shopper_share.gif
[link] => javascript:void(0);
[onClick] => action=share__itemID____itemUrl__
)
[Report] => Array
(
[icon] => action_shopper_report.gif
[link] => javascript:void(0);
[onClick] => action=report__itemID____itemUrl__
)
)
[iIconSize] => 45
[iThumbSize] => 150
[iBigThumbSize] => 300
[iImgSize] => 800
[sUploadDir] => media/images/shopper/
[iMaxUplPhotoSize] => 1000000
[iMaxUplVideoSize] => 10485760
[sSpacerPath] => templates/base/images/icons/spacer.gif
[sPicNotAvail] => images/icons/group_no_pic.gif
)
[type] => ->
[args] => Array
(
[0] => event
[1] => nearest
[2] =>
)
)
[3] => Array
(
[file] => /home/contexto/public_html/nutricionistas-online/inc/classes/BxDolShopper.php
[line] => 1116
[function] => getItems
[class] => BxDolShopper
[object] => BxDolShopper Object
(
[iViewer] => 0
[aConverter] => Array
(
)
[arrError] => Array
(
)
[iShopper] => 0
[titleLength] => 100
[descLength] => 300
[bAdminMode] =>
[rssTitleLength] => 150
[rssDescLength] => 400
[aMainActions] => Array
(
[Like] => Array
(
[icon] => shopper_like.png
[link] => javascript:void(0);
[onClick] => action=like__itemID____itemUrl__
)
[Dislike] => Array
(
[icon] => shopper_dislike.png
[link] => javascript:void(0);
[onClick] => action=dislike__itemID____itemUrl__
)
[Shopper Email Friend] => Array
(
[icon] => action_shopper_share.gif
[link] => javascript:void(0);
[onClick] => action=share__itemID____itemUrl__
)
[Report] => Array
(
[icon] => action_shopper_report.gif
[link] => javascript:void(0);
[onClick] => action=report__itemID____itemUrl__
)
)
[iIconSize] => 45
[iThumbSize] => 150
[iBigThumbSize] => 300
[iImgSize] => 800
[sUploadDir] => media/images/shopper/
[iMaxUplPhotoSize] => 1000000
[iMaxUplVideoSize] => 10485760
[sSpacerPath] => templates/base/images/icons/spacer.gif
[sPicNotAvail] => images/icons/group_no_pic.gif
)
[type] => ->
[args] => Array
(
[0] => event
[1] => nearest
[2] =>
)
)
[4] => Array
(
[file] => /home/contexto/public_html/nutricionistas-online/shopper_rss.php
[line] => 9
[function] => GetFeed
[class] => BxDolShopper
[object] => BxDolShopper Object
(
[iViewer] => 0
[aConverter] => Array
(
)
[arrError] => Array
(
)
[iShopper] => 0
[titleLength] => 100
[descLength] => 300
[bAdminMode] =>
[rssTitleLength] => 150
[rssDescLength] => 400
[aMainActions] => Array
(
[Like] => Array
(
[icon] => shopper_like.png
[link] => javascript:void(0);
[onClick] => action=like__itemID____itemUrl__
)
[Dislike] => Array
(
[icon] => shopper_dislike.png
[link] => javascript:void(0);
[onClick] => action=dislike__itemID____itemUrl__
)
[Shopper Email Friend] => Array
(
[icon] => action_shopper_share.gif
[link] => javascript:void(0);
[onClick] => action=share__itemID____itemUrl__
)
[Report] => Array
(
[icon] => action_shopper_report.gif
[link] => javascript:void(0);
[onClick] => action=report__itemID____itemUrl__
)
)
[iIconSize] => 45
[iThumbSize] => 150
[iBigThumbSize] => 300
[iImgSize] => 800
[sUploadDir] => media/images/shopper/
[iMaxUplPhotoSize] => 1000000
[iMaxUplVideoSize] => 10485760
[sSpacerPath] => templates/base/images/icons/spacer.gif
[sPicNotAvail] => images/icons/group_no_pic.gif
)
[type] => ->
[args] => Array
(
[0] => event
[1] => nearest
[2] =>
)
)
)
Called script: /shopper_rss.php
Request parameters:Array
(
[type] => event
[action] => nearest
[lang] => xx
)