Problem mit dem Datenbank

[Bag and Baggage]

Hallo,
Im Forum habe ich zu dieser Fehlermeldung nicht gefunden

ich habe das Modul: RMA gemäß der Anleitung eingebaut. Es tauchen nun jeweils zwei Fehlermeldungen

• https://www.bagandbaggage.de/rma_step2.php

1146 - Table 'usr_web47_1.TABLE_RMA' doesn't exist

SELECT rma_id, rma_date, rma_status_id FROM TABLE_RMA WHERE customers_id = '2' ORDER BY rma_id DESC

• https://www.bagandbaggage.de/rma_step3.php

1146 - Table 'usr_web47_1.TABLE_RMA_REASON' doesn't exist

SELECT rma_reason_id, rma_reason_name FROM TABLE_RMA_REASON WHERE language_id = '2'

auf. Eine drittes Problem ist, dass die Nachricht aus dem Freifeld, die man einem Kunden eigentlich zuschicken können soll, nicht übertragen wird. Es kommt zwar eine E-Mail an, in dem z.B. die Statusänderung mitgeteilt wird, die Nachricht aus dem Textfeld kommt aber nicht mit.

kann mir hier jemand weiterhelfen?

Vielen Dank im Voraus

[rivendarkness]

Du musst eine Erweiterung Deiner Datenbank durchführen (zusätzliche. neue Tabellen), das hast du scheinbar vergessen

[Bag and Baggage]

ich habe folgende SQL-Befehle aus ausgeführt

rma_id int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
orders_id int(11) NOT NULL default '0',
products_id int(11) NOT NULL default '0',
products_ean varchar(20) default NULL,
reason_id int(11) NOT NULL default '0',
description longtext NOT NULL,
rma_date datetime NOT NULL default '0000-00-00 00:00:00',
pickup smallint(1) default NULL,
shipping_time varchar(10) default NULL,
rma_status_id tinyint(1) NOT NULL default '1',
cost_estimate smallint(1) default NULL,
PRIMARY KEY (rma_id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS rma_comments;
CREATE TABLE rma_comments (
rma_comments_id int(11) NOT NULL auto_increment,
rma_id int(11) NOT NULL default '0',
rma_status_id tinyint(2) NOT NULL default '0',
comments text NOT NULL,
edit_date datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (rma_comments_id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS rma_reason;
CREATE TABLE rma_reason (
rma_reason_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '1',
rma_reason_name varchar(64) NOT NULL default '',
PRIMARY KEY (rma_reason_id,language_id),
KEY idx_rma_reason_name (rma_reason_name)
) TYPE=MyISAM;

INSERT INTO rma_reason VALUES (1, 1, 'Product defectively'), (1, 2, 'Ware defekt'),
(2, 1, 'Wrong delivery'),
(2, 2, 'Falschlieferung');

DROP TABLE IF EXISTS rma_status;
CREATE TABLE rma_status (
rma_status_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '1',
rma_status_name varchar(64) NOT NULL default '',
PRIMARY KEY (rma_status_id,language_id),
KEY idx_rma_status_name (rma_status_name)
) TYPE=MyISAM;

INSERT INTO rma_status VALUES (1, 1, 'Open'),
(1, 2, 'Offen'),
(2, 1, 'In Processing'),
(2, 2, 'In Bearbeitung'),
(3, 1, 'Sent'),
(3, 2, 'Versendet');

ALTER table admin_access add( rma int(1) default '0');
UPDATE admin_access SET rma= '1' where customers_id = 1;

INSERT INTO `configuration` VALUES ('','RMA_CHOOSE_PRODUCTS_OBLIGATION', 'true',
26, 5, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),'), ('','ENTRY_RMA_ERROR_MESSAGE_MIN_LENGTH', '50', 26, 9, NULL, '0000-00-00 00:00:00', NULL, NULL),
('','RMA_PRODUCTS_EAN_OBLIGATION', 'true', 26, 7, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),'),
('','RMA_MODUL_ON', 'true', 26, 1, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),'),
('','RMA_PRODUCTS_EAN_SHOW', 'true', 26, 6, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),'),
('','RMA_ERROR_MESSAGE_SHOW', 'true', 26, 8, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),'),
('','RMA_CHOOSE_REASON_OBLIGATION', 'true', 26, 10, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),'),
('','RMA_PICK_UP_SHOW', 'true', 26, 14, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),'),
('','RMA_COST_ESTIMATE_SHOW', 'true', 26, 16, NULL, '0000-00-00 00:00:00', NULL, 'xtc_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration_group` VALUES (26, 'RMA Einstellungen', 'Einstellungen zum RMA- Modul', 26, 1);

Vielen Dank im Voraus