Error
Database query error
Query:
SELECT `RayMusicFiles`.`ID` as `medID`, `RayMusicFiles`.`Owner` as `medProfId`, `RayMusicFiles`.`Title` as `medTitle`, `RayMusicFiles`.`Uri` as `medUri`, `RayMusicFiles`.`Description` as `medDesc`, `RayMusicFiles`.`Tags` as `medTags`, `RayMusicFiles`.`Date` as `medDate`, `RayMusicFiles`.`Listens` as `medViews`, `RayMusicFiles`.`Approved` as `Approved`,
COUNT(`share1`.`ID`) as `medCount`,
`Profiles`.`NickName`
FROM `RayMusicFiles`
LEFT JOIN `RayMusicFiles` as `share1` USING (`Owner`)
INNER JOIN `Profiles` ON `Profiles`.`ID`=`RayMusicFiles`.`Owner`
WHERE `RayMusicFiles`.`ID` = 0
GROUP BY `share1`.`Owner`
Mysql error:
Table './db1129477@002dscooterv2/Profiles' is marked as crashed and last (automatic?) repair failed
Found error in file
/is/htdocs/wp1129477_VV1CGJ1O8C/www/scooterv/inc/classes/BxDolSharedMedia.php
at line
192. Called
db_arr function
with erroneous argument #
0
Debug backtrace:Array
(
[1] => Array
(
[file] => /is/htdocs/wp1129477_VV1CGJ1O8C/www/scooterv/inc/db.inc.php
[line] => 104
[function] => db_res
[args] => Array
(
[0] => SELECT `RayMusicFiles`.`ID` as `medID`, `RayMusicFiles`.`Owner` as `medProfId`, `RayMusicFiles`.`Title` as `medTitle`, `RayMusicFiles`.`Uri` as `medUri`, `RayMusicFiles`.`Description` as `medDesc`, `RayMusicFiles`.`Tags` as `medTags`, `RayMusicFiles`.`Date` as `medDate`, `RayMusicFiles`.`Listens` as `medViews`, `RayMusicFiles`.`Approved` as `Approved`,
COUNT(`share1`.`ID`) as `medCount`,
`Profiles`.`NickName`
FROM `RayMusicFiles`
LEFT JOIN `RayMusicFiles` as `share1` USING (`Owner`)
INNER JOIN `Profiles` ON `Profiles`.`ID`=`RayMusicFiles`.`Owner`
WHERE `RayMusicFiles`.`ID` = 0
GROUP BY `share1`.`Owner`
[1] => 1
)
)
[2] => Array
(
[file] => /is/htdocs/wp1129477_VV1CGJ1O8C/www/scooterv/inc/classes/BxDolSharedMedia.php
[line] => 192
[function] => db_arr
[args] => Array
(
[0] => SELECT `RayMusicFiles`.`ID` as `medID`, `RayMusicFiles`.`Owner` as `medProfId`, `RayMusicFiles`.`Title` as `medTitle`, `RayMusicFiles`.`Uri` as `medUri`, `RayMusicFiles`.`Description` as `medDesc`, `RayMusicFiles`.`Tags` as `medTags`, `RayMusicFiles`.`Date` as `medDate`, `RayMusicFiles`.`Listens` as `medViews`, `RayMusicFiles`.`Approved` as `Approved`,
COUNT(`share1`.`ID`) as `medCount`,
`Profiles`.`NickName`
FROM `RayMusicFiles`
LEFT JOIN `RayMusicFiles` as `share1` USING (`Owner`)
INNER JOIN `Profiles` ON `Profiles`.`ID`=`RayMusicFiles`.`Owner`
WHERE `RayMusicFiles`.`ID` = 0
GROUP BY `share1`.`Owner`
)
)
[3] => Array
(
[file] => /is/htdocs/wp1129477_VV1CGJ1O8C/www/scooterv/inc/classes/BxDolSharedMediaView.php
[line] => 31
[function] => getFileInfo
[class] => BxDolSharedMedia
[type] => ->
[object] => BxDolSharedMedia Object
(
[sType] => music
[sCssName] => viewMusic.css
[iViewer] => 0
[sViewerPass] =>
[aConfigDir] => Array
(
[root] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/
[inc] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/inc/
[profileImage] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/profile/
[profileBackground] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/profile_bg/
[profileSound] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/sound/
[profileVideo] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/video/
[sharingImages] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/sharingImages/
[mediaImages] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/
[gallery] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/gallery/
[flags] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/flags/
[blogImage] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/blog/
[sdatingImage] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/sdating/
[smiles] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/smiles/
[banners] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/banners/
[imagesPromo] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/promo/
[tmp] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/tmp/
[cache] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/cache/
[plugins] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/plugins/
[base] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/templates/base/
[classes] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/inc/classes/
)
[aConfigSite] => Array
(
[ver] => 6.1
[build] => 6
[title] => ScooterV
[url] => http://gooscoot.de/scooterv/
[url_admin] => http://gooscoot.de/scooterv/admin/
[url_aff] => http://gooscoot.de/scooterv/aff/
[profileImage] => http://gooscoot.de/scooterv/media/images/profile/
[profileBackground] => http://gooscoot.de/scooterv/media/images/profile_bg/
[profileSound] => http://gooscoot.de/scooterv/media/sound/
[profileVideo] => http://gooscoot.de/scooterv/media/video/
[sharingImages] => http://gooscoot.de/scooterv/media/images/sharingImages/
[mediaImages] => http://gooscoot.de/scooterv/media/images/
[gallery] => http://gooscoot.de/scooterv/media/images/gallery/
[flags] => http://gooscoot.de/scooterv/media/images/flags/
[blogImage] => http://gooscoot.de/scooterv/media/images/blog/
[sdatingImage] => http://gooscoot.de/scooterv/media/images/sdating/
[smiles] => http://gooscoot.de/scooterv/media/images/smiles/default/
[banners] => http://gooscoot.de/scooterv/media/images/banners/
[imagesPromo] => http://gooscoot.de/scooterv/media/images/promo/
[tmp] => http://gooscoot.de/scooterv/tmp/
[preCheckout] => http://gooscoot.de/scooterv/checkout/pre_checkout.php
[plugins] => http://gooscoot.de/scooterv/plugins/
[base] => http://gooscoot.de/scooterv/templates/base/
[email] => karol@heavytuned.de
[email_notify] => karol@heavytuned.de
[bugReportMail] => karol@heavytuned.de
[js_init] =>
[images] => http://gooscoot.de/scooterv/templates/tmpl_uni/images/
[zodiac] => templates/tmpl_uni/images/zodiac/
[icons] => http://gooscoot.de/scooterv/templates/tmpl_uni/images/icons/
[css_dir] => templates/tmpl_uni/css/
)
[sFilesPath] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/ray/modules/music/files/
[sFilesUrl] => http://gooscoot.de/scooterv/ray/modules/music/files/
[sPrLinkPar] => permalinks_gallery_music
[sMainTable] => RayMusicFiles
[aTableFields] => Array
(
[medID] => ID
[medProfId] => Owner
[medTitle] => Title
[medUri] => Uri
[medDesc] => Description
[medTags] => Tags
[medDate] => Date
[medViews] => Listens
[Approved] => Approved
)
[sCommentsTable] => CmtsSharedMusic
[sFavoriteTable] => shareMusicFavorites
[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] => 30
[aInfo] =>
[aEditInfo] => Array
(
[medProfId] =>
[medTitle] => Title
[medTags] => Tags
[medDesc] => Description
[medUri] =>
)
)
[args] => Array
(
[0] => 0
)
)
[4] => Array
(
[file] => /is/htdocs/wp1129477_VV1CGJ1O8C/www/scooterv/viewMusic.php
[line] => 36
[function] => BxDolSharedMediaView
[class] => BxDolSharedMediaView
[type] => ->
[object] => BxDolSharedMediaView Object
(
[iFile] => 0
[sType] => music
[aInfo] =>
[oShared] => BxDolSharedMedia Object
(
[sType] => music
[sCssName] => viewMusic.css
[iViewer] => 0
[sViewerPass] =>
[aConfigDir] => Array
(
[root] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/
[inc] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/inc/
[profileImage] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/profile/
[profileBackground] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/profile_bg/
[profileSound] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/sound/
[profileVideo] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/video/
[sharingImages] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/sharingImages/
[mediaImages] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/
[gallery] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/gallery/
[flags] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/flags/
[blogImage] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/blog/
[sdatingImage] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/sdating/
[smiles] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/smiles/
[banners] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/banners/
[imagesPromo] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/promo/
[tmp] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/tmp/
[cache] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/cache/
[plugins] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/plugins/
[base] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/templates/base/
[classes] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/inc/classes/
)
[aConfigSite] => Array
(
[ver] => 6.1
[build] => 6
[title] => ScooterV
[url] => http://gooscoot.de/scooterv/
[url_admin] => http://gooscoot.de/scooterv/admin/
[url_aff] => http://gooscoot.de/scooterv/aff/
[profileImage] => http://gooscoot.de/scooterv/media/images/profile/
[profileBackground] => http://gooscoot.de/scooterv/media/images/profile_bg/
[profileSound] => http://gooscoot.de/scooterv/media/sound/
[profileVideo] => http://gooscoot.de/scooterv/media/video/
[sharingImages] => http://gooscoot.de/scooterv/media/images/sharingImages/
[mediaImages] => http://gooscoot.de/scooterv/media/images/
[gallery] => http://gooscoot.de/scooterv/media/images/gallery/
[flags] => http://gooscoot.de/scooterv/media/images/flags/
[blogImage] => http://gooscoot.de/scooterv/media/images/blog/
[sdatingImage] => http://gooscoot.de/scooterv/media/images/sdating/
[smiles] => http://gooscoot.de/scooterv/media/images/smiles/default/
[banners] => http://gooscoot.de/scooterv/media/images/banners/
[imagesPromo] => http://gooscoot.de/scooterv/media/images/promo/
[tmp] => http://gooscoot.de/scooterv/tmp/
[preCheckout] => http://gooscoot.de/scooterv/checkout/pre_checkout.php
[plugins] => http://gooscoot.de/scooterv/plugins/
[base] => http://gooscoot.de/scooterv/templates/base/
[email] => karol@heavytuned.de
[email_notify] => karol@heavytuned.de
[bugReportMail] => karol@heavytuned.de
[js_init] =>
[images] => http://gooscoot.de/scooterv/templates/tmpl_uni/images/
[zodiac] => templates/tmpl_uni/images/zodiac/
[icons] => http://gooscoot.de/scooterv/templates/tmpl_uni/images/icons/
[css_dir] => templates/tmpl_uni/css/
)
[sFilesPath] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/ray/modules/music/files/
[sFilesUrl] => http://gooscoot.de/scooterv/ray/modules/music/files/
[sPrLinkPar] => permalinks_gallery_music
[sMainTable] => RayMusicFiles
[aTableFields] => Array
(
[medID] => ID
[medProfId] => Owner
[medTitle] => Title
[medUri] => Uri
[medDesc] => Description
[medTags] => Tags
[medDate] => Date
[medViews] => Listens
[Approved] => Approved
)
[sCommentsTable] => CmtsSharedMusic
[sFavoriteTable] => shareMusicFavorites
[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] => 30
[aInfo] =>
[aEditInfo] => Array
(
[medProfId] =>
[medTitle] => Title
[medTags] => Tags
[medDesc] => Description
[medUri] =>
)
)
[oCmtsView] =>
[sPageName] =>
[aPage] =>
[sCode] =>
[sWhoViews] => non
[iMemberID] => 0
[bAjaxMode] =>
)
[args] => Array
(
[0] => 0
[1] => music
[2] => Array
(
[ver] => 6.1
[build] => 6
[title] => ScooterV
[url] => http://gooscoot.de/scooterv/
[url_admin] => http://gooscoot.de/scooterv/admin/
[url_aff] => http://gooscoot.de/scooterv/aff/
[profileImage] => http://gooscoot.de/scooterv/media/images/profile/
[profileBackground] => http://gooscoot.de/scooterv/media/images/profile_bg/
[profileSound] => http://gooscoot.de/scooterv/media/sound/
[profileVideo] => http://gooscoot.de/scooterv/media/video/
[sharingImages] => http://gooscoot.de/scooterv/media/images/sharingImages/
[mediaImages] => http://gooscoot.de/scooterv/media/images/
[gallery] => http://gooscoot.de/scooterv/media/images/gallery/
[flags] => http://gooscoot.de/scooterv/media/images/flags/
[blogImage] => http://gooscoot.de/scooterv/media/images/blog/
[sdatingImage] => http://gooscoot.de/scooterv/media/images/sdating/
[smiles] => http://gooscoot.de/scooterv/media/images/smiles/default/
[banners] => http://gooscoot.de/scooterv/media/images/banners/
[imagesPromo] => http://gooscoot.de/scooterv/media/images/promo/
[tmp] => http://gooscoot.de/scooterv/tmp/
[preCheckout] => http://gooscoot.de/scooterv/checkout/pre_checkout.php
[plugins] => http://gooscoot.de/scooterv/plugins/
[base] => http://gooscoot.de/scooterv/templates/base/
[email] => karol@heavytuned.de
[email_notify] => karol@heavytuned.de
[bugReportMail] => karol@heavytuned.de
[js_init] =>
[images] => http://gooscoot.de/scooterv/templates/tmpl_uni/images/
[zodiac] => templates/tmpl_uni/images/zodiac/
[icons] => http://gooscoot.de/scooterv/templates/tmpl_uni/images/icons/
[css_dir] => templates/tmpl_uni/css/
)
[3] => Array
(
[root] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/
[inc] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/inc/
[profileImage] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/profile/
[profileBackground] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/profile_bg/
[profileSound] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/sound/
[profileVideo] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/video/
[sharingImages] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/sharingImages/
[mediaImages] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/
[gallery] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/gallery/
[flags] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/flags/
[blogImage] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/blog/
[sdatingImage] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/sdating/
[smiles] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/smiles/
[banners] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/banners/
[imagesPromo] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/media/images/promo/
[tmp] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/tmp/
[cache] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/cache/
[plugins] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/plugins/
[base] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/templates/base/
[classes] => /is/htdocs/wp1129477_VV1CGJ1O8C/www//scooterv/inc/classes/
)
[4] => Array
(
[ID] => 0
[Password] =>
)
)
)
)
Called script: /scooterv/viewMusic.php
Request parameters:Array
(
[fileUri] => all
)