Coinbase

Author Topic: help with the manual install  (Read 4231 times)

0 Members and 1 Guest are viewing this topic.

Offline eladh7

  • Newbie
  • *
  • Posts: 3
    • Email
help with the manual install
« on: August 15, 2008, 05:05:07 pm »
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:
"
Code: [Select]
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
« Last Edit: August 15, 2008, 09:27:26 pm by eladh7 »

Offline gri

  • Full Member
  • ***
  • Posts: 111
  • Space Human
Re: help with the manual install
« Reply #1 on: August 19, 2008, 12: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 ?
Instruction on getting Help on PAY-ME (AdManagement) mod installing.
Your GRItoadMIXes

Offline ccbtimewiz

  • Sr. Member
  • ****
  • Posts: 326
    • Dream Portal
Re: help with the manual install
« Reply #2 on: August 19, 2008, 08:14:06 pm »
Make sure your host/server permits usage of the CREATE and ALTER MySQL commands.

Offline eladh7

  • Newbie
  • *
  • Posts: 3
    • Email
Re: help with the manual install
« Reply #3 on: August 23, 2008, 01:15:55 am »
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  ;)


Offline fadun

  • Jr. Member
  • **
  • Posts: 35
Re: help with the manual install
« Reply #4 on: September 04, 2008, 07:15:34 am »
Someone should please help me wit steps involve in manually installing adverts on my SMF 1.1.5 Forum. Thanks

Offline bigguy

  • Support
  • Elite Member
  • *
  • Posts: 1518
    • SMF Helper
Re: help with the manual install
« Reply #5 on: September 04, 2008, 07:56:07 pm »
Please do a search all the edits are posted here. :)

Offline fadun

  • Jr. Member
  • **
  • Posts: 35
Re: help with the manual install
« Reply #6 on: September 05, 2008, 07:06:20 am »
@ bigguy. I can't find the edit you are refering to in your post. Kindly repost same, thank you.

Offline mtcasa

  • Newbie
  • *
  • Posts: 5
Re: help with the manual install
« Reply #7 on: September 11, 2008, 02:06:25 am »
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".

Offline mtcasa

  • Newbie
  • *
  • Posts: 5
Re: help with the manual install
« Reply #8 on: September 12, 2008, 03:17:53 am »
Never mind.  I got it.  Thanks.

SMF Ads Support Forum

Re: help with the manual install
« Reply #8 on: September 12, 2008, 03:17:53 am »
.

 

.