Page 1 of 1
1.1 and Media Library, can't see my pics
Posted: Sun Jan 07, 2007 12:08 am
by PerfectCr
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'
Posted: Sun Jan 07, 2007 9:24 pm
by mattsches
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
Posted: Sun Jan 07, 2007 9:31 pm
by PerfectCr
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.
Posted: Mon Jan 08, 2007 11:33 am
by garvinhicking
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
Posted: Mon Jan 08, 2007 1:49 pm
by PerfectCr
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
Posted: Mon Jan 08, 2007 11:18 pm
by judebert
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.
Posted: Tue Jan 09, 2007 12:26 am
by PerfectCr
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
Posted: Tue Jan 09, 2007 12:23 pm
by PerfectCr
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!
Posted: Tue Jan 09, 2007 10:28 pm
by judebert
Finally, I got something fixed. I was starting to think I was in a slump!
Posted: Sun Jan 21, 2007 1:05 am
by eddyjunior
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.
Posted: Tue May 01, 2007 2:12 am
by francistill
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!
Posted: Tue May 01, 2007 4:06 pm
by judebert
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.
Posted: Wed May 02, 2007 12:25 am
by francistill
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.
Posted: Wed May 02, 2007 7:42 pm
by judebert
Well, good job, and good luck! At least it's working.
If you DO have any problems, let us know.