Requete deffectueuse Insert avec select
Bonjour tout le monde,
Je suis debutant en sql,voila je suis entrain d'installer la contribution separate_price_415
http://www.oscommerce.com/community/...rch,price+list
Il y a une requetes Sql a executer
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
ALTER TABLE customers
ADD customers_group_ra enum('0','1') NOT NULL,
ADD customers_payment_allowed varchar(255) NOT NULL default '',
ADD customers_shipment_allowed varchar(255) NOT NULL default '';
CREATE TABLE customers_groups (
customers_group_id smallint UNSIGNED NOT NULL,
customers_group_name varchar(32) NOT NULL default '',
customers_group_show_tax enum('1','0') NOT NULL,
customers_group_tax_exempt enum('0','1') NOT NULL,
group_payment_allowed varchar(255) NOT NULL default '',
group_shipment_allowed varchar(255) NOT NULL default '',
PRIMARY KEY (customers_group_id)
);
INSERT INTO customers_groups SELECT DISTINCT c.customers_group_id, c.customers_group_name, '1', '0' , '', '' FROM customers c GROUP BY customers_group_id;
ALTER TABLE address_book
ADD entry_company_tax_id VARCHAR(32) DEFAULT NULL AFTER entry_company;
ALTER TABLE specials
ADD customers_group_id smallint UNSIGNED NOT NULL default '0'; |
Le probleme vient de "INSERT INTO customers_groups SELECT DISTINCT c.customers_group_id, c.customers_group_name, '1', '0' , '', '' FROM customers c GROUP BY customers_group_id;"
L'erreur est : #1054 - Unknown column 'c.customers_group_id' in 'field list'
Voila je suis pas un pro de sql si quelqu'un peut m'aider je pense que c'est tout bete.
Je vais continuer a chercher, merci pour vos contributions.:king:
