I am receiving the following error when any member tries to upload shared images. I am currently running ver. 6.1.6. I have doubled check permissions and all of them is correct. Please help!
---------
Database error in GoZoKo
Query:
SELECT `sharePhotoFiles`.`medID` as `medID`, `sharePhotoFiles`.`medExt` as `medExt`, `sharePhotoFiles`.`medTitle` as `medTitle`, `sharePhotoFiles`.`medUri` as `medUri`, `Profiles`.`NickName` FROM `sharePhotoFiles` LEFT JOIN `Profiles` ON `Profiles`.`ID` = `sharePhotoFiles`.medProfId WHERE `Approved`='true' AND `medProfId`='120'
ORDER BY `medDate` DESC LIMIT -0, 0
Mysql error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, 0' at line 2
Found error in file /home/gsmithjr/public_html/inc/classes/BxDolSharedMedia.php
at line 553. Called db_res function
with erroneous argument #0
Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/gsmithjr/public_html/inc/classes/BxDolSharedMedia.php
[line] => 553
[function] => db_res
[args] => Array
(
[0] => SELECT `sharePhotoFiles`.`medID` as `medID`, `sharePhotoFiles`.`medExt` as `medExt`, `sharePhotoFiles`.`medTitle` as `medTitle`, `sharePhotoFiles`.`medUri` as `medUri`, `Profiles`.`NickName` FROM `sharePhotoFiles` LEFT JOIN `Profiles` ON `Profiles`.`ID` = `sharePhotoFiles`.medProfId WHERE `Approved`='true' AND `medProfId`='120'
ORDER BY `medDate` DESC LIMIT -0, 0
)
)
[2] => Array
(
[file] => /home/gsmithjr/public_html/inc/classes/BxDolSharedMedia.php
[line] => 776
[function] => getFilesList
[class] => BxDolSharedMedia
[type] => ->
[object] => BxDolSharedMedia Object
(
[sType] => photo
[sCssName] => viewPhoto.css
[iViewer] => 120
[sViewerPass] =>
[aConfigDir] => Array
(
[root] => /home/gsmithjr/public_html/
[inc] => /home/gsmithjr/public_html/inc/
[profileImage] => /home/gsmithjr/public_html/media/images/profile/
[profileBackground] => /home/gsmithjr/public_html/media/images/profile_bg/
[profileSound] => /home/gsmithjr/public_html/media/sound/
[profileVideo] => /home/gsmithjr/public_html/media/video/
[sharingImages] => /home/gsmithjr/public_html/media/images/sharingImages/
[mediaImages] => /home/gsmithjr/public_html/media/images/
[gallery] => /home/gsmithjr/public_html/media/images/gallery/
[flags] => /home/gsmithjr/public_html/media/images/flags/
[blogImage] => /home/gsmithjr/public_html/media/images/blog/
[sdatingImage] => /home/gsmithjr/public_html/media/images/sdating/
[smiles] => /home/gsmithjr/public_html/media/images/smiles/
[banners] => /home/gsmithjr/public_html/media/images/banners/
[imagesPromo] => /home/gsmithjr/public_html/media/images/promo/
[tmp] => /home/gsmithjr/public_html/tmp/
[cache] => /home/gsmithjr/public_html/cache/
[plugins] => /home/gsmithjr/public_html/plugins/
[base] => /home/gsmithjr/public_html/templates/base/
[classes] => /home/gsmithjr/public_html/inc/classes/
)
[aConfigSite] => Array
(
[ver] => 6.1
[build] => 6
[title] => GoZoKo
[url_admin] => http://gozoko.com/admin-login/
[url_aff] => http://gozoko.com/aff/
[profileImage] => http://gozoko.com/media/images/profile/
[profileBackground] => http://gozoko.com/media/images/profile_bg/
[profileSound] => http://gozoko.com/media/sound/
[profileVideo] => http://gozoko.com/media/video/
[sharingImages] => http://gozoko.com/media/images/sharingImages/
[mediaImages] => http://gozoko.com/media/images/
[gallery] => http://gozoko.com/media/images/gallery/
[flags] => http://gozoko.com/media/images/flags/
[blogImage] => http://gozoko.com/media/images/blog/
[sdatingImage] => http://gozoko.com/media/images/sdating/
[smiles] => http://gozoko.com/media/images/smiles/default/
[banners] => http://gozoko.com/media/images/banners/
[imagesPromo] => http://gozoko.com/media/images/promo/
[tmp] => http://gozoko.com/tmp/
[preCheckout] => http://gozoko.com/checkout/pre_checkout.php
[plugins] => http://gozoko.com/plugins/
[base] => http://gozoko.com/templates/base/
[email] => info@gozoko.com
[email_notify] => subscribe@gozoko.com
[bugReportMail] => webmaster@gozoko.com
[js_init] =>
dpoll_progress_bar_color = "#88C86A";
[images] => http://gozoko.com/templates/tmpl_uni/images/
[zodiac] => templates/tmpl_uni/images/zodiac/
[icons] => http://gozoko.com/templates/tmpl_uni/images/icons/
[css_dir] => templates/tmpl_uni/css/
)
[sFilesPath] => /home/gsmithjr/public_html/media/images/sharingImages/
[sFilesUrl] => http://gozoko.com/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://gozoko.com/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 `Approved`='true' AND `medProfId`='120'
[sqlOrder] =>
ORDER BY `medDate` DESC
[sqlLimit] => LIMIT -0, 0
)
[1] => Array
(
[0] => medID
[1] => medExt
[2] => medTitle
[3] => medUri
)
)
)
[3] => Array
(
[file] => /home/gsmithjr/public_html/member.php
[line] => 372
[function] => getBlockCode_SharedMedia
[class] => BxDolSharedMedia
[type] => ->
[object] => BxDolSharedMedia Object
(
[sType] => photo
[sCssName] => viewPhoto.css
[iViewer] => 120
[sViewerPass] =>
[aConfigDir] => Array
(
[root] => /home/gsmithjr/public_html/
[inc] => /home/gsmithjr/public_html/inc/
[profileImage] => /home/gsmithjr/public_html/media/images/profile/
[profileBackground] => /home/gsmithjr/public_html/media/images/profile_bg/
[profileSound] => /home/gsmithjr/public_html/media/sound/
[profileVideo] => /home/gsmithjr/public_html/media/video/
[sharingImages] => /home/gsmithjr/public_html/media/images/sharingImages/
[mediaImages] => /home/gsmithjr/public_html/media/images/
[gallery] => /home/gsmithjr/public_html/media/images/gallery/
[flags] => /home/gsmithjr/public_html/media/images/flags/
[blogImage] => /home/gsmithjr/public_html/media/images/blog/
[sdatingImage] => /home/gsmithjr/public_html/media/images/sdating/
[smiles] => /home/gsmithjr/public_html/media/images/smiles/
[banners] => /home/gsmithjr/public_html/media/images/banners/
[imagesPromo] => /home/gsmithjr/public_html/media/images/promo/
[tmp] => /home/gsmithjr/public_html/tmp/
[cache] => /home/gsmithjr/public_html/cache/
[plugins] => /home/gsmithjr/public_html/plugins/
[base] => /home/gsmithjr/public_html/templates/base/
[classes] => /home/gsmithjr/public_html/inc/classes/
)
[aConfigSite] => Array
(
[ver] => 6.1
[build] => 6
[title] => GoZoKo
[url_admin] => http://gozoko.com/admin-login/
[url_aff] => http://gozoko.com/aff/
[profileImage] => http://gozoko.com/media/images/profile/
[profileBackground] => http://gozoko.com/media/images/profile_bg/
[profileSound] => http://gozoko.com/media/sound/
[profileVideo] => http://gozoko.com/media/video/
[sharingImages] => http://gozoko.com/media/images/sharingImages/
[mediaImages] => http://gozoko.com/media/images/
[gallery] => http://gozoko.com/media/images/gallery/
[flags] => http://gozoko.com/media/images/flags/
[blogImage] => http://gozoko.com/media/images/blog/
[sdatingImage] => http://gozoko.com/media/images/sdating/
[smiles] => http://gozoko.com/media/images/smiles/default/
[banners] => http://gozoko.com/media/images/banners/
[imagesPromo] => http://gozoko.com/media/images/promo/
[tmp] => http://gozoko.com/tmp/
[preCheckout] => http://gozoko.com/checkout/pre_checkout.php
[plugins] => http://gozoko.com/plugins/
[base] => http://gozoko.com/templates/base/
[email] => info@gozoko.com
[email_notify] => subscribe@gozoko.com
[bugReportMail] => webmaster@gozoko.com
[js_init] =>
dpoll_progress_bar_color = "#88C86A";
[images] => http://gozoko.com/templates/tmpl_uni/images/
[zodiac] => templates/tmpl_uni/images/zodiac/
[icons] => http://gozoko.com/templates/tmpl_uni/images/icons/
[css_dir] => templates/tmpl_uni/css/
)
[sFilesPath] => /home/gsmithjr/public_html/media/images/sharingImages/
[sFilesUrl] => http://gozoko.com/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://gozoko.com/media/images/sharingImages/__file__
[onClick] =>
[add] => target="_blank"
)
)
[sViewActionName] => 31
[aInfo] =>
[aEditInfo] => Array
(
[medProfId] =>
[medTitle] => Title
[medTags] => Tags
[medDesc] => Description
[medUri] =>
)
)
[args] => Array
(
[0] => 120
)
)
[4] => Array
(
[file] => /home/gsmithjr/public_html/inc/classes/BxDolPageView.php
[line] => 167
[function] => getBlockCode_SharePhotos
[class] => BxDolMember
[type] => ->
[object] => BxDolMember Object
(
[iMember] => 120
[aMemberInfo] => Array
