Graham Orford

I’m happy to report that I’ve found the problem and fixed it. So this ticket can be closed.

The issue was down to a custom search template which was using a query on the wp_ahm_files table. This table is no longer used, and a new query on wp_posts did the trick.

I can indeed, but only if you don’t put single quotes around the ID numbers. Armed with that knowledge I went back to the PHP and tried again.

The following code in my sidebar.php allows me to select the latest documents and display them with their unique link templates.

The other thing that was tripping me up is now needing to echo the do_shortcode which wasn’t required before (I assume WordPress changed something there).

<?php
global $wpdb;
$start=0;
$limit=5;
$res = $wpdb->get_results("select ID from {$wpdb->prefix}posts WHERE post_type = 'wpdmpro' and post_status = 'publish' order by ID DESC limit $start, $limit",ARRAY_A);
$showDocuments='';
foreach($res as $media) { $showDocuments .= '[wpdm_package id='.$media['ID'].']'; } 
echo do_shortcode("$showDocuments");
?>

note: The graves (slanted single quotes) have been removed from the above as they are used as code tags in this editor.

That is causing my client a great deal of upset, but from a technical viewpoint I understand that switching to the WordPress post model you are now using a dynamicially allocated id number. Thanks for confirming it is working as expected, I can rule my concerns it was a database issue.

They have created 1200 documents and 900 of them have reached their expiry date. In the old version they can only see 300 remaining ones, but in the test system (which is testing the new version) they can see all 1200. When we edit old ones the expiry data is blank but if I view the document it tells me it is expired (and provides the date). If you are editting a document that has an expiry date shouldn’t it show the expiry date?

Currently my recommendation to them is to bin all 1200 documents, and then un-bin the ones they want to keep live. They then note the new document id and updates the pages that reference them. Better to work on 300, then weed out the unwanted 900. Unless you can recommend a better way of sorting live from expired documents.

I’ve got another issue that I’d like to share with you.

I’ve found why we lost all our documents, the WordPress backup tool I was using didn’t handle all the tables, so I found a better plugin which found (I hope) all the tables. The test site now has all the documents listed again.

However, I can’t see of them as the “Allow Access” settings appear to have been lost. Looking at the source site it has them listed as “All visitors” but once migrated the values are blank. Can you shed any light on how these settings might have been lost? If you can tell me which table they are stored in I can check if they migrated correctly.

Well that was a silly mistake of mine. Thank you.

I’ve updated to the latest version, but when you viewing the packages you get the following error (once WP Debug was enabled)…

Notice: Undefined index: id in /home3/lithium1/public_html/medsmanagement/wp-content/plugins/download-manager/modules/canonical-url.php on line 138

Fatal error: Uncaught Error: Call to undefined function get_wpdm_meta() in /home3/lithium1/public_html/medsmanagement/wp-content/plugins/download-manager/modules/misc.php:34 Stack trace: #0 /home3/lithium1/public_html/medsmanagement/wp-includes/class-wp-hook.php(288): wpdm_preview_slider(NULL) #1 /home3/lithium1/public_html/medsmanagement/wp-includes/plugin.php(208): WP_Hook->apply_filters(NULL, Array) #2 /home3/lithium1/public_html/medsmanagement/wp-content/plugins/download-manager/libs/class.Package.php(1383): apply_filters(‘wdm_before_fetc…’, Array, ‘<!– WPDM Templ…’, ‘page’) #3 /home3/lithium1/public_html/medsmanagement/wp-content/plugins/download-manager/wpdm-functions.php(1548): WPDM\Package::fetchTemplate(‘<!– WPDM Templ…’, Array, ‘page’) #4 /home3/lithium1/public_html/medsmanagement/wp-content/plugins/download-manager/wpdm-functions.php(580): wpdm_fetch_template(‘page-template-1…’, 5549, ‘page’) #5 /home3/lithium1/public_html/medsmanagement/wp-includes/class-wp-hook.php(286): wpdm_downloadable(‘<p>wpdmpr in /home3/lithium1/public_html/medsmanagement/wp-content/plugins/download-manager/modules/misc.php on line 34