Hi all,
We just completed the install for 3.3 on Tuesday and we're having a lot
of complaints about staying logged in. We noticed it right away, but
thought it was due to the maintenance page being up while we linked
our pages and such. Well, we were wrong, lol.
Apparently, some members complain of being getting logged out as little
as 30 seconds after logging in. At the moment, we have no idea why
this is happening. If anyone could give us a quick fix, we'd really appreciate it.
URL to your eFiction: http://www.ik-eternal.net
Version of eFiction: 3.3
Have you bridged eFiction, if so with what?: No
Server Type: Linux
Version of PHP: 4.4.4
Version of MySQL: 4.1.22
Have you searched for your problem: Yes
If so, what terms did you try: login/logout
Have you looked at the FAQs: Yes, and I saw about 3 few things that were similar, but none seemed to be what I needed.
I don't know, but when you mess with your sitekey, or more your files to a subdirectory, ect, you get problems with the log in. Did you do anything like that?
You might want to have your users delete all their cookies and temp files.
I'd suggest changing the sitekey everywhere, but that could get messy with users who don't clean out their cookies.
Whoever said nothing is impossible never tried slamming a revolving door.
url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word
Hmmm. My sister did the installation, and she isn't here at the moment, so I really don't know.
When she checks in, I'll be sure to ask and report back. Thanks a lot for the response. π
According to my sister, we changed the sitekey during the upgrade process, because there was a step that asked
you to define a sitekey. Is the sitekey supposed to read something specific, perhaps the name of a table or something?
Because if so, then I don't think she used the proper name, so that might be the problem. She isn't sure of whether
it can be a random key or not. You also mentioned changing the site key "everywhere." Does it need to be changed
several places?
Pages of code, perhaps? Or can you just change it using the sitekey setting under the Admin panel?
Many Thanks. π
Hi again,
As suggested, we changed the sitekey to solve the login issue and the site went to blazes.
The site info that should show the number of reviews, members, etc disappeared and soon
after the site pretty much fell apart.
We're getting errors messages left and right, and upon trying to log in, we got:
The requested URL /install/install.php was not found on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
We also got this when we clicked on an author's name:
A fatal MySQL error was encountered.
Query: SELECT stories.*, author.penname as penname, UNIX_TIMESTAMP(stories.date) as date, UNIX_TIMESTAMP(stories.updated) as updated FROM (fanfiction_authors as author, fanfiction_stories as stories) WHERE author.uid = stories.uid AND stories.validated > 0 AND (stories.uid = '503' OR FIND_IN_SET(503, stories.coauthors) > 0) ORDER BY stories.title ASC LIMIT 0,
Error: (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
Oddly though, stories that appear on the main page can still be viewed provided they are not labeled mature (that requires logging in).
The site has been skinned, but it's just white, nothing but the first page is coming up. We have backups (Thank God)
and we're hoping that with time we can fix all of this and put it back together, but do you have any idea what may
have happened or what steps should be taken to fix it? Will we need to reinstall 3? Any insight would be appreciated.
The stats problem is because you changed your sitekey. You'll need to go into phpmyadmin and change it in the _stats table. You should probably also check your _settings table to make sure it got changed correctly there.
Thanks very much, Tammy. We've got everything up and back to normal.
Turns out, you were right, we missed the key change in a couple of spots.
Thanks again! π
Hey this is exactly my problem.
The files were copied and pasted recently into a new domain name.
How and where is the sitekey located in the files? And what do I change it to?
At the moment it logs you out instantly after logging in.
Please help!
Thank you so much!
URL to your eFiction: http://fanfiction.bespelled.net
Version of eFiction: 3.3
Have you bridged eFiction, if so with what?: No
Server Type: Linux
Version of PHP: 4.4.4
Version of MySQL: 4.1.22
Have you searched for your problem: Yes, and found this topic.
If so, what terms did you try: login/logout
Have you looked at the FAQs: Yes I did
It's in your config.php file and in the database at various locations mentioned above.