SQL error on logout

134 Posts

arphaus Reply #1, 18 years, 7 months ago

Folks,

I have one client still on ModX (I switched to Drupal over a year ago). I just got this error when logging out:

error replacing into active users! SQL: REPLACE INTO
`gatewayy_modx`.modx_active_users (internalKey, username, lasthit,
action, id, ip) values('1', 'admin', '1205314856', '8', NULL,
'24.162.236.251')

Is there something wrong with the database? Is the whole site about to go kerplooey?

thanks,

Arp

Sorry - not using ModX anymore 01/01/2007

MODX Staff
12,272 Posts

Ryan Thrash Reply #2, 18 years, 7 months ago

Have you upgraded the site since switching to Drupal to a current MODx version?

Ryan Thrash, MODX Co-Founder
Follow me on Twitter at @rthrash or catch my occasional unofficial thoughts at thrash.me

134 Posts

arphaus Reply #3, 18 years, 7 months ago

Nope - no change to the site since January 2007.

Sorry - not using ModX anymore 01/01/2007

MODX Staff
10,725 Posts

opengeek Reply #4, 18 years, 7 months ago

Maybe MySQL was upgraded and one of the strict sql_modes enabled?

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

134 Posts

arphaus Reply #5, 18 years, 7 months ago

Ah - that’s very possible. That shouldn’t affect the way the site functions, no?

Sorry - not using ModX anymore 01/01/2007

MODX Staff
10,725 Posts

opengeek Reply #6, 18 years, 7 months ago

Quote from: arphaus at Mar 12, 2008, 09:25 PM

Ah - that’s very possible. That shouldn’t affect the way the site functions, no?

Likely it will yes, as there were several bugs in older versions of MODx when the new strict sql modes are used in MySQL 5.0.x.

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

134 Posts

arphaus Reply #7, 18 years, 7 months ago

Ouch. Looks like I’ll have to Drupallize then. Thanks very much for the info.

Sorry - not using ModX anymore 01/01/2007