Keeps logging me out!

137 Posts

wiggy Reply #1, 15 years, 4 months ago

Hi Guys, seem to be getting logged out when ever I save any alteration to a page (Very frustrating)

Revo 2.1.1pl

It was working fine but the other night it crashed and I couldn’t log back on, via these forums someone suggested deleting the core/cache/ files. I did this and could log back into the manager and all seemed fine.

But today every time I need to click to do something I get logged out, I have flushed all permissions & caches (inc browser cache)
heres the error from the log file

[2011-06-28 19:00:56] (ERROR in xPDO::connect @ /services3/webpages/c/o/mysite.co.uk/public/core/xpdo/xpdo.class.php : 344) SQLSTATE[HY000] [2005] Unknown MySQL server host 'blahblah.carrierzone.com' (2)
[2011-06-28 19:00:56] (ERROR @ /connectors/browser/directory.php) Error preparing statement for query: SELECT `modSession`.`id` AS `modSession_id`, `modSession`.`access` AS `modSession_access`, `modSession`.`data` AS `modSession_data` FROM `modx_session` AS `modSession` WHERE `modSession`.`id` = ?  - Array
(
    [0] => 00000
)

Hope someone can shed some light on the frustrating little problem

137 Posts

wiggy Reply #2, 15 years, 4 months ago

.....Not sure but it may have been because Google Chrome was updating in the background? I click about (On Chrome) where is said installing update but since it restarted I can now save my changes?

Very strange?

137 Posts

wiggy Reply #3, 15 years, 4 months ago

Nope spoke too soon, its still not working Aghhhhhhhhhhhhhhhh

Do I need to reinstall modx? (can I just dump a newly downloaded version over the top of the existing one and preform a setup??

Or could the mysql host be having issues (My clients using BT as there host) hense database connection problem?

Decisions, Decisions >:(

☆ A M B ☆
3,141 Posts

Mark Hamstra Reply #4, 15 years, 4 months ago

If the host would be DB connection couldn’t be made, you wouldn’t be able to login at all so I’m not sure that is the main cause.

Perhaps try to open up the database with PhpMyAdmin and flush the sessions database, clear the core/cache folder again and finally your browser cache.

If that doesn’t work try running an upgrade like you suggested yourself.

Mark Hamstra • Developer spending his days working on Premium Extras and a MODX Site Dashboard with the ability to remotely upgrade MODX and extras to make the MODX world a little better.

Tweet me @mark_hamstra, check my infrequent blog at markhamstra.com, my slightly more frequent ramblings at MODX.today or see code at Github.

137 Posts

wiggy Reply #5, 15 years, 4 months ago

Hi Mark,
Just installed/ updated (alto on the same version) but still the same problem, without sounding stupid how do I flush the Session DB?

137 Posts

wiggy Reply #6, 15 years, 4 months ago

I’ve even added a new administrator but symptoms still persisting...hoping its a hosting problem?

☆ A M B ☆
3,141 Posts

Mark Hamstra Reply #7, 15 years, 4 months ago

Quote from: wiggy at Jun 28, 2011, 03:43 PM

Hi Mark,
Just installed/ updated (alto on the same version) but still the same problem, without sounding stupid how do I flush the Session DB?

Open up the database with a tool like PhpMyAdmin and find (iirc) modx_session, and then choose to Flush/empty the database.

Mark Hamstra • Developer spending his days working on Premium Extras and a MODX Site Dashboard with the ability to remotely upgrade MODX and extras to make the MODX world a little better.

Tweet me @mark_hamstra, check my infrequent blog at markhamstra.com, my slightly more frequent ramblings at MODX.today or see code at Github.

MODX Staff
10,725 Posts

opengeek Reply #8, 15 years, 4 months ago

Sounds like you are having connectivity issues with the machine hosting the database server.

Jason Coward
Chief Architect @ MODX
http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek

137 Posts

wiggy Reply #9, 15 years, 4 months ago

I’ve had a nightmare... reinstalled modx, reloaded mysql database, still same problems!

I’ve tried to flush the modx_session (In myslq) but am getting the following error:

SQL query:

FLUSH TABLE  `modx_session`

MySQL said: 

#1227 - Access denied; you need the RELOAD privilege for this operation

also the overhead under that table "6,800B" (in red!?)

Hope someone can help because this will be a major pain in the ass if I have to start from scratch 20+hours sad

137 Posts

wiggy Reply #10, 15 years, 4 months ago

Also when I click Logout nothing happens??