Database filled with recurrent appoinments
Thanks Nikola.
Best regards.
Alberto
Nikola,
I did what you said deleted EA_Appoinments, EA_Fields and EA_Connect_links and it did the job there is no trash records now but when I add a new appoinment it doesn’t start from 1, What can I do to fix it?
Thank you in advance.
Regards
Alberto.
Use more SQL, like:
alter table wp_ea_appointments auto_increment=1;
to reset the auto_increment counter. To get current auto_increment value for table, check the “information schema”:
select table_schema, table_name, auto_increment from information_schema.tables where table_name=”wp_ea_appointments”;
(for mysql command line or use phpMyAdmin and click around…)
Similary, to start at a larger id (to look “popular”) use:
alter table wp_ea_appointments auto_increment=10000;
to start at id 10000 🙂
Please login or Register to submit your answer
To delete all appointments SQL-statements like
delete from wp_ea_appointments;
can be used (WARNING: DELETES ALL RECORDS) with phpMyAdmin or similar. Possibly also custom fields in wp_ea_fields. Adding a where statement is recommended to not delete all appointments.
Thanks Erik