Good Day Guys, has anyone seen this error before?

Table 'osticket.ost_ticket__cdata' doesn't exist<br />

<br />

---- Backtrace ----<br />

#0 (root)/include/mysqli.php(177): osTicket->logDBError('DB Error #1146', '[SELECT a.ticke...')<br />

#1 (root)/include/staff/ticket-view.inc-dsc3.php(14): db_query('SELECT a.ticket...')<br />

#2 (root)/include/staff/ticket-view.inc.php(739): include('/var/www/html/o...')<br />

#3 (root)/scp/tickets.php(499): require_once('/var/www/html/o...')<br />

#4 {main}

Haven't personally seen this on one of my installations, but according to the error message there seems to be some issues with your database:Table 'osticket.ost_ticket__cdata' doesn't existSo I would suggest to check, e.g. with phpmyadmin or mysql command line, if the table exists.Btw I moved the thread to the problems and troubleshooting section of the forum.(Was at Suggestions and Feedback)

Thank you, i see the table is not there, i'm unsure as to why this tables does not exist. Can someone tell me what i need to create this table?

Here's an export of the structure from phpmyadmin. The bold parts should be the interesting ones for you to re-create the table:-- phpMyAdmin SQL Dump-- version 4.2.3-- http://www.phpmyadmin.net---- Host: localhost-- Generation Time: Apr 02, 2015 at 02 PM-- Server version: 5.6.12-- PHP Version: 5.6.6SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";SET time_zone = "+00";/*!40101 SET @[deleted]=@@CHARACTER_SET_CLIENT */;/*!40101 SET @[deleted]=@@CHARACTER_SET_RESULTS */;/*!40101 SET @[deleted]=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;---- Database: `osTicket`---- ------------------------------------------------------------ Table structure for table `ost_ticket__cdata`--CREATE TABLE IF NOT EXISTS `ost_ticket__cdata` (  `ticket_id` int(11) unsigned NOT NULL DEFAULT '0',  `subject` mediumtext,  `priority` mediumtext) ENGINE=InnoDB DEFAULT CHARSET=utf8;---- Indexes for dumped tables------ Indexes for table `ost_ticket__cdata`--ALTER TABLE `ost_ticket__cdata` ADD PRIMARY KEY (`ticket_id`);/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

13 days later

Thank you very much i have created the table with the output above you have provided. 

Great! Did it fix the issue?

Just tested it, and even tho the table now does exist and contains data, i'm still getting the above error? 

Hmm, then I don't have an idea currently.

So... you have a table in your database now called: ost_ticket__cdata?Are you sure you added it to the right database?

14 days later

Hi Ntozier, yes, please see belowmysql> use osticket;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> describe ost_ticket__cdata;+-----------+------------------+------+-----+---------+-------+| Field     | Type             | Null | Key | Default | Extra |+-----------+------------------+------+-----+---------+-------+| ticket_id | int(11) unsigned | NO   | PRI | 0       |       | | subject   | longblob         | YES  |     | NULL    |       | | priority  | longblob         | YES  |     | NULL    |       | +-----------+------------------+------+-----+---------+-------+3 rows in set (0.00 sec)

Are you sure that the database that installation is using is called 'osTicket'?Check the /include/ost-config.php for DBNAME.

Write a Reply...