Added a new Field to my Ticket using this thread, the field shows up an dis marked required, like we wanted it. But When you fill out a ticket and submit the systems send a log to me saying:

DB Error #1054

Unknown column 'company' in 'field list'

http://www.cv-helpdesk.com/support/open.php(http://www.cv-helpdesk.com/support/open.php)

To me it seems I missed adding the column 'company' to 'field list'

Where is this? Is it in MySQL DB? I am guessing so cause it is a DB error. If so how do I go about adding this column to the field list?

If you need any information please let me know.

This is the thread I followed:

http://osticket.com/forums/showthread.php?p=37940#post37940(http://osticket.com/forums/showthread.php?p=37940#post37940)

Thanks in advance.

:

Did you add the column to your database? ie the first step.

ie something like:

ALTER TABLE `DATABASENAME`.`ost_ticket` ADD COLUMN `company` VARCHAR(255) AFTER `updated`;

Valid CSRF Token Required for Staff Login and Action denied (400)! for New Tickets

Did you add the column to your database? ie the first step.

ie something like:

ALTER TABLE `DATABASENAME`.`ost_ticket` ADD COLUMN `company` VARCHAR(255) AFTER `updated`;

That did the trick. Thank you very much.

But now whenever any of my staff try to login they get:

Valid CSRF Token Required

This is with any staff, any browser.

I have already tried this thread:

http://osticket.com/forums/showthread.php?t=12714&highlight=Valid+CSRF+Token+Required(http://osticket.com/forums/showthread.php?t=12714&highlight=Valid+CSRF+Token+Required)

this one, but this isn't an exact match, so I didn't try to do the troubleshooting:

http://osticket.com/forums/showthread.php?t=10256&highlight=Valid+CSRF+Token+Required(http://osticket.com/forums/showthread.php?t=10256&highlight=Valid+CSRF+Token+Required)

And also this one, but a page reload, new browser, new session, nothing works:

http://osticket.com/forums/showthread.php?t=9880&highlight=Valid+CSRF+Token+Required(http://osticket.com/forums/showthread.php?t=9880&highlight=Valid+CSRF+Token+Required)

Also, if I try to create a new ticket I get:

Action denied (400)

Sounds like you broke something moding your source. I recommend that you back up your mods, and put vanilla default files back in place from the download archive. If that fixes your problem then you know its your modifications and then you can put them back in 1 at a time until you figure out where the break occurred. (The php error logs might also be helpful in narrowing down issues.)

Sounds like you broke something moding your source. I recommend that you back up your mods, and put vanilla default files back in place from the download archive. If that fixes your problem then you know its your modifications and then you can put them back in 1 at a time until you figure out where the break occurred. (The php error logs might also be helpful in narrowing down issues.)

Yeah I forgot to close some functions and was using the old mod name (serial) instead of company.

Also Dreamhost has 2 table entries. So I have an ost_ticket table and a

ost1_ticket table, once I added the same

ALTER TABLE `DATABASENAME`.`ost_ticket` ADD COLUMN `company` VARCHAR(255) AFTER `updated`;

to both tables everything started working fine!!!

Sounds to me like you setup osTicket on your web host twice and used a different table prefix each time . If you look at your /include/ost-config.php file for the "TABLE_PREFIX" it will tell you which database tables you are actually using. If it says ost_ then you can get rid of the ost1_ and vice versa.

That makes sense. I will look into, I think I am using ost1 because my table entry in ost_ticket did not work. I will double check that.

Also, where are the logo's stored for the system? You seem very knowledgeable in this system I would appreciate if you can point me where the logo files are. I have checked the /images folder but there is only a spinner, and calendar image in that folder along with a captcha folder.

2 years later

I think right now with the latest version 1.9.9, this should be fixed already? blank

@[deleted] please start your own thread instead of creating a zombie.  This thread is from April 2013.killing zombie with a head shot.

Write a Reply...