I upgraded PHP and OSTicket to the latest, 1.14.2. I now get "Support Ticket System Offline" and I'm unable to access /scp/ so attempted update ost_config SET isonline='1';I have a custom prefix of eq, so I ran update osteq_config SET isonline='1'; instead, but get: ERROR 1054 (42S22): Unknown column 'isonline' in 'field list'. When I list columns in the table I only show:
+-----------+------------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------------+------+-----+-------------------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| namespace | varchar(64) | NO | MUL | NULL | |
| key | varchar(64) | NO | | NULL | |
| value | text | NO | | NULL | |
| updated | timestamp | NO | | CURRENT_TIMESTAMP | |
+-----------+------------------+------+-----+-------------------+----------------+

Any thoughts?

    You should be using:
    update ost_config SET value='1' WHERE key=isonline

      ntozier Thanks for the suggestion, but I'm getting mysql> update ost_config SET value='1' WHERE key=isonline;
      ERROR 1064 (42000): 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 'key=isonline' at line 1

        Interestingly when I do a select * FROM osteq_config; it shows core | isonline | 1

        3 years later
        Write a Reply...