Quote:
Originally Posted by y2ksw
The posts are scanned top-down (from postid=1 to latest).
The plugin adds a field to post, called iei_parsed.
If you issue the query:
Code:
SELECT postid
FROM post
WHERE iei_parsed>0
ORDER BY postid DESC
LIMIT 1
you get the last post ID which was successfully parsed. If this value stays put, then something is not working.
As for the concerns with https and SSL (I've been looking into it now), requesting data from such sites requires you to use CURL. You can choose the mode from the options. CURL is installed anyway since required by 4.x vBulletin versions.
Marking a post "OK" can be done this way:
Code:
UPDATE post SET
iei_parsed=1
WHERE postid=N
where N is the postid.
|
Thank you.
Running the first query shows 242442 as the last post ID.
Manually running the cron job leaves that number unchanged.
Running the second query yields
Code:
Affected Rows: 0 (0.0015s)
Repeating the whole sequence gives the same result.
Does that mean the add-on has stopped working?
Note my statement above that I recently updated to 4.2.4 but the issues were happening prior to that update.