JA Job Board Component 8,554 posts

[wskyguide Friend wskyguideJoin date: February 2011Posts: 25Downloads:0Uploads:1 Thanks: 2]

#164980

As I see we cannot filter jobs by status (“approved”, “expired” and etc) in 1.5.1 Stable.

In 1.5.1 beta it worked:
index.php?option=com_jajobboard&view=jajobs&layout=myjobs&status=expired

In 1.5.1 “stable”))

500 – JDatabaseMySQL::query: 1064 – 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 ‘WHERE 1=1 AND a.status in ( SELECT jos_ja_codes.value FROM jos_ja_codes WHERE ‘ at line 9 SQL=SELECT count(distinct a.id) FROM jos_ja_jobs as a INNER JOIN jos_ja_profiles as profi ON profi.user_id=a.user_id and profi.approved=1 INNER JOIN jos_users as rs ON rs.id=a.user_id and rs.block=0 LEFT JOIN jos_ja_codes as code WHERE 1=1 AND a.status in ( SELECT jos_ja_codes.value FROM jos_ja_codes WHERE jos_ja_codes.text IN (‘expired’) OR jos_ja_codes.value IN (‘expired’) ) and a.user_id=0

[Vinh CV Friend Vinh CVJoin date: August 2009Posts: 574Downloads:0Uploads:2 Thanked: 76 times in 72 posts]

#395440

Hi wskyguide

Please give us your site URL, Admin, FTP account for closer check by editing your first post and fill required information.

[wskyguide Friend wskyguideJoin date: February 2011Posts: 25Downloads:0Uploads:1 Thanks: 2]

#395538

http://demo.jobboard.joomlart.com/
Employer Account: employer/employer
Example:
It works: http://demo.jobboard.joomlart.com/index.php?option=com_jajobboard&view=jajobs&layout=myjobs&Itemid=26&title=Secretary

But there is a mysql error (debug mode):
http://demo.jobboard.joomlart.com/index.php?option=com_jajobboard&view=jajobs&layout=myjobs&Itemid=26&status=approved

[Vinh CV Friend Vinh CVJoin date: August 2009Posts: 574Downloads:0Uploads:2 Thanked: 76 times in 72 posts]

#395682

Dear wskyguid,

Thanks for your report. We have fixed the problem on our demo site already.

[wskyguide Friend wskyguideJoin date: February 2011Posts: 25Downloads:0Uploads:1 Thanks: 2]

#395901

OK! What files did you change? Thank you!

[Vinh CV Friend Vinh CVJoin date: August 2009Posts: 574Downloads:0Uploads:2 Thanked: 76 times in 72 posts]

#396024

Hi wskyguide,

The error comes from our sample data file, not related to source code.

[wskyguide Friend wskyguideJoin date: February 2011Posts: 25Downloads:0Uploads:1 Thanks: 2]

#396104

Its strange. I have got that error after upgrading from 1.5.1 beta to 1.5.1 stable on my localhost.. Different database structure?

[wskyguide Friend wskyguideJoin date: February 2011Posts: 25Downloads:0Uploads:1 Thanks: 2]

#396119

Quick start package has the same error.

[Vinh CV Friend Vinh CVJoin date: August 2009Posts: 574Downloads:0Uploads:2 Thanked: 76 times in 72 posts]

#396236

Hi wskyguide,

Please give us your site URL, Admin, FTP account for closer check by editing your first post and fill required information.

[wskyguide Friend wskyguideJoin date: February 2011Posts: 25Downloads:0Uploads:1 Thanks: 2]

#396334

I use localhost.You can download jobboard software and install it. You will see that error.

[Vinh CV Friend Vinh CVJoin date: August 2009Posts: 574Downloads:0Uploads:2 Thanked: 76 times in 72 posts]

#396403

Hi wskyguide,

To fix the problem, please download, extract the attach file and replace following file:
componentscom_jajobboardhelperjafunctions.class.php

13770

[Author]

Posts