Renewal question

The value of the field notified after I approved is 'Y'

Does someone can confirm that after a renewal of an advertisement, the fields "notified" of the table listings in the database phpmyadmin remains to 'Y'.


I would like this confirmation to continue my research to know if the bugs come from my changes or is the software that this is a problem.

Does someone has this problem or am I the only one?

I haven't heard of any other reports. If you would send a ticket with the ftp and I will see if I can track it down and run some tests.

I freshly installed the latest version 4.12 without any change in the code and have the same problem. This is certainly not my setup.

When you say you installed the latest did you also do a clean install creating a new database?

Yes all clean installed, database and software.

My process is:

1. Add a new AD
2. Goto "Administration" page change manually expiration date of the listing for today
3. Goto phpmyadmin changed field lastDate in checkout_settings Table to yesterday
4. Goto "Homepage" of 68classified and do a refresh page
5. Now the "notified" field in listing Table is set to Y
6. Goto "Modify An Ad" and renew the same listing
7. Goto phpmyadmin and look notified field and it steal to Y

This field supposed to be set to N else no notified for the renewal time.

Thanks for the steps. I went step by step just like you and did discover the issue. In the Orders class find:

Code:

elseif($rs['oType']==3)
        {
            //listing
            $Listings->setExpiration($rs['oProductID'], $rs['oRenewal'], TRUE);
            $this->updateNotification($orderid);
            return TRUE;
        }

Replace with:

Code:

elseif($rs['oType']==3)
        {
            //listing
            $Listings->setExpiration($rs['oProductID'], $rs['oRenewal'], TRUE);
            $this->updateNotification($rs['oRenewal']);
            return TRUE;
        }

and that should fix it. Also it should be the same change in v4.0.9 as well.

Thanks again Eric,