Topics

[Unknown column 'CATEGORY' in 'field list'File: /home/username/domains/mydomain.net/public_html/Sources/Ads.phpLine: 190]

Hello,
I have just installed the Ad mod for smf forum version 1.1.2. I had to install the mod manualy with a little help from a couple of the guys from smf because for some reason the server wont allow me to install mods from the admin panel. Everything seems to be working fine and i can ad, edit and do the other things from within the admin panel. However. As soon as click save or i should say "Ad," i get this error message

Unknown column 'CATEGORY' in 'field list'
File: /home/username/domains/mydomain.net/public_html/Sources/Ads.php
Line: 190

I have searched this forum for answers and found 2 possibilities.
1 Reupload the Ads.php file to the sourceses directory but still doesnt work
2 Something maybe missing from the database. If it is the CATEGORY table, please tell me the code i must put to ad it into the database.

Here is the database that come with the ad mods install.php

Code Select Expand

--
-- Table structure for table `smf_ads`
--

CREATE TABLE `smf_ads` (
  `ADS_ID` mediumint(8) unsigned NOT NULL auto_increment,
  `NAME` tinytext NOT NULL,
  `CONTENT` text NOT NULL,
  `BOARDS` tinytext,
  `POSTS` tinytext,
  `HITS` mediumint(8) NOT NULL default '0',
  `TYPE` smallint(4) NOT NULL default '0',
  `show_index` smallint(4) NOT NULL default '0',
  `show_board` smallint(4) NOT NULL default '0',
  `show_threadindex` smallint(4) NOT NULL default '0',
  `show_lastpost` smallint(4) NOT NULL default '0',
  `show_thread` smallint(4) NOT NULL default '0',
  `show_bottom` smallint(4) NOT NULL default '0',
  `show_welcome` smallint(4) NOT NULL default '0',
  `show_topofpage` smallint(4) NOT NULL default '0',
  `show_towerright` smallint(4) NOT NULL default '0',
  `show_towerleft` smallint(4) NOT NULL default '0',
  `show_betweencategories` smallint(4) NOT NULL default '0',
  `show_underchildren` smallint(4) NOT NULL default '0',
  PRIMARY KEY  (`ADS_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `smf_ads`
--

INSERT INTO `smf_ads` VALUES (4, 'test', 'test', NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `smf_ads` VALUES (3, 'Test', 'Fuck', NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `smf_ads` VALUES (5, 'Fuck You', 'OMG It Worked', NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `smf_ads` VALUES (6, 'TESTING', 'JUST TESTING', NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `smf_ads_settings`
--

CREATE TABLE `smf_ads_settings` (
  `variable` tinytext NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY  (`variable`(30))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `smf_ads_settings`
--


Please help as i realy need this mod to work.

Thanks
smithy

EDIT:
Sorry but i have put this in the wrong place. Please move.
Thanks