__jd_donors question: published column = 0 or 1

  • Dave
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
5 years 6 months ago #117192 by Dave
In the -jd_donors table, the 'published' column has value 0 or 1.

If value 1, then row is included in showNumberDonors total for the JD Donation Campaigns module.
If value 0, row is not included in total.

On localhost development server, using Test mode for donation transaction, the Continue button will write a new record to __jd_donors table with 'published' value=0, therefore the new record is not included in JD Donation Campaigns module showNumberDonors total.

I don't know if this is due to Test transaction, or some other problem.

Is published' value=0 an expected feature of Test transaction?

Thx.

Please Log in or Create an account to join the conversation.

More
5 years 6 months ago #117195 by Mr. Dam
Hi,
You should make transaction (even on test mode) if you want to field: "published" = 1
You can test with Paypal sandbox or Authorize.net test mode.
Thanks
Dam

Please Log in or Create an account to join the conversation.

  • Dave
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
5 years 6 months ago #117234 by Dave
My test transactions create new row with column 'published' = 0.

Why is it 0?

Test mode always writes 'published' = 0?

Please Log in or Create an account to join the conversation.

More
5 years 6 months ago #117252 by Mr. Dam
Hi Dave
0 means Unpaid
1 means Paid
When you make new donation, but you haven't paid through Payment system, Joom Donation will create new donor record in #__jd_donors to store your information.
Once you make payment through Payment system, Joom Donation will update Paid status (Published -> 1).
Actually, i can't explain deeper because this is technical area. Hope you understand.
Dam

Please Log in or Create an account to join the conversation.

Moderators: Mr. DamDũng Nguyễn Việt