CONTENIDO Forum

Code: Alles auswählen

CREATE TABLE `con_pifa_contact` (`id` int(10) unsigned NOT NULL auto_increment COMMENT 'primary key',`salutation` varchar(255) default NULL,`first_name` varchar(255) default NULL,`last_name` varchar(255) default NULL,`company` varchar(255) default NULL,`street` varchar(255) default NULL,`street_number` varchar(255) default NULL,`plz` varchar(255) default NULL,`city` varchar(255) default NULL,`phone` varchar(255) default NULL,`email` varchar(255) default NULL,`message` text,`privacy` varchar(255) default NULL,PRIMARY KEY  (`id`)) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 
Mysql Error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=11' at line 2 (1064)

Unable to execute SQL statement:

CREATE TABLE `con_pifa_field` (`idfield` int(10) unsigned NOT NULL auto_increment COMMENT 'unique identifier for a ConForm field',`idform` int(10) unsigned NOT NULL default '0' COMMENT 'foreign key for the ConForm form',`field_rank` int(10) unsigned NOT NULL default '0' COMMENT 'rank of a field in a form',`field_type` int(10) unsigned NOT NULL default '0' COMMENT 'id which defines type of form field',`column_name` varchar(64) NOT NULL COMMENT 'name of data table column to store values',`label` varchar(1023) default NULL COMMENT 'label to be shown in frontend',`display_label` int(1) NOT NULL default '0' COMMENT '1 means that the label will be displayed',`default_value` varchar(1023) default NULL COMMENT 'default value to be shown for form field',`option_labels` varchar(1023) default NULL COMMENT 'CSV of option labels',`option_values` varchar(1023) default NULL COMMENT 'CSV of option values',`option_class` varchar(1023) default NULL COMMENT 'class implementing external datasource',`help_text` text COMMENT 'help text to be shown for form field',`obligatory` int(1) NOT NULL default '0' COMMENT '1 means that a value is obligatory',`rule` varchar(1023) default NULL COMMENT 'regular expression to validate value',`error_message` varchar(1023) default NULL COMMENT 'error message to be shown for an invalid value',`css_class` varchar(1023) default NULL COMMENT 'CSS classes to be used for field wrapper',PRIMARY KEY  (`idfield`)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='contains meta data of PIFA fields' AUTO_INCREMENT=1 
Mysql Error: Too big column length for column 'label' (max = 255). Use BLOB instead (1074)

Code: Alles auswählen

[21-Aug-2014 10:50:42 Europe/Berlin] PHP Warning:  Database failure: 1062 (Duplicate entry '0' for key 1) - /contenido/main.php?area=system_log&frame=4&contenido=hlchaj4jcdpp84jfrmmvvkiud8dlsiak INSERT INTO `con_system_prop` (`idsystemprop`) VALUES ('')
 in /www/htdocs/.../contenido/includes/functions.general.php on line 1329

Code: Alles auswählen

CREATE TABLE `con_pifa_field` (`idfield` int(10) unsigned NOT NULL auto_increment COMMENT 'unique identifier for a ConForm field',`idform` int(10) unsigned NOT NULL default '0' COMMENT 'foreign key for the ConForm form',`field_rank` int(10) unsigned NOT NULL default '0' COMMENT 'rank of a field in a form',`field_type` int(10) unsigned NOT NULL default '0' COMMENT 'id which defines type of form field',`column_name` varchar(64) NOT NULL COMMENT 'name of data table column to store values',`label` varchar(255) default NULL COMMENT 'label to be shown in frontend',`display_label` int(1) NOT NULL default '0' COMMENT '1 means that the label will be displayed',`default_value` varchar(255) default NULL COMMENT 'default value to be shown for form field',`option_labels` varchar(255) default NULL COMMENT 'CSV of option labels',`option_values` varchar(255) default NULL COMMENT 'CSV of option values',`option_class` varchar(255) default NULL COMMENT 'class implementing external datasource',`help_text` text COMMENT 'help text to be shown for form field',`obligatory` int(1) NOT NULL default '0' COMMENT '1 means that a value is obligatory',`rule` varchar(255) default NULL COMMENT 'regular expression to validate value',`error_message` varchar(255) default NULL COMMENT 'error message to be shown for an invalid value',`css_class` varchar(255) default NULL COMMENT 'CSS classes to be used for field wrapper',PRIMARY KEY  (`idfield`)) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='contains meta data of PIFA fields' AUTO_INCREMENT=1 
Mysql Error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8 COMMENT='contains meta data of PIFA fields (1064)