date registered incorrect

[[Unknown]]

Correct me if I'm wrong.  Anyone that have a different mambo prefix, they should change everywhere you have mos_ to {prefix}_

ie: if an user is using test as their mambo prefix
SELECT mos.username,
will then be SELECT test.username,

FROM mambo.mos_users
will then be FROM mambo.test_users

No, they should change "smf.smf_" to their database name dot table prefix, and mambo.mos_ to their database name, dot, and table prefix for Mambo.  You should not change the "mos." at all.

-[Unknown]

[Fardo]

Thnx It worked!!!!

you should indeed change "smf.smf_" to their database name dot table prefix, and mambo.mos_ to their database name, dot, and table prefix for Mambo

[NoRad]

Here is a valid date: 1088918391
A lot of my invalid dates from the Snitz migration were: 0

I need a default date for the old Snitz users with 0. I am thinking about setting them all to January 1st, 2002. What would be my mySQL string to do this? Thanks.

[[Unknown]]

UPDATE smf_members
SET dateRegistered = UNIX_TIMESTAMP('2004-01-01')
WHERE dateRegistered = 0;

-[Unknown]

[NoRad]

Rock on. Thanks.