vb.org Archive - Major Additions - Product Review Forums ? Research, Review & Compare Items

Okay Ted, no problem, will continue.

I just added a new product and used an external image link, then I ran the sync external images, at the end of sync I see this text:

Quote:

photoid is: 5001fd68874b3
filename is: C:\xampp\htdocs\vb4dev\productphotos/5001fd68874b3
download is: http://i1049.photobucket.com/albums/...ndPipeRack.jpg
should now have: C:\xampp\htdocs\vb4dev\productphotos/5001fd68874b3_original.unknown
skipping the delete
exiting

The images are present in the productphotos folder YES

This is what I see on my localhost test site:

Manage Product in admin
Attachment 139818

Viewing forum
Attachment 139817

Viewing the Product itself
Attachment 139820

Viewing Product listings
Attachment 139819

Ted S

07-14-2012 10:51 PM

Quote:

Originally Posted by Kirk Fitzgerald (Post 2348160)

I just added a new product and used an external image link, then I ran the sync external images, at the end of sync I see this text:

I think I see what's happening here...

Your test forum is hosted on a windows server which has backwards urls (productphotos\ instead of productphotos/)...

It's strange that nothing errors in creating the images but perhaps windows is smarter in processing than it is in rendering...

To this this run the mySQL query:

Code:

update pf_product set mainphoto = replace(mainphoto, '/', '\\');

update pf_product set mainphoto_thumb = replace(mainphoto_thumb, '/', '\\');

update pf_product set mainphoto_small = replace(mainphoto_small, '/', '\\');

Then check that C:\xampp\htdocs\vb4dev\productphotos\5001fd68874b3 .jpg [png|gif] opens properly.

Note: This will update all images, including those with external links.

Kirk Fitzgerald

07-14-2012 11:00 PM

Ran the query Ted, now there are no images anywhere, not in admin, forum, product view or product listing

ywwz	07-14-2012 11:06 PM

1 Attachment(s)

Quote:

Originally Posted by Ted S (Post 2348111)

Care to be more specific? Have you followed the install guide? A

Read all 1 reviews

when I click this, I get error.:

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT pf.postid,pf.threadid,pf.headline,pf.rating,pf.loc ation,pf.mainphoto_thumb,DATE_FORMAT(pf.createddat e,'%a %b %D, %Y') as posted,u.userid,u.username,
pfp.title as productitle,pfp.mainphoto_thumb

FROM pf_review as pf
JOIN user as u ON u.userid = pf.userid
JOIN pf_product as pfp ON pfp.productid = pf.productid
WHERE pf.productid = '1' AND pf.approved = 1

ORDER BY pf.createddate DESC
LIMIT 0, 25;

MySQL Error : Unknown column 'pf.mainphoto_thumb' in 'field list'
Error Number : 1054
Request Date : Saturday, July 14th 2012 @ 07:04:44 PM
Error Date : Saturday, July 14th 2012 @ 07:04:44 PM
Script : http://xxx/forum/productforums.php?d...es&productid=1
Referrer : http://xxx/forum/threads/275
IP Address : xxx
Username : xx
Classname : vB_Database
MySQL Version : 5.5.23-55

Ted S

07-14-2012 11:28 PM

1 Attachment(s)

Quote:

Originally Posted by ywwz (Post 2348177)

Gotcha... That's a bug in beta 2, revised for beta 3 using the attached copy of /forums/productforums.php

Ted S

07-14-2012 11:31 PM

Quote:

Originally Posted by Kirk Fitzgerald (Post 2348172)

Ran the query Ted, now there are no images anywhere, not in admin, forum, product view or product listing

Once you synced the images the first time wasn't this already the case? The same paths are used on the frontend and backend.

View a product [in the front or backend] and open the page source. Copy down the image src path and try loading it on your server... it should be \productforums\xxxxx.image which should correspond to where the image is saved.

I can't see your server configuration to know how your folders, slashes and file types are set so it's hard to tell what part of your links are broken but from everything you've posted there doesnt seem to be an issue in how the script works but rather in the configuration versus where images actually are.

PattiOz

07-15-2012 02:34 AM

This has got to be one of the most valuable and best mods ever. You guys have worked HARD on this. I will wait until the beta graduates before upgrading to the latest to go live with but I am watching this thread very closely! I think tens of thousands of my forum participants are going to use this once I turn it on.

Kirk Fitzgerald

07-15-2012 04:40 AM

Quote:

Originally Posted by Ted S (Post 2348187)

Hey Ted,

sorry about delay, had to sleep. :)

Okay then, so when viewing a product ont he front end I obviously see no image, viewing source code I see this for the image call:

Code:

http:\\i1049.photobucket.com\albums\s386\KirkFitzgerald\PetersonCeramic3PipeStandPipeRack.jpg

but where it sends me when I put it in the broswer is this:

Code:

http://localhost/vb4dev/%5C%5Ci1049.photobucket.com%5Calbums%5Cs386%5CKirkFitzgerald%5CPetersonCeramic3PipeStandPipeRack.jpg

I can send you the main Apache config file httpd.conf is that helps to know how xampp is configured on my end, do you want me to do that?

Ted S

07-15-2012 08:11 AM

Quote:

Originally Posted by Kirk Fitzgerald (Post 2348209)

Hey Ted,

sorry about delay, had to sleep. :)

Okay then, so when viewing a product ont he front end I obviously see no image, viewing source code I see this for the image call:

Code:

http:\\i1049.photobucket.com\albums\s386\KirkFitzgerald\PetersonCeramic3PipeStandPipeRack.jpg

but where it sends me when I put it in the broswer is this:

Code:

http://localhost/vb4dev/%5C%5Ci1049.photobucket.com%5Calbums%5Cs386%5CKirkFitzgerald%5CPetersonCeramic3PipeStandPipeRack.jpg

I can send you the main Apache config file httpd.conf is that helps to know how xampp is configured on my end, do you want me to do that?

I'm so confused here... didn't you process the images through the bulk sync script turning them into local links like /productforums/xxxxxx.img?

The reason external links won't work is the query I had you run which changes / to \ to work specifically for local links. If you want to use remote images instead that's no problem, we can fix the links to point back to those...

Ted S

07-15-2012 08:12 AM

Quote:

Originally Posted by PattiOz (Post 2348200)

Thanks! :up:

All times are GMT. The time now is 04:36 AM.

Page 106 of 186

106

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02899 seconds Memory Usage 1,767KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: