jeg har installeret dette modul, og det virker egentligt meget godt, problemet med det opstår når jeg skal indsætte feks. administratore, status, priotet og afdelinger, her kan man indsætte de forskelige værdier for disse navne. og når jeg opretter et af de ovenstående så kommer der en blank side frem med følgende tekst:
Fatal error: Call to undefined function: tep_array_merge() in /hsphere/local/home/xxxx/xxxxxxxxxx/admin/support_admin.php on line 38
og i linie 38 og linierne omkring står følgende:
}
$insert_sql_data = array('support_assign_id' => $support_assign_id,
'language_id' => $language_id);
$sql_data_array = tep_array_merge($sql_data_array, $insert_sql_data);
tep_db_perform(TABLE_SUPPORT_ADMINS, $sql_data_array);
} elseif ($HTTP_GET_VARS['action'] == 'save') {
tep_db_perform(TABLE_SUPPORT_ADMINS, $sql_data_array, 'update', "support_assign_id = '" . tep_db_input($support_assign_id) . "' and language_id = '" . $language_id . "'");
}
er der en der kan se hvad der går galt, jeg har uploadet den fil der skulle uploades til databasen, og set at de ligger der via phpmyadmin.
dog skriver min database følgende ved de dataer der blev uploadet:
PRIMARY og INDEX nøgler burde ikke begge være sat for kolonne `support_department_id`
hvad betyder dette?
her er den fil der blev uploadet til databasen:
# MySQL-Front Dump 1.19 beta
#
# Host: localhost Database: osc_bb
#--------------------------------------------------------
# Server version 4.0.0-alpha-nt
#
# Table structure for table '002_news'
#
DROP TABLE /*!32200 IF EXISTS*/ 002_news;
CREATE TABLE /*!32300 IF NOT EXISTS*/ 002_news (
id_news bigint(13) NOT NULL auto_increment,
ueberschrift varchar(250) ,
kurztext longtext ,
autor varchar(100) ,
von date ,
bis date ,
langtext longtext ,
bild varchar(30) ,
weiter enum('Y','N') NOT NULL DEFAULT 'N' ,
PRIMARY KEY (id_news)
);
#
# dumping data fortable configuration
#
INSERT INTO configuration VALUES("","Default Support ticket Status","DEFAULT_SUPPORT_TICKET_STATUS","1","This is the default status assigned to all new support tickets","6",NULL,NULL,"0001-01-01 00:00:00",NULL,NULL);
INSERT INTO configuration VALUES("","Default Support Ticket Priority","DEFAULT_SUPPORT_TICKET_PRIORITY","5","This is the default priority assigned to new supporttickets","6",NULL,NULL,"0001-01-01 00:00:00",NULL,NULL);
INSERT INTO configuration VALUES("","Default support deparmtnet","DEFAULT_SUPPORT_TICKET_DEPARTMENT","2","Default department support tickets are assigned to","6",NULL,NULL,"0001-01-01 00:00:00",NULL,NULL);
INSERT INTO configuration VALUES("","Default Support Administraor","DEFAULT_SUPPORT_ADMIN_ID","4","This is the default supporter assigned to new tickets","6",NULL,NULL,"0001-01-01 00:00:00",NULL,NULL);
INSERT INTO configuration VALUES("","NewsDesk","MAX_DISPLAY_NEWSDESK_NEWS","3","maximum number of items to display in the NewsDesk box","3",NULL,NULL,"2003-02-05 15:16:49",NULL,NULL);
#
# Table structure for table 'faq'
#
DROP TABLE /*!32200 IF EXISTS*/ faq;
CREATE TABLE /*!32300 IF NOT EXISTS*/ faq (
faq_id tinyint(3) unsigned NOT NULL auto_increment,
visible enum('1','0') NOT NULL DEFAULT '1' ,
v_order tinyint(3) unsigned NOT NULL DEFAULT '0' ,
question varchar(128) NOT NULL DEFAULT '' ,
answer text NOT NULL DEFAULT '' ,
date date NOT NULL DEFAULT '0000-00-00' ,
PRIMARY KEY (faq_id)
);
#
# Dumping data for table 'faq'
#
#
# Table structure for table 'support_assign'
#
DROP TABLE /*!32200 IF EXISTS*/ support_assign;
CREATE TABLE /*!32300 IF NOT EXISTS*/ support_assign (
support_assign_id tinyint(3) unsigned NOT NULL auto_increment,
language_id tinyint(3) NOT NULL DEFAULT '0' ,
support_assign_name varchar(64) ,
support_assign_email varchar(90) ,
PRIMARY KEY (support_assign_id,language_id),
INDEX assign_id (support_assign_id)
);
#
# Dumping data for table 'support_assign'
#
INSERT INTO support_assign VALUES("1","1","Administrator","admin@localhost");
INSERT INTO support_assign VALUES("1","3","Admin","admin@localhost");
INSERT INTO support_assign VALUES("1","2","Admin","admin@localhost");
#
# Table structure for table 'support_department'
#
DROP TABLE /*!32200 IF EXISTS*/ support_department;
CREATE TABLE /*!32300 IF NOT EXISTS*/ support_department (
support_department_id tinyint(3) unsigned NOT NULL DEFAULT '0' ,
language_id tinyint(3) unsigned NOT NULL DEFAULT '1' ,
support_department_name varchar(40) ,
PRIMARY KEY (support_department_id,language_id),
INDEX department_id (support_department_id)
);
#
# Dumping data for table 'support_department'
#
INSERT INTO support_department VALUES("2","3","Hosting");
INSERT INTO support_department VALUES("2","2","Hosting");
INSERT INTO support_department VALUES("1","2","billing");
INSERT INTO support_department VALUES("1","3","billing");
INSERT INTO support_department VALUES("2","1","Hosting");
INSERT INTO support_department VALUES("1","1","Billing");
INSERT INTO support_department VALUES("3","1","General");
INSERT INTO support_department VALUES("3","2","General");
INSERT INTO support_department VALUES("3","3","General");
#
# Table structure for table 'support_priority'
#
DROP TABLE /*!32200 IF EXISTS*/ support_priority;
CREATE TABLE /*!32300 IF NOT EXISTS*/ support_priority (
support_priority_id smallint(11) unsigned NOT NULL DEFAULT '0' ,
language_id tinyint(3) unsigned NOT NULL DEFAULT '1' ,
support_priority_name varchar(40) ,
PRIMARY KEY (support_priority_id,language_id),
INDEX priority_id (support_priority_id)
);
#
# Dumping data for table 'support_priority'
#
INSERT INTO support_priority VALUES("1","1","Urgent");
INSERT INTO support_priority VALUES("5","2","Low");
INSERT INTO support_priority VALUES("3","1","Medium");
INSERT INTO support_priority VALUES("4","1","High");
INSERT INTO support_priority VALUES("1","2","Dringend");
INSERT INTO support_priority VALUES("5","1","Low");
INSERT INTO support_priority VALUES("3","2","Mittel");
INSERT INTO support_priority VALUES("4","2","Hoch");
INSERT INTO support_priority VALUES("5","3","Low");
#
# Table structure for table 'support_status'
#
DROP TABLE /*!32200 IF EXISTS*/ support_status;
CREATE TABLE /*!32300 IF NOT EXISTS*/ support_status (
support_status_id tinyint(3) unsigned NOT NULL DEFAULT '0' ,
language_id tinyint(3) unsigned NOT NULL DEFAULT '1' ,
support_status_name varchar(25) ,
PRIMARY KEY (support_status_id,language_id),
INDEX status_id (support_status_id)
);
#
# Dumping data for table 'support_status'
#
INSERT INTO support_status VALUES("2","3","Re-opened");
INSERT INTO support_status VALUES("2","2","Re-opened");
INSERT INTO support_status VALUES("2","1","Re-opened");
INSERT INTO support_status VALUES("1","3","Open");
INSERT INTO support_status VALUES("1","1","Open");
INSERT INTO support_status VALUES("1","2","Open");
#
# Table structure for table 'support_ticket_history'
#
DROP TABLE /*!32200 IF EXISTS*/ support_ticket_history;
CREATE TABLE /*!32300 IF NOT EXISTS*/ support_ticket_history (
support_history_id int(11) NOT NULL auto_increment,
ticket_id int(11) unsigned DEFAULT '0' ,
new_value tinyint(3) unsigned DEFAULT '0' ,
old_value tinyint(3) unsigned DEFAULT '0' ,
date_modified datetime ,
customer_notified tinyint(3) unsigned DEFAULT '0' ,
old_department tinyint(3) unsigned ,
new_department tinyint(3) unsigned ,
old_support tinyint(3) unsigned ,
new_support tinyint(3) unsigned ,
PRIMARY KEY (support_history_id),
INDEX support_history_id (support_history_id)
);
#
# Dumping data for table 'support_ticket_history'
#
#
# Table structure for table 'support_tickets'
#
DROP TABLE /*!32200 IF EXISTS*/ support_tickets;
CREATE TABLE /*!32300 IF NOT EXISTS*/ support_tickets (
ticket_id int(11) NOT NULL auto_increment,
ticket_status tinyint(1) unsigned NOT NULL DEFAULT '1' ,
customers_id int(11) unsigned DEFAULT '0' ,
customers_name varchar(70) DEFAULT '0' ,
customers_email_address varchar(90) DEFAULT '0' ,
customers_company varchar(90) DEFAULT '0' ,
customers_domain varchar(90) DEFAULT '0' ,
ticket_date datetime ,
ticket_comments text ,
department_id tinyint(3) unsigned DEFAULT '0' ,
status_id tinyint(3) unsigned DEFAULT '0' ,
priority_id tinyint(3) unsigned DEFAULT '0' ,
admin_id tinyint(3) unsigned DEFAULT '0' ,
admin_comments text ,
last_modified datetime ,
PRIMARY KEY (ticket_id),
INDEX ticket_id (ticket_id)
);
#
# Dumping data for table 'support_tickets'
#
håber nogen kan hjælpe
