1.1 and Media Library, can't see my pics

PerfectCr · Post by **PerfectCr** » Sun Jan 07, 2007 12:08 am

I cannot manage, or even see any of my pictures or thumbnails any more since upgrading. 1.0.4 was fine. Below is the error message. Help!

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
                       

                       WHERE 1=1  AND i.path LIKE 'pics/%'

                     GROUP BY i.id
            ORDER BY i.date DESC  LIMIT 0, 9

/ Unknown column 'i.realname' in 'field list'

Post by **mattsches** » Sun Jan 07, 2007 9:24 pm

Looks like your upgrade was not performed correctly, i.e. your database has note been updated. The column 'realname' was only added with version 1.1-alpha5 (as far as I can tell). Please try to upgrade again.

Alternatively, you can execute the respective statements given in the sql/db_update*mysql.sql files yourself. But only do that if you know what you're doing

PerfectCr · Post by **PerfectCr** » Sun Jan 07, 2007 9:31 pm

mattsches wrote:Looks like your upgrade was not performed correctly, i.e. your database has note been updated. The column 'realname' was only added with version 1.1-alpha5 (as far as I can tell). Please try to upgrade again.

Alternatively, you can execute the respective statements given in the sql/db_update*mysql.sql files yourself. But only do that if you know what you're doing

I actually did run the install again and I got the same thing. What could have changed? Yeah I have no idea how to update mysql files on my own, my database is hosted with Godaddy.com.

Post by **garvinhicking** » Mon Jan 08, 2007 11:33 am

Hi!

You only write "I did run the install again".

What *EXACTLY* did you do? Please perform upgrades exactly as outlined in the FAQ on www.s9y.org.

Best regards,
Garvin

PerfectCr · Post by **PerfectCr** » Mon Jan 08, 2007 1:49 pm

garvinhicking wrote:Hi!

You only write "I did run the install again".

What *EXACTLY* did you do? Please perform upgrades exactly as outlined in the FAQ on www.s9y.org.

Best regards,
Garvin

I've been using S9Y for over a year now and performed many upgrades. I extracted the files over the old files on the server exactly as outlined in the FAQ.

This is the first time I have done the upgrade where I did not see the "upgraded screen". I just went to the admin panel and it DOES say I am running 1.1.

I've followed the FAQ, as far as I can tell, all it says to do is simply extract the new files and copy them over the old ones on the server. I've done this for every upgrade I've run.

I reinstalled v1.1 twice and I still have no access to my Media Library

judebert · Post by **judebert** » Mon Jan 08, 2007 11:18 pm

This is the first time I have done the upgrade where I did not see the "upgraded screen". I just went to the admin panel and it DOES say I am running 1.1.

A-ha! (Well, kinda.) It sounds like S9Y never recognized that it needed to do an upgrade. What I'm about to recommend is a little unorthodox, so back up your database before you try it!

Edit your serendipity_config_local.inc.php. Find the $serendipity['Version'] variable. Change it to "1.0.4". Visit the admin screen again, and it should run the updates and modify your tables for you.

If it doesn't, try "1.0.3", and let us know: it'll give us an idea of where to look.

PerfectCr · Post by **PerfectCr** » Tue Jan 09, 2007 12:26 am

judebert wrote:
This is the first time I have done the upgrade where I did not see the "upgraded screen". I just went to the admin panel and it DOES say I am running 1.1.
A-ha! (Well, kinda.) It sounds like S9Y never recognized that it needed to do an upgrade. What I'm about to recommend is a little unorthodox, so back up your database before you try it!

Edit your serendipity_config_local.inc.php. Find the $serendipity['Version'] variable. Change it to "1.0.4". Visit the admin screen again, and it should run the updates and modify your tables for you.

If it doesn't, try "1.0.3", and let us know: it'll give us an idea of where to look.

Ok, as soon as I can get access to my site again I will run the backup plugin. I also have access to PHPMyAdmin to perform a backup there, but the inferface is very confusing and I have no idea how to perform a proper backup

PerfectCr · Post by **PerfectCr** » Tue Jan 09, 2007 12:23 pm

judebert wrote:
This is the first time I have done the upgrade where I did not see the "upgraded screen". I just went to the admin panel and it DOES say I am running 1.1.
A-ha! (Well, kinda.) It sounds like S9Y never recognized that it needed to do an upgrade. What I'm about to recommend is a little unorthodox, so back up your database before you try it!

Edit your serendipity_config_local.inc.php. Find the $serendipity['Version'] variable. Change it to "1.0.4". Visit the admin screen again, and it should run the updates and modify your tables for you.

If it doesn't, try "1.0.3", and let us know: it'll give us an idea of where to look.

THAT WORKED!! Thanks you so much! The Media Library is now working! Thank you again!

judebert · Post by **judebert** » Tue Jan 09, 2007 10:28 pm

Finally, I got something fixed. I was starting to think I was in a slump!

eddyjunior · Post by **eddyjunior** » Sun Jan 21, 2007 1:05 am

judebert wrote:
This is the first time I have done the upgrade where I did not see the "upgraded screen". I just went to the admin panel and it DOES say I am running 1.1.
A-ha! (Well, kinda.) It sounds like S9Y never recognized that it needed to do an upgrade. What I'm about to recommend is a little unorthodox, so back up your database before you try it!

Edit your serendipity_config_local.inc.php. Find the $serendipity['Version'] variable. Change it to "1.0.4". Visit the admin screen again, and it should run the updates and modify your tables for you.

If it doesn't, try "1.0.3", and let us know: it'll give us an idea of where to look.

Thank you very much, this worked perfectly.

francistill · Post by **francistill** » Tue May 01, 2007 2:12 am

Just to let you know, I encountered the same problem and followed this procedure successfully. I ran into a bit of an obstacle after the upgrade because the system wanted to run some sql files that it couldn't. I revised the config file to show I was running 1.1 and FTPd it to the site and all was well. Thanks very much!

judebert · Post by **judebert** » Tue May 01, 2007 4:06 pm

How about that? Maybe it's time to add this to the Expert.

Interesting; francistill, do you remember what those SQL errors were? If they were trivial, you'll have no problems. If they were important, you might start getting weird errors.

Most likely your user didn't have the "create index" right, or something similar. You may want to grant him the appropriate privileges, and run the upgrade again. Of course, if it's working, what the heck.

francistill · Post by **francistill** » Wed May 02, 2007 12:25 am

I suspect they were trivial but didn't keep a record. As soon as I reverted the config file to the proper version number (after the update ran) the website worked perfectly. Until I did that, I was caught in a virtuous circle - the script indicated there were sql files to run but said I had successfully upgraded and the "visit your website" link was visible. Once clicked, however, it went back to the upgrade install page.

judebert · Post by **judebert** » Wed May 02, 2007 7:42 pm

Well, good job, and good luck! At least it's working.

If you DO have any problems, let us know.