Posted on: 03/31/07 07:19pm
By: dbsmall
I will post this, and if history is any indicator, one of two things will happen:
1) I'll realize that I made a common/easy/obvious mistake, and apologize in about 5 minutes.
2) Someone will chime in quickly with expert help.
-------
So I upgraded to 1.4.1. My old theme isn't working, and I leave the site alone for a couple of weeks, while I learn about CSS. Determined to create a new, CSS-enabled theme (by modifying the default/professional theme), I do the following:
1) Use PHPMyAdmin to manually change the theme setting for a 'test' account
2) Enable user themes in config.php
[No, I don't know why I did #1, but I did.]
I go to log in as the test account, and I'm immediately logged out.
I log in as an admin acct, same thing.
I undo #1 and #2, and the problem persists (making me think it preexisted my theme efforts).
So the strong bet is 'cookies', according to the FAQ (http://www.geeklog.net/faqman/index.php?op=view&t=26 ).
But I can log in fine to geeklog.net! (so it's probably not a firewall issue)
# You are using frame forwarding or some other means of "hiding" the real URL of your site. Browsers, however, will only accept cookies from the real domain. You should set the $_CONF['cookiedomain'] variable to point to the real domain, not to the domain that's displayed in the browser's URL field in such a case.
Well, gee, I'm not actually doing this, so...
What I will check is the following---I've added a number of subdomains for playing with Ruby on Rails. Perhaps there's a cookie conflict there...
Whitespace at the end of your config.php or lib-common.php can also prevent you from logging in.
Nope.
# The site has been running an earlier version of Geeklog (pre-1.3.8) before. The problem here is that cookies have changed slightly in Geeklog 1.3.8. Try deleting your cookies (for that site).
Not likely, it's worked since then.
It is possible my hosting provider has updated to PHP 5. I'll check by doing a phpinfo(); script and see the parameter settings.
But in the meantime, if anyone has any suggestions, ...
Re: Can't log in. Really.
Posted on: 03/31/07 07:23pm
By: dbsmall
Nope, clearing out the cookies didn't help.
Perhaps this message in my error.log provides a clue:
1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1. SQL in question: SELECT * FROM
Re: Can't log in. Really.
Posted on: 04/01/07 10:32am
By: Laugh
Was logging into 1.4.1 working before you did the theme database changes to the test user?
Re: Can't log in. Really.
Posted on: 04/01/07 02:00pm
By: Anonymous (dbsmall)
Yes, although possibly not immediately before.
Logging in was working, but some of the posting forms didn't look right (e.g., posting as HTML), so I started mucking with the original theme---result, I lost the "contribute" portion of the toolbar (I think I replaced something with a {menu_items} variable or whatever).
Then, a few days later, I tried changing the theme for the test user. I don't think they're related, but I don't know what else it could be.
Re: Can't log in. Really.
Posted on: 04/01/07 02:09pm
By: Dirk
I'd suggest you reinstall the original professional theme, set it as the default theme in config.php, and rename the folders for all the other themes you have. When Geeklog can't find a theme, it will fall back to the default theme.
If you still can't log in then, we know it's not a theme issue and can take things from there.
bye, Dirk
Re: Can't log in. Really.
Posted on: 04/03/07 08:04am
By: Anonymous (dbsmall)
Hmmm...no change on my end...(well, a reboot, but I had tried other computers, as well).
Before Dirk's message, I'd tried his approach (other than renaming the unused themes).
But, mysteriously, today, it all works again. (I've lost my "conribute" menu item, but I'm sure I can find that). Logging in works find with/without user-selected themes.
I'll chalk this up to my hosting provider updating PHP, perhaps, and mucking with settings.
Thanks, as always, for the help.