Found it. Status field is missing in table charge_to_account in 3.0 sql
file. We will fix that.
Reboot must not have created any impact on table as field is already
missing.

On Sat, 3 Dec 2016 at 6:53 AM, bingy92 <notifications@github.com> wrote:

> Error Number: 1054
>
> Unknown column 'status' in 'field list'
>
> INSERT INTO charge_to_account (charge_id, accountid, status, assign_date)
> VALUES ('1', '25', 0, '2016-08-07 14:58:37')
>
> Filename: /var/www/html/astpp/modules/signup/models/signup_model.php
>
> Line Number: 90
>
> This was working until after I rebooted my server.
>
> Any suggestions?
>
> Regards,
> Phil
>
> —
> You are receiving this because you are subscribed to this thread.
> Reply to this email directly, view it on GitHub
> <https://github.com/iNextrix/ASTPP/issues/161>, or mute the thread
> <https://github.com/notifications/unsubscribe-auth/AA6gcat-WTndrwaUE10kZhi-XxlCdhb0ks5rEMSOgaJpZM4LDJos>
> .
>
–
Sent from my iPhone

Just an update:

I was able to get it working by adding the missing table column like this:

"ALTER TABLE charge_to_account ADD status INT;"

I then clicked the signup link and it worked. I got welcome email and was able to login with the credentials. My data row looks like this after the update:

-------------------------------------------------------------------------------------

Note the status set to "0" but charge_upto remains on 0000-00-00 00:00:00.

Is this okay? Can you shed some more light on that charge_upto column?

Regards,
Phil

We added the field in database.

Regarding charge_upto column, is used for invoice and receipt generation. That is to track down the date till charge has been taken from this customer for this subscription package.