Ad Management 0.1.2 sql

Looking for a MOD? Have a MOD request? Post here for help. (Note: This forum is community supported; phpBB does not have official MOD authors)
Ideas Centre
Locked
xctaek21r
Registered User
Posts: 31
Joined: Fri Jun 15, 2007 4:18 pm

Ad Management 0.1.2 sql

Post by xctaek21r »

Ad Management 0.1.2
where i must put this code to work :cry:

Code: Select all

CREATE TABLE `phpbb_ad` (
  `ID` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `code` text NOT NULL,
  `show_forums` int(11) NOT NULL default '0',
  `show_all_forums` int(11) NOT NULL default '0',
  `activ` int(11) NOT NULL default '0',
  `views` int(11) NOT NULL default '0',
  `max_views` int(11) NOT NULL default '0',
  `position` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ; 
whithout create this table i see this:

SQL ERROR [ mysql4 ]

Table 'ggforum_phpbb3.phpbb_ad' doesn't exist [1146]

SQL

SELECT ID, name, activ, show_all_forums, views, max_views FROM phpbb_ad

BACKTRACE

FILE: includes/db/mysql.php
LINE: 133
CALL: dbal_mysql->sql_error()

FILE: includes/acp/acp_ads.php
LINE: 132
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 460
CALL: acp_ads->main()

FILE: adm/index.php
LINE: 80
CALL: p_master->load_active()
Last edited by xctaek21r on Sat Jun 23, 2007 12:47 am, edited 1 time in total.
tashkar18
Registered User
Posts: 375
Joined: Sat Mar 19, 2005 5:44 am
Location: to concur the nation
Contact:

Re: PLEASE HELP ME

Post by tashkar18 »

change your topic title before you get flamed.
Kingshady.Com - Read The NEWS about EMINEM's NEW ALBUM

DO NOT CLICK HERE
mshiznitzh
Registered User
Posts: 99
Joined: Wed Mar 02, 2005 5:20 pm

Re: Ad Management 0.1.2 sql

Post by mshiznitzh »

xctaek21r wrote:Ad Management 0.1.2
where i must put this code to work :cry:

Code: Select all

CREATE TABLE `phpbb_ad` (
  `ID` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `code` text NOT NULL,
  `show_forums` int(11) NOT NULL default '0',
  `show_all_forums` int(11) NOT NULL default '0',
  `activ` int(11) NOT NULL default '0',
  `views` int(11) NOT NULL default '0',
  `max_views` int(11) NOT NULL default '0',
  `position` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ; 
whithout create this table i see this:

SQL ERROR [ mysql4 ]

Table 'ggforum_phpbb3.phpbb_ad' doesn't exist [1146]

SQL

SELECT ID, name, activ, show_all_forums, views, max_views FROM phpbb_ad

BACKTRACE

FILE: includes/db/mysql.php
LINE: 133
CALL: dbal_mysql->sql_error()

FILE: includes/acp/acp_ads.php
LINE: 132
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 460
CALL: acp_ads->main()

FILE: adm/index.php
LINE: 80
CALL: p_master->load_active()
To add the table to the db you will have to use phpMyAdmin say sql statement.
Locked

Return to “[3.0.x] MOD Requests”