Administrative and Maintenance Tools - Import External Images

This vBulletin 4 product imports external images in your posts from external servers or paths into a specific path, normally your forum's image folder.

Differently than the previous product Image Cache for vBulletin 3.x., it parses the posts at regular intervals for new images and replaces the external references in the background. Also, instead of using only a single folder, it creates folders for years and months, making it much easier to handle large quantities of images. The source and destination image URL's are stored into database, too, avoiding unnecessary duplicates.

It moves and optionally converts images from one place to another. It is a handy tool in order to keep your images local to your forums.

Version 1.0.4 is temporarily in BETA stage until the users have confirmed the newly requested features.
Version 1.0.5 is still in BETA stage. It adds a new bunch of additional features, one of which allows you to test your mathematical understanding ... and a few other to fine-tune CURL and socket timeouts, and resizing on the fly of too large images. If you don't know what these options do, please leave them at their default values.

[RichieBoy67]

Just found this in my log:

Database error in vBulletin 4.2.5 Beta 1:

Invalid SQL:
INSERT INTO oasl_session SET userid='85961', session_token='JEOGPb3rGt1nfI7PfB2LXGTq8B6xJazzQGD v', date_created='1488993068';

MySQL Error : Duplicate entry '85961' for key 'userid'
Error Number : 1062
Request Date : Wednesday, March 8th 2017 @ 12:11:07 PM
Error Date : Wednesday, March 8th 2017 @ 12:11:08 PM
Script : http://##############
Referrer : http://#######
IP Address : 173.245.50.139
Username : #######
Classname : vB_Database_MySQLi
MySQL Version :
Server : ########

It is supposed to be https://// also not sure about the duplicate session..

[djbaxter]

@RichieBoy67: That's essentially what is / was happening for me.

I recently updated to vBulletin 4.2.4 but I was getting all that with 4.2.3 PL2.

[y2ksw]

Originally Posted by djbaxter

How do you mark it as "scanned ok"? How do you even know which image to do that for if there's no notification and if the add-on is no longer logging its activity?

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:

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:

UPDATE post SET
iei_parsed=1
WHERE postid=N

where N is the postid.

[y2ksw]

Originally Posted by RichieBoy67

Just found this in my log:

Database error in vBulletin 4.2.5 Beta 1:

Invalid SQL:
INSERT INTO oasl_session SET userid='85961', session_token='JEOGPb3rGt1nfI7PfB2LXGTq8B6xJazzQGD v', date_created='1488993068';

MySQL Error : Duplicate entry '85961' for key 'userid'
Error Number : 1062
Request Date : Wednesday, March 8th 2017 @ 12:11:07 PM
Error Date : Wednesday, March 8th 2017 @ 12:11:08 PM
Script : http://##############
Referrer : http://#######
IP Address : 173.245.50.139
Username : #######
Classname : vB_Database_MySQLi
MySQL Version :
Server : ########

It is supposed to be https://// also not sure about the duplicate session..

These are crashed database issues and require a table repair.

[y2ksw]

Originally Posted by RichieBoy67

I just checked and this does not appear to be working at all any more.. no changes to the settings or plug in but updated Vbulletin, changed php version..things like that. Vbulletin 4.2.4 beta 1..also changed site to https://

Cron tasks says done but nothing happens..

Please disregard my PM and see here:

https://vborg.vbsupport.ru/showpost....&postcount=743

[djbaxter]

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:

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:

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

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.

[RichieBoy67]

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:

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:

UPDATE post SET
iei_parsed=1
WHERE postid=N

where N is the postid.

When I run this I get nothing..

##I get an id now after running a table repair. I will run the other one ..

[RichieBoy67]

I think it's working now because I do see the id moving after I run the 1st query. I do not see any new images yet in my import folder but I assume that just means it has not found any to import yet?

Thanks for your help!

[djbaxter]

Still not working for me. I did a repair and optimize on the database. No errors found.

[RichieBoy67]

Nope, not working.. looks like it went through the posts and is caught up with the last post but it has not imported any of the images..