Error
Database query error
Query:
SELECT `Owner`, `creatorID`
FROM `RayMovieFiles` WHERE `ID`=28
LEFT JOIN `Groups` ON ``.`GroupId`=`Groups`.`ID`
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 'LEFT JOIN `Groups` ON ``.`GroupId`=`Groups`.`ID`' at line 3
Found error in file
/home/modelcom/public_html/inc/classes/ctzGroupMedia.php
at line
219. Called
db_arr function
with erroneous argument #
0
Debug backtrace:Array
(
[1] => Array
(
[file] => /home/modelcom/public_html/inc/db.inc.php
[line] => 115
[function] => db_res
[args] => Array
(
[0] => SELECT `Owner`, `creatorID`
FROM `RayMovieFiles` WHERE `ID`=28
LEFT JOIN `Groups` ON ``.`GroupId`=`Groups`.`ID`
[1] => 1
)
)
[2] => Array
(
[file] => /home/modelcom/public_html/inc/classes/ctzGroupMedia.php
[line] => 219
[function] => db_arr
[args] => Array
(
[0] => SELECT `Owner`, `creatorID`
FROM `RayMovieFiles` WHERE `ID`=28
LEFT JOIN `Groups` ON ``.`GroupId`=`Groups`.`ID`
)
)
[3] => Array
(
[file] => /home/modelcom/public_html/inc/classes/ctzGroupMedia.php
[line] => 53
[function] => deleteMedia
[class] => ctzGroupMedia
[type] => ->
[object] => ctzGroupMedia Object
(
[sType] => video
[sCssName] => viewVideo.css
[iViewer] => 0
[sViewerPass] =>
[aConfigDir] => Array
(
[root] => /home/modelcom/public_html/
[inc] => /home/modelcom/public_html/inc/
[profileImage] => /home/modelcom/public_html/media/images/profile/
[profileBackground] => /home/modelcom/public_html/media/images/profile_bg/
[profileSound] => /home/modelcom/public_html/media/sound/
[profileVideo] => /home/modelcom/public_html/media/video/
[sharingImages] => /home/modelcom/public_html/media/images/sharingImages/
[mediaImages] => /home/modelcom/public_html/media/images/
[articleImage] => /home/modelcom/public_html/media/images/articles/
[gallery] => /home/modelcom/public_html/media/images/gallery/
[flags] => /home/modelcom/public_html/media/images/flags/
[blogImage] => /home/modelcom/public_html/media/images/blog/
[sdatingImage] => /home/modelcom/public_html/media/images/sdating/
[smiles] => /home/modelcom/public_html/media/images/smiles/
[banners] => /home/modelcom/public_html/media/images/banners/
[imagesPromo] => /home/modelcom/public_html/media/images/promo/
[tmp] => /home/modelcom/public_html/tmp/
[cache] => /home/modelcom/public_html/cache/
[plugins] => /home/modelcom/public_html/plugins/
[base] => /home/modelcom/public_html/templates/base/
[classes] => /home/modelcom/public_html/inc/classes/
)
[aConfigSite] => Array
(
[ver] => 6.1
[build] => 4
[title] => Modelcomplex.net
[url] => http://www.modelcomplex.net/
[url_admin] => http://www.modelcomplex.net/admin/
[url_aff] => http://www.modelcomplex.net/aff/
[profileImage] => http://www.modelcomplex.net/media/images/profile/
[profileBackground] => http://www.modelcomplex.net/media/images/profile_bg/
[profileSound] => http://www.modelcomplex.net/media/sound/
[profileVideo] => http://www.modelcomplex.net/media/video/
[sharingImages] => http://www.modelcomplex.net/media/images/sharingImages/
[emoticons] => http://www.modelcomplex.net/media/images/emoticons/
[mediaImages] => http://www.modelcomplex.net/media/images/
[articleImage] => http://www.modelcomplex.net/media/images/articles/
[gallery] => http://www.modelcomplex.net/media/images/gallery/
[flags] => http://www.modelcomplex.net/media/images/flags/
[blogImage] => http://www.modelcomplex.net/media/images/blog/
[sdatingImage] => http://www.modelcomplex.net/media/images/sdating/
[smiles] => http://www.modelcomplex.net/media/images/smiles/default/
[banners] => http://www.modelcomplex.net/media/images/banners/
[imagesPromo] => http://www.modelcomplex.net/media/images/promo/
[tmp] => http://www.modelcomplex.net/tmp/
[preCheckout] => http://www.modelcomplex.net/checkout/pre_checkout.php
[plugins_admin] => http://www.modelcomplex.net/plugins/
[plugins] => http://www.modelcomplex.net/plugins/
[base] => http://www.modelcomplex.net/templates/base/
[email] => admin@modelcomplex.net
[email_notify] => admin@modelcomplex.net
[bugReportMail] => admin@modelcomplex.net
[js_init] =>
[images] => http://www.modelcomplex.net/templates/tmpl_uni/images/
[zodiac] => templates/tmpl_uni/images/zodiac/
[icons] => http://www.modelcomplex.net/templates/tmpl_uni/images/icons/
[css_dir] => templates/tmpl_uni/css/
[events] => http://www.modelcomplex.net/events/
[events_gallery] => http://www.modelcomplex.net/events/gallery/
)
[sFilesPath] => /home/modelcom/public_html/ray/modules/movie/files/
[sFilesUrl] => http://www.modelcomplex.net/ray/modules/movie/files/
[sPrLinkPar] => permalinks_gallery_videos
[sMainTable] => RayMovieFiles
[aTableFields] => Array
(
[medID] => ID
[medProfId] => Owner
[medTitle] => Title
[medUri] => Uri
[medDesc] => Description
[medTags] => Tags
[medDate] => Date
[medViews] => Views
[Approved] => Approved
[GroupId] => GroupId
)
[sCommentsTable] => CmtsSharedVideo
[sFavoriteTable] => shareVideoFavorites
[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] =>
[sViewActionName] => 32
[aInfo] =>
[aEditInfo] => Array
(
[medProfId] =>
[medTitle] => Title
[medTags] => Tags
[medDesc] => Description
[medUri] =>
)
)
[args] => Array
(
[0] => 28
[1] => Array
(
[admin] =>
[member] =>
[aff] =>
[moderator] =>
)
)
)
[4] => Array
(
[file] => /home/modelcom/public_html/browseVideo.php
[line] => 26
[function] => getConditionArray
[class] => ctzGroupMedia
[type] => ->
[object] => ctzGroupMedia Object
(
[sType] => video
[sCssName] => viewVideo.css
[iViewer] => 0
[sViewerPass] =>
[aConfigDir] => Array
(
[root] => /home/modelcom/public_html/
[inc] => /home/modelcom/public_html/inc/
[profileImage] => /home/modelcom/public_html/media/images/profile/
[profileBackground] => /home/modelcom/public_html/media/images/profile_bg/
[profileSound] => /home/modelcom/public_html/media/sound/
[profileVideo] => /home/modelcom/public_html/media/video/
[sharingImages] => /home/modelcom/public_html/media/images/sharingImages/
[mediaImages] => /home/modelcom/public_html/media/images/
[articleImage] => /home/modelcom/public_html/media/images/articles/
[gallery] => /home/modelcom/public_html/media/images/gallery/
[flags] => /home/modelcom/public_html/media/images/flags/
[blogImage] => /home/modelcom/public_html/media/images/blog/
[sdatingImage] => /home/modelcom/public_html/media/images/sdating/
[smiles] => /home/modelcom/public_html/media/images/smiles/
[banners] => /home/modelcom/public_html/media/images/banners/
[imagesPromo] => /home/modelcom/public_html/media/images/promo/
[tmp] => /home/modelcom/public_html/tmp/
[cache] => /home/modelcom/public_html/cache/
[plugins] => /home/modelcom/public_html/plugins/
[base] => /home/modelcom/public_html/templates/base/
[classes] => /home/modelcom/public_html/inc/classes/
)
[aConfigSite] => Array
(
[ver] => 6.1
[build] => 4
[title] => Modelcomplex.net
[url] => http://www.modelcomplex.net/
[url_admin] => http://www.modelcomplex.net/admin/
[url_aff] => http://www.modelcomplex.net/aff/
[profileImage] => http://www.modelcomplex.net/media/images/profile/
[profileBackground] => http://www.modelcomplex.net/media/images/profile_bg/
[profileSound] => http://www.modelcomplex.net/media/sound/
[profileVideo] => http://www.modelcomplex.net/media/video/
[sharingImages] => http://www.modelcomplex.net/media/images/sharingImages/
[emoticons] => http://www.modelcomplex.net/media/images/emoticons/
[mediaImages] => http://www.modelcomplex.net/media/images/
[articleImage] => http://www.modelcomplex.net/media/images/articles/
[gallery] => http://www.modelcomplex.net/media/images/gallery/
[flags] => http://www.modelcomplex.net/media/images/flags/
[blogImage] => http://www.modelcomplex.net/media/images/blog/
[sdatingImage] => http://www.modelcomplex.net/media/images/sdating/
[smiles] => http://www.modelcomplex.net/media/images/smiles/default/
[banners] => http://www.modelcomplex.net/media/images/banners/
[imagesPromo] => http://www.modelcomplex.net/media/images/promo/
[tmp] => http://www.modelcomplex.net/tmp/
[preCheckout] => http://www.modelcomplex.net/checkout/pre_checkout.php
[plugins_admin] => http://www.modelcomplex.net/plugins/
[plugins] => http://www.modelcomplex.net/plugins/
[base] => http://www.modelcomplex.net/templates/base/
[email] => admin@modelcomplex.net
[email_notify] => admin@modelcomplex.net
[bugReportMail] => admin@modelcomplex.net
[js_init] =>
[images] => http://www.modelcomplex.net/templates/tmpl_uni/images/
[zodiac] => templates/tmpl_uni/images/zodiac/
[icons] => http://www.modelcomplex.net/templates/tmpl_uni/images/icons/
[css_dir] => templates/tmpl_uni/css/
[events] => http://www.modelcomplex.net/events/
[events_gallery] => http://www.modelcomplex.net/events/gallery/
)
[sFilesPath] => /home/modelcom/public_html/ray/modules/movie/files/
[sFilesUrl] => http://www.modelcomplex.net/ray/modules/movie/files/
[sPrLinkPar] => permalinks_gallery_videos
[sMainTable] => RayMovieFiles
[aTableFields] => Array
(
[medID] => ID
[medProfId] => Owner
[medTitle] => Title
[medUri] => Uri
[medDesc] => Description
[medTags] => Tags
[medDate] => Date
[medViews] => Views
[Approved] => Approved
[GroupId] => GroupId
)
[sCommentsTable] => CmtsSharedVideo
[sFavoriteTable] => shareVideoFavorites
[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] =>
[sViewActionName] => 32
[aInfo] =>
[aEditInfo] => Array
(
[medProfId] =>
[medTitle] => Title
[medTags] => Tags
[medDesc] => Description
[medUri] =>
)
)
[args] => Array
(
[0] => Array
(
[admin] =>
[member] =>
[aff] =>
[moderator] =>
)
)
)
)
Called script: /browseVideo.php
Request parameters:Array
(
[action] => del
[fileID] => 28
)