9
« on: November 05, 2005, 11:56:21 AM »
I am aware that patched 4images will not be supported, but I am just needing at least a direction where to look for the problem. I integrated 4images 1.7.1 with Xoops portal.
I was trying to edit a user in the 4images control panel and I get this DB error:
DB Error: Bad SQL Query: UPDATE xoops_users SET level = 1, uname = 'lyzz', email = 'lyzzandra74@yahoo.com', user_viewemail = 0, user_mailok = 1, user_regdate = UNIX_TIMESTAMP('2005-08-04 09:27'), = UNIX_TIMESTAMP('1969-12-31 16:00'), url = '', user_icq = '', user_dl_limit = '40', user_dl_time = '0', user_dl_count = '0' WHERE uid = 4
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 '= UNIX_TIMESTAMP('1969-12-31 16:00'), url = '', user_icq = '', user_dl_limit = '' at line 2
Error editing user
--
I tried editing the download limit - I got the above error
I tried editing the "Last Activity" to an actual date (it seems by default it is with year 1969) - I got similar error message
I concluded that this has nothing to do with the download limit at all but somewhere in editing a user.
It says on that message to check for the right syntax to use? Could anyone pls point out to me where and how I could fix that?
--
Not sure if the ff. info would help:
SERVER_SOFTWARE Apache/1.3.33 (Unix) DAV/1.0.3 mod_fastcgi/2.4.2 mod_gzip/1.3.26.1a PHP/4.3.10 mod_ssl/2.8.22 OpenSSL/0.9.7e
MySQL client 4.1.11
TYVM in advance.
Xandra