easy mod problem

[luigi2212]

were do is the default table name ?

[luigi2212]

were do i change the name ****

[luigi2212]

i went on phpmyadmin and ran the queries that appear on the the install.php file.....all went well BUT the table the error says is missing, still is ! its not ther :S:S:S rely need help ! ( didn't fully understand what you said i had to do in ure last post)
thanks alot ^^

[WhiteWolfSix]

In installation text of the MOD you'll find SQL that you have to run. You have to little change this query according your table prefix. If you are unsure, please, insert that SQL here and I will change it for you.

Default table prefix is 'phpbb_', so in your SQL it could looks like CREATE TABLE 'phpbb_bookie_admin_bets' and you have to change it to CREATE TABLE 'luigi_luigi.phpbb_bookie_admin_bets'

[luigi2212]

i cant find any sql query that is called phpbb_bookie_admin_bets.......these are the queries that are in the install file :
#
#-----[ SQL ]------------------------------------------
#

CREATE TABLE phpbb_foretell_config (
config_name varchar(255) NOT NULL default '',
config_value varchar(255) NOT NULL default ''
) TYPE=MyISAM;

INSERT INTO phpbb_foretell_config VALUES ('email_reminder', '0');
INSERT INTO phpbb_foretell_config VALUES ('email_remhours', '48');
INSERT INTO phpbb_foretell_config VALUES ('auto_close', '0');

#
#-----[ SQL ]------------------------------------------
#

CREATE TABLE phpbb_foretell_matches (
match_id mediumint(9) UNSIGNED NOT NULL auto_increment,
match_num tinyint(4) UNSIGNED NOT NULL default '0',
tournament_id smallint(5) UNSIGNED NOT NULL default '0',
round_id tinyint(4) UNSIGNED NOT NULL default '0',
local_id smallint(5) UNSIGNED NOT NULL default '0',
visitor_id smallint(5) UNSIGNED NOT NULL default '0',
score tinyint(4) UNSIGNED NOT NULL default '0',
PRIMARY KEY (match_id),
KEY match_num (match_num),
KEY tournament_id (tournament_id),
KEY round_id (round_id)
) TYPE=MyISAM;

#
#-----[ SQL ]------------------------------------------
#

CREATE TABLE phpbb_foretell_points (
points_id mediumint(9) UNSIGNED NOT NULL auto_increment,
tournament_id smallint(5) UNSIGNED NOT NULL default '0',
user_id int(11) NOT NULL default '0',
points mediumint(9) NOT NULL default '0',
playedrounds smallint(6) UNSIGNED NOT NULL default '0',
playedmatches mediumint(9) UNSIGNED NOT NULL default '0',
temp tinyint(4) NOT NULL default '0',
prevdiff smallint(6) NOT NULL default '0',
reminder tinyint(4) UNSIGNED NOT NULL default '0',
PRIMARY KEY (points_id),
KEY tournament_id (tournament_id),
KEY user_id (user_id)
) TYPE=MyISAM;

#
#-----[ SQL ]------------------------------------------
#

CREATE TABLE phpbb_foretell_predictions (
prediction_id mediumint(9) UNSIGNED NOT NULL auto_increment,
round_id tinyint(4) UNSIGNED NOT NULL default '0',
user_id int(11) NOT NULL default '0',
tournament_id smallint(5) UNSIGNED NOT NULL default '0',
match_id mediumint(9) UNSIGNED NOT NULL default '0',
prediction tinyint(4) UNSIGNED NOT NULL default '0',
PRIMARY KEY (prediction_id),
KEY round_id (round_id),
KEY tournament_id (tournament_id),
KEY match_id (match_id)
) TYPE=MyISAM;

#
#-----[ SQL ]------------------------------------------
#

CREATE TABLE phpbb_foretell_rounds (
rounds_id mediumint(9) UNSIGNED NOT NULL auto_increment,
tournament_id smallint(6) UNSIGNED NOT NULL default '0',
round_id tinyint(4) UNSIGNED NOT NULL default '0',
`status` tinyint(4) UNSIGNED NOT NULL default '0',
control tinyint(4) UNSIGNED NOT NULL default '0',
close_time int(11) NOT NULL default '0',
tie tinyint(4) UNSIGNED NOT NULL default '0',
reminder_sent tinyint(4) NOT NULL default '0',
PRIMARY KEY (rounds_id),
KEY tournament_id (tournament_id),
KEY round_id (round_id)
) TYPE=MyISAM;


#
#-----[ SQL ]------------------------------------------
#

CREATE TABLE phpbb_foretell_sfcountries (
country_id smallint(5) UNSIGNED NOT NULL auto_increment,
country_name varchar(40) NOT NULL default '',
PRIMARY KEY (country_id)
) TYPE=MyISAM;

#
#-----[ SQL ]------------------------------------------
#

CREATE TABLE phpbb_foretell_sports (
sport_id smallint(5) UNSIGNED NOT NULL auto_increment,
sport_name varchar(20) NOT NULL default '',
def tinyint(4) NOT NULL default '0',
PRIMARY KEY (sport_id)
) TYPE=MyISAM;

#
#-----[ SQL ]------------------------------------------
#

CREATE TABLE phpbb_foretell_teams (
team_id smallint(5) UNSIGNED NOT NULL auto_increment,
team_name varchar(40) NOT NULL default '',
country_id tinyint(4) UNSIGNED NOT NULL default '0',
sport_id smallint(5) UNSIGNED NOT NULL default '0',
PRIMARY KEY (team_id),
KEY sport_id (sport_id)
) TYPE=MyISAM;

#
#-----[ SQL ]------------------------------------------
#

CREATE TABLE phpbb_foretell_tournaments (
tournament_id smallint(5) UNSIGNED NOT NULL auto_increment,
tournament_name varchar(40) NOT NULL default '',
tournament_type tinyint(4) NOT NULL default '0',
tournament_description varchar(255) NOT NULL default '',
tournament_rounds tinyint(4) UNSIGNED NOT NULL default '0',
tournament_matchesround tinyint(4) UNSIGNED NOT NULL default '0',
country_id smallint(5) UNSIGNED NOT NULL default '0',
def tinyint(4) UNSIGNED NOT NULL default '0',
tournament_mode tinyint(4) UNSIGNED NOT NULL default '0',
sport_id smallint(6) NOT NULL default '0',
players_mode tinyint(4) NOT NULL default '0',
PRIMARY KEY (tournament_id),
KEY sport_id (sport_id)
) TYPE=MyISAM;

#
#-----[ SQL ]------------------------------------------
#

CREATE TABLE phpbb_foretell_winners (
winner_id smallint(6) UNSIGNED NOT NULL auto_increment,
user_id mediumint(9) NOT NULL default '0',
tournament_id smallint(5) UNSIGNED NOT NULL default '0',
PRIMARY KEY (winner_id),
KEY user_id (user_id)
) TYPE=MyISAM;


as u can see, they are all phpbb_foretell not phpbb_bookie.......whats going on !?

[Lumpy Burgertushie]

first, whitewolf is mistaken this time.

that luigi_luigi part is the database name , not part of the table name.
so your table name is fine.

however, since it cant find that table, and you can't find the sql to create it in that MOD.
guess what? it is probably from one of the other MODs you just installed. go back and check them all for that sql.


robert

[luigi2212]

is ther anyway i can "uninstall" the mod thats creating this error ?

[luigi2212]

ok, u was right, it was a different mod...BUT i still cant install foretell sports, wen trying with easymod this happens :
Critical Error

COPY FAILED: The target file to be copied [./mods/Foretell-Sports_BETA-0-0-3/foretell_sports/root/foretell.php] could not be found.
copy foretell_sports/root/foretell.php to foretell.php
MOD script line #261 :: FAQ :: Report

Critical Error

COPY FAILED: The target file to be copied [./mods/Foretell-Sports_BETA-0-0-3/foretell_sports/root/fspoints.php] could not be found.
copy foretell_sports/root/fspoints.php to fspoints.php
MOD script line #261 :: FAQ :: Report

Critical Error

COPY FAILED: The target file to be copied [./mods/Foretell-Sports_BETA-0-0-3/foretell_sports/root/fsviewuser.php] could not be found.
copy foretell_sports/root/fsviewuser.php to fsviewuser.php
MOD script line #261 :: FAQ :: Report

Critical Error

COPY FAILED: The target file to be copied [./mods/Foretell-Sports_BETA-0-0-3/foretell_sports/root/fsfixture.php] could not be found.
copy foretell_sports/root/fsfixture.php to fsfixture.php
MOD script line #261 :: FAQ :: Report

Critical Error

COPY FAILED: The target file to be copied [./mods/Foretell-Sports_BETA-0-0-3/foretell_sports/root/includes/functions_foretell.php] could not be found.
copy foretell_sports/root/includes/functions_foretell.php to includes/functions_foretell.php
MOD script line #261 :: FAQ :: Report


ive tried copying them myself into the main directory as it says to, but nothing happens....same errors

[Lumpy Burgertushie]

if you have uploaded all those files to their proper place, then open the MOD install file and remove the whole
#----[ COPY ]------

section.

then run the MOD through easymod again.


robert

[luigi2212]

that seems to have fixed those errors, but now i encounter this one :
Critical Error

FIND FAILED: In file [admin/admin_groups.php] could not find:

$sql = "INSERT INTO " . GROUPS_TABLE . " (group_type, group_name, group_description, group_moderator, group_single_user)
VALUES ($group_type, '" . str_replace("\'", "''", $group_name) . "', '" . str_replace("\'", "''", $group_description) . "', $group_moderator, '0')";

MOD script line #945 :: FAQ :: Report

i would try inserting it, but when i counted the lines using microsoft word's word count ther was only 490.....help !!

noob in need ^^ thnks !