phpBB.de

CREATE TABLE phpbb2_tuh_gb_config (

config_id int(10) NOT NULL auto_increment,

back_ground_color varchar(25) NOT NULL default '#cfd9ff',

min_entrylength int(10) NOT NULL default '15',

max_entrylength int(10) NOT NULL default '750',

font_color varchar(25) NOT NULL default '#343434',

font_size_one int(2) NOT NULL default '11',

font_size_two int(2) NOT NULL default '14',

font_size_three int(2) NOT NULL default '15',

link_size int(2) NOT NULL default '10',

design_gb_links varchar(50) NOT NULL default 'no',

design_t_links varchar(50) NOT NULL default 'no',

checkbox_gb_links int(1) NOT NULL default '0',

checkbox_t_links int(1) NOT NULL default '0',

entries_per_site int(3) NOT NULL default '5',

use_gd2 int(1) NOT NULL default '0',

PRIMARY KEY (config_id)

);



INSERT INTO phpbb2_tuh_gb_config (config_id, back_ground_color, min_entrylength, max_entrylength, font_color, font_size_one, font_size_two, font_size_three, link_size, design_gb_links, design_t_links, checkbox_gb_links, checkbox_t_links, entries_per_site) VALUES

(1, '#cfd9ff', 15, 750, '#343434', 11, 14, 15, 10, 'no', 'no', 0, 0, 5, 0);

Fehler
SQL-Befehl:

INSERT INTO phpbb2_tuh_gb_config( config_id, back_ground_color, min_entrylength, max_entrylength, font_color, font_size_one, font_size_two, font_size_three, link_size, design_gb_links, design_t_links, checkbox_gb_links, checkbox_t_links, entries_per_site )
VALUES ( 1, '#cfd9ff', 15, 750, '#343434', 11, 14, 15, 10, 'no', 'no', 0, 0, 5, 0 ) ;

MySQL meldet:

#1136 - Column count doesn't match value count at row 1