provided by Star2Billing S.L.

Hello guys,

Its me again with my lots of questions.

I will start helping others out when i am confident in my knowledge of the product.

My problem this time is with the creation date.

I am trying to list all users created within the last week but nothing is coming up when i am confident users were created. I checked the database and realize that all the creation date for all the users are set to '0000-00-00 00:00:00'.

Can someone help me in sorting this bug out it is important that we know when an account was created.

Any help will be greatly appreciated.

Most important hint: which db are you using? Implementations for time on Postgres/Mysql are really different.

XRG,

Thanks for replying.

I am using:

mysql server version: 4.1.20

Hey Guys,

I have resolved this issue.

Incase anyone is having the same problem here is what i did.

Change the default data type of creationdate from TIMESTAMP to CURRENT_TIMESTAMP.

which file?

Anest,

Sorry i wasn't clear.

I change the default data type of the creationdate from TIMESTAMP to CURRENT_TIMESTAMP on the cc_card table.

can you make .sql file for patch?

Here goes;

Log into mya2billing database and issue the following commands:

ALTER TABLE `cc_card` CHANGE `creationdate` `creationdate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;

Or you may acchieve the same result by:

Going to your phpMyAdmin interface and click on table cc_card then click on structure and edit column creationdate and click on the check box for CURRENT_TIMESTAMP which is just below default2

Hope this helps.

Your solution sounds most appropriate. Will work.
( I personally use Postgres, so it doesn't affect me )

However, it bothers me why the current implementation (in a2b v. 1.2.3) doesn't work. See:
A2B_entity_card_multi.php:86
and FG_var_card.inc:582

Hint: try increasing the verbosity with FG_DEBUG and look at the query string.

thank you karie_ng! good job!!