i create a new form field to contact information.but when i insert a value to that field,it's not insert value to database.i try to create a new field to ticket information,nothing errors and value from that field can insert to database.i running fresh installment v1.8.0.2.thx before

When I understand you correct you try to insert a value normally via the gui of osticket but the value is not saved, is that correct? The field was normally created via the gui? Do you get an error message?

yes that correct.i added field normally from custom form.everything seems fine nothing error message was appear.

Hmm, I have done this also just with a fresh test installation. It works for me. Seems to be something wrong with your environment. Maybe there is an error in your php log or in the osticket log (Admin Panel->Dashboard->System Logs) that helps to see why that doesn't work.

Table 'ost_ticket__cdata' already exists---- Backtrace ----#0 C:\xampp\htdocs\support\include\mysqli.php(132): osTicket->logDBError('DB Error #1050', '[CREATE TABLE `...')#1 C:\xampp\htdocs\support\include\class.dynamic_forms.php(238): db_query('CREATE TABLE `o...')#2 C:\xampp\htdocs\support\include\class.dynamic_forms.php(218): TicketForm:()#3 C:\xampp\htdocs\support\include\staff\tickets.inc.php(254): TicketForm:()#4 C:\xampp\htdocs\support\scp\tickets.php(626): require_once('C:\\xampp\\htdocs...')#5 C:\xampp\htdocs\support\scp\index.php(17): require('C:\\xampp\\htdocs...')#6 {main}

Are you sure you made a fresh install? This seems to me that osticket could'nt been successfully installed because there is a data/table from a former installation of osticket ->Table 'ost_ticket__cdata' already exists. This is a table from osticket, it couldn't been created because it already exists in the database..

well not actually fresh install.but,i don't change anything about database and file.i import this database from another server to my localhost.

Strange, when the environment does fit the system requirements, you didn't modify osticket and transferred it 1 it should also work crrectly on your local host in my opinion..

what is the name of file that insert query to database from custom form

This question I'm unfortunately not able to answer. As I can see you started another thread at github with the same issue (https://github.com/osTicket/osTicket-1.8/issues/2013), you should maybe link from there to this thread so the supporting people can see all information about this problem to better assist you. 

Write a Reply...