Page 1 of 1
image_selector borked
Posted: Thu Aug 24, 2006 8:16 pm
by bdconnolly
Well... this was working fine Monday. Today the imageselector stopped working. ???
I hit the [MEDIA} button in add/edit article. Launches the following link.
http://www.site.com/serendipity_admin_i ... area]=body
The page that opens is just the blue media folders bar on the right. Center pane is empty.
If I click on any folder, I get the following error.
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
WHERE 1
AND i.path LIKE 'august06/'%'
I tried to repair the db but that doesn't work.
HELP!
Re: image_selector borked
Posted: Fri Aug 25, 2006 11:26 am
by garvinhicking
Hi!
Are you sure the query you pasted is the only output you get? No error message at the end?
Regards
Garvin
Posted: Fri Aug 25, 2006 1:41 pm
by bdconnolly
That was the only error. That all it said.
So... I upgraded to 1.1 b1. Fixed it.
Posted: Tue Aug 29, 2006 12:59 am
by Trench
I'm getting a similar message after I updated to 1.1B
Code: Select all
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
/ Unknown column 'i.realname' in 'field list'
Any help would be greatly appreciated.
Posted: Tue Aug 29, 2006 9:22 am
by garvinhicking
Hi Trench!
How did you update? The db_update*.sql files did not seem to have been run on your system, because the 'i.realname' column gets added from the upgrader.
Regards,
Garvin
Posted: Tue Aug 29, 2006 3:05 pm
by Trench
I think when I was uplaoding the files some of them got lost in the transfer. Do I have to restore the old database and start from scratch?
Posted: Tue Aug 29, 2006 3:21 pm
by garvinhicking
Hi!
I suggest you to first upload all missing files, and then edit your serendipity_config_local.inc.php file and set the version number again to the version you were upgrading from. Then you can re-run the installer/upgrader and should be able to run the .SQL updates again.
Best regards,
Garvin
Posted: Wed Aug 30, 2006 4:51 am
by Trench
It took some fiddling with serendipity_config_local.inc.php. I had to delete it and create one from scratch then manually change the version on it after the upgrade but it's working now. Thanks as always Garvin.