DB customers_info field default entries?

Hello

I am having problems with the date and can't find out the good configuration for fields in the table customers_info:

customers_info_date_account_created:

customers_info_date_account_last_modified

etc.

Mine was setup with basic Zencart:

Default: NULL

But suddenly i ended up with :

customers_info_date_account_last_modified: 10/11/2036

In the db I changed it for the 1st day of this month and now all new customers have this same date in customers_info_date_account_last_modified...

On the wiki page:

http://www.zen-cart.com/wiki/index.php/Table_customers_info

it says:

Default: NULL

AND

Default Entries

customers_info_id: 	1
customers_info_date_of_last_logon: 	0001-01-01 00:00:00
customers_info_number_of_logons: 	0
customers_info_date_account_created: 	2004-01-21 01:35:28
customers_info_date_account_last_modified: 	0001-01-01 00:00:00
global_product_notifications: 	0 

So basically what is the good way to configure those fields to avoid having a wrong date?

Thanks

P.

The default of NULL is correct. You can see the original valid structure in the /zc_install/sql/mysql_zencart.sql file.

Your problem probably has nothing to do with MySQL or default field entries, but rather a display problem conflicting with date mask settings which you've changed or customized in your store. There are various other threads on the same topic.

Hi

I can't find any info specific about "date mask settings" are you referring to the date showing in the catalog / admin language file ?

I have this in the catalog file (french.php):

@setlocale(LC_TIME, 'fr_FR.ISO_8859-1');

define('DATE_FORMAT_SHORT', '%d/%m/%Y'); // this is used for strftime()

define('DATE_FORMAT_LONG', '%A %d %B %Y'); // this is used for strftime()

define('DATE_FORMAT', 'd/m/Y'); // this is used for date()

define('DATE_TIME_FORMAT', 'd/m/Y H:i:s'); // this is used for date()

and this in the admin file (french.php)

setlocale(LC_TIME, 'fr_FR.ISO_8859-1');
define('DATE_FORMAT_SHORT', '%d/%m/%Y'); // this is used for strftime()
define('DATE_FORMAT_LONG', '%A %d %B %Y'); // this is used for strftime()
define('DATE_FORMAT', 'd/m/Y'); // this is used for date()
define('PHP_DATE_TIME_FORMAT', 'd/m/Y H:i:s'); // this is used for date()
define('DATE_TIME_FORMAT', DATE_FORMAT_SHORT . ' %H:%M:%S');
define('DATE_FORMAT_SPIFFYCAL', 'dd/MM/yyyy'); //Use only 'dd', 'MM' and 'yyyy' here in any order

Beside those 2 files, where should i look?

Thanks

Pat