neilticktin

Interesting … as this is varying from what I saw when I wrote the post.

I now see items, and that’s good.

Google calendar subscribe doesn’t appear to work, however.
And, for iCal (Apple), as well as Google, it doesn’t give the right name for the calendar. The name is the URL which is of course, bad looking.

See example at:
https://pro.mactech.com/schedule/detail/action~week/exact_date~1427180400/

Happy to find out this is a configuration error.

Through some echo statements, I poked around the code and came down to this line being the problem.

$postid = $wpdb->get_var(“SELECT post_id FROM $wpdb->postmeta WHERE meta_key = ‘$customkey’ AND meta_value = ‘$get_value’ LIMIT 1”);

$postid is not set correctly, and so when you get to this line:

if($postid)
$redirect_url .= ‘/?p=’ . $postid;

it doesn’t even execute the “then” portion. That’s why it’s just going to the default news page.

Any ideas on how to get this to work?

Thanks,
Neil

Ok … my bad on the line 16. What it was was that when I copied the code from the browser, the “spaces” were some hi-ASCII char that were confusing PHP. I replaced those with real spaces and it can interpret it.

I’ve pasted the current code at:

https://paste.uni.cc/6935

and I’m still having problems in that the script doesn’t think that it can see a valid query and therefore defaults to the default news page. For example, this link should work:

https://www.mactech.com/news/archivedisplay.mgi?id=000003a2b820445e

and I have browsed the MySQL database to be sure that it does actually exist (it does).

Thoughts?

Thanks,
Neil

First off, thanks for the quick reply!

I implemented your suggestion, and made the one change:

$customkey = ‘mgidb_id’;

I left the querytype as ‘id’; and gave it a try. I got the error:

Parse error: parse error in /Library/WebServer/Documents/mactech/news/mt-news-detail.mgi on line 16

Line 16 is:

????????$get_value = $_GET[$querytype];

Ideas?

Just to be clear, I didn’t need to install a plug-in, right? I just used the code at the link that you posted.

Thanks,
Neil