News:

Welcome to SMF Ads Support Forum

Main Menu
Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - smithy

Pages1
#1
Ad Support / Re: Big problem... Help
May 03, 2007, 06:35:15 AM
Hello,
I dont realy know php or sql that well. I learn much from the smf forum eg:

http://www.simplemachines.org/community/index.php?topic=167201.0

And just play around with things till i get right. The good thing about installing mods manualy is that you can correct and fix mistakes instantly. For instace. Every time i ad, before and replace i allways refresh the page so if i get a parse error then i know where the problem is then i just undo what i edited and start again. I have heard somany uses make a mess of there forum when installing certain mods from the package manager its unreal. I would advise anybody to learn how to install mods manualy because i personaly fell its the safest way to do so.

smithy
#2
Ad Support / Re: Unknown column 'CATEGORY' in 'field list'
May 02, 2007, 05:52:24 PM
Quote from: bigguy on April 27, 2007, 07:25:15 AM
Glad to hear its fixed. So you added that through phpmyadmin. ???
Yes, because the tables wouldnt install when i tried installing them from the browser.

smithy

#3
Ad Support / Re: Big issue please help
May 02, 2007, 05:47:28 PM
Maybe it didnt install correctly. Try installing it manualy and it will definitly work.

smithy
#4
Ad Support / Re: Big problem... Help
May 02, 2007, 05:42:34 PM
Guys as bigguy says Are using default or a custom theme? I myself installed it manualy but you need to make sure that you edit your custom themes files and not the default. To give you an idea of what i mean. Check this out.

Code Select
<file name="$themedir/index.template.php">
−
<operation>
<search position="before"><body>';</search>
−
<add>

//Display ads on the top of the page
if (function_exists("show_topofpageAds"))
{
$ads = show_topofpageAds();
if(!empty($ads))
if($ads['type']==0)
echo $ads['content'];
else
eval($ads['content']);
unset($ads);
}
</add>

Where it says themedir/index.template.php This should be the index.template.php of the theme your using.

Also another small problem i encounted is when i searched this <body>'; on my theme.index.php. It didnt find out because the theme am using only had <body> without the ; so i just added it.

smithy

#5
Ad Support / Re: Unknown column 'CATEGORY' in 'field list'
April 26, 2007, 12:55:50 PM
Hello,
I got it workinging :) I had to ad the category into the list like this.

  `ADS_ID` mediumint(8) unsigned NOT NULL auto_increment,
  `NAME` tinytext NOT NULL,
  `CONTENT` text NOT NULL,
  `BOARDS` tinytext,
  `POSTS` tinytext,
  `CATEGORY` tinytext,[/b]

Is it also possible for mod makers to ad a SQL.txt file to make the manual install of mods much easier for newbies like me.

Thanks
smithy
#6
Ad Support / Re: Unknown column 'CATEGORY' in 'field list'
April 26, 2007, 11:38:38 AM
ok thanks. I have seen the ad mod on other forums and its exctly what i am looking for.

cheers
smithy
#7
Ad Support / Re: Big problem... Help
April 25, 2007, 05:44:50 AM
You may not have installed it correctly. Make sure all codes are in the correct place eg: Before, After and replace. Then make sure Ads.php + LoadAds.php are in the sources directory. The Ads.template.php in your Themes directory and Ads.english.php in your themes language dirctory.

smithy
#8
Ad Support / Unknown column 'CATEGORY' in 'field list'
April 25, 2007, 05:33:15 AM
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
--
-- 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
Pages1