Author Topic: fehlermeldung nach installtion  (Read 2531 times)

0 Members and 1 Guest are viewing this topic.

Offline candys

  • Newbie
  • *
  • Posts: 21
    • View Profile
fehlermeldung nach installtion
« on: April 04, 2005, 03:28:25 AM »
also ich habe vorhin versucht eure datenbank zu installieren und nach  dem ich auf den install button gedrückt habe kam folgen fehlermeldung.


DB Error: Bad SQL Query: CREATE TABLE 4images_categories (cat_id int(10) unsigned NOT NULL auto_increment,cat_name varchar(255) NOT NULL default '',cat_description text NOT NULL,cat_parent_id int(10) unsigned NOT NULL default '0',cat_hits int(10) unsigned NOT NULL default '0',cat_order int(10) unsigned NOT NULL default '0',auth_viewcat tinyint(2) NOT NULL default '0',auth_viewimage tinyint(2) NOT NULL default '0',auth_download tinyint(2) NOT NULL default '0',auth_upload tinyint(2) NOT NULL default '0',auth_directupload tinyint(2) NOT NULL default '0',auth_vote tinyint(2) NOT NULL default '0',auth_sendpostcard tinyint(2) NOT NULL default '0',auth_readcomment tinyint(2) NOT NULL default '0',auth_postcomment tinyint(2) NOT NULL default '0',PRIMARY KEY (cat_id),KEY cat_parent_id (cat_parent_id),KEY cat_order (cat_order)) TYPE=MyISAM
Table '4images_categories' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_comments (comment_id int(10) unsigned NOT NULL auto_increment,image_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',user_name varchar(100) NOT NULL default '',comment_headline varchar(255) NOT NULL default '',comment_text text NOT NULL,comment_ip varchar(20) NOT NULL default '',comment_date int(11) unsigned NOT NULL default '0',PRIMARY KEY (comment_id),KEY image_id (image_id),KEY user_id (user_id),KEY comment_date (comment_date)) TYPE=MyISAM
Table '4images_comments' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_groupaccess (group_id int(10) unsigned NOT NULL default '0',cat_id int(10) unsigned NOT NULL default '0',auth_viewcat tinyint(1) NOT NULL default '0',auth_viewimage tinyint(1) NOT NULL default '0',auth_download tinyint(1) NOT NULL default '0',auth_upload tinyint(1) NOT NULL default '0',auth_directupload tinyint(1) NOT NULL default '0',auth_vote tinyint(1) NOT NULL default '0',auth_sendpostcard tinyint(1) NOT NULL default '0',auth_readcomment tinyint(1) NOT NULL default '0',auth_postcomment tinyint(1) NOT NULL default '0',KEY group_id (group_id),KEY cat_id (cat_id)) TYPE=MyISAM
Table '4images_groupaccess' already exists

DB Error: Bad SQL Query: CREATE TABLE 4images_groupmatch (group_id int(10) unsigned NOT NULL default '0',user_id int(11) NOT NULL default '0',groupmatch_startdate int(11) unsigned NOT NULL default '0',groupmatch_enddate int(11) unsigned NOT NULL default '0',KEY group_id (group_id),KEY user_id (user_id)) TYPE=MyISAM
Table '4images_groupmatch' already exists


kann mir da jemand weiterhelfen

danke

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: fehlermeldung nach installtion
« Reply #1 on: April 11, 2005, 04:43:24 PM »
-> "Table '4images_categories' already exists"

meint das diese tabelle bereits existiert

DB ausleeren, neu installieren.. KEIN MYSQL dump einspielen
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi