Table 'hotel.apps' doesn't exist

Status
Not open for further replies.

JynX

Posting Freak
Feb 6, 2016
710
438
Just make a table with an ID that isn't null, is a primary key, and auto-increments. Then save and name the table to "apps". Load the page that needs that table and it'll tell you "unknown ##### in fieldlist" then go back to the table and add that to it,
 

Zodiak

recovering crack addict
Nov 18, 2011
453
417
Code:
DROP TABLE IF EXISTS `apps`;
CREATE TABLE `apps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `content` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`,`user_id`),
  UNIQUE KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

You'll need to edit the columns to add whatever you require.
 

anthonyy

Member
Dec 23, 2014
127
10
Code:
DROP TABLE IF EXISTS `apps`;
CREATE TABLE `apps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `content` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`,`user_id`),
  UNIQUE KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

You'll need to edit the columns to add whatever you require.
thanks man working! :D
 
Status
Not open for further replies.

Users who are viewing this thread

Top