At this stage don't know whether the computer used for data entry had a clock error (?) or the host server has a clock error ... or what.
The problem now is how to correct the dates used for the Meeting Event and Full-Membership Payment. Here are the steps and essential info you need to note using phpMyAdmin.
1. log-in to your database
2. There are 2 tables you'll need to look at: Events, Members
3. In the Event table you will need to note the Event-ID, Date, and Type
There are 4 types of event: 1. Membership Payment, 2. Meeting, 3. Other Income, 4. Expenses.
4. Click on the table name in left column = SGEMS_event
5. Click on the <i>browse</i> tab in the main frame (right column)
6. Click on the double arrow >> pointing right to move to the last page of records.
7. Scroll down the page - locate and make note of the EventID number for the event you wish to correct (read the event description)
8. Note the figure in the DATE column - it is a series of numbers that represent time in seconds.
9. In a new browser window, use this UNIX timestamp caculator to convert the timestamp to a regular date so you can make sure this is the record you wish to correct. Make sure you choose the correct timezone (Australia = +10)
10. Now use the timestamp calculator to convert the correct date into a UNIX timestamp. Be sure to insert leading zero for months and times (ie. 6th June 07 = 06 06 2007)
11. Click on the Pencil icon in SGEMS_event table, then replace the incorrect timestamp with the corrected timestamp.
12. Repeat these steps other events with incorrect dates.
In the case of incorrect Full-Membership payment dates, continue with the next step(s)
13. Browse SGEMS_member table to find and make note of the memberID.
14. Browse SGEMS_payment table to find and make note of the eventID based on the memberID found in step 13.
15. Browse SGEMS_event table to find and correct the timestamp for the event record matching the eventID found in step 14.
16. Finally browse the SGEMS_member table to locate members, and click on the Pencil icon to correct the Full-Membership Status Expires Date with a new timestamp - 12 months ahead of payment date (you will need to use the Unix Timestamp Calculator).
Before you log out of the database refresh the SGEMS page and check your changes.
.gif){kind=small}
