Need PHP help.

[Lysine]

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

I get this error
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

[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.

[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.

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

+ Rep.

[Heinous]

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.

[Lysine]

It did not have a install script.

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

[Heinous]

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

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

[Lysine]

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 :)

[Tomm]

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.

[Heinous]

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.

[Lysine]

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

[Heinous]

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


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.

[Lysine]

Thank you :) + rep

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