Jump to content

justinboncou

Members
  • Posts

    12
  • Joined

  • Last visited

Everything posted by justinboncou

  1. Salut à tous je viens de migrer sur la version final mais le probleme est idem Quelqu'un aurait il corriger ce probleme et m'aider merci d'avance
  2. Salut junnecito j'ai bien fait ce que tu m'as dit mais le probleme est toujours la
  3. Salut a tous J'ai le meme probleme avec les transporteurs, J'ai 3 transporteur avec 3 tranches de poids differents, pourtant mais tranches de prix se chevauche pas: 0 à 5 Kg 6 à 9 kg 10 à 400kg lors d'une commande de client cela lui donne le choix avec les 3 tansporteurs ce que je ne veux pas. aurais je oublié quelquechose svp une iddee j'utilise le rc5
  4. Salut j'ai le meme probleme pourais tu m'expliquer comment tu as fais pour regler ce dilemme. merci d'avance
  5. salut a tous je ne demissionnerais pas car comme je l'ai plus tot reellement prestashop est un bon produit qui me satisfait a tout poin (saut la version 0.9) . j'ai reinstallé l'ancienne version pour le moment . en tout cas merci a vous tous d'etre si réactif
  6. bonsoir lucas voici la fin du message: ( id_product_download INT(10) UNSIGNED NOT NULL auto_increment, id_product INT(10) UNSIGNED NOT NULL, display_filename VARCHAR(255) DEFAULT NULL, physically_filename VARCHAR(255) DEFAULT NULL, date_deposit DATETIME NOT NULL, date_expiration DATETIME DEFAULT NULL, nb_days_accessible int(10) UNSIGNED DEFAULT NULL, nb_downloadable int(10) UNSIGNED DEFAULT 1, PRIMARY KEY (id_product_download) ) DEFAULT CHARSET=utf8;' You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; CREATE TABLE ps_image_type ( id_image_type INTEGER UNSIGNED NOT NULL AUTO_I' at line 8(Erreur : : 1064) et Si je comprend bien c'est ma base de donnée qui ne prend aucune table mais si c'est cela je demissionne Je suis chez OVH et 1&1 et je recontre que des bugs avec la derniere version. Merci a vous pour vos réponses aussi rapide
  7. Merci peter, je rencontre des problemes avec cette nouvelle version aussi chez ovh que chez 1&1 .Je suis en php 5 sur les deux.Je suis bloqué a l'etape 3 et je suis désolé cela va etre long mais voila ce que j'ai d'ecrit: Erreur lors de l'insertion dans la base : 'CREATE TABLE ps_lang ( id_lang INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL, active TINYINT UNSIGNED NOT NULL DEFAULT 0, iso_code CHAR(2) NOT NULL, PRIMARY KEY(id_lang), INDEX lang_iso_code(iso_code) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_image_type ( id_image_type INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(16) NOT NULL, width INTEGER UNSIGNED NOT NULL, height INTEGER UNSIGNED NOT NULL, products BOOL NOT NULL DEFAULT 1, categories BOOL NOT NULL DEFAULT 1, PRIMARY KEY(id_image_type), INDEX image_type_name(name) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_module ( id_module INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(64) NOT NULL, active INTEGER UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY(id_module) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_manufacturer ( id_manufacturer INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(64) NOT NULL, date_add DATETIME NOT NULL, date_upd DATETIME NOT NULL, PRIMARY KEY(id_manufacturer) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_hook ( id_hook INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(64) NOT NULL, title VARCHAR(64) NOT NULL, description TEXT NULL, position BOOL NOT NULL DEFAULT 1, PRIMARY KEY(id_hook), INDEX hook_name(name) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_discount_type ( id_discount_type INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY(id_discount_type) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_currency ( id_currency INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL, iso_code varchar(3) NOT NULL DEFAULT 0, sign VARCHAR(8) NOT NULL, format TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, conversion_rate DECIMAL(10,2) NOT NULL, deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY(id_currency) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_gender ( id_gender INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, iso_code TINYINT(3) UNSIGNED NOT NULL, name VARCHAR(16) NOT NULL, PRIMARY KEY(id_gender) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_feature ( id_feature INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY(id_feature) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_order_state ( id_order_state INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, invoice TINYINT(1) UNSIGNED NULL DEFAULT 0, send_email TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, color VARCHAR(32) NULL, unremovable TINYINT(1) UNSIGNED NOT NULL, PRIMARY KEY(id_order_state) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_tab ( id_tab INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, id_parent INTEGER NOT NULL, class_name VARCHAR(64) NOT NULL, position INTEGER UNSIGNED NOT NULL, PRIMARY KEY(id_tab) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_supplier ( id_supplier INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(64) NOT NULL, date_add DATETIME NOT NULL, date_upd DATETIME NOT NULL, PRIMARY KEY(id_supplier) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_zone ( id_zone INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(64) NOT NULL, active TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, enabled TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, eu_zone TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY(id_zone) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_tax ( id_tax INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, rate FLOAT NOT NULL, PRIMARY KEY(id_tax) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_search ( id_search INTEGER UNSIGNED NOT NULL, keyword VARCHAR(64) NOT NULL, results INTEGER UNSIGNED NOT NULL DEFAULT 0, date DATETIME NOT NULL, PRIMARY KEY(id_search), INDEX search_keyword(keyword) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_quick_access ( id_quick_access INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, link VARCHAR(128) NOT NULL, PRIMARY KEY(id_quick_access) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_profile ( id_profile INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY(id_profile) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_range_weight ( id_range_weight INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, delimiter1 FLOAT NOT NULL DEFAULT 0, delimiter2 FLOAT NOT NULL DEFAULT 0, PRIMARY KEY(id_range_weight), INDEX range_weight_index(delimiter1, delimiter2) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_range_price ( id_range_price INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, delimiter1 FLOAT NOT NULL DEFAULT 0, delimiter2 FLOAT NOT NULL DEFAULT 0, PRIMARY KEY(id_range_price), INDEX range_price_index(delimiter1, delimiter2) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_category ( id_category INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, id_parent INTEGER UNSIGNED NOT NULL, level_depth TINYINT(3) UNSIGNED NOT NULL DEFAULT 0, active TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, date_add DATETIME NOT NULL, date_upd DATETIME NOT NULL, PRIMARY KEY(id_category), INDEX category_parent(id_parent) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_configuration ( id_configuration INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL, value TEXT NULL, date_add DATETIME NOT NULL, date_upd DATETIME NOT NULL, PRIMARY KEY(id_configuration), INDEX configuration_name(name) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_accessory ( id_product_1 INTEGER UNSIGNED NOT NULL, id_product_2 INTEGER UNSIGNED NOT NULL, INDEX accessory_product(id_product_1, id_product_2) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_attribute_group ( id_attribute_group INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY(id_attribute_group) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_carrier ( id_carrier INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(64) NOT NULL, url VARCHAR(255) NULL, active TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, deleted TINYINT UNSIGNED NOT NULL DEFAULT 0, tax INT(10) UNSIGNED NULL DEFAULT 0, PRIMARY KEY(id_carrier) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_contact ( id_contact INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, email VARCHAR(128) NOT NULL, position TINYINT(2) UNSIGNED NOT NULL, PRIMARY KEY(id_contact) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_customer ( id_customer INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, id_gender INTEGER UNSIGNED NOT NULL, email VARCHAR(128) NOT NULL, passwd VARCHAR(32) NOT NULL, birthday DATE NULL, name VARCHAR(32) NOT NULL, newsletter TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, optin TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, surname VARCHAR(32) NOT NULL, active TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, date_add DATETIME NOT NULL, date_upd DATETIME NOT NULL, PRIMARY KEY(id_customer), INDEX customer_login(email, passwd) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_country ( id_country INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, id_zone INTEGER UNSIGNED NOT NULL, iso_code VARCHAR(3) NOT NULL, active TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY(id_country), INDEX country_iso_code(iso_code), INDEX country_(id_zone) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_feature_value ( id_feature_value INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, id_feature INTEGER UNSIGNED NOT NULL, custom TINYINT UNSIGNED NULL, PRIMARY KEY(id_feature_value), INDEX feature(id_feature), INDEX feature_value_FKIndex1(id_feature) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_tag ( id_tag INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, id_lang INTEGER UNSIGNED NOT NULL, name VARCHAR(32) NOT NULL, PRIMARY KEY(id_tag), INDEX tag_name(name) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_employee ( id_employee INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, id_profile INTEGER UNSIGNED NOT NULL, name VARCHAR(32) NOT NULL, surname VARCHAR(32) NOT NULL, email VARCHAR(128) NOT NULL, passwd VARCHAR(32) NOT NULL, active TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY(id_employee), INDEX employee_login(email, passwd), INDEX employee_FKIndex1(id_profile) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_connections ( id_connections INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, id_customer INTEGER UNSIGNED NOT NULL, ip_address VARCHAR(16) NOT NULL, date DATETIME NOT NULL, PRIMARY KEY(id_connections) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_attribute ( id_attribute INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, id_attribute_group INTEGER UNSIGNED NOT NULL, PRIMARY KEY(id_attribute), INDEX attribute_group(id_attribute_group) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_tab_lang ( id_lang INTEGER UNSIGNED NOT NULL, id_tab INTEGER UNSIGNED NOT NULL, name VARCHAR(32) NULL, INDEX tab_lang(id_lang, id_tab), INDEX tab_lang_FKIndex1(id_tab), INDEX tab_lang_FKIndex2(id_lang) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_address ( id_address INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, id_country INTEGER UNSIGNED NOT NULL, id_customer INTEGER UNSIGNED NOT NULL, alias VARCHAR(32) NOT NULL, company VARCHAR(32) NULL, name VARCHAR(32) NOT NULL, surname VARCHAR(32) NOT NULL, address1 VARCHAR(128) NOT NULL, address2 VARCHAR(128) NULL, postcode VARCHAR(12) NULL, city VARCHAR(64) NOT NULL, other TEXT NULL, phone VARCHAR(16) NULL, phone_mobile VARCHAR(16) NULL, date_add DATETIME NOT NULL, date_upd DATETIME NOT NULL, active TINYINT(1) UNSIGNED NOT NULL DEFAULT 1, deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY(id_address), INDEX address_customer(id_customer) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_order_state_lang ( id_order_state INTEGER UNSIGNED NOT NULL, id_lang INTEGER UNSIGNED NOT NULL, name VARCHAR(64) NOT NULL, template VARCHAR(64) NOT NULL, UNIQUE INDEX order_state_lang_index(id_order_state, id_lang) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_attribute_group_lang ( id_attribute_group INTEGER UNSIGNED NOT NULL, id_lang INTEGER UNSIGNED NOT NULL, name VARCHAR(128) NOT NULL, public_name VARCHAR(64) NOT NULL, INDEX attribute_group_lang_index(id_attribute_group, id_lang) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_attribute_lang ( id_attribute INTEGER UNSIGNED NOT NULL, id_lang INTEGER UNSIGNED NOT NULL, name VARCHAR(128) NOT NULL, UNIQUE INDEX attribute_lang_index(id_attribute, id_lang) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_quick_access_lang ( id_quick_access INTEGER UNSIGNED NOT NULL, id_lang INTEGER UNSIGNED NOT NULL, name VARCHAR(32) NOT NULL, PRIMARY KEY(id_quick_access, id_lang), INDEX quick_access_lang_FKIndex1(id_quick_access), INDEX quick_access_lang_FKIndex2(id_lang) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_profile_lang ( id_lang INTEGER UNSIGNED NOT NULL, id_profile INTEGER UNSIGNED NOT NULL, name VARCHAR(128) NOT NULL, INDEX profile_lang_index(id_lang, id_profile), INDEX profile_lang_FKIndex1(id_profile), INDEX profile_lang_FKIndex2(id_lang) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_contact_lang ( id_contact INTEGER UNSIGNED NOT NULL, id_lang INTEGER UNSIGNED NOT NULL, name VARCHAR(32) NOT NULL, description TEXT NULL, UNIQUE INDEX contact_lang_index(id_contact, id_lang) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_carrier_lang ( id_carrier INTEGER UNSIGNED NOT NULL, id_lang INTEGER UNSIGNED NOT NULL, delay VARCHAR(128) NULL, UNIQUE INDEX shipper_lang_index(id_lang, id_carrier) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_feature_value_lang ( id_feature_value INTEGER UNSIGNED NOT NULL, id_lang INTEGER UNSIGNED NOT NULL, value VARCHAR(255) NULL, PRIMARY KEY(id_feature_value, id_lang), INDEX feature_value_lang_FKIndex1(id_feature_value), INDEX feature_value_lang_FKIndex2(id_lang) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_feature_lang ( id_feature INTEGER UNSIGNED NOT NULL, id_lang INTEGER UNSIGNED NOT NULL, name VARCHAR(128) NULL, PRIMARY KEY(id_feature, id_lang), INDEX feature_lang_FKIndex1(id_feature), INDEX feature_lang_FKIndex2(id_lang) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_hook_module ( id_module INTEGER UNSIGNED NOT NULL, id_hook INTEGER UNSIGNED NOT NULL, position TINYINT(2) UNSIGNED NOT NULL, INDEX hook_module_index(id_module, id_hook) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_configuration_lang ( id_configuration INTEGER UNSIGNED NOT NULL, id_lang INTEGER UNSIGNED NOT NULL, value TEXT NULL, date_upd DATETIME NULL, INDEX configuration_lang_index(id_configuration, id_lang) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_discount ( id_discount INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, id_discount_type INTEGER UNSIGNED NOT NULL, id_customer INTEGER UNSIGNED NOT NULL, name VARCHAR(32) NOT NULL, value DECIMAL(10,2) NOT NULL DEFAULT 0, quantity INTEGER UNSIGNED NOT NULL DEFAULT 0, cumulable TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, cumulable_reduction TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, date_from DATETIME NOT NULL, date_to DATETIME NOT NULL, minimal DECIMAL(10,2) NULL, active TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY(id_discount), INDEX discount_name(name), INDEX discount_customer(id_customer) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_access ( id_access INTEGER NOT NULL AUTO_INCREMENT, id_profile INTEGER UNSIGNED NOT NULL, id_tab INTEGER UNSIGNED NOT NULL, view INTEGER NOT NULL, `add` INTEGER NOT NULL, edit INTEGER NOT NULL, `delete` INTEGER NOT NULL, PRIMARY KEY(id_access), INDEX access_profile(id_profile), INDEX access_tab(id_tab), INDEX access_FKIndex1(id_profile), INDEX access_FKIndex2(id_tab) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_discount_type_lang ( id_discount_type INTEGER UNSIGNED NOT NULL, id_lang INTEGER UNSIGNED NOT NULL, name VARCHAR(32) NOT NULL, INDEX discount_type_lang_index(id_discount_type, id_lang), INDEX discount_type_lang_FKIndex1(id_discount_type), INDEX discount_type_lang_FKIndex2(id_lang) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_discount_lang ( id_discount INTEGER UNSIGNED NOT NULL, id_lang INTEGER UNSIGNED NOT NULL, description TEXT NULL, INDEX discount_lang_index(id_discount, id_lang) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_country_lang ( id_country INTEGER UNSIGNED NOT NULL, id_lang INTEGER UNSIGNED NOT NULL, name VARCHAR(64) NOT NULL, UNIQUE INDEX country_lang_index(id_country, id_lang) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_tax_lang ( id_tax INTEGER UNSIGNED NOT NULL, id_lang INTEGER UNSIGNED NOT NULL, name VARCHAR(32) NOT NULL, UNIQUE INDEX tax_lang_index(id_tax, id_lang) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_hook_module_exceptions ( id_hook_module_exceptions INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, id_module INTEGER UNSIGNED NOT NULL, id_hook INTEGER UNSIGNED NOT NULL, file_name VARCHAR(255) NULL, PRIMARY KEY(id_hook_module_exceptions), INDEX hook_module_exceptions_FKIndex1(id_hook), INDEX hook_module_exceptions_FKIndex2(id_module) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_category_lang ( id_category INTEGER UNSIGNED NOT NULL, id_lang INTEGER UNSIGNED NOT NULL, name VARCHAR(128) NOT NULL, description TEXT NULL, link_rewrite VARCHAR(128) NOT NULL, meta_title VARCHAR(128) NULL, meta_keywords VARCHAR(128) NULL, meta_description VARCHAR(128) NULL, UNIQUE INDEX category_lang_index(id_category, id_lang) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_product ( id_product INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, id_supplier INTEGER UNSIGNED NULL, id_manufacturer INTEGER UNSIGNED NULL, id_tax INTEGER UNSIGNED NOT NULL, bargain TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, ean13 VARCHAR(13) NULL, ecotax DECIMAL(10,2) NOT NULL DEFAULT 0, quantity INTEGER UNSIGNED NOT NULL DEFAULT 0, price DECIMAL(10,6) NOT NULL DEFAULT 0, reduction_price DECIMAL(10,2) NULL, reduction_percent FLOAT NULL, reference VARCHAR(32) NULL, weight FLOAT NOT NULL DEFAULT 0, out_of_stock INTEGER UNSIGNED NOT NULL DEFAULT 2, active TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, date_add DATETIME NOT NULL, date_upd DATETIME NOT NULL, PRIMARY KEY(id_product), INDEX product_supplier(id_supplier), INDEX product_manufacturer(id_manufacturer), INDEX product_FKIndex1(id_supplier) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_delivery ( id_delivery INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, id_carrier INTEGER UNSIGNED NOT NULL, id_range_price INTEGER UNSIGNED NULL, id_range_weight INTEGER UNSIGNED NULL, id_zone INTEGER UNSIGNED NOT NULL, price DECIMAL(10,2) NOT NULL, PRIMARY KEY(id_delivery) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_cart ( id_cart INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, id_carrier INTEGER UNSIGNED NOT NULL, id_lang INTEGER UNSIGNED NOT NULL, id_address_delivery INTEGER UNSIGNED NOT NULL, id_address_invoice INTEGER UNSIGNED NOT NULL, id_currency INTEGER UNSIGNED NOT NULL, id_customer INTEGER UNSIGNED NOT NULL, recyclable TINYINT(1) UNSIGNED NOT NULL DEFAULT 1, gift TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, gift_message TEXT NULL, date_add DATETIME NOT NULL, date_upd DATETIME NOT NULL, PRIMARY KEY(id_cart), INDEX cart_customer(id_customer) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_orders ( id_order INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, id_carrier INTEGER UNSIGNED NOT NULL, id_lang INTEGER UNSIGNED NOT NULL, id_customer INTEGER UNSIGNED NOT NULL, id_cart INTEGER UNSIGNED NOT NULL, id_currency INTEGER UNSIGNED NOT NULL, id_address_delivery INTEGER UNSIGNED NOT NULL, id_address_invoice INTEGER UNSIGNED NOT NULL, payment VARCHAR(64) NOT NULL, module VARCHAR(32) NULL, recyclable TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, gift TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, gift_message TEXT NULL, shipping_number VARCHAR(32) NULL, total_discounts DECIMAL(10,2) NOT NULL DEFAULT 0, total_paid DECIMAL(10,2) NOT NULL DEFAULT 0, total_paid_real DECIMAL(10,2) NOT NULL DEFAULT 0, total_products DECIMAL(10,2) NOT NULL DEFAULT 0, total_shipping DECIMAL(10,2) NOT NULL DEFAULT 0, date_add DATETIME NOT NULL, date_upd DATETIME NOT NULL, PRIMARY KEY(id_order), INDEX orders_customer(id_customer) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_image ( id_image INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, id_product INTEGER UNSIGNED NOT NULL, position TINYINT(2) UNSIGNED NOT NULL DEFAULT 0, cover TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY(id_image), INDEX image_product(id_product) ) DEFAULT CHARSET=utf8; CREATE TABLE ps_order_discount ( id_order_discount INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, id_order INTEGER UNSIGNED NOT NULL, name VARCHAR(32) NOT NULL, value DECIMAL(10,2) NOT NULL DEFAULT 0, PRIMARY KEY(id_order_discount), INDEX order_discount_order(id_order) ) DEFAULT CHARSET=utf8; CREATE TABLE
  8. je viens d'installer la v 0.9 sur mon serveur et au moment ou j'apelle la page install voici ce que j'ai: Parse error: parse error, unexpected T_STATIC, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /homepages/xx/xxxxxxxx/htdocs/shop/classes/Tools.php on line 23 quelqu'un aurait une idée merci d'avance.
  9. Merci bruno, probleme reglé c'est de ma faute je n'avais pas donné les bons droits a un sous dossier. Je vais me permettre une deuxieme question si je veux donner un autre nom a mon dossier admin a quelle dossier dois je le stipuler. par contre ja vais essayer de ce pas la 0.9
  10. bonjour bruno, merci pour la rapidité de ta réponse ce qui me dit que j'ai bien raison d'utiliser votre logiciel. Je viens de regarder et les droits sont bien 777 sur tous les dossiers et sous dossiers du repertoir img. Je rectifie: j'avais oublié un sous dossier désolé. Bravo à l'équipe, et un grand merciii
  11. Salut a tous, voila mon probleme, je n'arrive pas a telecharger une image enfin je veux aucune image et pourtant j'ai meme essayé avec une petite image et idem toujours le meme probleme. je suis chez ovh et j'utilise la derniere version de prestashop. Voila ce que cela me dit : 2 erreurs une erreur s'est produite pendant le redimensionnement de l'image une erreur s'est produite pendant la mise à jour product Quelqu'un aurait une solution merci à vous
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More