Rabbitoschi

[koudekerk]

Ik heb een probleem met de mod rabbitoschi hij zegt dit

phpBB

: Critical Error

Error Getting Rabbitoshi Users!

DEBUG MODE

SQL Error : 1146 Table 'forumfun2.RABBITOSHI_USERS_TABLE' doesn't exist

HOe moet ik dei database aanmaken
_________________

[Just Me]

Wil jij is vertellen van waar jij die "rabbitoschi" modd hebt ??
ps dat moet hier niet staan maar in de mods topics

[Luuk]

Zoek http://www.phpbbhacks.com/searchresults ... rch_type=1

maar even voor koudekerk,

heb je de database veranderingen ook gedaan? Heb je de prefix ook veranderd van je database veranderingen?

[koudekerk]

wat is dat en waar kan ik dat doen en hoe??

[Luuk]

lees dit eens (onderaan, NR 10) http://www.phpbb.nl/kb.php?mode=article&k=24

[V!ncent]

je moet ff de databese aan maken.

[koudekerk]

Nu zegt die dit weer: En nu??
Fout

SQL-query :

INSERT INTO phpbb_config( config_name, config_value )
VALUES (

'rabbitoshi_enable', '1'
)

MySQL retourneerde:


#1062 - Duplicate entry 'rabbitoshi_enable' for key 1

[Luuk]

je moet phpbb_config veranderen naar jouwprefix_config

[koudekerk]

hoe doe ik dat?

[Luuk]

ga naar je database
rechts zie je allemaal tabellen staan, XXX_auth_access etc.
Op de plaats waar XXX staat, staat de prefix. Zo kom je erachter wat je prefix is.

Nu ga je naar SQL en voer je dit in:

Code: Selecteer alles

INSERT INTO XXX_config( config_name, config_value ) 
VALUES ( 

'rabbitoshi_enable', '1' 
) 

Op de plaats van XXX vul je de prefix in

[koudekerk]

mijn prefix is phpbb (kan dat?) maar dan doet die het nog niet

[Podium4]

phpbb is inderdaad de standaard prefix... let wel op het is phpbb_ dus vergeet de underscore niet als je zelf de prefix moet invullen...

Controleer gelijk ook even of je alle wijzigingen hebt uitgevoerd voor de mod... MET NAME die in de includes/constants.php

[koudekerk]

wie wil en kan het oplossen als ik ff het wachtwoord van mijn phpmijadmin geef?? en mijn forum is http://www.maltastart.com/~forumfun/

[koudekerk]

niemand?

[Luuk]

zet de code die je uit moest voeren hier eens neer, die in install.txt staat dus.

[koudekerk]

[/code]INSERT INTO phpbb_config (config_name, config_value) VALUES ('rabbitoshi_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('rabbitoshi_name', 'Rabbistoshi');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('rabbitoshi_enable_cron', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('rabbitoshi_cron_time', '86400');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('rabbitoshi_cron_last_time', '0');

CREATE TABLE phpbb_rabbitoshi_config (
creature_id smallint(2) NOT NULL default '0',
creature_name varchar(255) NOT NULL default '',
creature_prize int(8) NOT NULL default '0',
creature_max_hunger int(8) NOT NULL default '0',
creature_max_thirst int(8) NOT NULL default '0',
creature_max_health int(8) NOT NULL default '0',
creature_max_hygiene int(8) NOT NULL default '0',
creature_food_id smallint(2) NOT NULL default '0',
creature_buyable tinyint(1) NOT NULL default '1',
creature_evolution_of int(8) NOT NULL default '0',
creature_img varchar(255) NOT NULL default '',
PRIMARY KEY (creature_id)
) TYPE=MyISAM;

INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (10, 'Eagle', 500, 150, 60, 150, 60, 3, 1, 0, 'Eagle.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (9, 'Tiger', 5000, 60, 400, 60, 400, 5, 1, 0, 'Tiger.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (8, 'Beaver', 30, 20, 20, 20, 50, 1, 1, 0, 'Beaver.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (7, 'Hiloterium', 50, 200, 200, 200, 1500, 5, 1, 0, 'Hiloterium.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (6, 'Dragon', 20000, 300, 1000, 5000, 250, 6, 1, 0, 'Dragon.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (11, 'Polar Bear', 700, 500, 500, 500, 500, 4, 1, 0, 'Polar_Bear.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (12, 'Rabbit', 20, 20, 20, 20, 50, 2, 1, 0, 'Rabbit.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (13, 'Chaos Rabbit', 8000, 1500, 1500, 1500, 100, 2, 1, 12, 'Chaos_Rabbit.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (4, 'Lion', 240, 80, 70, 400, 120, 5, 1, 0, 'Lion.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (3, 'Cat', 40, 20, 20, 90, 20, 4, 1, 0, 'Cat.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (2, 'Dog', 40, 50, 50, 60, 100, 3, 1, 0, 'Dog.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (1, 'Chinchilla', 120, 100, 100, 15, 100, 1, 1, 0, 'Chinchilla.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (5, 'Penguin', 500, 120, 60, 75, 50, 4, 1, 0, 'Penguin.gif');

CREATE TABLE phpbb_rabbitoshi_general (
config_name varchar(255) NOT NULL default '0',
config_value int(15) NOT NULL default '0',
PRIMARY KEY (config_name)
) TYPE=MyISAM;

INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('thirst_time', 600);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('thirst_value', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hunger_time', 600);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hunger_value', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hygiene_time', 3600);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hygiene_value', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('health_time', 86400);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('health_value', 5);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('rebirth_enable', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('rebirth_price', 50000);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('vet_enable', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('vet_price', 300);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hotel_enable', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hotel_cost', 500);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('evolution_enable', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('evolution_cost', 100);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('evolution_time', 25);

CREATE TABLE phpbb_rabbitoshi_shop (
item_id smallint(1) NOT NULL default '0',
item_name varchar(255) NOT NULL default '',
item_prize int(8) NOT NULL default '0',
item_desc varchar(255) NOT NULL default '',
item_type smallint(1) NOT NULL default '0',
item_power int(8) NOT NULL default '0',
item_img varchar(255) NOT NULL default '',
PRIMARY KEY (item_id)
) TYPE=MyISAM;

INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (1, 'Rabbitoshi_items_seeds', 10, 'Rabbitoshi_items_seeds_desc', 1, 1, 'Seeds.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (2, 'Rabbitoshi_items_carrots', 20, 'Rabbitoshi_items_carrots_desc', 1, 20, 'Carotts.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (3, 'Rabbitoshi_items_meat', 30, 'Rabbitoshi_items_meat_desc', 1, 3, 'Fresh_meat.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (4, 'Rabbitoshi_items_fish', 30, 'Rabbitoshi_items_fish_desc', 1, 3, 'Fish.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (5, 'Rabbitoshi_items_gazelle', 100, 'Rabbitoshi_items_gazelle_desc', 1, 8, 'Gazelle.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (6, 'Rabbitoshi_items_diamonds', 500, 'Rabbitoshi_items_diamonds_desc', 1, 10, 'Diamonds.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (7, 'Rabbitoshi_items_limpid_water', 2, 'Rabbitoshi_items_limpid_water_desc', 2, 4, 'Limpid_water.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (8, 'Rabbitoshi_items_cleaner', 500, 'Rabbitoshi_items_cleaner_desc', 3, 10, 'Cleaner.gif');


CREATE TABLE phpbb_rabbitoshi_shop_users (
item_id mediumint(8) NOT NULL default '0',
user_id mediumint(8) NOT NULL default '0',
item_amount mediumint(8) NOT NULL default '0',
KEY item_id (item_id),
KEY user_id (user_id)
) TYPE=MyISAM;

CREATE TABLE phpbb_rabbitoshi_users (
owner_id int(8) NOT NULL default '0',
owner_last_visit int(11) NOT NULL default '0',
owner_creature_id smallint(2) NOT NULL default '0',
owner_creature_name varchar(255) NOT NULL default '',
creature_hunger int(8) NOT NULL default '0',
creature_thirst int(8) NOT NULL default '0',
creature_health int(8) NOT NULL default '0',
creature_hygiene int(8) NOT NULL default '0',
creature_age int(11) NOT NULL default '0',
creature_hotel int(11) NOT NULL default '0',
owner_notification tinyint(1) NOT NULL default '0',
owner_hide tinyint(1) NOT NULL default '0',
owner_feed_full tinyint(1) NOT NULL default '1',
owner_drink_full tinyint(1) NOT NULL default '1',
owner_clean_full tinyint(1) NOT NULL default '1',
PRIMARY KEY (owner_id)
) TYPE=MyISAM;

Code: Selecteer alles

 

Kan iemand het oplossen als ik het wachtwoord geef??

[koudekerk]

niemand? :thumb:

[Luuk]

ik kan het wel, maar ik denk dat je het zelf ook wel kunt hoor

[koudekerk]

Nauw heb ik al wat gemaakt maar nauw geeft die deze fout weer:

Could not obtain items pets information

DEBUG MODE

SQL Error : 1146 Table 'forumfun2.RABBITOSHI_SHOP_USERS_TABLE' doesn't exist

SELECT item_amount FROM RABBITOSHI_SHOP_USERS_TABLE WHERE user_id = 2 AND item_id = 1

Line : 194
File : /home/forumfun/public_html/includes/functions_rabbitoshi.php

[hotrid]

ik kan het wel, maar ik denk dat je het zelf ook wel kunt hoor

Tss..zeg dan gewoon niets! Hier heeft niemand wat aan

maarja...er staat dat de volgende tabel in je database (mysql) niet bestaat :
forumfun2.RABBITOSHI_SHOP_USERS_TABLE


terwijl dit je database staat :
phpbb_rabbitoshi


er moet dus ergens forumfun2.RABBITOSHI staan terwijl er phpbb_rabbitoshi moet staan...

{ik hoop dat je hier wat aan hebt}