Discover Habbo's history
Treat yourself with a Secret Santa gift.... of a random Wiki page for you to start exploring Habbo's history!
Happy holidays!
Celebrate with us at Habbox on the hotel, on our Forum and right here!
Join Habbox!
One of us! One of us! Click here to see the roles you could take as part of the Habbox community!


Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Need PHP help.

  1. #1
    Join Date
    Jun 2005
    Location
    USA
    Posts
    2,047
    Tokens
    0

    Latest Awards:

    Default Need PHP help.

    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
    *Image Removed*

    Thank you Brad for the sig


    Signature edited by Nick- (Forum Super Moderator): Please do not have images that exceed the limit for non VIPs (700 x 150) in your signature.

  2. #2
    Join Date
    Dec 2005
    Location
    Australia
    Posts
    693
    Tokens
    0

    Default

    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.
    Last edited by Heinous; 17-10-2006 at 01:51 AM.
    XHTML, CSS, AJAX, JS, php, MySQL.

    --

    HxF moderators can't read timestamps.

  3. #3
    Join Date
    Jun 2005
    Location
    USA
    Posts
    2,047
    Tokens
    0

    Latest Awards:

    Default

    Quote Originally Posted by Heinous View Post
    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.
    *Image Removed*

    Thank you Brad for the sig


    Signature edited by Nick- (Forum Super Moderator): Please do not have images that exceed the limit for non VIPs (700 x 150) in your signature.

  4. #4
    Join Date
    Dec 2005
    Location
    Australia
    Posts
    693
    Tokens
    0

    Default

    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.
    XHTML, CSS, AJAX, JS, php, MySQL.

    --

    HxF moderators can't read timestamps.

  5. #5
    Join Date
    Jun 2005
    Location
    USA
    Posts
    2,047
    Tokens
    0

    Latest Awards:

    Default

    It did not have a install script.

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

    Thank you Brad for the sig


    Signature edited by Nick- (Forum Super Moderator): Please do not have images that exceed the limit for non VIPs (700 x 150) in your signature.

  6. #6
    Join Date
    Dec 2005
    Location
    Australia
    Posts
    693
    Tokens
    0

    Default

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

    Show me the SQL query you were to run, please.
    XHTML, CSS, AJAX, JS, php, MySQL.

    --

    HxF moderators can't read timestamps.

  7. #7
    Join Date
    Jun 2005
    Location
    USA
    Posts
    2,047
    Tokens
    0

    Latest Awards:

    Default

    PHP Code:
    CREATE TABLE `rares` (
      `
    idsmallint(6NOT NULL auto_increment,
      `
    titlevarchar(30NOT NULL default '',
      `
    categorytinyint(6NOT NULL default '0',
      `
    imagevarchar(100NOT NULL default '',
      `
    datevarchar(20NOT NULL default '',
      `
    namevarchar(255) default '',
      
    UNIQUE KEY `id` (`id`)
    ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;


    CREATE TABLE `cats` (
      `
    idtinyint(4NOT NULL auto_increment,
      `
    namevarchar(30NOT NULL default '',
      
    UNIQUE KEY `id` (`id`)
    ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 
    That is the SQL
    *Image Removed*

    Thank you Brad for the sig


    Signature edited by Nick- (Forum Super Moderator): Please do not have images that exceed the limit for non VIPs (700 x 150) in your signature.

  8. #8
    Join Date
    Jun 2005
    Posts
    4,795
    Tokens
    0

    Latest Awards:

    Default

    Quote Originally Posted by Lysine View Post
    PHP Code:
    CREATE TABLE `rares` (
      `
    idsmallint(6NOT NULL auto_increment,
      `
    titlevarchar(30NOT NULL default '',
      `
    categorytinyint(6NOT NULL default '0',
      `
    imagevarchar(100NOT NULL default '',
      `
    datevarchar(20NOT NULL default '',
      `
    namevarchar(255) default '',
      
    UNIQUE KEY `id` (`id`)
    ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;


    CREATE TABLE `cats` (
      `
    idtinyint(4NOT NULL auto_increment,
      `
    namevarchar(30NOT 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.

  9. #9
    Join Date
    Dec 2005
    Location
    Australia
    Posts
    693
    Tokens
    0

    Default

    Quote Originally Posted by Organised View Post
    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.
    XHTML, CSS, AJAX, JS, php, MySQL.

    --

    HxF moderators can't read timestamps.

  10. #10
    Join Date
    Jun 2005
    Location
    USA
    Posts
    2,047
    Tokens
    0

    Latest Awards:

    Default

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

    Thank you Brad for the sig


    Signature edited by Nick- (Forum Super Moderator): Please do not have images that exceed the limit for non VIPs (700 x 150) in your signature.

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •