Media Library Display Issues

[AbstractUtopia]

I upgraded to 1.3.1 recently and all of the sudden my media library died on me. The files are still there, but I cannot view my media library- instead I get this message:

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 s_images AS i
LEFT OUTER JOIN s_authors AS a
ON i.authorid = a.authorid
LEFT JOIN s_authorgroups AS acl_a
ON acl_a.authorid = 1
LEFT JOIN s_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'

and no images in my library 9but all the library tags and drop down menus are there.

I trolled around the site a bit and tried the fix listed here: http://svn.berlios.de/viewcvs/serendipi ... threv=2293 but it didn't seem to work.

Thoughts?

[garvinhicking]

Hi!

You did not seem to have executed the upgrade process correctly according to the FAQ on www.s9y.org.

How exactly did you proceed? You are missing the database .sql updates that the upgrader should've applied for you.

Regards,
Garvin

[AbstractUtopia]

I went to my go daddy page and clicked on the update version link because they control my databases. They do all the work upgrading to the next version.

There is no "upgrade" on my administration panel.

[garvinhicking]

Hi!

In that case you might want to contact godaddy support, sadly I do not know how their update mechanism works.

The way that s9y intends it to run is that the sql/dbupdate*.sql files need to be run to upgrade your database.

Regards,
Garvin

[AbstractUtopia]

Ah- well, that is too bad. I'm not going to pay the money for them to help me.

Either I'll uninstall or just suck it up and try to fix it.

[garvinhicking]

Hi!

Do you have access to the tables through phpMyAdmin? If so, your situation can be fixed, but if not, godaddy is really the only one.

Why would you need to pay them? if their upgrade tool isnot working they surely appreciate your input.

Regards,
Garvin

[AbstractUtopia]

They make you pay for any help they give you. Its just how they work.

I do have access to phpMyAdmin.

[garvinhicking]

Hi!

They make you pay for any help they give you. Its just how they work.

Hm, but also when it's a bug caused by them? I can't imagine that...

I do have access to phpMyAdmin.

Then try to execute this statement:

Code: Select all

create table s_mediaproperties (
  mediaid int(11) not null,
  property varchar(128) not null,
  property_group varchar(50) not null default '',
  property_subgroup varchar(50) not null default '',
  value text
);

create table s_options (
  name varchar(255) not null,
  value text not null,
  okey varchar(64) not null default ''
);

ALTER TABLE s_images ADD COLUMN realname varchar(255) not null default '';
ALTER TABLE s_references ADD COLUMN type varchar(128) not null default '';

ALTER TABLE s_category ADD COLUMN sort_order int(11);
ALTER TABLE s_category ADD COLUMN hide_sub int(1);

CREATE INDEX categoryso_idx ON s_category (sort_order);
CREATE INDEX reftype_idx ON s_references (type);
CREATE INDEX options_idx ON s_options (okey);

Regards,
Garvin