Error with channels

[artisanrose]

i realised that my server files werent updated so i redownloaded the fullserver_vX.rar file and got it to v15. I fixed all the config files. but now it gives me an error about my channels.

I searched the forum and it said to use the new channel tables but i dont know how to edit the channel table and what file to edit because im completely new at this stuff. I tried opening the osrose svn with notepad to try and edit it but it just freezes. Some people tell me to edit the table in navicat but when i open the channel table it just has 2 colums. one saying channe 1 and another saying channel 2.

To view the content, you need to sign in or register

Is the table below the newest one?

DROP TABLE IF EXISTS `channels`;
CREATE TABLE `channels` (
`id` int(11) NOT NULL,
`type` int(11) NOT NULL,
`name` varchar(255) default NULL,
`host` varchar(255) default NULL,
`port` int(11) default NULL,
`lansubmask` varchar(255) default NULL,
`lanip` varchar(255) default NULL,
`connected` int(11) default NULL,
`maxconnections` int(11) default NULL,
`owner` int(11) default NULL)
ENGINE=InnoDB DEFAULT CHARSET=latin1;

EDIT*** nvm i figured it out.
This is my channel table. is it the newest one or is the one above the one i should use?

-- Table "channels" DDL
CREATE TABLE `channels` (
  `id` int(11) NOT NULL,
  `name` varchar(256) default NULL,
  `host` varchar(256) default NULL,
  `port` int(11) default NULL,
  `status` int(11) default '0',
  `owner` int(11) default '0',
  `number` int(11) default NULL,
  `inetIP` varchar(16) default '0.0.0.0',
  `charIP` varchar(16) default '0.0.0.0',
  `charPort` int(11) default '29100',
  `charPass` int(11) default '0',
  `maxclients` int(11) default '100',
  `connectedclients` int(11) default '0',
  `online` tinyint(1) default '0',
  `worldIP` varchar(16) default '0.0.0.0',
  `worldPort` int(11) default '292000',
  `worldPass` int(11) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

And whats which one is my lanip?(picture below) Is it another name for my regular ip or is it something else?

 

[MjClarke1]

Um which Rev are you using? The rev 30 channels are set up in the .conf files :SD

 

[artisanrose]

im using rev 30 but im new at this so its confusing for me. i still dont understand how to fix those 2 green errors.

 

[MjClarke1]

Um, Dude, You have to edit the Channels in the .conf files, not in the SQL. The Channels SQL is no longer used for channels..