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