after relocating the blog to another server my media database is damaged. ok, I've done an export / import of the SQL table, but I've forgotten to move the real images from the uploads dir.
Now is the state of trouble an empty (all records are deleted) table serendipity_images and the directory uploads is emty too.
I want to do fresh uploads and fresh integration in entries.
Uploading images via s9y works, but in the media database couldn't be found anything and I cant select anything while editing. Error messages see below.
How can I repair this awful state. Should we do a fresh initial CREATE for the table? (I haven't any access via PHPMyAdmin or other tools, the only accessible way routes via my administrator.)
Thx, regards, Juergen.
This is the message while "browsing" the media database:
SELECT i.id, '' AS orderkey, i.name, i.extension, i.mime, i.size, i.dimensions_width, i.dimensions_height, i.date, i.thumbnail_name, i.authorid, i.path, i.hotlink, i.realname,
a.realname AS authorname
FROM serendipity_images AS i
LEFT OUTER JOIN serendipity_authors AS a
ON i.authorid = a.authorid
LEFT JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 1
LEFT JOIN serendipity_access AS acl_acc
ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'directory'
AND acl_acc.artifact_index = i.path
)
WHERE 1=1 AND (
i.path IS NULL OR
acl_acc.groupid IS NULL
OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL
)
)
GROUP BY i.id
ORDER BY i.date DESC LIMIT 0, 8
/ Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
And this is the message in the popup if I want to insert an image while editing:
SELECT i.id, '' AS orderkey, i.name, i.extension, i.mime, i.size, i.dimensions_width, i.dimensions_height, i.date, i.thumbnail_name, i.authorid, i.path, i.hotlink, i.realname,
a.realname AS authorname
FROM serendipity_images AS i
LEFT OUTER JOIN serendipity_authors AS a
ON i.authorid = a.authorid
LEFT JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 1
LEFT JOIN serendipity_access AS acl_acc
ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'directory'
AND acl_acc.artifact_index = i.path
)
WHERE 1=1 AND (
i.path IS NULL OR
acl_acc.groupid IS NULL
OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL
)
)
GROUP BY i.id
ORDER BY i.date DESC LIMIT 0, 9
/ Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Both of them are pointing to code problem...