We're sorry, but the system experienced an unrecoverable error. Please try again later.
Script:
Query: SELECT p.id,p.user,p.userid,p.cat,p.storecat,p.storeid,p.date,p.title,p.description,p.ismature,p.keywords,
p.bigimage,p.width,p.height,p.filesize,
p.views,p.medwidth,p.medheight,p.medsize,p.approved,p.rating,p.extra1,p.extra2,p.extra3,p.extra4,p.extra5,p.extra6,
p.disporder,p.ipaddress,
p.allowprint,p.allowrate,p.allowcoms,p.tags,p.exifinfo,
p.gender, p.stage, p.reliability, p.party, p.location, p.date_time, p.priority,
i.oldid, p.reliability_userid, ur.username as reliability_username, p.reliabilitydatetime,
p.filepath, p.eduserid, p.eddatetime, ue.username as edusername,
m.id as newgalleryid, p.bigmd5, g.name AS genus_name, s.name AS species_name, s.name1 AS species_name1,
c.catname, c.catname1,
map.id mappointid, map.state mapstate, map.latitude, map.longitude,
au.id authorid, au.name authorname, c.ayear, c.aparent
FROM ppi_photos p
LEFT JOIN ppi_categories c ON c.id = p.cat
LEFT JOIN ppi_class_genus g ON g.id = c.genus_id
LEFT JOIN ppi_class_species s ON s.id = c.spec_id
LEFT JOIN ppi_import_cpg i on i.ppid=p.id
LEFT JOIN ppi_import_pp_photos m on m.catalogid=p.id
LEFT JOIN ppi_users ur on ur.userid=p.reliability_userid
LEFT JOIN ppi_users ue on ue.userid=p.eduserid
LEFT JOIN ppi_geolocation map on map.photo=p.id
LEFT JOIN ppi_class_author au on au.id=c.authorid
WHERE p.id=146054
Result: Out of resources when opening file './admin_macroid8/ppi_class_author.MYD' (Errcode: 24)
Database handle: Resource id #7
|
|