Warning: include(../common.php): failed to open stream: No such file or directory in C:\xampp\htdocs\volvo40forum\forum\extract_external_links.php on line 15
Warning: include(): Failed opening '../common.php' for inclusion (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\volvo40forum\forum\extract_external_links.php on line 15
Warning: include(../includes/functions_display.php): failed to open stream: No such file or directory in C:\xampp\htdocs\volvo40forum\forum\extract_external_links.php on line 16
Warning: include(): Failed opening '../includes/functions_display.php' for inclusion (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\volvo40forum\forum\extract_external_links.php on line 16
Warning: include(../includes/functions_posting.php): failed to open stream: No such file or directory in C:\xampp\htdocs\volvo40forum\forum\extract_external_links.php on line 17
Warning: include(): Failed opening '../includes/functions_posting.php' for inclusion (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\volvo40forum\forum\extract_external_links.php on line 17
Warning: include(../phpbb/db/tools/tools_interface.php): failed to open stream: No such file or directory in C:\xampp\htdocs\volvo40forum\forum\extract_external_links.php on line 18
Warning: include(): Failed opening '../phpbb/db/tools/tools_interface.php' for inclusion (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\volvo40forum\forum\extract_external_links.php on line 18
Notice: Undefined variable: table_prefix in C:\xampp\htdocs\volvo40forum\forum\extract_external_links.php on line 20
Notice: Undefined variable: table_prefix in C:\xampp\htdocs\volvo40forum\forum\extract_external_links.php on line 21
Notice: Undefined variable: db in C:\xampp\htdocs\volvo40forum\forum\extract_external_links.php on line 37
Fatal error: Call to a member function sql_query() on null in C:\xampp\htdocs\volvo40forum\forum\extract_external_links.php on line 37
Here's a link to a thread on my forum that had a good number of photos if it helps. I have the extension running but with the proxy server disabled. http://www.forum.corvette-restoration.c ... &start=540
Have you extracted the links and downloaded the images that Mike has very kindly supplied?mainevette wrote: ↑Fri Jul 28, 2017 1:48 am I've also installed the extension and adjusted the settings per the readme file. I've tried running it both with and without the proxy server enabled. Any thoughts?
The script is not able to open some of the phpBB library files it need in order to run.
Do not enable the proxy function unless you have a secure site (using https://) and have a known working secure image proxy server.mainevette wrote: ↑Fri Jul 28, 2017 1:48 am Hello,
I've also installed the extension and adjusted the settings per the readme file. I've tried running it both with and without the proxy server enabled.
With the extension enabled the stock photobucket "speedometer" image is replaced with a simple icon only, it doesn't display the actual image. A screenshot is provided below. When I click the image link I'm redirected to photobucket's website where it displays the "speedometer" image.
Here's a link to a thread on my forum that had a good number of photos if it helps. I have the extension running but with the proxy server disabled. http://www.forum.corvette-restoration.c ... &start=540
As a last-ditch effort I purged my cache but that didn't work (figured it wouldn't anyhow). Any thoughts?
Code: Select all
<img src="https://forum.corvette-restoration.com//744eb10dac795a078c9b85e340d669757a799ebc/687474703a2f2f6933342e70686f746f6275636b65742e636f6d2f616c62756d732f643133382f7669746f70617363616c652f436f6e736f6c652532306b69745f7a707365696e736f7768312e6a7067" class="postimage" alt="Image">
Code: Select all
<img src="https://frenchcarforum.co.uk/forum/images/ext/d389166a50329df89686874142f3c83d" class="postimage" alt="Image">
Code: Select all
https://frenchcarforum.co.uk/forum/images/ext/d389166a50329df89686874142f3c83d
Thanks, the files were in the wrong folder indeed, maybe i missed it where to putt those files.
Where can i change the execution time?Fatal error: Maximum execution time of 150 seconds exceeded in C:\xampp\htdocs\volvo40forum\forum\scripts\download_external_images.php on line 165
I don't know much about php on windows. On linux, I think you can change the timeout by setting an environment variable in the shell where you run the script.Havym wrote: ↑Fri Jul 28, 2017 11:17 am Thanks, the files were in the wrong folder indeed, maybe i missed it where to putt those files.
Now it runs but stops after 150 seconds.
Where can i change the execution time?Fatal error: Maximum execution time of 150 seconds exceeded in C:\xampp\htdocs\volvo40forum\forum\scripts\download_external_images.php on line 165
Im not a hero with php scripting as you can see
I have just tried to run this and got the following error:-v12mike wrote: ↑Fri Jul 07, 2017 6:18 am I have uploaded my scripts to extract and download photobucket-hosted in-line images at: https://github.com/v12mike/fetch-external-images
<snip>
Code: Select all
[28-Jul-2017 07:28:08 CST6CDT] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/mronionm/public_html/_hifikabin/scripts/extract_external_links.php:72) in /home/mronionm/public_html/_hifikabin/includes/functions.php on line 1949
Code: Select all
$sql = 'CREATE TABLE IF NOT EXISTS ' . EXTERNAL_IMAGES_TABLE . ' (
ext_image_id INTEGER PRIMARY KEY AUTO_INCREMENT,
status INT(10),
size INT(10),
url VARCHAR(500),
host VARCHAR(100),
file VARCHAR(100),
ext VARCHAR(10)
)';
I would say skip. 500 characters is a long url in anyones languagev12mike wrote: ↑Fri Jul 28, 2017 2:23 pm Most likely you have found an image with a vveerryy long url...
At the beginning of the script we set the database field to length 500:Maybe you need more, or maybe we should skip images with excessively long urls?Code: Select all
$sql = 'CREATE TABLE IF NOT EXISTS ' . EXTERNAL_IMAGES_TABLE . ' ( ext_image_id INTEGER PRIMARY KEY AUTO_INCREMENT, status INT(10), size INT(10), url VARCHAR(500), host VARCHAR(100), file VARCHAR(100), ext VARCHAR(10) )';
General Error
SQL ERROR [ mysqli ]
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'MAX_URL_LEN), host VARCHAR(100), file VARCHAR(100), ext VARCHAR(10) ' at line 5 [1064]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.