hey Guys,

i have an error an cannot save the seetings

The settings can not be updated - Please correct the errors and try again

SQL Error

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

---- Ablaufverfolgung ----

#0 D:\xampp\htdocs\OSTicket\include\mysqli.php(177): osTicket->logDBError('DB Error #1064', '[SELECT propert...')

#1 D:\xampp\htdocs\OSTicket\include\staff\modules-modstat.inc.php(48): db_query('SELECT property...')

#2 D:\xampp\htdocs\OSTicket\scp\module.php(143): include_once('D:\xampp\htdocs...')

#3 {main}

what is the problem?

Update: the same problem with version 1.9.8.1

Hey everyone, I have now made a new backup from the old system and will now again the updatet perform on 1.9.8.1. I give then again a feedback whether it be running, as I previously had problems with the LDAP plugin.

13 days later

Hi all,I was wondering if you are able to add extra columns on the open tickets page on 1.9.7?If yes how is it done?Because reading through most of the previous posts I have not been able to find some sort of guide or set of instructions.Any help would be much appreciatedThank youVas

@ Vas - I am trying to accomplish the same thing. I believe this is the line of code you are looking for (368-410). Although it is not a guide it is relatively easy if you know which variables you would like to add.

https://github.com/osTicket/osTicket-1.8/blob/v1.9.8.1/include/staff/tickets.inc.php#L368

@ anyone who can help -

What I cannot figure out is how to add a column that is not a standard variable? (e.g. Standards: "ID", "date", "subj", "name", "status", "pri") I'm sure the variables are stored in some sort of database but I do not know where or what it is called. How do I know what database I need to search to find the variables I created in the "User Information" form?

Any help would be great!

Thanks in advance.

Just thought i would write an update to this topic.The purpose of the module that was created by rowlandan25 is only if you would like to customize the appearance of each status i.e. change color,size shape of each individual status.This does require adding a table to the database and coding changes.There are complications with this in later versions of osticket.However if all you want is just to add a column lets say to list statuses  it is quite simple and there is no need for the mod.It requires editing only one file  \include\staff\tickets.inc.phpthere are 2 lines of code that need editing . One adds the column header , the other adds the data that goes into it.rather than repeat myself here is a link to a discussion where i wrote out how to add due date the same can be done for statushttp://osticket.com/forum/discussion/comment/94976/

@[deleted] & @[deleted]Thank you very much for the info. I am also interested (like natedawg) in getting a column with a different variable. Especially one that gets the data from a form.To be more specific, we have a form that the user must fill out on the web interface in order to submit a ticket.On the form we have a couple of drop down options which differentiate the type of ticket/job. If we could display those on the ticket interface that would make our system more efficient and easier to assign tickets to users.Vas

@[deleted]

v1.9.8 (9c6acce)Same here it would be great to be able to add a custom field from a custom form. I use a field called "personnummer" swedish security number, witch has to be searchable in the ticket view list for staff. The number field is in the form contact information. How to do?Please Help

You can.The code is on include\staff\ticket-view.inc.phpNow before you go further you need to make sure the same classes that are instantiated on that page are instantiated on ticket.inc.phpOnce you have done that you can go furtherThere is an array called $answers. As you can see below there is a foreach loop which runs through them all and gets the label which is the form field name and gets the field entry which is referred by the variable name $v Just create a variable to contain the label and run an if statement in the loop that id  f the label equals this field name write $v.of course you still need to make the edits mentioned earlier in this thread to actually create the html table column and row. <?php foreach($answers as $a) {                if (!($v = $a->display())) continue; ?>                <tr>                    <th width="100"><?phpEcho $a->getField()->get('label');                    ?>:</th>                    <td ><?php    echo $v;

Hello,I'm new to osTicket, and am using the latest, v1.9.8.1. I'm also new to PHP and have managed to confuse myself several times while reading this thread.The problem that i'm trying to resolve is changing the field "From" to "Location" and pull from the "location" variable that is set up in the ticket form."location" pulls from a custom list which includes the Schools in our district. I am able to change the physical name "From" to "Location" but I'm unable to get the data that it pulls to change, it just keeps pulling the "name" variable.Any assistance would be greatly appreciated.

sounds like you did not edit the <tr> section where the data is actually pulled to.thats located around row 469

That helped a bit, thanks! Now it's pulling data, but instead of what the actual school name is, it is displaying the number in which the school is in the list. e.g. List: School HighSchool ElementaryAcutal Output:12Am I missing something?Below is what I changed, found around 488: Where is says 'locat', it used to be 'name'<td nowrap>&nbsp;<?php echo Format:(                        Format:($row, 22, strpos($row, '@'))); ?>&nbsp;</td>

list data is not actually stored in the form data table . all it does is reference it by ID and does a lookup to pull the data when necessary. So you will need to pull that data separately.however you can do it uch easier by just creating a local array on your php page which would be something like '1'=>'School High' etc.. and than just pass the list number into the array and it wil automatically pull the value 

I apologize for my ignorance as I'm just starting to learn PHP.I believe I understand how to create my array, as a 1-based index:$location = array(1 => 'School High', 'School Middle', 'School Elementary');I'm just not sure where to place the array (around which line) and how to have it pull. It's making my head hurt...

you dont need to use 1 based index you can just use an associative array such as array('1'=> 'school high','2' =>'school elementary' );either way is fine.anywhere you load it is fine as long as its before your php which writes in the value. 

I'm still not understanding how to make it interpret the data from the array and output it in the queue.

are you asking how to pull the school name out of your locations array or how to pull the number from the form field?to pull the school name from the locations array you would just output echo $location;however instead of using the number 1 you would pass in the list number as a variable so echo $location;

I'm honestly not understanding any of it...I have <td nowrap>&nbsp;<?php echo Format:(                        Format:($row, 22, strpos($row, '@'))); ?>&nbsp;</td>Which is pulling the numbers in the list and displaying it. I don't know what to add or change to make it display my custom list if i set that up as an array.I apologize again, i jumped headfirst into all of this without any prior knowledge. I feel like i'm in another country without any grasp on the language.