Hi Jeff,
I’m assuming you can access PHPMyAdmin to look at the database.
**** EXPORT THE DATABASE FIRST JUST IN CASE THIS GOES PEAR SHAPED ****
Also assuming your wordpress database table prefix is the default wp_ if not change wp_ to whatever in the MySQL statements below…
If you want to completely clear the sermon series table
TRUNCATE TABLE wp_church_admin_sermon_series;
And the sermon files table
TRUNCATE TABLE wp_church_admin_sermon_files;
OR
This query will show you any duplicated sermon files entries
SELECT t1.* t1 FROM wp_church_admin_sermon_files t1 INNER JOIN wp_church_admin_sermon_files t2 WHERE t1.file_id < t2.file_id AND t1.file_name!="" AND t1.file_name = t2.file_name;
And then this one would delete them....
DELETE t1 FROM wp_church_admin_sermon_files t1 INNER JOIN wp_church_admin_sermon_files t2 WHERE t1.file_id < t2.file_id AND t1.file_name!="" AND t1.file_name = t2.file_name;
-
This reply was modified 2 years, 2 months ago by
Andy Moyle.