Photo Gallery

[biszek]

wszystko skopiowalem , uruchomilem gallery_db.php i otrzymalem :
General Error
SQL ERROR [ mysqli ]

Table 'phpbb_gallery' already exists [1050]

SQL

CREATE TABLE phpbb_gallery (gallery_id mediumint(8)UNSIGNED NOT NULL auto_increment, user_id mediumint(8)UNSIGNED DEFAULT '0' NOT NULL, parent_id mediumint(8)UNSIGNED DEFAULT '0' NOT NULL, left_id mediumint(8)UNSIGNED DEFAULT '0' NOT NULL, right_id mediumint(8)UNSIGNED DEFAULT '0' NOT NULL, gallery_name varchar(255)DEFAULT '' NOT NULL, gallery_desc text NOT NULL, gallery_desc_bitfield varchar(255)DEFAULT '' NOT NULL, gallery_desc_options int(11)UNSIGNED DEFAULT '7' NOT NULL, gallery_desc_uid varchar(5)DEFAULT '' NOT NULL, gallery_style tinyint(4)UNSIGNED DEFAULT '0' NOT NULL, gallery_image varchar(255)DEFAULT '' NOT NULL, gallery_rules varchar(255)DEFAULT '' NOT NULL, gallery_rules_bitfield varchar(255)DEFAULT '' NOT NULL, gallery_rules_options int(11)UNSIGNED DEFAULT '7' NOT NULL, gallery_rules_uid varchar(5)DEFAULT '' NOT NULL, gallery_images_per_page tinyint(4)UNSIGNED DEFAULT '0' NOT NULL, gallery_type tinyint(4)UNSIGNED DEFAULT '0' NOT NULL, gallery_photos mediumint(8)UNSIGNED DEFAULT '0' NOT NULL, gallery_comments mediumint(8)UNSIGNED DEFAULT '0' NOT NULL, gallery_views mediumint(8)UNSIGNED DEFAULT '0' NOT NULL, gallery_last_image_id mediumint(8)UNSIGNED DEFAULT '0' NOT NULL, gallery_last_comment_id mediumint(8)UNSIGNED DEFAULT '0' NOT NULL, gallery_last_uploader_id mediumint(8)UNSIGNED DEFAULT '0' NOT NULL, gallery_last_comenter_id mediumint(8)UNSIGNED DEFAULT '0' NOT NULL, gallery_last_update_time int(11)UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (gallery_id), KEY user_id (user_id), KEY parent_id (parent_id)) CHARACTER SET `utf8` COLLATE `utf8_bin`;

BACKTRACE


FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: gallery_db.php
LINE: 266
CALL: dbal_mysqli->sql_query()


czy ja cos zepsulem ???
doradzcie prosze co z tym zrobic ??
z gory dzieki

[Dares]

błąd świadczy o tym że tabela phpbb_gallery już istnieje

[Grin]

Wykonałeś dwa razy to samo zapytanie sql i stąd ten błąd. A czy taki błąd masz tylko przy uruchamianiu tego pliku ?

[biszek]

dzieki za odpowiedz , wywalilem ta galeri i wrzucilem to "phpbb_gallery_0_4_1" i chodzi bez problemu ,
dzieki za zainteresowanie