[MOD] Show "Assigned To" in Ticket View: Page 6

[MOD] Show "Assigned To" in Ticket View

scottro

Does this happen even when my MOD isn't installed? It sounds like a bug in the system not something related to my MOD.

Chrisl

I am not sure how to uninstall it, nor do I really want to. Was just wondering if there was anyone else having the same issue / how they worked around it.

What would be great is a "Unassign" option in the drop down box that would remove all assignments (Both department and Staff) from the ticket....

Any ideas?

ryanp

This worked for me! Thank you

It works beautifully for me also.

:TIP: Ignore the line numbers and search for the line prior to

Addition by webPragmatist

It worked perfectly in 1.6ST

mrevelle

Minor problems

Good addition, we've got a few minor issues with this contribution. When searching for closed tickets we're getting the following db error

Column 'source' in field list is ambiguous

scottro

Good addition, we've got a few minor issues with this contribution. When searching for closed tickets we're getting the following db error
Column 'source' in field list is ambiguous

Hmm, I have not run into that before. You may trying changing the code from 'source' to 'ticket.source' (assuming thats where the source field is).

consumedsoul

Hmm, I have not run into that before. You may trying changing the code from 'source' to 'ticket.source' (assuming thats where the source field is).

Getting database errors as well when performing any search (no results produced, and db errors result). Examples:

Unknown column 'message.message' in 'where clause'

consumedsoul

Hmm, I have not run into that before. You may trying changing the code from 'source' to 'ticket.source' (assuming thats where the source field is).

Here's a screenshot of the admin errors/logs when I just try to run a search for 'test search' (0 results produced):

Screen shot 2011-04-05 at 1.25 AM.jpg

consumedsoul

Here's a screenshot of the admin errors/logs when I just try to run a search for 'test search' (0 results produced):

Oops - image compressed, here's a better image:

blank

scottro

The important part to take away from this is

Unknown column 'message.message' in 'where clause'

I've looked at even the original unedited source code for osTickets that message.message is present. Have you modified your database at all to not include this column? You should have a table ost_ticket_message and within that a column 'message'. I can't imagine that its not there though or your tickets would be all or nearly blank and you'd be getting database errors all over the place.

consumedsoul

The important part to take away from this is
Unknown column 'message.message' in 'where clause'
I've looked at even the original unedited source code for osTickets that message.message is present. Have you modified your database at all to not include this column? You should have a table ost_ticket_message and within that a column 'message'. I can't imagine that its not there though or your tickets would be all or nearly blank and you'd be getting database errors all over the place.

I haven't touched the database, just modified code to files - here's my 3 associated tickets...files if that helps.

Thx!

[Archive.zip](https://forum.osticket.com/assets/files/migrated/b/8e75190027135b1c1bbf13832be1f80.zip)

scottro

Are you running 1.6ST?

For tickets.inc.php (under include/staff/)

I have the following with 1.6RC5:

//query

if($searchTerm){

$qstr.='&query='.urlencode($searchTerm);

$queryterm=db_real_escape($searchTerm,false); //escape the term ONLY...no quotes.

if(is_numeric($searchTerm)){

$qwhere.=" AND ticket.ticketID LIKE '$queryterm%'";

}elseif(strpos($searchTerm,'@') && Validator:($searchTerm)){ //pulling all tricks!

$qwhere.=" AND ticket.email='$queryterm'";

}else{//Deep search!

//This sucks..mass scan! search anything that moves!

$deep_search=true;

$qwhere.=" AND ( ticket.email LIKE '%$queryterm%'".

" OR ticket.name LIKE '%$queryterm%'".

" OR ticket.subject LIKE '%$queryterm%'".

" OR message.message LIKE '%$queryterm%'".

" OR response.response LIKE '%$queryterm%'".

" OR note.note LIKE '%$queryterm%'".

" OR note.title LIKE '%$queryterm%'".

' ) ';

}

and yours has the following:

//query

if($searchTerm){

$qstr.='&query='.urlencode($searchTerm);

$queryterm=db_real_escape($searchTerm,false); //escape the term ONLY...no quotes.

if(is_numeric($searchTerm)){

$qwhere.=" AND ticket.ticketID LIKE '$queryterm%'";

}elseif(strpos($searchTerm,'@') && Validator:($searchTerm)){ //pulling all tricks!

$qwhere.=" AND ticket.email='$queryterm'";

}else{//Deep search!

//This sucks..mass scan! search anything that moves!

$deep_search=true;

if($_REQUEST && $_REQUEST=='FT') { //Using full text on big fields.

$qwhere.=" AND ( ticket.email LIKE '%$queryterm%'".

" OR ticket.name LIKE '%$queryterm%'".

" OR ticket.subject LIKE '%$queryterm%'".

" OR note.title LIKE '%$queryterm%'".

" OR MATCH(message.message) AGAINST('$queryterm')".

" OR MATCH(response.response) AGAINST('$queryterm')".

" OR MATCH(note.note) AGAINST('$queryterm')".

' ) ';

}else{

$qwhere.=" AND ( ticket.email LIKE '%$queryterm%'".

" OR ticket.name LIKE '%$queryterm%'".

" OR ticket.subject LIKE '%$queryterm%'".

" OR message.message LIKE '%$queryterm%'".

" OR response.response LIKE '%$queryterm%'".

" OR note.note LIKE '%$queryterm%'".

" OR note.title LIKE '%$queryterm%'".

' ) ';

}

I assume the big difference is from a version variance?

consumedsoul

Are you running 1.6ST?
For tickets.inc.php (under include/staff/)
I have the following with 1.6RC5:
//query
if($searchTerm){
$qstr.='&query='.urlencode($searchTerm);
$queryterm=db_real_escape($searchTerm,false); //escape the term ONLY...no quotes.
if(is_numeric($searchTerm)){
$qwhere.=" AND ticket.ticketID LIKE '$queryterm%'";
}elseif(strpos($searchTerm,'@') && Validator:($searchTerm)){ //pulling all tricks!
$qwhere.=" AND ticket.email='$queryterm'";
}else{//Deep search!
//This sucks..mass scan! search anything that moves!
$deep_search=true;
$qwhere.=" AND ( ticket.email LIKE '%$queryterm%'".
" OR ticket.name LIKE '%$queryterm%'".
" OR ticket.subject LIKE '%$queryterm%'".
" OR message.message LIKE '%$queryterm%'".
" OR response.response LIKE '%$queryterm%'".
" OR note.note LIKE '%$queryterm%'".
" OR note.title LIKE '%$queryterm%'".
' ) ';
}
}
and yours has the following:
//query
if($searchTerm){
$qstr.='&query='.urlencode($searchTerm);
$queryterm=db_real_escape($searchTerm,false); //escape the term ONLY...no quotes.
if(is_numeric($searchTerm)){
$qwhere.=" AND ticket.ticketID LIKE '$queryterm%'";
}elseif(strpos($searchTerm,'@') && Validator:($searchTerm)){ //pulling all tricks!
$qwhere.=" AND ticket.email='$queryterm'";
}else{//Deep search!
//This sucks..mass scan! search anything that moves!

$deep_search=true;
if($_REQUEST && $_REQUEST=='FT') { //Using full text on big fields.
$qwhere.=" AND ( ticket.email LIKE '%$queryterm%'".
" OR ticket.name LIKE '%$queryterm%'".
" OR ticket.subject LIKE '%$queryterm%'".
" OR note.title LIKE '%$queryterm%'".
" OR MATCH(message.message) AGAINST('$queryterm')".
" OR MATCH(response.response) AGAINST('$queryterm')".
" OR MATCH(note.note) AGAINST('$queryterm')".
' ) ';
}else{
$qwhere.=" AND ( ticket.email LIKE '%$queryterm%'".
" OR ticket.name LIKE '%$queryterm%'".
" OR ticket.subject LIKE '%$queryterm%'".
" OR message.message LIKE '%$queryterm%'".
" OR response.response LIKE '%$queryterm%'".
" OR note.note LIKE '%$queryterm%'".
" OR note.title LIKE '%$queryterm%'".
' ) ';
}
}
}
I assume the big difference is from a version variance?

Yep - running ST - does this mean I won't be able to implement the assigned to column (w/o sacrificing search functionality)?

consumedsoul

Yep - running ST - does this mean I won't be able to implement the assigned to column (w/o sacrificing search functionality)?

btw sorting by 'department' causes 0 results and these errors in db:

blank

scottro

I just went and installed a fresh install of osTickets 1.6ST and then rewrote my HowTo article. I also made a zip file of the files needed for this mod alone.

I then went and did a couple of searches and had no problems.

File is attached - updated code is at:

http://sudobash.net/?p=158(http://sudobash.net/?p=158)

[assignedTo.zip](https://forum.osticket.com/assets/files/migrated/0/74f4f66c5dd66df923f4b2dfae07698.zip)

consumedsoul

I just went and installed a fresh install of osTickets 1.6ST and then rewrote my HowTo article. I also made a zip file of the files needed for this mod alone.
I then went and did a couple of searches and had no problems.
File is attached - updated code is at:
http://sudobash.net/?p=158(http://sudobash.net/?p=158) Search and sort column functions all work now.
Thx again!

scottro

Search and sort column functions all work now.
Thx again

Awesome, glad its all working now!

consumedsoul

Awesome, glad its all working now

Hmm - now that I updated your 3 files, the cc/bcc is not functional after I modify the include/class.ticket.php file per:

http://sudobash.net/?p=234(http://sudobash.net/?p=234)

That should be the only file I need to tweak (to add cc/bcc functionality again) right?

Result is I can't browse to website after applying the code in that file...

consumedsoul

Hmm - now that I updated your 3 files, the cc/bcc is not functional after I modify the include/class.ticket.php file per:
http://sudobash.net/?p=234(http://sudobash.net/?p=234)
That should be the only file I need to tweak (to add cc/bcc functionality again) right?
Result is I can't browse to website after applying the code in that file...

Additional details, seems to be when I apply the following code replacement:

// Just in case they wiped out the send address we still need to make sure it gets somewhere.

***************if($_POST){

*******************$email->send($_POST,$subj,$body,$file);

*******************}else{

*******************$email->send($this->getEmail(),$subj,$body,$file);

***************}

Result is following in browser:

Error 324 (net:): Unknown error.

consumedsoul

Additional details, seems to be when I apply the following code replacement:
// Just in case they wiped out the send address we still need to make sure it gets somewhere.
***************if($_POST){
*******************$email->send($_POST,$subj,$body,$file);
*******************}else{
*******************$email->send($this->getEmail(),$subj,$body,$file);
***************}
Result is following in browser:
Error 324 (net:): Unknown error.

Weird - removed the 'spaces' (clue was my **'s above) and now functional again (copied/pasted your code from blog).

Disregard!

scottro

Weird - removed the 'spaces' (clue was my **'s above) and now functional again (copied/pasted your code from blog).
Disregard

Ah, sure - I blame Windows - I've ran into it inserting invisible characters before with other scripting :\

« Previous Page Next Page »