Glaube, ich habe das Problem!! Habe zwei Portals auf meiner DB!
Habe jetzt nochmal auf meine 1.(Hauptpage) das Mod installiert! Da funktionierts! Da habe ich auch nicht die SQL ändern müssen:
Code: Alles auswählen
#
# MOM 2.0.6 (Media Center) for phpBB2 - MySQL schema & basic (by Cf Manager)
#
# --------------------------------------------------------
#
# Table structure for table 'phpbb_music'
#
CREATE TABLE phpbb_music (
song_id int(11) UNSIGNED NOT NULL auto_increment,
song_filename varchar(255) NOT NULL,
song_title varchar(255) NOT NULL,
song_url varchar(255) NOT NULL,
song_desc text,
song_singer varchar(255) NOT NULL,
song_user_id mediumint(8) NOT NULL,
song_username varchar(32),
song_user_ip char(8) NOT NULL DEFAULT '0',
song_time int(11) UNSIGNED NOT NULL,
song_cat_id mediumint(8) UNSIGNED NOT NULL DEFAULT '1',
song_view_count int(11) UNSIGNED NOT NULL DEFAULT '0',
song_lock tinyint(3) NOT NULL DEFAULT '0',
song_approval tinyint(3) NOT NULL DEFAULT '1',
PRIMARY KEY (song_id),
KEY song_cat_id (song_cat_id),
KEY song_user_id (song_user_id),
KEY song_time (song_time));
# --------------------------------------------------------
#
# Table structure for table 'phpbb_music_rate'
#
CREATE TABLE phpbb_music_rate (
rate_song_id int(11) UNSIGNED NOT NULL,
rate_user_id mediumint(8) NOT NULL,
rate_user_ip char(8) NOT NULL,
rate_point tinyint(3) UNSIGNED NOT NULL,
KEY rate_song_id (rate_song_id),
KEY rate_user_id (rate_user_id),
KEY rate_user_ip (rate_user_ip),
KEY rate_point (rate_point));
# --------------------------------------------------------
#
# Table structure for table 'phpbb_music_comment'
#
CREATE TABLE phpbb_music_comment (
comment_id int(11) UNSIGNED NOT NULL auto_increment,
comment_song_id int(11) UNSIGNED NOT NULL,
comment_user_id mediumint(8) NOT NULL,
comment_username varchar(32),
comment_user_ip char(8) NOT NULL,
comment_time int(11) UNSIGNED NOT NULL,
comment_text TEXT,
comment_edit_time int(11) UNSIGNED,
comment_edit_count smallint(5) UNSIGNED NOT NULL DEFAULT '0',
comment_edit_user_id mediumint(8),
PRIMARY KEY(comment_id),
KEY comment_song_id (comment_song_id),
KEY comment_user_id (comment_user_id),
KEY comment_user_ip (comment_user_ip),
KEY comment_time (comment_time));
# --------------------------------------------------------
#
# Table structure for table 'phpbb_music_cat'
#
CREATE TABLE phpbb_music_cat (
cat_id mediumint(8) UNSIGNED NOT NULL auto_increment,
cat_title varchar(255) NOT NULL,
cat_desc text,
cat_order mediumint(8) NOT NULL,
cat_view_level tinyint(3) NOT NULL DEFAULT '-1',
cat_upload_level tinyint(3) NOT NULL DEFAULT '0',
cat_rate_level tinyint(3) NOT NULL DEFAULT '0',
cat_comment_level tinyint(3) NOT NULL DEFAULT '0',
cat_edit_level tinyint(3) NOT NULL DEFAULT '0',
cat_delete_level tinyint(3) NOT NULL DEFAULT '2',
cat_view_groups varchar(255),
cat_upload_groups varchar(255),
cat_rate_groups varchar(255),
cat_comment_groups varchar(255),
cat_edit_groups varchar(255),
cat_delete_groups varchar(255),
cat_moderator_groups varchar(255),
cat_approval tinyint(3) NOT NULL DEFAULT '0',
PRIMARY KEY (cat_id),
KEY cat_order (cat_order));
# --------------------------------------------------------
#
# Table structure for table 'phpbb_music_config'
#
CREATE TABLE phpbb_music_config (
config_name varchar(255) NOT NULL,
config_value varchar(255) NOT NULL,
PRIMARY KEY (config_name));
# -- Music config
INSERT INTO phpbb_music_config VALUES ('max_songs', '1024');
INSERT INTO phpbb_music_config VALUES ('user_songs_limit', '50');
INSERT INTO phpbb_music_config VALUES ('mod_songs_limit', '250');
INSERT INTO phpbb_music_config VALUES ('max_file_size', '3145728');
INSERT INTO phpbb_music_config VALUES ('rows_per_page', '20');
INSERT INTO phpbb_music_config VALUES ('cols_per_page', '1');
INSERT INTO phpbb_music_config VALUES ('top', '5');
INSERT INTO phpbb_music_config VALUES ('sort_method', 'song_time');
INSERT INTO phpbb_music_config VALUES ('sort_order', 'DESC');
INSERT INTO phpbb_music_config VALUES ('mp3_allowed', '1');
INSERT INTO phpbb_music_config VALUES ('wav_allowed', '1');
INSERT INTO phpbb_music_config VALUES ('wma_allowed', '1');
INSERT INTO phpbb_music_config VALUES ('wmv_allowed', '1');
INSERT INTO phpbb_music_config VALUES ('mid_allowed', '1');
INSERT INTO phpbb_music_config VALUES ('ram_allowed', '1');
INSERT INTO phpbb_music_config VALUES ('au_allowed', '1');
INSERT INTO phpbb_music_config VALUES ('mpeg_allowed', '1');
INSERT INTO phpbb_music_config VALUES ('avi_allowed', '1');
INSERT INTO phpbb_music_config VALUES ('swf_allowed', '1');
INSERT INTO phpbb_music_config VALUES ('qt_allowed', '1');
INSERT INTO phpbb_music_config VALUES ('rm_allowed', '1');
INSERT INTO phpbb_music_config VALUES ('desc_length', '512000');
INSERT INTO phpbb_music_config VALUES ('hotlink_prevent', '0');
INSERT INTO phpbb_music_config VALUES ('hotlink_allowed', 'cfmanager.gate2vn.net');
INSERT INTO phpbb_music_config VALUES ('rate', '1');
INSERT INTO phpbb_music_config VALUES ('rate_scale', '10');
INSERT INTO phpbb_music_config VALUES ('comment', '1');
INSERT INTO phpbb_music_config VALUES ('music_version', '.0.6');
Auf meinem zweiten Portal, also selbe DB, müssen die SQL anders benannt werden!
das komplette portal unter einem andern SQL-Namen laufen.
Bsp. xxxphpbb_
Nun schätze ich mal das das SQL diesen Namen nicht erkennt! Obwohl ich die oben genannten SQL-Tables richtig benannt habe!
Also immer davor Bsp. "xxxphpbb_music_confic"!!!
Ich habe jetzt zwei Music-Online-SQL-Tables auf meiner DB!
1.Homepage test (funktioniert):
Portal 1
2.Homepage test (funktioniert nicht):
Test Portal
wie muss ich die SQL ändern, wenns dieser Fehler dann ist!
Thnx
arni22
- was passiert eigentlich wenn die datei aus dem beispiel: 
Also hochgeladen werden sie jetzt. Sehen ungefähr so aus: 
