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

Hey Ted,

importing bulk xml's isn't working on my site, is there something I am missing here, I import a bulk xml, the script runs and says done but there are no products showing at all!

Ted S

07-22-2012 06:32 AM

Quote:

Originally Posted by Kirk Fitzgerald (Post 2350352)

Hey Ted,

importing bulk xml's isn't working on my site, is there something I am missing here, I import a bulk xml, the script runs and says done but there are no products showing at all!

Is your product feed in the right format? If so you'll see an update on each product if finds and whether it's new, existing or incomplete.

Kirk Fitzgerald

07-22-2012 06:37 AM

Quote:

Originally Posted by Ted S (Post 2350353)

Is your product feed in the right format? If so you'll see an update on each product if finds and whether it's new, existing or incomplete.

It was my error there Ted, I forgot to add the <productData> opening in each xml, but now I got a database error:

Quote:

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT threadid FROM thread WHERE title = 'Dr Plumb 9mm Absorbent Carbon smoking Pipe Filters 10's';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's'' at line 1
Error Number : 1064
Request Date : Sunday, July 22nd 2012 @ 01:35:11 AM
Error Date : Sunday, July 22nd 2012 @ 01:35:12 AM
Script : http://www.pipesmokerscubby.com/admi....php?do=do_xml
Referrer : http://www.pipesmokerscubby.com/admi...ums.php?do=xml
IP Address : 86.130.60.119
Username : Kirk Fitzgerald
Classname : vB_Database
MySQL Version : 5.1.63-community-log

Any ideas on this Ted?

Ted S

07-22-2012 06:52 AM

1 Attachment(s)

Quote:

Originally Posted by Kirk Fitzgerald (Post 2350354)

It was my error there Ted, I forgot to add the <productData> opening in each xml, but now I got a database error:

Any ideas on this Ted?

It's the ' in the line which is not being escaped...

admincp/productforums.php attached

Kirk Fitzgerald

07-22-2012 06:58 AM

Quote:

Originally Posted by Ted S (Post 2350357)

It's the ' in the line which is not being escaped...

admincp/productforums.php attached

Perfect, thanks Ted

Kirk Fitzgerald

07-22-2012 07:12 AM

Hey Ted,
what happened to the images on the forum/productforums.php page, the product listings no longer have images, has this feature been removed since the Beta?

Ted S

07-22-2012 07:13 AM

Quote:

Originally Posted by Kirk Fitzgerald (Post 2350361)

Hey Ted,
what happened to the images on the forum/productforums.php page, the product listings no longer have images, has this feature been removed since the Beta?

Nothing was changed in this between beta 2 and the final... In our test site images show up just fine.

Have you checked your template to be sure it's not using an older, customized version?

Kirk Fitzgerald

07-22-2012 07:24 AM

Quote:

Originally Posted by Ted S (Post 2350362)

Nothing was changed in this between beta 2 and the final... In our test site images show up just fine.

Have you checked your template to be sure it's not using an older, customized version?

Okay, had to revert some templates, huge changes in some templates then, the files don't even compare in winmerge, they are too different now, will have to figure out my changes again, no biggie I guess, just annoying.

Thanks for your help Ted, much appreciated. ):

Kirk Fitzgerald

07-22-2012 01:56 PM

Little addition for anyone wanting it in the forumdisplay for your products, to add the +add new product button to be at the top of the thread listing as well as the bottom, do the following:

Open FORUMDISPLAY

FIND:

Code:

<div id="above_threadlist" class="above_threadlist">

BELOW ADD:

Code:

<vb:if condition="$show['newproduct']">

        <a href="{vb:raw $vboptions.vbforum_url}{vb:if "$vboptions['vbforum_url']", '/', ''}productforums.php?do=addproduct" rel="nofollow" class="newcontent_textcontrol" id="newthreadlink_top"><span>+</span> {vb:rawphrase post_newproduct}</a>

</vb:if>

Perhaps something you could add in future release Ted, not essential as easy enough to hack. :)

Ted S

07-22-2012 06:16 PM

Quote:

Originally Posted by Kirk Fitzgerald (Post 2350429)

Code:

<div id="above_threadlist" class="above_threadlist">

BELOW ADD:

Code:

<vb:if condition="$show['newproduct']">

    <a href="{vb:raw $vboptions.vbforum_url}{vb:if "$vboptions['vbforum_url']", '/', ''}productforums.php?do=addproduct" rel="nofollow" class="newcontent_textcontrol" id="newthreadlink_top"><span>+</span> {vb:rawphrase post_newproduct}</a>

</vb:if>

Perhaps something you could add in future release Ted, not essential as easy enough to hack. :)

There's no hook to add it there or we would have :(

All times are GMT. The time now is 02:17 AM.

Page 110 of 186

110

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03274 seconds Memory Usage 1,756KB 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 (4)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: