DB error: ..right syntax to use near '= UNIX_TIMESTAMP...

[Xandra]

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

[Acidgod]

user_regdate = UNIX_TIMESTAMP('2005-08-04 09:27'), XXXXX = UNIX_TIMESTAMP('1969-12-31 16:00'),

here is the problem

[Xandra]

Acidgod: thank you so much for the prompt reply.. now hehe, where can I fix that? Sorry, if I sound dumb, but I prefer to know what I am doing.

[Acidgod]

for what do you need this "= UNIX_TIMESTAMP('1969-12-31 16:00')"?

[Xandra]

that refers to the field: Last Activity
(when you go and edit a user in the 4images ACP, you see that field after "Date of Registration")

[Acidgod]

can you show me the Part with the Query?

[Xandra]

lol, I just discovered the problem now. After so many testings, I got it right. xoops uses a different variable and the "patcher" just left that field blank in the sessions.php

NOTE: I am using Koudanshi's patch - a good starting (only!) step to integrate xoops and 4images. But it is not a flawless patch - I had to fix several db errors plus if you want to use some 4images mods - a good comprehension in php is the most ideal. I basically know nothing if I were to do a php page lol.

TY so much for your help, Acid!