search plugin queries wrong

Status: under development
Branch: https://gitlab.com/joomleague/joomleague/tree/3.0.0

Moderator: And_One

User avatar
benio08
.
Posts: 496
Joined: Wed May 05, 2010 11:00 am
Location: Poland
Contact:

search plugin queries wrong

Postby benio08 » Thu Sep 08, 2016 8:21 am

search plugin don't works
ou may not be able to visit this page because of:

an out-of-date bookmark/favourite
a search engine that has an out-of-date listing for this site
a mistyped address
you have no access to this page
The requested resource was not found.
An error has occurred while processing your request.

Please try one of the following pages:

Home Page

If difficulties persist, please contact the System Administrator of this site and report the error below.

Unknown column 'tp.projectteam_id' in 'on clause' SQL=SELECT 'Staff' as section, REPLACE(CONCAT(pe.firstname, ' \'', pe.nickname, '\' ' , pe.lastname ),'\'\'','') AS title, pe.birthday AS created, pe.country, pe.picture AS picture, CONCAT( ' Birthday:',pe.birthday , ' Notes:', pe.notes ) AS text, pt.project_id AS project_id, pt.team_id as team_id, pe.id as person_id, '' AS href, '2' AS browsernav FROM #__joomleague_person AS pe LEFT JOIN #__joomleague_team_staff AS ts ON ts.person_id = pe.id LEFT JOIN #__joomleague_project_team AS pt ON pt.id = tp.projectteam_id WHERE ( (pe.firstname LIKE '%jacek%' OR pe.lastname LIKE '%jacek%' OR pe.nickname LIKE '%jacek%') AND (pe.firstname LIKE '%zieliński%' OR pe.lastname LIKE '%zieliński%' OR pe.nickname LIKE '%zieliński%') ) AND pe.published = '1' GROUP BY pe.lastname, pe.firstname, pe.nickname ORDER BY pe.lastname,pe.firstname,pe.nickname
Jomla 2.5.8 last joomleague revision

And_One
Joomleague Project Manager, Donator
Joomleague Project Manager, Donator
Posts: 3610
Joined: Fri Sep 11, 2009 4:00 pm
Joomleague version: 2.0.x
Location: Graz
Contact:

Re: php7 and JL

Postby And_One » Thu Sep 08, 2016 12:13 pm

This error is NOT php7 related ... there is a sql query problem, i will have a look at it

And_One
Joomleague Project Manager, Donator
Joomleague Project Manager, Donator
Posts: 3610
Joined: Fri Sep 11, 2009 4:00 pm
Joomleague version: 2.0.x
Location: Graz
Contact:

Re: php7 and JL

Postby And_One » Thu Sep 08, 2016 1:05 pm

search plugin fixed


Return to “3.0.22.57ae969-Blue (Joomla: 3.x)”

Who is online

Users browsing this forum: No registered users and 1 guest

cron