Applications not showing on admin page

Hi again.

To clearify, when I wrote “applications” above I meant “submissions”. I have the Swedish version and translated incorrectly.

/Ove

Hi,

I’m also in a similar position…we have been using the plugin for years now and have thousands of applications that are no longer accessible via wp-admin/admin.php?page=jobman-list-applications or wp-admin/admin.php?page=jobman-list-applications&jobman-jobid=53909 pages.

Currently the page loads up blank.
I’m able to see the applications via a custom page template but it’s a bit messy and the export to csv option does not work from that screen.

Any assistance is greatly appreciated.
Thanks

I have many clients that also have used for years and we noticed that DB optimization is a key issue. We have had success with following the advice from the UG from 7.20.

If when you did this UG and you never followed these directions and are now experiencing the issues ….you might want to review this again.

Manually deleting old submissions? We use the submissions as an archive. If we delete everything we won’t be able to. This isn’t really a solution. The problem is that after a certain number the code isn’t sufficient enough to list the submissions.

Very disappointing answer after I mailed you and explained how important this was to solve.

How come I can list the submissions? Why isn’t DB optimization a problem for both my and user Desmondts solutions we made our selves?

From what I can ascertain by your domain at sometime you have changed servers and migrated your install is that correct ?

If that’s the case, then that action may have resulted in DB issues such as remnants and other issues that transpire when you have a DB running for a long period of time, adding,removing other plugins , updates etc.

We took over development of the plugin after 7.20 Version and we know that issues with huge Db were causing issues and that’s why we came up with that set of instructions. If you moved your DB and were using the older version of JM prior to that update then YES you should follow the advice we provided. We now the issue and that had allowed others to resume normal usage. I apologize is if this is not what you want to hear but that’s the resolution.

Thanks for all your help, I was able to solve this issue in my environment by:

1. Moving a copy of our existing job portal unto an archive box.
2. Deleted all dated post and postmeta entries from the database using
SELECT * FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE DATE_FORMAT(post_date, ‘%Y-%m-%d’) < 2015;
DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE DATE_FORMAT(post_date, ‘%Y-%m-%d’) < 2015;

Please note that in my case I truncated all post and postmeta entries older that 2015. You may want to fine grain this query by adjusting the date and limiting the post types your deleting to:
(jobman_job, jobman_app, attachment)

Query would be:
DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE DATE_FORMAT(post_date, ‘%Y-%m-%d’) < 2015 AND post_type in (jobman_job, jobman_app, attachment);

desmondt – Glad to hear your back in business – Thanks for sharing your work around.