| Error: |
Error in: Library_global::do_standard_query Line 547
Query Execution failed!
Got error 28 from storage engine
SQL Statement -- SELECT *
FROM (
SELECT images.id as img_id, images.user_account_id, images.filename, images.title, images.filesize, images.dimensions,
images.image_category_id, images.image_rating_id, images.image_rating_qualifiers, images.image_class_id,
images.description, images.image_views, images.mass_uploaded, images.friends_only, images.is_archived,
images.uploaded_date, images.is_avatar, images.copyright_year, images.last_modified_date,
user_accounts.id as user_id, user_accounts.username, user_accounts.first_name, user_accounts.last_name,
user_accounts.status,
image_descriptions.*,
image_ratings.rating, image_categories.category, image_class.class
FROM images
LEFT JOIN user_accounts
ON user_accounts.id = images.user_account_id
LEFT JOIN image_ratings
ON image_ratings.id = images.image_rating_id
LEFT JOIN image_categories
ON image_categories.id = images.image_category_id
LEFT JOIN image_class
ON image_class.id = images.image_class_id
LEFT JOIN image_descriptions
ON images.id = image_descriptions.image_id
WHERE images.mass_uploaded != 'true'
ORDER BY images.uploaded_date DESC
LIMIT 16) as foo
WHERE foo.status = 'active'
LIMIT 8
Parameters -- |
