DB Error #1146

anellys

Hello. I get this error when I want to create a new table.
Help!

DB Error #1146
[SELECT COUNT(*) FROM (SELECT A1.id FROM EMPRESAS_TABLE A1) __] Table 'farma_test_ostikets.EMPRESAS_TABLE' doesn't exist

---- Backtrace ----
#0 (root)/include/mysqli.php(200): osTicket->logDBError('DB Error #1146', '[SELECT COUNT(...')
#1 (root)/include/class.orm.php(3466): db_query('SELECT COUNT()...', true, true)
#2 (root)/include/class.orm.php(3522): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(2952): MySqlExecutor->getRow()
#4 (root)/include/class.orm.php(1380): MySqlCompiler->compileCount(Object(QuerySet))

ntozier

How are you creating a "new table"?
Why are you creating a new table?

anellys

Hi.
I want to create a new module called "companies" with different fields and different functionalities.

I create my table from PhpMyAdmin, but when I want to bring information from the model that I also create, I get this error.

anellys

I create my table from PhpMyAdmin like this:

--tabla de empresas
DROP TABLE IF EXISTS %TABLE_PREFIX%empresa;
CREATE TABLE %TABLE_PREFIX%empresa (
id_empresa int(11) unsigned NOT NULL AUTO_INCREMENT,
nombre varchar(128) NOT NULL DEFAULT '',
imagen text NOT NULL DEFAULT '',
created timestamp NULL DEFAULT NULL,
updated timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id_empresa)
) DEFAULT CHARSET=utf8;

ntozier

You do not need to create tables to store additional information in the osTicket database, you can use forms to do that.
You creating a new tables does not tell the rest of the product that the table exists or how to pull information from it. You would have to figure out how to do that.

anellys

Can you help me to System recognize my new table?

ntozier

Sorry I cannot. I haven't added a new table to osTicket since circa 1.7 and its a totally different database interface now.