Error
Database query error
Query:
SELECT `sharePhotoFiles`.`medID` as `medID`, `sharePhotoFiles`.`medProfId` as `medProfId`, `sharePhotoFiles`.`medTitle` as `medTitle`, `sharePhotoFiles`.`medUri` as `medUri`, `sharePhotoFiles`.`medDate` as `medDate`, `sharePhotoFiles`.`medViews` as `medViews`, `sharePhotoFiles`.`medExt` as `medExt`, `Profiles`.`NickName` ,gphoto_rating.`gal_rating_count` as `voting_count`, (gphoto_rating.`gal_rating_sum` / gphoto_rating.`gal_rating_count`) AS `voting_rate` FROM `sharePhotoFiles` LEFT JOIN `Profiles` ON `Profiles`.`ID` = `sharePhotoFiles`.medProfId LEFT JOIN gphoto_rating ON (gphoto_rating.`gal_id` = `sharePhotoFiles`.`medID`) WHERE 1 AND `Approved`= 'true' ORDER BY `voting_rate` DESC, `voting_count` DESC, `medDate` DESC LIMIT 0, 10
Mysql error:
Out of memory (Needed 2095536 bytes)
Found error in file
/home/billwide/public_html/sites/saopaulofc/inc/classes/BxDolSharedMedia.php
at line
553. Called
db_res function
with erroneous argument #
0
Debug backtrace:Array
(
[1] => Array
(
[file] => /home/billwide/public_html/sites/saopaulofc/inc/classes/BxDolSharedMedia.php
[line] => 553
[function] => db_res
[args] => Array
(
[0] => SELECT `sharePhotoFiles`.`medID` as `medID`, `sharePhotoFiles`.`medProfId` as `medProfId`, `sharePhotoFiles`.`medTitle` as `medTitle`, `sharePhotoFiles`.`medUri` as `medUri`, `sharePhotoFiles`.`medDate` as `medDate`, `sharePhotoFiles`.`medViews` as `medViews`, `sharePhotoFiles`.`medExt` as `medExt`, `Profiles`.`NickName` ,gphoto_rating.`gal_rating_count` as `voting_count`, (gphoto_rating.`gal_rating_sum` / gphoto_rating.`gal_rating_count`) AS `voting_rate` FROM `sharePhotoFiles` LEFT JOIN `Profiles` ON `Profiles`.`ID` = `sharePhotoFiles`.medProfId LEFT JOIN gphoto_rating ON (gphoto_rating.`gal_id` = `sharePhotoFiles`.`medID`) WHERE 1 AND `Approved`= 'true' ORDER BY `voting_rate` DESC, `voting_count` DESC, `medDate` DESC LIMIT 0, 10
)
)
[2] => Array
(
[file] => /home/billwide/public_html/sites/saopaulofc/browsePhoto.php
[line] => 52
[function] => getFilesList
[class] => BxDolSharedMedia
[type] => ->
[object] => BxDolSharedMedia Object
(
[sType] => photo
[sCssName] => viewPhoto.css
[iViewer] => 0
[sViewerPass] =>
[aConfigDir] => Array
(
[root] => /home/billwide/public_html/sites/saopaulofc/
[inc] => /home/billwide/public_html/sites/saopaulofc/inc/
[profileImage] => /home/billwide/public_html/sites/saopaulofc/media/images/profile/
[profileBackground] => /home/billwide/public_html/sites/saopaulofc/media/images/profile_bg/
[profileSound] => /home/billwide/public_html/sites/saopaulofc/media/sound/
[profileVideo] => /home/billwide/public_html/sites/saopaulofc/media/video/
[sharingImages] => /home/billwide/public_html/sites/saopaulofc/media/images/sharingImages/
[mediaImages] => /home/billwide/public_html/sites/saopaulofc/media/images/
[gallery] => /home/billwide/public_html/sites/saopaulofc/media/images/gallery/
[flags] => /home/billwide/public_html/sites/saopaulofc/media/images/flags/
[blogImage] => /home/billwide/public_html/sites/saopaulofc/media/images/blog/
[sdatingImage] => /home/billwide/public_html/sites/saopaulofc/media/images/sdating/
[smiles] => /home/billwide/public_html/sites/saopaulofc/media/images/smiles/
[banners] => /home/billwide/public_html/sites/saopaulofc/media/images/banners/
[imagesPromo] => /home/billwide/public_html/sites/saopaulofc/media/images/promo/
[tmp] => /home/billwide/public_html/sites/saopaulofc/tmp/
[cache] => /home/billwide/public_html/sites/saopaulofc/cache/
[plugins] => /home/billwide/public_html/sites/saopaulofc/plugins/
[base] => /home/billwide/public_html/sites/saopaulofc/templates/base/
[classes] => /home/billwide/public_html/sites/saopaulofc/inc/classes/
)
[aConfigSite] => Array
(
[ver] => 6.1
[build] => 5
[title] => Comunidade do São Paulo Futebol Clube
[url] => http://saopaulofc.org/
[url_admin] => http://saopaulofc.org/admin/
[url_aff] => http://saopaulofc.org/aff/
[profileImage] => http://saopaulofc.org/media/images/profile/
[profileBackground] => http://saopaulofc.org/media/images/profile_bg/
[profileSound] => http://saopaulofc.org/media/sound/
[profileVideo] => http://saopaulofc.org/media/video/
[sharingImages] => http://saopaulofc.org/media/images/sharingImages/
[mediaImages] => http://saopaulofc.org/media/images/
[gallery] => http://saopaulofc.org/media/images/gallery/
[flags] => http://saopaulofc.org/media/images/flags/
[blogImage] => http://saopaulofc.org/media/images/blog/
[sdatingImage] => http://saopaulofc.org/media/images/sdating/
[smiles] => http://saopaulofc.org/media/images/smiles/default/
[banners] => http://saopaulofc.org/media/images/banners/
[imagesPromo] => http://saopaulofc.org/media/images/promo/
[tmp] => http://saopaulofc.org/tmp/
[preCheckout] => http://saopaulofc.org/checkout/pre_checkout.php
[plugins] => http://saopaulofc.org/plugins/
[base] => http://saopaulofc.org/templates/base/
[email] => contato@saopaulofc.org
[email_notify] => contato@saopaulofc.org
[bugReportMail] => contato@saopaulofc.org
[js_init] =>
[images] => http://saopaulofc.org/templates/tmpl_purplebox/images/
[zodiac] => templates/tmpl_purplebox/images/zodiac/
[icons] => http://saopaulofc.org/templates/tmpl_purplebox/images/icons/
[css_dir] => templates/tmpl_purplebox/css/
)
[sFilesPath] => /home/billwide/public_html/sites/saopaulofc/media/images/sharingImages/
[sFilesUrl] => http://saopaulofc.org/media/images/sharingImages/
[sPrLinkPar] => permalinks_gallery_photos
[sMainTable] => sharePhotoFiles
[aTableFields] => Array
(
[medID] => medID
[medProfId] => medProfId
[medExt] => medExt
[medTitle] => medTitle
[medUri] => medUri
[medDesc] => medDesc
[medTags] => medTags
[medDate] => medDate
[medViews] => medViews
[Approved] => Approved
)
[sCommentsTable] => CmtsSharedPhoto
[sFavoriteTable] => sharePhotoFavorites
[aMainActions] => Array
(
[Fave] => Array
(
[icon] => action_fave.gif
[link] => javascript:void(0);
[onClick] => action=favorite__fileID__
)
[Share] => Array
(
[icon] => action_share.gif
[link] => javascript:void(0);
[onClick] => action=share__fileID____fileUrl__
)
[Report] => Array
(
[icon] => action_report.gif
[link] => javascript:void(0);
[onClick] => action=report__fileID____fileUrl__
)
)
[aAddActions] => Array
(
[Original_Size] => Array
(
[icon] => action_download.gif
[link] => http://saopaulofc.org/media/images/sharingImages/__file__
[onClick] =>
[add] => target="_blank"
)
)
[sViewActionName] => 31
[aInfo] =>
[aEditInfo] => Array
(
[medProfId] =>
[medTitle] => Title
[medTags] => Tags
[medDesc] => Description
[medUri] =>
)
)
[args] => Array
(
[0] => Array
(
[sqlWhere] => WHERE 1 AND `Approved`= 'true'
[sqlLimit] => LIMIT 0, 10
[sqlOrder] => ORDER BY `voting_rate` DESC, `voting_count` DESC, `medDate` DESC
[rateFields] => ,gphoto_rating.`gal_rating_count` as `voting_count`, (gphoto_rating.`gal_rating_sum` / gphoto_rating.`gal_rating_count`) AS `voting_rate`
[rateJoin] => LEFT JOIN gphoto_rating ON (gphoto_rating.`gal_id` = `sharePhotoFiles`.`medID`)
)
)
)
)
Called script: /browsePhoto.php
Request parameters:Array
(
[rate] => top
[page] => 1
[per_page] => 10
[lang] => pt
)