Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

DB Error #1054

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
[INSERT INTO ost1_ticket SET created=NOW() ,lastmessage= NOW() ,ticketID=132454 ,dept_id=1 ,topic_id=1 ,priority_id=2 ,email='blah@blah.com' ,company='frank' ,name='Gaming' ,subject='help' ,phone="9095356736" ,phone_ext='' ,ip_address='96.251.22.139' ,source='Web']

Unknown column 'company' in 'field list'

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

Thanks in advance.
:confused:

Comments

  • 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
    ntozier;37965 said:
    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

    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

    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

    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.)
  • ntozier;38036 said:
    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!!!

    :D
  • Sounds to me like you setup osTicket on your web host twice and used a different table prefix each time [ost_ and ost1_]. 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.
  • I think right now with the latest version 1.9.9, this should be fixed already? image
  • @ragortue please start your own thread instead of creating a zombie.  This thread is from April 2013.
    killing zombie with a head shot.
This discussion has been closed.