• eCommerce
  • Social and Community Suite
  • Content Management
  • RSS Extensions
  • VirtueMart Extensions
Follow us on Twitter   Join The Factory on the New Digg  
(0) | Login | Register | Lost Password?
Username: Password:  
Home
Our Products
Joomla 1.7.x  (23) & J!1.6.x
Joomla 1.5.x (28)
Joomla 1.0.x (17)
Factory Club Extensions (7)
Drupal, Elxis, MODx (6)
Windows Gadgets for J! (11)
Free Templates (4)
All Products (92)
Documentation
Tweets
Forum
Contact Us
Terms & Conditions
How to Buy Guide
Customers FAQ's
Updates & Upgrades
About Us
The Factory Demo Server for Joomla Extensions
Money Back Guarantee
Payment Methods for Joomla Extensions
Follow us on Facebook

Latest Tweets

  • Join us at the Joomladay UK!
  • The Factory Extensions Joomla Compatibility Chart
  • Love Factory 2.4 for Joomla 1.7
  • Love Factory - Memberships [VIDEO]
  • Love Factory - Custom Fields Integration [VIDEO]
  • Love Factory - Google Maps Integration [VIDEO]
  • Love Factory - Administrator Guide [VIDEO]
  • Love Factory - Memberships
  • Collection Factory for Joomla 1.6 with CB support
  • Reverse Auction Factory 1.5.9
 
   Home   Help Search Login Register  
The Factory > Forum > eCommerce Factory Suite for Joomla CMS. > Raffle Factory > Problem with Joomfish & Search & Tags
Pages: [1]
« previous next »
  Print  
Author Topic: Problem with Joomfish & Search & Tags  (Read 1244 times)
lumo
Newbie
*
Posts: 24


View Profile
Problem with Joomfish & Search & Tags
« on: March 07, 2010, 11:21:50 am »

Hi Guys,

There is a problem with task=tags and task=search with com_bids

Both give the error

No valid database connection Unknown column 'jfc.reference_table' in 'where clause' SQL=select count(*) from jos_bid_auctions a left join jos_bid_tags t on t.auction_id=a.id left join jos_bid_users us on a.userid=us.userid where a.close_offer=0 and a.published = 1 and jfc.reference_table = 'bid_auctions' and jfl.code = 'en-GB' and t.tagname LIKE '%Luxusurlaub Gewinn Verlosung%'

I see these are JOOMFISH_DETECT dependant but Joomfish is being detected correctly

Debug Line 482 JOOMFISH_DETECT

JOOMFISH_DETECT=1


Even commenting out all JOOMFISH_DETECT if clauses in models/jauction.php makes no difference (strangely!)
(leaving the query of course)

e.g.
//if(JOOMFISH_DETECT)
         $query .= " LEFT JOIN #__jf_content as jfc ON reference_id = a.id
               LEFT JOIN #__languages as jfl ON jfc.language_id = jfl.id ";

gives exactly the same error.

Please look into this,

Thanks

« Last Edit: March 09, 2010, 12:10:33 pm by lumo » Logged
Factory Staff 02
The Factory Staff
Hero Member
*
Posts: 1912



View Profile
Re: Problem with Joofish & Search & Tags
« Reply #1 on: March 09, 2010, 10:56:03 am »

Hi,

In the models/jauction.php file in the 619 line you have this query constructed:

   $q = "  select count(*) from #__bid_auctions a
         left join #__bid_tags t on  t.auction_id=a.id
                $join
               $where ";


Try replacing it with

   $q = "  select count(*) from #__bid_auctions a
       LEFT JOIN #__jf_content as jfc ON reference_id = a.id
      LEFT JOIN #__languages as jfl ON jfc.language_id = jfl.id
      left join #__bid_tags t on  t.auction_id=a.id
                $join
               $where ";


Cheers,
Sorin
Logged

The Factory's Development Team member.
lumo
Newbie
*
Posts: 24


View Profile
Re: Problem with Joofish & Search & Tags
« Reply #2 on: March 09, 2010, 11:19:01 am »

Hi Sorin,

Thanks, solves the error but no results are returned.

I have multiple Raffles all with Tag Gewinn (comma separated etc) .

When I click on the "Gewinn" Tag link the correct page is returned

/index.php?option=com_bids&task=tags&Itemid=11&tag=Gewinn&lang=de

error gone now but just blank with the filter boxes (see image)

Thanks again..

Logged
Factory Staff 02
The Factory Staff
Hero Member
*
Posts: 1912



View Profile
Re: Problem with Joofish & Search & Tags
« Reply #3 on: March 09, 2010, 11:31:30 am »

You probably don't have the translation of the raffle or the tag in the german language.

Sorin
Logged

The Factory's Development Team member.
lumo
Newbie
*
Posts: 24


View Profile
Re: Problem with Joofish & Search & Tags
« Reply #4 on: March 09, 2010, 12:05:19 pm »

Thanks Sorin,

That solved the problem!!

Regards,
Logged
Pages: [1]
  Print  
« previous next »
 
Jump to:  

Loading...
Joomla Extension - RSS Factory Manager  Joomla Extension - EBook Factory  Joomla Extension - Briefcase Factory  Joomla Extension - Auctions Factory  Joomla Module - RSS Contextual  Joomla Module - Exchange Factory (Europe / EURO)  Joomla Module - Exchange Factory (Romania/ RON)  Joomla Custom Extensions Development   Free Joomla Extensions  Joomla Extension - RSS Factory Pro (Enhanced Version)  Joomla Virtuemart Payment Plugin - Gecad (EPayment.ro)  Joomla Module - Mosimage / Image Module  Joomla Extension - Reverse Auction Factory (Lowest Bidder Auctions)  Joomla Extension - Article Factory Manager  Joomla Module - Lavalamp Menu  Joomla Module - RSS Image Extractor  Joomla Module - Exchange Factory (Europe / EURO) for Joomla 1.0.15  Joomla Module - Exchange Factory (Romania / RON) for Joomla 1.0.15  Joomla Module - Top Movies (IMDB)   Joomla Module - EBay Latest Auctions  Auction Factory Standalone PHP script