Page 5 of 7
Posted: Thu Aug 30, 2007 2:25 pm
by Chinster
blog.brockha.us wrote:Is the directory you configured for the media database existing on your server and accessible to your server?
Yes, I set up /serendipity/uploads/images for my images. I can upload no problems using the media manager and it creates the thumbs also in that directory.
Here's a few screen grabs which might help:
http://www.crookedabstraction.com/seren ... oblem1.jpg
http://www.crookedabstraction.com/seren ... oblem2.jpg
http://www.crookedabstraction.com/seren ... oblem3.jpg
Posted: Thu Aug 30, 2007 2:30 pm
by blog.brockha.us
The second screenshot shows an error relating to a wrong database version. Did you upgrade to 1.2 or did you do a fresh install?
Posted: Thu Aug 30, 2007 2:34 pm
by Chinster
It was an upgrade.
Posted: Thu Aug 30, 2007 3:44 pm
by garvinhicking
Hi!
Sadly you didn't properly perform the upgrade. Did you follow the steps mentioined in the FAQ? You are missing a database upgrade.
Please redo the upgrade like outlined in the FAQ.
Regards,
Garvin
Posted: Thu Aug 30, 2007 3:58 pm
by Chinster
Hiya,
The upgrade appeared to go smoothly, with no errors and everything marked as writeable that should have been.
/sigh
Is it a big issue? If not I'll probably just leave it as is
Posted: Thu Aug 30, 2007 4:06 pm
by garvinhicking
Hi!
IT is a big issue! You are missing database columns that are required for porpoer operation.
Did you see the upgrader when you upgraded ?Did it tell you that it will execute some SQL statements? And did you tell the installer to go ahead with these? any error messages on the following screen?
Make sure your SQL user has privileges to execute "ALTER TABLE" statements.
Regards,
Garvin
Posted: Thu Aug 30, 2007 4:18 pm
by Chinster
Ok, I re-upgraded and got some error messages this time. Screenshot below:
http://www.crookedabstraction.com/seren ... /prob1.jpg
Posted: Thu Aug 30, 2007 4:22 pm
by garvinhicking
Hi!
The mediadatabase upgrade for the realname column happened much earlier then the verison you backgraded, it seems.
The realname column was introduced somewhere in serendipity 1.1, so you might need to browse through the sql/db_update*.sql files to check if those listed columns exist.
You might need to backdate your version to serendipity 1.0 (like the FAQ mentions) and then all other DB updates can be re-executed. Already existing columns will not be readded, so there shouldn't be any problem with that.
Regards,
Garvin
Posted: Thu Aug 30, 2007 4:35 pm
by Chinster
Posted: Thu Aug 30, 2007 6:11 pm
by garvinhicking
Hi!
Okay, that screen looks good. Now you no longer get that SQL error in the media database, right?
Regards,
Garvin
Posted: Thu Aug 30, 2007 6:45 pm
by Chinster
Result! Thank you.
I had to re-create my images directory for some reason and re-upload through media manager to get them to show but all is now good.
Now, that just leaves the small problem of the 'Add image from mediadatabase' button not working on tinyMCE
I'm still getting the 'You have to be logged in to view this page' message
Posted: Thu Aug 30, 2007 6:50 pm
by garvinhicking
Hi!
Could it be that you login to a different URL than the one that opens the media selector? If you are logged in to
www.example.com, you are not automatically logged on to example.com!
Regards,
Garvin
Posted: Thu Aug 30, 2007 7:12 pm
by Chinster
Good thinking there batman!
You are right, when I click to add from the media button the address is:
http://crookedabstraction.com
Whereas I log into:
www.crookedabstraction.com
So I changed it in the config and now all is good!
Have a sweetie on me
Posted: Thu Aug 30, 2007 7:17 pm
by garvinhicking
Hi!
Glad that's solved.
I'll dedicate my next Big Daddy Kill to you.
Regards,
Garvin
Posted: Thu Aug 30, 2007 7:44 pm
by Chinster
We need an off topic forum
