Jump to content

[Résolu] probleme d’installation


Recommended Posts

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.

Link to comment
Share on other sites

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 

Link to comment
Share on other sites

Bonjour,

 

Pour le premier problème,

 

votre version de php devait être trop ancienne (php 4 ?).

En effet, "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" indique que votre interpréteur PHP ne comprend pas le mot clef "static", propre à php5.

 

Bienentendu, nous nous occupons de corriger ce problème dans les plus bref délais afin que le message soit plus clair.

 

Pour le second problème, pouvez-vous me préciser la fin du message d'erreur car elle m'est essentielle pour vous aider.

 

A très bientôt.

Link to comment
Share on other sites

Au sujet du second problème: j'ai le même

 

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(Error: : 1064)

 

Merci.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Bonjour,

 

Nous analysons actuellement les causes du problème, en effet celui-ci n'a pas été détécté malgrés nos nombreux tests d'installations sur differentes plateformes.

 

Il semblerait qu'il soit lié à la découpe des requêtes du fichier SQL. Nous allons bien évidement corriger ce problème en urgence et sortir dès que possible un patch corrigeant ce problème.

Link to comment
Share on other sites

Merci à vous de supporter activement le projet PrestaShop. C'est notamment grâce à toutes vos remarques que le projet progresse !

 

Ce bug est désormais corrigé et sera disponible dans la toute prochaine version (si tous les tests sont concluant, elle sera disponible lundi ou mardi prochain).

 

Pour infos (techniques....), lors de la découpe du fichier SQL en tableau de requêtes SQL, nous avions choisis le mot-clef ";r" comme séparateur (nous développons principalement sous linux), or ce fichier a été édité avec plusieurs outils sous différentes plateformes (mac, linux, windows). Pour rappel, le retour charriot est différent selon les plateformes (voir le sujet très interessant http://www.commentcamarche.net/forum/affich-2944869-php-difference-entre-n-et-r).

 

Une découpe basée sur une expression régulière plus complexe qu'un simple ";r" a résolu le problème.

 

A bientôt, encore merci.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...