How do I set a highlight image through phpMyAdmin?
|
WebKat
Joined: 2002-11-22
Posts: 182 |
Posted: Thu, 2012-03-29 06:11
|
|
As I've been lamenting in this thread over here: http://gallery.menalto.com/node/105831, I can't login except through the manual way (with all the login stuff in the url) and nothing I do while logged in (even though I can get into all the admin functions just fine) ever "sticks"... like changing the description on a photo, or changing a setting, or making a different image the album highlight. This last one is the one that's really bothering me right now. Where are highlights "stored" in the database? I'm sure if I could get to the right table via phpMyAdmin I could manually change the image that is the highlight, right? Anyone care to point me in the right direction? -- |
|
Posts: 8339
Check the last line of gallery2/config.php has either the correct value, or a blank value.
$gallery->setConfig('baseUri', 'http://gallery2.opalcat.com/gallery2/main.php');or
$gallery->setConfig('baseUri', '');did you move it to a sub-domain when you switched servers?
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
Posts: 1642
Webkat,
You have been reporting a lot of issues since your server move. I belive the error msg about the user not having permission to access the database on the feed issue you had earlier points to a possible root cause. You therefore need to verify the permissions your main database user has on your new server.
Basically, when you say changes you make do not "take" it suggests the database user does not have some permissions needed to edit the database as changes to G2 simply mean changes to database entries.
This needs to be solved instead of hacking around symptoms if you get what I mean.
I'll suggest opening a support ticket with your host or creating a new db user on the new server and changing your config.php accordingly.
--
dakanji.com
Posts: 182
Yeah I have talked to tech support a number of times, and today I opened an extensively descriptive support ticket about these problems. I worry that they are going to turn around and say "we don't support this software, go to the software developers for support." We shall see, though.
By the way, every time I try to type a capital I into the Comment box here, it enters it as a closing italics bbcode followed by an I. Weird. I have to copy/paste a capital I from elsewhere every time I use one.
--
WebKat, Gallery2 holdover extraordinaire.
Posts: 182
As I suspected... their response was:
--
WebKat, Gallery2 holdover extraordinaire.
Posts: 182
Consolidating all of my problems into one thread (since I'm SURE they're all tied together) here: http://gallery.menalto.com/node/105890
Please respond there, and let this thread die.
--
WebKat, Gallery2 holdover extraordinaire.
Posts: 182
I wish I had seen this little post tucked away in between the others earlier!
My last line was
So I changed it to add main.php to the end and you know what? IT WORKS NOW! That was the problem! The weird thing is, I didn't change that part of the config file when I moved the site... the old setting is what it was before, and it worked before. I wonder what made the difference?
Well anyway, THANK YOU so much. I hope that clears up everything, but it at least cleared up the login issue and the highlights issues!
--
WebKat, Gallery2 holdover extraordinaire.
Posts: 1642
Actually, with a standard G2 installation on a standard server setup, skipping the "main.php" part should not make a difference. Such URLs will normally default to index.php which, in G2, will load main.php.
Anyway, glad it is sorted.
--
dakanji.com
Posts: 8339
baseUri is used in gallery's UrlGenerator
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2