HKCCCC IT

I am building up an app to join 2 tables in a many to many relationship:

1. Contact – Master table of personnel (ID, Name, Tel, etc.)
2. Position – Master table of company position (ID, Position, Department, Rank, etc.)
3. Duty – relation table with start/end date to join Contact.ID and Position.ID

After I created Contact and Positon, how to set up the Duty table?

I am using 5.5.11 Premium lifetime edition.

I deleted the table, re-created a new design and it worked!

Thanks a lot.

There is no varchar in column type.

Thank you.

In [Data Designer] when I add new design, the column type can choose varchar. But after save it all changes to text and there is no varchar options. Please advice.

Tested Timezone displays correctly, haven’t tested other functions yet.

Thanks a lot.

Thank you very much. Agree it should be stored in UTC and display according to WordPress timezone setting.

Thank you, the settings worked.

Our website is behind a nginx reverse proxy with IP 192.168.1.2

When a client submits a form, the entry’s IP address is not the client’s IP address but 192.168.1.2. How to report the correct IP?

FYI: We use other wordpress plugins that has an option to choose which IP address to use, if we set HTTP_X_FORWARDED_FOR it will correctly report client’s IP.

Thank you very much, problem solved!

I found that the aiowps_ip_retrieve_method is not in the settings.php, after checking it turns out that the php files does not have permission for WordPress to write. I added the setting but not working, so I uninstalled and re-install the plugin, set the file permission again and everything’s fine.