Fri Nov 20, 2015 7:45 am
I now get following permanent error:
A Database Error Occurred
Error Number: 1
Can't create/write to file '/tmp/#sql_2b48_0.MYD' (Errcode: 17)
SELECT music_id, position as c_position, cc_position, organ_image, chart_position, comment_position, fk_user_id, fk_organ_id, music_description, music_file_name, music_title, IF(fk_composer_id = 999, composer_other, composer_name) AS composer_name, IF(fk_genre_id = 999, genre_other, genre_name) AS genre_name, IF(fk_organ_id = 999, organ_other, organ_name) AS organ_name, user_name, fk_composer_id, organ_id, organ_url, organ_other, music_created, music_stereo, music_live, music_youtube_id, comment_count, view_count, recommendations FROM music LEFT JOIN fa_user_profile on fa_user_profile.id = music.fk_user_id LEFT JOIN monthly_chart c ON chart_music_id = music_id LEFT JOIN monthly_comment_chart ON cc_music_id = music_id LEFT JOIN composers ON fk_composer_id = composer_id LEFT JOIN organs ON fk_organ_id = organ_id LEFT JOIN genres ON fk_genre_id = genre_id LEFT JOIN fa_user ON fk_user_id = fa_user.id WHERE music_valid = 1 AND upload_to = 'public' ORDER BY music_created desc LIMIT 0, 50