Browsing this Thread:   1 Anonymous Users






Re: Jobs 4.0 resume error
#5
Webmaster
Webmaster


See User information
I have just fixed this error and it is in the current download.
I only used the 2nd edit.
I knew I must have forgot something after last week, hope that's it.


Thanks,

John

Posted on: 2010/3/22 6:33
Twitter Facebook Google Plus Linkedin Del.icio.us Digg Reddit Mr. Wong Top


Re: Jobs 4.0 resume error
#4
Just popping in
Just popping in


See User information
Hi John,

I think you forget to add this change to the latest jobs module, I just fix the problem on my xoops installation and now, it seems to work fine.

Regards

EDIT:

euh, no, still having the same problem, we can see all resumes on a specific category even if they aren't contented on this specific category.

I try to check the request on the file resumecat.php but it seems to be fine
"select cid, pid, title from ".$xoopsDB->prefix("jobs_res_categories")." where valid='Yes' and  cid=".mysql_real_escape_string($cid).""



EDIT 2:

on the file resumecat.php, line 154:
change:
$sql="select lid, cid, name, title, exp, expire, private, salary, typeprice, date, town, state, valid, view from ".$xoopsDB->prefix("jobs_resume")." where valid='yes' order by $orderby";

to:
$sql="SELECT lid, cid, name, title, exp, expire, private, salary, typeprice, date, town, state, valid, view FROM ".$xoopsDB->prefix("jobs_resume")." WHERE valid='yes' AND cid=".mysql_real_escape_string($cid). " ORDER BY $orderby";

Posted on: 2010/3/21 22:55

Edited by ghaith on 2010/3/21 23:12:16
Twitter Facebook Google Plus Linkedin Del.icio.us Digg Reddit Mr. Wong Top


Re: Jobs 4.0 resume error
#3
Webmaster
Webmaster


See User information
I have added this change to the current download.

Thanks,

John

Posted on: 2009/11/18 15:01
Twitter Facebook Google Plus Linkedin Del.icio.us Digg Reddit Mr. Wong Top


Re: Jobs 4.0 resume error
#2
Just popping in
Just popping in


See User information
Thanks to you bro for your fix and for your great module.
Tested now and works fine ;)

Posted on: 2009/11/18 13:14
Twitter Facebook Google Plus Linkedin Del.icio.us Digg Reddit Mr. Wong Top


Jobs 4.0 resume error
#1
Webmaster
Webmaster


See User information
There was an error reported by Houss. The error is in the resume section, If you click on a category you get all categories listings.
The fix is below:

Go to the file jobs/index2.php around line 364 and find this line:

$sql="select lid, cid, name, title, exp, expire, private, salary, typeprice, date, town, state, valid, view from ".$xoopsDB->prefix("jobs_resume")." where valid='yes' order by $orderby";

change it to this:

$sql="select lid, cid, name, title, exp, expire, private, salary, typeprice, date, town, state, valid, view from ".$xoopsDB->prefix("jobs_resume")." where valid='yes' and cid=".mysql_real_escape_string($cid)." order by $orderby";

The difference is adding

and cid=".mysql_real_escape_string($cid)."

after valid='yes'

That should do it.

Thanks to Houss for pointing that out.

John

Posted on: 2009/11/18 6:44
Twitter Facebook Google Plus Linkedin Del.icio.us Digg Reddit Mr. Wong Top







You can view topic.
You cannot start a new topic.
You cannot reply to posts.
You cannot edit your posts.
You cannot delete your posts.
You cannot add new polls.
You cannot vote in polls.
You cannot attach files to posts.
You cannot post without approval.
You cannot use topic type.
You cannot use HTML syntax.
You cannot use signature.
You cannot create pdf.
You cannot get print page.

[Advanced Search]


Login
Username:

Password:

Remember me



Lost Password?

Register now!
 
Main Menu
 
Who's Online
4 user(s) are online (1 user(s) are browsing Forum)

Members: 0
Guests: 4

more...
 
Donat-O-Meter
Make donations with PayPal!
Stats
Goal: $25.00
Due Date: Oct 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $25.00