« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - 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 ’ ’’, ’1263207530’, ’998’, NULL, ’213.83.161.198’)’ at line 1 »
SQL: REPLACE INTO `database_modx`.`modx_active_users` (internalKey, username, lasthit, action, id, ip) values(-, ’’, ’1263207530’, ’998’, NULL, ’213.83.161.198’)
[Copy SQL to ClipBoard]
Parser timing
MySQL: 0.0015 s (0 Requests)
PHP: 0.0176 s
Total: 0.0191 s
Im Using ..
MYSQL 5.1.41-3
Apache/2.2.9 (Debian) PHP/5.2.6-1+lenny3 with Suhosin-Patch
phpMyAdmin 3.1.1
Please help me ..
Mysql 5.1.52
Apache 2.2.17
PHP 5.2.12
Linux
-
MODX Staff
- 12,272 Posts
You might start by explaining what you were doing when this error occurred.
Ryan Thrash, MODX Co-Founder
Follow me on Twitter at @rthrash or catch my occasional unofficial thoughts at thrash.me
i think it was one of the web users who were using WebLoginPE and saved profile without being logged in, ( Unauthorized area ) have not fixed that yet :S
Mysql 5.1.52
Apache 2.2.17
PHP 5.2.12
Linux
Ive Noted this aswell, ’1267208971’, ’998’, NULL, ’213.xx.125.xxx’
its same number as i found in the table: modx_active_users | lasthit
Mysql 5.1.52
Apache 2.2.17
PHP 5.2.12
Linux
Mysql 5.1.52
Apache 2.2.17
PHP 5.2.12
Linux
i dont get it, ive repaired table modx_active_users, but problem doesnt seem solved ... :-(, maybe i never get this fixed...
Mysql 5.1.52
Apache 2.2.17
PHP 5.2.12
Linux
Is there any solutions to this?? :O
Mysql 5.1.52
Apache 2.2.17
PHP 5.2.12
Linux
Found problem, i solved this
Mysql 5.1.52
Apache 2.2.17
PHP 5.2.12
Linux
Please post solution for all to learn.
Even if it sounds stupid we are all in the dark at the moment.
DEVELOPMENT ENV:- Ubuntu 12.04 | MODx Revolution 2.2.8 | LAMP 2i Apache 2.2.22 | Php 5.3.10 | Mysql 5.5.31 MySQL client version: 5.5.31
