Ich habe mich entschlossen mal den News Artikel Manager aus dem amerikanischen Zen Cart im Test Shop zu installieren und zu testen.
ich habe versucht des sql befehl wie folgt zu ändern aber leider bekomme ich es nicht hin:
der fehler im phpmyadmin ist folgender:
vielen dank
ich habe versucht des sql befehl wie folgt zu ändern aber leider bekomme ich es nicht hin:
PHP-Code:
# Configuration
INSERT INTO configuration_group VALUES ('', '43', 'News & Articles Management', 'The options which configure News & Articles Management', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
INSERT INTO configuration VALUES ('', '43', 'Display News Summary', 'DISPLAY_NEWS_SUMMARY', 'true', 'Display the news summary on the main index page (part of the optional install)?', last_insert_id(), '0', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
('', '43', 'News Summary Cutoff Days', 'DISPLAY_NEWS_SUMMARY_DAYS', '7', 'Only display the news summary if there was news in the past xx days', last_insert_id(), '1', NULL, now(), NULL, NULL),
('', '43', 'News Summary Length', 'DISPLAY_NEWS_SUMMARY_LENGTH', '300', 'If no news summary is present for the article being displayed by the summary module, truncate the main article content to no more than this number of characters (will truncate at the nearest whole word)', last_insert_id(), '2', NULL, now(), NULL, NULL),
('', '43', 'Comments Require Customer Login', 'NEWS_COMMENTS_REQUIRE_CUSTOMER', 'false', 'Require a user to be logged in to post comments on news articles?', last_insert_id(), '3', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
('', '43', 'Comments Name Min Length', 'ENTRY_NEWS_NAME_MIN_LENGTH', '3', 'Minimum length for the name input of news comments', last_insert_id(), '4', NULL, now(), NULL, NULL),
('', '43', 'Comments Text Min Length', 'ENTRY_NEWS_COMMENTS_MIN_LENGTH', '25', 'Minimum length for the comments text input of news comments', last_insert_id(), '5', NULL, now(), NULL, NULL),
('', '43', 'Email Admin Comments Notice', 'NEWS_COMMENTS_EMAIL_ADMIN_NOTICE', 'true', 'Email a notification to the store admin when comments are posted?', last_insert_id(), '6', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
('', '43', 'News RSS Feed Days', 'NEWS_RSS_FEED_NUMBER_OF_DAYS', '7', 'The RSS feed will only contain news from the past xx news days', last_insert_id(), '7', NULL, now(), NULL, NULL);
# Table structure for table news_articles
DROP TABLE IF EXISTS news_articles;
CREATE TABLE news_articles (
article_id int(11) NOT NULL auto_increment,
authors_id int(11) NOT NULL default '0',
news_image varchar(64) default NULL,
news_image_two varchar(64) default NULL,
news_date_added datetime NOT NULL default '0000-00-00 00:00:00',
news_last_modified datetime default NULL,
news_date_published datetime default NULL,
news_status tinyint(1) NOT NULL default '0',
sort_order tinyint(6) NOT NULL default '0',
PRIMARY KEY (article_id),
KEY (news_date_published)
) TYPE=MyISAM;
# Table structure for table news_articles_text
DROP TABLE IF EXISTS news_articles_text;
CREATE TABLE news_articles_text (
article_id int(11) NOT NULL auto_increment,
language_id int(11) NOT NULL default '1',
news_article_name varchar(64) NOT NULL default '',
news_article_text text,
news_article_shorttext text,
news_article_url varchar(255) default NULL,
news_article_url_text varchar(64) default NULL,
news_article_url_2 varchar(255) default NULL,
news_article_url_2_text varchar(64) default NULL,
news_article_url_3 varchar(255) default NULL,
news_article_url_3_text varchar(64) default NULL,
news_article_url_4 varchar(255) default NULL,
news_article_url_4_text varchar(64) default NULL,
news_article_url_store int(11) default NULL,
news_article_url_store_2 int(11) default NULL,
news_article_url_store_misc varchar(255) default NULL,
news_article_url_store_misc_text varchar(64) default NULL,
news_article_url_store_misc_2 varchar(255) default NULL,
news_article_url_store_misc_2_text varchar(64) default NULL,
news_image_text text,
news_image_text_two text,
PRIMARY KEY (article_id,language_id),
KEY (news_article_name)
) TYPE=MyISAM;
# Table structure for table news_authors
DROP TABLE IF EXISTS news_authors;
CREATE TABLE news_authors (
authors_id int(11) NOT NULL auto_increment,
author_name varchar(64) default NULL,
author_email varchar(96) default NULL,
status int(1) NOT NULL default '1',
PRIMARY KEY (authors_id)
) TYPE=MyISAM;
# Dumping data for table news_authors
INSERT INTO news_authors VALUES (1, 'Administrator', 'admin@localhost.com', 1);
# Table structure for table news_comments
DROP TABLE IF EXISTS news_comments;
CREATE TABLE news_comments (
comments_id int(11) NOT NULL auto_increment,
article_id int(11) NOT NULL default '0',
customers_id int(11) default NULL,
customers_name varchar(64) NOT NULL default '',
date_added datetime default NULL,
last_modified datetime default NULL,
approved tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (comments_id)
) TYPE=MyISAM;
# Table structure for table news_comments_description
DROP TABLE IF EXISTS news_comments_description;
CREATE TABLE news_comments_description (
comments_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '0',
comments_subject varchar(64) default NULL,
comments_text text NOT NULL,
PRIMARY KEY (comments_id,language_id)
) TYPE=MyISAM;
PHP-Code:
SQL-Befehl:
INSERT INTO configuration
VALUES (
'', '43', 'Display News Summary', 'DISPLAY_NEWS_SUMMARY', 'true', 'Display the news summary on the main index page (part of the optional install)?', LAST_INSERT_ID( ) , '0', NULL , NOW( ) , NULL , 'zen_cfg_select_option(array("true", "false"),'
), (
'', '43', 'News Summary Cutoff Days', 'DISPLAY_NEWS_SUMMARY_DAYS', '7', 'Only display the news summary if there was news in the past xx days', LAST_INSERT_ID( ) , '1', NULL , NOW( ) , NULL , NULL
), (
'', '43', 'News Summary Length', 'DISPLAY_NEWS_SUMMARY_LENGTH', '300', 'If no news summary is present for the article being displayed by the summary module, truncate the main article content to no more than this number of characters (will truncate at the nearest whole word)', LAST_INSERT_ID( ) , '2', NULL , NOW( ) , NULL , NULL
), (
'', '43', 'Comments Require Customer Login', 'NEWS_COMMENTS_REQUIRE_CUSTOMER', 'false', 'Require a user to be logged in to post comments on news articles?', LAST_INSERT_ID( ) , '3', NULL , NOW( ) , NULL , 'zen_cfg_select_option(array("true", "false"),'
), (
'', '43', 'Comments Name Min Length', 'ENTRY_NEWS_NAME_MIN_LENGTH', '3', 'Minimum length for the name input of news comments', LAST_INSERT_ID( ) , '4', NULL , NOW( ) , NULL , NULL
), (
'', '43', 'Comments Text Min Length', 'ENTRY_NEWS_COMMENTS_MIN_LENGTH', '25', 'Minimum length for the comments text input of news comments', LAST_INSERT_ID( ) , '5', NULL , NOW( ) , NULL , NULL
), (
'', '43', 'Email Admin Comments Notice', 'NEWS_COMMENTS_EMAIL_ADMIN_NOTICE', 'true', 'Email a notification to the store admin when comments are posted?', LAST_INSERT_ID( ) , '6', NULL , NOW( ) , NULL , 'zen_cfg_select_option(array("true", "false"),'
), (
'', '43', 'News RSS Feed Days', 'NEWS_RSS_FEED_NUMBER_OF_DAYS', '7', 'The RSS feed will only contain news from the past xx news days', LAST_INSERT_ID( ) , '7', NULL , NOW( ) , NULL , NULL
)
MySQL meldet:
#1136 - Column count doesn't match value count at row 1
Kommentar