Photo Gallery
: 29 kwietnia 2009, 07:44
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
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