eCommerce
Social and Community Suite
Content Management
RSS Extensions
VirtueMart Extensions
(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
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
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
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
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
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
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:
Please select a destination:
-----------------------------
Forum
-----------------------------
=> News & Announcements
===> Community News
===> General Discussion
===> Unlisted Products
=> eCommerce Factory Suite
for Joomla CMS.
===> Auction Factory
===> Reverse Auction Factory
===> Raffle Factory
===> Collection Factory
===> Ads Factory
===> Media Mall Factory
=> Social & Community Factory Suite
for Joomla CMS.
===> jAnswers Factory
===> Love Factory
===> Chat Factory
===> Deluxe Blog Factory
===> HOT or NOT Deluxe Factory
===> Photo Battle Factory
===> HOT or NOT Factory
=> Content Management Suite
for Joomla CMS.
===> Advertisement Factory
===> Briefcase Factory
===> eBook Factory
===> Article Factory Manager
===> Content Image Factory
=> RSS Factory Suite
for Joomla CMS.
===> rss Factory PRO
===> rss Factory
===> rss to Image Factory
===> rss Context Factory
=> VirtueMart Extensions & Payment Facilities
===> VM Factory Reports
===> VM Factory Orders & Reviews
===> VM Tree Factory
===> VM ePayment Factory
=> Miscellaneous Extensions & Modules
for Joomla.
===> eBay Factory Module
===> Top Movies Factory
===> Exchange Rates Factory
===> Factory Calculators
===> Lava Factory Menu
===> Feedback Factory
===> Awards Factory
=> Other CMS Extensions
===> DRUPAL Extensions & Modules
===> ELXIS Extensions & Modules
===> MODx Extensions & Modules
=> Windows Gadgets
=> Template Factory
===> Joomla Business Template #01
===> Joomla Business Template #02
Loading...