News:

Welcome to SMF Ads Support Forum

Main Menu
Coinbase

help with the manual install

Started by eladh7, August 15, 2008, 06:05:07 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

eladh7

Hi!
I am trying to install the Ad management mod manually without the use of the package manager and the only thing missing right now is the querys.
i go to my php my admin and there i go to SQL.
i paste my third code, and i replace the '{$db_prefix}' with my database prefix, but i receive error.
its my error:
"Error

SQL query:

ALTER IGNORE TABLE smf_ads ADD show_lastpost smallint( 4 ) NOT NULL default '0' AFTER show_threadindex

MySQL said: Documentation
#1060 - Duplicate column name 'show_lastpost'
"

what i need to do?
thanks very much

gri

Quote from: "url=http://www.smfads.com/forums/index.php?topic=1778.msg7125#msg7125]eladh7 in ~help with the manual install~[/url]"]
I am trying to install the Ad management mod manually
without the use of the package manager

Why have you refused from installing the mod by Package Manager ?
Instruction on getting Help on PAY-ME (AdManagement) mod installing.
Your GRItoadMIXes

ccbtimewiz

Make sure your host/server permits usage of the CREATE and ALTER MySQL commands.

eladh7

Quote from: gri on August 19, 2008, 01:53:20 PM
Quote from: "url=http://www.smfads.com/forums/index.php?topic=1778.msg7125#msg7125]eladh7 in ~help with the manual install~[/url]"]
I am trying to install the Ad management mod manually
without the use of the package manager

Why have you refused from installing the mod by Package Manager ?


because every mod that i install with Package Manager, the mod not installed good.
i dont no why.
anyway i succeeded to install the ad mod  ;)


fadun

Someone should please help me wit steps involve in manually installing adverts on my SMF 1.1.5 Forum. Thanks

bigguy

Please do a search all the edits are posted here. :)

fadun

@ bigguy. I can't find the edit you are refering to in your post. Kindly repost same, thank you.

mtcasa

Hello everyone! Please help or give me instructions on how to do the part below (Code and File Operations).  Thanks.

Code
install.php
This file should not be able to execute standalone. You may have to run the following queries manually.


Query: [Select]
CREATE TABLE IF NOT EXISTS {$db_prefix}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) )
Query: [Select]
CREATE TABLE IF NOT EXISTS {$db_prefix}ads_settings ( variable tinytext NOT NULL, value text NOT NULL, PRIMARY KEY (variable(30)) )
Query: [Select]
ALTER IGNORE TABLE {$db_prefix}ads ADD show_lastpost smallint(4) NOT NULL default '0' AFTER show_threadindex
Query: [Select]
ALTER IGNORE TABLE {$db_prefix}ads ADD CATEGORY tinytext AFTER POSTS
Query: [Select]
ALTER IGNORE TABLE {$db_prefix}ads ADD show_underchildren smallint(4) NOT NULL default '0'
Query: [Select]
INSERT IGNORE INTO {$db_prefix}settings (variable, value) VALUES ('ads_displayAdsAdmin', '0'), ('ads_updateReports', '0'), ('ads_quickDisable', '0'), ('ads_lookLikePosts', '1')

File Operations
Move the included file "Ads.php" to "./Sources".
Move the included file "LoadAds.php" to "./Sources".
Move the included file "Ads.template.php" to "./Themes/default".
Move the included file "Ads.english.php" to "./Themes/default/languages".

mtcasa