Need PHP help.

I got a titorial of this forum for a rare value system but it is not working.

I get this error

Quote:

---

Error during the execution of the MySQL query : Table 'hablaugh_rares.categories' doesn't exist

---

In the 'create_rv.php' file.

Does anyone know what the problem is?

+ rep
- Lysine

A mysql database table is missing.

edit;
FTAO: Nublet who can't leave his or her name: I care about rep, why? Leave your name so I can return the favor, moron.

Quote:

---

Originally Posted by Heinous

A mysql database table is missing.

edit;
FTAO: Nublet who can't leave his or her name: I care about rep, why? Leave your name so I can return the favor, moron.

---

Ok, What do i have too call it and what else do i need too add?

+ Rep.

It should be in the install script, but I'm not sure what columns it would need, as I don't know what ones it uses.

It did not have a install script.

There was just a file with the SQL and i added it all.

Then it could be a problem when the table was created.

Show me the SQL query you were to run, please.

PHP Code:

---

CREATE TABLE `rares` (
  `id` smallint(6) NOT NULL auto_increment,
  `title` varchar(30) NOT NULL default '',
  `category` tinyint(6) NOT NULL default '0',
  `image` varchar(100) NOT NULL default '',
  `date` varchar(20) NOT NULL default '',
  `name` varchar(255) default '',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;


CREATE TABLE `cats` (
  `id` tinyint(4) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ; 


---

That is the SQL :)

Quote:

---

Originally Posted by Lysine

PHP Code:

---

CREATE TABLE `rares` (
  `id` smallint(6) NOT NULL auto_increment,
  `title` varchar(30) NOT NULL default '',
  `category` tinyint(6) NOT NULL default '0',
  `image` varchar(100) NOT NULL default '',
  `date` varchar(20) NOT NULL default '',
  `name` varchar(255) default '',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;


CREATE TABLE `cats` (
  `id` tinyint(4) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ; 


---

That is the SQL :)

---

It's looking for a table called "categorys" which does not exist. I am guessing it is really looking for the table called cats.

Quote:

---

Originally Posted by Organised

It's looking for a table called "categorys" which does not exist. I am guessing it is really looking for the table called cats.

---

By looking at it I'd agree.

How would i be able too add the table which needs too be added?

You could either just do this (assuming all calls to the category table are wrong, and look for cats):

PHP Code:

---

CREATE TABLE `categories` (
  `id` tinyint(4) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ; 


---

Or, change all the files to look for cats rather than categories.

Thank you :) + rep

I now have another problem with it read this thread :- http://www.habboxforum.com/showthread.php?t=246161