Results 1 to 3 of 3

Thread: Mysql question

  1. #1
    Join Date
    Sep 2004
    Location
    Lebanon
    Posts
    1

    Unanswered: Mysql question

    hello guys

    I have this mysql code, it's for my IPB
    and I recenly converted my Yabbse to IPB
    but it's showing me that I have 1 registered user, infact I have 109
    so is there a way to fix this code and make it start counting from 109 ?

    Code:
    CREATE TABLE `ibf_members` (
      `id` mediumint(8) NOT NULL default '0',
      `name` varchar(255) NOT NULL default '',
      `mgroup` smallint(3) NOT NULL default '0',
      `password` varchar(255) NOT NULL default '',
      `email` varchar(255) NOT NULL default '',
      `joined` int(10) NOT NULL default '0',
      `ip_address` varchar(16) NOT NULL default '',
      `avatar` varchar(128) default NULL,
      `avatar_size` varchar(9) default NULL,
      `posts` mediumint(7) default '0',
      `aim_name` varchar(40) default NULL,
      `icq_number` varchar(40) default NULL,
      `location` varchar(128) default NULL,
      `signature` text,
      `website` varchar(70) default NULL,
      `yahoo` varchar(32) default NULL,
      `title` varchar(64) default NULL,
      `allow_admin_mails` tinyint(1) default NULL,
      `time_offset` varchar(10) default NULL,
      `interests` text,
      `hide_email` varchar(8) default NULL,
      `email_pm` tinyint(1) default NULL,
      `email_full` tinyint(1) default NULL,
      `skin` smallint(5) default NULL,
      `warn_level` int(10) default NULL,
      `warn_lastwarn` int(10) NOT NULL default '0',
      `language` varchar(32) default NULL,
      `msnname` varchar(64) default NULL,
      `last_post` int(10) default NULL,
      `restrict_post` varchar(100) NOT NULL default '0',
      `view_sigs` tinyint(1) default '1',
      `view_img` tinyint(1) default '1',
      `view_avs` tinyint(1) default '1',
      `view_pop` tinyint(1) default '1',
      `bday_day` int(2) default NULL,
      `bday_month` int(2) default NULL,
      `bday_year` int(4) default NULL,
      `new_msg` tinyint(2) default NULL,
      `msg_from_id` mediumint(8) default NULL,
      `msg_msg_id` int(10) default NULL,
      `msg_total` smallint(5) default NULL,
      `vdirs` text,
      `show_popup` tinyint(1) default NULL,
      `misc` varchar(128) default NULL,
      `last_visit` int(10) default '0',
      `last_activity` int(10) default '0',
      `dst_in_use` tinyint(1) default '0',
      `view_prefs` varchar(64) default '-1&-1',
      `coppa_user` tinyint(1) default '0',
      `mod_posts` varchar(100) NOT NULL default '0',
      `auto_track` tinyint(1) default '0',
      `org_perm_id` varchar(255) default '',
      `org_supmod` tinyint(1) default '0',
      `integ_msg` varchar(250) default '',
      `temp_ban` varchar(100) default NULL,
      `sub_end` int(10) NOT NULL default '0',
      PRIMARY KEY  (`id`),
      KEY `name` (`name`),
      KEY `mgroup` (`mgroup`),
      KEY `bday_day` (`bday_day`),
      KEY `bday_month` (`bday_month`)
    ) TYPE=MyISAM;

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    You'd have to post the code for us to see. You've only posted your table layout which isn't going to tell us why there is a problem with the number of records.

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    All I can see is DDL. Count what?

    -PatP

Posting Permissions

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