SOLVED !!! CTPDF Error and 1064 SQL error

Hello i have 2 problems.
1. I followed your instructions here:http://joomdonation.com/forum/os-property-popular-questions/44734-export-pdf-with-non-utf8-characters.html#51987 but now when i try to export a pdf i get an error like this:
6 - ERROR n°6 : Impossible to load the image

2. In front-end when i go to company profile and manage agents, "SORTBY" is clickable and gives that error:
"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 '' at line 1 SQL=Select a.*,u.username from zjn1o_osrs_agents as a inner join zjn1o_users as u on u.id = a.user_id where a.id in (Select id from zjn1o_osrs_agents where company_id = '5') order by " .

Also "OS_STATUS" also gives same error.

My company.php file is like that:

$sortbyArr[] = JHTML::_('select.option','',JText::_('OS_SORTBY'));
$sortbyArr[] = JHTML::_('select.option','a.ordering',JText::_('OS_ORDERING'));
$sortbyArr[] = JHTML::_('select.option','a.name',JText::_('OS_NAME'));
$sortbyArr[] = JHTML::_('select.option','a.email',JText::_('OS_EMAIL'));
$sortbyArr[] = JHTML::_('select.option','a.publish',JText::_('OS_STATUS'));
$sortbyArr[] = JHTML::_('select.option','a.id',JText::_('ID'));
$lists = JHTML::_('select.genericlist',$sortbyArr,'sortby','class="input-medium" onchange="javascript:document.manageagent.submit();"','value','text',$sortby);

Hi,
With the issues related to Company profile, you can fix by following these steps
1. Open file: components > com_osproperty > classes > company.php
find
$query .= " order by $sortby $orderby";
and replace by
if($sortby != ""){
$query .= " order by $sortby $orderby";
}

and find
$sortbyArr[] = JHTML::_('select.option','a.publish',JText::_('OS_STATUS'));
replace by
$sortbyArr[] = JHTML::_('select.option','a.published',JText::_('OS_STATUS'));

Good luck
Dam

Regarding to PDF export function, your PHP variable : memory_limit is too small, just 32 MB, and this is the reason of the issue when you export PDF. Please increase to at least 128 MB (or higher) to make the function to work properly
Thanks
Dam

Hello again,
I have changed PHP variable : memory_limit to 109MB and didn't solve my problem. I can't get it any higher.

That feature need quite high memory limit, so if you can't increase that value, we should turn off PDF export
Thanks
Dam

Hi guys, hello everyone...I'm using help desk pro but i've got 2 problems:
1: When the user open a ticket i actually don't receive any email about this ticket, so happens that the users submit a ticket but I can't see it;
2: When I found the ticket on my backend I would like to reply strait away to the user but jumping out this error: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 '' at line 1 SQL=SELECT title FROM jos_helpdeskpro_categories WHERE id=

I should modify the database manually and put the number of the ticket? how I can fix this issue?
Thanks a lot guys.
Have a good day

Hi Tech,
With the issue of Helpdesk pro, please submit ticket on category Helpdesk Pro, Tuan will answer you directly
Thanks
Dam

Thanks a lot... I will do.. have a great day..