Search the Community

Hello guys , Hope you all doing good. im working on prestashop 1.7.8.5 and i added a module that override Category Class and CategoryController and i made some changes and evrythink work correctly . the problem is in /home/var/tmp folder .mad files are generated with big sizes and in some cases (not all the time) they are not autodeled wiche is the normal case in mysql so i run into diskspace problem . any ideas please ?

Estoy intentando realizar una consulta a la base de datos de PrestaShop (versión 1.5.6.2) para exportar los productos incluyendo las características de este, pero no conozco mucho SQL/MySQL y al intervenir tantas tablas se me está haciendo un poco complejo.. Aunque la consulta es exclusiva según las características de cada tienda, supongo que es un caso común el usar características de productos pensando en que al almacenarse en campos independientes en la base de datos posteriormente se pueden consultar/exportar de forma automática, por lo que entiendo que esta consulta/duda no es nueva, pero por más que busco no doy con la solución.. Si alguien sabría un ejemplo de consulta tipo que poder modificar/adaptar sería muy interesante para necesidades como la mía. Si no a unas malas, cuando la consiga sacar os la paso por aquí Saludos cordiales y gracias!

nleft and nright values for new categories are 0 . They are not getting updated. the new categories that i create are not visible in the front office in the screenshit you will be able to see the last 4 categories have 0 nleft and nright values .htaccess file has not been changes images for other categories not visible in top horizontal menu rest all categories work fine these new categories are set to be enabled obviously i want to regenerate the category tree---prestashop is not doing it automatically for me

Bonsoir, Après N tentatives pour modifier ma liste de liens, je me suis résolu à "réinitialiser" ce module, mal m'en a pris, le module a alors disparu ! Qu'a cela ne tienne, il me suffisait de le réinstaller depuis le catalogue de module. Là encore, malgré un message de succès, le module n'est pas toujours tout pas disponible dans ma liste de modules. Le module ps_linklist se réinstalle pourtant bien dans le répertoire des modules, mais je n'en vois toutefois pas trace dans ma table ps_tab, ou ps_module (où il devrait être référencé (?)). Quelqu'un aurait t'il une idée pour résoudre ce problème ? Effacer toutes les traces du module et le réinstaller ? quelles sont ls tables impactées par ce module ?, il ya t'il d'autres éléments indispensables ? autres que le diossier module et ces tables ? Merci de votre aide PS 1.7.8.5 Theme classic Pas de modules tiers.

Hello, I'd like to install prestashop using a remote mysql database, hosted by Amazon AWS RDS. I'm at the 5th step of the install assistant, where I need to add the database credentials. I've filled all the inputs, but I still get an error saying the credentials aren't right: Impossible to connect to the database server. Check your login credentials (DbPDO) Just to be sure, I tried to connect to the database using a MySQL client and using the Command Line Interface. It worked with both, so the credentials should be right. Here is what I'm writing (some letters were changed of course): address of the database server: prestadbrds.cdwmpettorfzt.us-east-1.rds.amazonaws.com Name of the database: prestadbrds Username of the database: prestadbusername Password of the databse: XXXXXX prefix of the tables: ps_ And when I click on testing, I get the same error message. Has anyone ever managed to use an AWS RDS database with Prestashop ? Thanks for your help Matthias

Hi, In my prestashop backoffice I had set the all products prices as tax_incl and for that products tax_incl is coming. Now I have to change my pricing to specific pricing but in specific pricing I can see only an option like tax_excl price to enter, Because of that the tax is calculating and I want to know how it can be made to tax_incl. Can anyone please help on this?

Hola a todos, Estoy intentando instalar prestashop, y todo va bien hasta que llega a la parte de instalación de módulos Addons. Se queda pensando hasta que me sale el siguiente error: " Se ha producido un error durante la instalación... Puede utilizar los enlaces que se encuentran en la columna de la izquierda para volver a los pasos anteriores, o también reiniciar el proceso de instalación haciendo clic aquí. 1: An exception occurred while executing 'SELECT t0.id_tab AS id_tab_1, t0.id_parent AS id_parent_2, t0.position AS position_3, t0.module AS module_4, t0.class_name AS class_name_5, t0.route_name AS route_name_6, t0.active AS active_7, t0.enabled AS enabled_8, t0.hide_host_mode AS hide_host_mode_9, t0.icon AS icon_10 FROM ps_tab t0 WHERE t0.class_name = ? LIMIT 1' with params ["AdminGamification"]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away " He buscado soluciones pero no encuentro ninguna para mi caso. Podría alguien ayudarme a solucionarlo?? Gracias, un saludo

When i go to the new url: http://calcemi.com it redirects in some way to localhost/prestashop. I think it is not a server error but somethinh on the prestashop files, i looked the db from top to bottom and i don't see any configuration beside the one which mentions the prestashop migrating tutorial (already modified). I migrated my prestashop (v1.7.1.2) from localhost/prestashop/ to my new VPS and did all the steps to migrate the prestashop on this post https://www.prestashop.com/en/blog/how-to-migrate-prestashop-to-a-new-server including the database modifications.

Hello, I'm trying to use the SQL Manager to list user details (first/last name, email and their country) but i would like the query to only return a certain amount of users. But when i include the LIMIT clause, i get this error message : "The LIMIT clause must contain numeric arguments" This is what my query looks like : SELECT firstname, lastname, email, FROM ps_customer LIMIT 150 Any help is welcome

Bonjour à tous, Je suis un peu désespéré car j'ai mon site Prestashop qui ne fonctionne plus du tout. Quand je vais sur l'URL, rien ne s'affiche et impossible d'accéder à l'administration. J'ai regardé au niveau de l'hébergement et j'ai cru comprendre que cela venait de la base de données qui était saturée (200mo). Il me semble avoir compris qu'il s'agissait de certaines tables qui étaient particulièrement volumineuses alors j'ai "empty" celles qui étaient les plus volumineuses - liées au trafic apparemment - mais rien ne change ! J'ai accès au ftp et il me semble que cela peut être réglé via le fichier .htaccess mais je ne sais pas exactement quoi faire. Merci infiniment par avance si vous pouvez m'aider à trouver une solution à mon problème car ça fini par me déprimer je dois avouer... Bien à vous et vous souhaitant une bonne journée.

Hello everyone, I am looking to develop a Prestashop connector (version 1.7) to integrate e-commerce with different ERP's like SAP Business One and Ekon due to my need to have my users, orders, products, categories and so on synchronized in both directions. I am a software developer mainly in Python. I would like to know recommendations, or even find an expert developer for this job and not waste so much time with that.

Hi, I want to delete some categories from my Prestashop 1.6 backoffice. Nothing is happening on deletion. When I enable the debug mode from defines.inc.php, then I got below error: PHP Fatal error: Uncaught You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 1' at line 4<br /><br /><pre> SELECT m.* FROM `ps_module` m JOIN `ps_module_shop` ms ON (m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1) WHERE m.`id_module` = LIMIT 1</pre> thrown in C:\xampp\htdocs\abcxyz\classes\db\Db.php on line 791 Can someone help me to resolve this?

Hello, I am doing a type of sales report through a mysql query. The objective is to create a line for each product (with its corresponding attribute) within a purchase order. With my current query I am able to bring some information, but it is not right. For example, I get multiples for a purchase order, the products are listed but these are repeated by their attributes, and not all the products of the order come out. The mysql query is as follows. Thanks to who can hel me to solve this issue. select distinctrow o.date_add, o.reference, c.firstname, c.lastname, pa.city, ppl.name, GROUP_CONCAT(DISTINCT(pal.name) SEPARATOR ", ") AS combinations, carrier.name, o.payment, p.price ,o.total_discounts, o.valid from ps_orders as o join ps_customer as c on o.id_customer = c.id_customer join ps_cart as cart on cart.id_cart = o.id_cart join ps_cart_product as cartProduct on o.id_cart = cartProduct.id_cart join ps_product as p on cartProduct.id_product = p.id_product join ps_product_lang ppl on ppl.id_product = cartProduct.id_product join ps_address pa on c.id_customer = pa.id_customer join ps_carrier carrier on cart.id_carrier = carrier.id_carrier join ps_product_attribute prodatt on prodatt.id_product = cartProduct.id_product join ps_product_attribute_combination ppac on prodatt.id_product_attribute = ppac.id_product_attribute join ps_attribute a on ppac.id_attribute = a.id_attribute join ps_attribute_lang pal on a.id_attribute = pal.id_attribute join ps_order_detail pod on o.id_order = pod.id_order where pod.id_order = o.id_order GROUP BY ppac.id_product_attribute

Hello , I have Prestashop 1.7.5 one VPS with 6GB ram and 100 GB of hard disk. I have a big problem with the performance of the web site . I have a lot of query as this this one :Creating sort index | SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2020-07-05 00:00:00", INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `pr_category_product` cp LEFT JOIN `pr_product` p ON p.`id_product` = cp.`id_product` INNER JOIN pr_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `pr_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN pr_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `pr_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 2 AND cl.id_shop = 1 ) LEFT JOIN `pr_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2 AND pl.id_shop = 1 ) LEFT JOIN `pr_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `pr_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2) LEFT JOIN `pr_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 1306 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC LIMIT 0,9 | 0.000 | And server is busy and a lot of time I have a timeout error How I can fix it ? Thanks Luca

Witam Mam problem z PrestaShop w wersji 1.6.1.24 – po wejściu w Panel administracyjny nie mogę wejść w zakładki Moduły i Usługi oraz w zakładkę Pozycje i Płatności. Po włączeniu raportowania błędów lub trybu debugowania przez PresteShop z czego dowiedziałem się z tego forum… dostaje takie komunikaty o błędach: „Warning in line 551 in the file /home/hbriijom/public_html/shop/classes/controller/AdminController.php [2] count(): Parameter must be an array or an object that implements Countable Unknown error in line 75 in the file /home/hbriijom/public_html/shop/tools/smarty/sysplugins/smarty_internal_compilebase.php [8192] The each() function is deprecated. This message will be suppressed on further calls Warning in line 3274 in the file /home/hbriijom/public_html/shop/classes/controller/AdminController.php [2] count(): Parameter must be an array or an object that implements Countable Unknown error in line 198 in the file /home/hbriijom/public_html/shop/classes/helper/HelperList.php [8192] Function create_function() is deprecated.” Podsyłam screeny jako załączniki odnośnie błedów jakie mi wyskakują. Prosiłbym o pomoc w rozwiązaniu problemu….

I have Prestashop v1.6; it's a long-running site with no major problems. I have made no changes recently, no alterations in modules or back office settings, but today I have lost access to the back office. Instead, I have an error page: MySQL Server has gone away. Then: UPDATE `xx_configuration` SET `value` = '1508599399',`date_upd` = '2017-10-21 16:24:25' WHERE `name` = 'PRESTO_CHANGEO_UC' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) LIMIT 1 Then follows a list of more specific errors. These seem to relate to the Presto Changeo module for CategoryQuantityDiscount (which I use on the site, successfully until now). I'm now having problems regaining Back Office and need some advice. I've tried so far: Checked database size - this is well within permitted requirements by the ISP, rather than being too large. When I attempt to access the back office, the page takes a long time to try to load then times out (I presume) with the error message. I found an old reference to the _UC note in the error that indicates it is something to do with time. One suggestion was to delete cache/class_index.php; I did, it replaced itself but made no difference. The module appears under Modules and also Modules in the Theme. Disabling both by renaming them produces no difference in loading Back Office, but the website itself (which otherwise works) then fails to load correctly Renaming the main Modules folder of course causes a total error for the website loading, but the Back Office now loads (empty of everything but the heading etc, but it does now load) php settings are quite high for timeouts (10000, memory limit 256M) and have worked for many months So I feel stuck. If it is this module (which I don't understand enough about code and stuff to mean that I am correct in what I am trying to do)< as opposed to some other module or group of modules, I cannot solve things by deleting it alone. I'm unsure if the cache is involved - but I'm unclear what I can delete within this (must I keep all the folders, or can I delete every file in the cache and also the theme/cache?). And even in my notes, I'm unsure what to rely on as being a correct thing to have tried. Help please?

Hi All, Greetings of the day. The module helps to integrate Database Management Tool Adminer in back-office. This helps to run SQL queries, database backups, perform various jobs such as SELECT/INSERT/UPDATE/DELETE database tables and columns in tables. Also, get information and search data in different tables and databases. It is a fully­ functional database administration panel available many databases. It works with very huge/big database size in GB for example 4 GB database. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement. Features ­ Create, drop and alter tables ­ Delete, edit and add fields as well as manage keys on fields ­ Execute any SQL statement ­ Query your databases ­ Manage privileges ­ Export data into various formats ­ Back up and restore your databases ­ Connect to a database server with username and password ­ Select an existing database or create a new one ­ List fields, indexes, foreign keys and triggers of table ­ Change name, engine, collation, auto_increment, and comment of table ­ Alter name, type, collation, comment and default values of columns ­ Add and drop tables and columns ­ Create, alter, drop and search by indexes including full-text ­ Create, alter, drop and link lists by foreign keys ­ Create, alter, drop and select from views ­ Create, alter, drop and call stored procedures and functions ­ Create, alter and drop triggers ­ List data in tables with search, aggregate, sort and limit results ­ Insert new records, update and delete the existing ones ­ Supports all data types, blobs through file transfer ­ Execute any SQL command from a text field or a file ­ Export table structure, data, views, routines, databases to SQL or CSV ­ Print database schema connected by foreign keys ­ Show processes and kill them ­ Display users and rights and change them ­ Display variables with links to documentation ­ Manage events and table partitions (MySQL 5.1) ­ Schemas, sequences, user types (PostgreSQL) ­ Easy to install and use. ­ Nice graphical user interface to perform various database operations on multiple databases. ­ Security using login and password screen. ­ Cross-platform works on all windows and Linux distributions. ­ Help you interact with your MySQL database easily and effortlessly. ­ Web-Based which means you can access from any computer ­ Local resources aren't used when connecting ­ Simplicity. Compatible with PrestaShop 1.6.x,1.7.x,8.x.x Benefits to Merchants ­ It has a user­ friendly and intuitive user interface with a little learning curve, meaning that people can use and get used to the functions easily and quickly. ­ It allows users to perform most of the MySQL functions, including managing databases, running MySQL queries, executing SQL statements, managing users and permissions, and many more. ­ It can import data and export data from and to different formats. ­ It is able to alter the stored data into any other formats with the help of predefined functions.­ Installation Step 1: Upload module zip file from the back-office Module & Services menu tab. Module Manager area using the upload button. After the successful installation module menu, the link will appear in the left menu or top menu in back-office more area. Step 2: Install the module using the install button. Step 3: Visit module management page from the back-office "More" area (section) in the left menu in the back-office. Step 4: The module installation process is very easy, how module configuration works can be seen in a demo instance. Step 5: Please visit our demo instance for module configuration and usage demo. Step 6: Please watch our demo video on our YouTube Channel for module configuration and usage demo. - Module works without making any change in the existing PrestaShop file so that existing customization and theme change do not affect. - We provide free technical and feature support in installation, configuration, as well as access to updates available for this product. - Free support on installation, configuration, and customization as per store requirements, for example, new hook addition on your store. Other : Please leave your valuable feedback after using the module on this post. This will help to increase self-confidence, improve service, and enhancements the module as per requirements to make it better for different online stores. Our Website URL => https://www.presta-addons-modules.com/en/ Pay any amount as per your choice to get the multi-languages,multi-shops, and multi-shop-groups feature in the free addon Download Module and Documentation File. sfkdbmanage.zip readme_en.pdf

Hola muy buenas, es mi primer tema que escribo y la verdad que no se si lo estoy haciendo bien. Llevo mucho tiempo leyendo vuestras preguntas y respuesta y la verdad que de no saber nada de nada he aprendido mucho de ustedes. Mil gracias. Mi intención RS que a ver mi alguien puede ayudarme a importar un XML a prestas hoy 1.7.2.4. He logrado importar todos los productos perfectamente pero sin imágenes. Solo he conseguido escribir en las tres tablas referentes a dichas imágenes pero no las consigo emparejar con los productos ya que no se como guardarlas en su carpeta correspondiente. El script que estoy intentando hacer funcionar es este. <?php //incluimos funciones simples de imagen //include('config/config.inc.php'); //include('images.inc.php'); //include('classes/controller/AdminController.php'); //include('config/config.inc.php'); //include('controllers/admin/AdminImportController'); //include('controllers/admin/AdminImagesController.php'); //include('SimpleImage.php'); // archivo del import (.xml) $context = stream_context_create(array('https' => array('header' => 'Accept: text/html, application/xhtml+xml,image/jpeg,application/xml;q=0.9, */*;q=0.8'))); $url = 'https://dreamlove.gesio.be/dyndata/exportaciones/csvzip/catalog_1_50_8_0_f2f9102e37db89d71346b15cbc75e8ce_xml_plain.xml'; $xml = file_get_contents($url, false, $context); $xml = simplexml_load_string($xml,null,LIBXML_NOCDATA); //datos de nuestra base de datos $username = "*************"; $password = "*************"; $hostname = "localhost"; //Conexión con la base de datos $dbhandle = mysql_connect($hostname, $username, $password) or die("No se ha podido conectar"); echo "Conectado a MySQL<br><br> "; $selected = mysql_select_db("meycalco_presta", $dbhandle) or die("No se ha podido conectar a Prueba1"); echo "Conectado a Prueba1<br><br> "; //Primero recogemos el valor del % por ciento de la base de datos $incremento_precio = 0; //declaramos la variable que guardara el valor del incremento $sql_increase = "SELECT `value`"; $sql_increase .= " FROM `ps_configuration`"; $sql_increase .= " WHERE `name` "; $sql_increase .= "LIKE 'PS_INCREASE_PRICE'"; //Ejecutamos la sentencia $result = mysql_query($sql_increase) or die("No se ha ejecutado la sentencia select PS_INCREASE_PRICE"); while ($row = mysql_fetch_array($result)) { $incremento_precio = $row{'value'}; } echo "El incremento del precio es " . $incremento_precio . "% "; //funcion para comprobar si la categoria ya existe en la base de datos function comprobarCategoriaExistente($categoria) { //Comprobar si existe categoria $sql = "SELECT * FROM `ps_category_lang` WHERE `name` LIKE '" . $categoria . "'"; $result = mysql_query($sql) or die("No se ha ejecturado la sentencia comprobarCategoriaExistente"); $id_categoria = mysql_num_rows($result); while ($row = mysql_fetch_array($result)) { //Recogemos el id de la categoria $id_categoria = $row{'id_category'}; } echo "El resultado de la busqueda comprobarCategoriaExistente es " . $id_categoria . " "; return $id_categoria; } //funcion para comprobar si el producto ya existe en la base de datos function comprobarExisteProducto($id_articulo) { //comprobamos que el producto existe en el sistema o no $sql = "SELECT * FROM `ps_product` WHERE `reference` LIKE '" . $id_articulo . "'"; $result = mysql_query($sql) or die("No se ha ejecturado la sentencia comprobarExisteProducto"); $id_articulo = mysql_num_rows($result); while ($row = mysql_fetch_array($result)) { //Recogemos el id del producto en la bd $id_articulo = $row{'id_product'}; } echo "El resultado de la busqueda comprobarExisteProducto es " . $id_articulo . " "; return $id_articulo; } //funcion para comprobar si la marca ya existe en la base de datos function comprobarMarcaExistente($marca) { //miramos si existe su marca $sql = "SELECT * FROM `ps_manufacturer` WHERE `name` LIKE '" . $marca . "'"; $result = mysql_query($sql) or die("No se ha ejecturado la sentencia comprobarMarcaExistente"); $id_fabricante = mysql_num_rows($result); while ($row = mysql_fetch_array($result)) { //Recogemos el id de la marca en la bd $id_fabricante = $row{'id_manufacturer'}; } echo "El resultado de la busqueda comprobarMarcaExistente es " . $id_fabricante . " "; return $id_fabricante; } //Creamos una función para cambiar permisos de archivos //funcion para canviar permisos function recursiveChmod($path, $filePerm = 0775, $dirPerm = 0775) { // Check if the path exists if (!file_exists($path)) { //echo "No existe el directorio"; return (false); } // See whether this is a file if (is_file($path)) { // Chmod the file with our given filepermissions chmod($path, $filePerm); // If this is a directory... } elseif (is_dir($path)) { // Then get an array of the contents $foldersAndFiles = scandir($path); // Remove "." and ".." from the list $entries = array_slice($foldersAndFiles, 2); // Parse every result... foreach ($entries as $entry) { // And call this function again recursively, with the same permissions recursiveChmod($path . "/" . $entry, $filePerm, $dirPerm); } // When we are done with the contents of the directory, we chmod the directory itself chmod($path, $dirPerm); } // Everything seemed to work out well, return true return (true); } //funcion que genera y coloca en el directorio correspondiente //los diferentes tamaños de imagen que usa prestashop function save_image($url_image,$id_image) { $array_id_image = str_split($id_image); $num_digits = strlen($id_image); $cadena_url_mod = NULL; for($img= 0;$img>load("".$path . $filename . "." .$img_ext.""); ); $image->resizeToWidth(98,98); $image->save("".$path . $filename . "-small_default." .$img_ext.""); $image2 = new SimpleImage(); $image2->load("".$path . $filename . "." .$img_ext.""); $image2->resizeToWidth(213,120); $image2->save("".$path . $filename . "-home_alysum." .$img_ext.""); $image3 = new SimpleImage(); $image3->load("".$path . $filename . "." .$img_ext.""); $image3->resizeToWidth(124); $image3->save("".$path . $filename . "-home_default." .$img_ext.""); $image4 = new SimpleImage(); $image4->load("".$path . $filename . "." .$img_ext.""); $image4->resizeToWidth(310); $image4->save("".$path . $filename . "-large_alysum." .$img_ext.""); $image5 = new SimpleImage(); $image5->load("".$path . $filename . "." .$img_ext.""); $image5->resizeToWidth(264); $image5->save("".$path . $filename . "-large_default." .$img_ext.""); $image6 = new SimpleImage(); $image6->load("".$path . $filename . "." .$img_ext.""); $image6->resizeToWidth(104); $image6->save("".$path . $filename . "-medium_alysum." .$img_ext.""); $image7 = new SimpleImage(); $image7->load("".$path . $filename . "." .$img_ext.""); $image7->resizeToWidth(58); $image7->save("".$path . $filename . "-medium_default." .$img_ext.""); $image8 = new SimpleImage(); $image8->load("".$path . $filename . "." .$img_ext.""); $image8->resizeToWidth(45); $image8->save("".$path . $filename . "-small_alysum." .$img_ext.""); $image9 = new SimpleImage(); $image9->load("".$path . $filename . "." .$img_ext.""); $image9->resizeToWidth(600); $image9->save("".$path . $filename . "-thickbox_alysum." .$img_ext.""); $image10 = new SimpleImage(); $image10->load("".$path . $filename . "." .$img_ext.""); $image10->resizeToWidth(600); $image10->save("".$path . $filename . "-thickbox_default." .$img_ext.""); chmod($ruta, 0775); $valor_permisos = recursiveChmod ($path, $filePerm=0755, $dirPerm=0775); echo "Se han dado todos los permisos? ".$valor_permisos; return filesize($filex); } //visitamos todos los nodos foreach($xml->product as $product){ $id_articulo = ($product->public_id); $ean = ($product->barcodes->barcode); $categoriaxml = (explode("|",$product->categories->category)); $nombre = mysql_real_escape_string($product->title); $marca = mysql_real_escape_string($product->brand); $descripcion = mysql_real_escape_string($product->html_description); $descripcion_corta = mysql_real_escape_string($product->description); $precio =mysql_real_escape_string($product->price); $precio_tarifa =mysql_real_escape_string($product->cost_price); $stock = mysql_real_escape_string($product->available); $stock_disponible = mysql_real_escape_string($product->stock->location); $img = ($product->images->image); $categoria = utf8_decode($categoriaxml[0]); $subcategoria = utf8_decode($categoriaxml[1]); $subsubcategoria = utf8_decode($categoriaxml[2]); $image = ($img[0]); $image2 = ($img[1]); $image3 = ($img[2]); $image4 = ($img[3]); $image5 = ($img[4]); $image6 = ($img[5]); $image7 = ($img[6]); $image8 = ($img[7]); $image8 = ($img[8]); $image9 = ($img[9]); echo " **** ####Acabado el cargado del articulo<br><br>"; $follow = TRUE; if ($follow) { // Aqui empieza todo el trabajo echo "La subcategoria es<br><br>" . $subcategoria; echo "La categoria es<br><br>" . $categoria; $id_articulo_bd = comprobarExisteProducto($id_articulo); $id_marca = comprobarMarcaExistente($marca); if (!$id_articulo_bd) { echo "El producto no existe en la base de datos "; //si la marca no existe la creamos if (!$id_marca) { //Insertamos la marca en la tabla ps_manufacturer $sql = "INSERT INTO `meycalco_presta`.`ps_manufacturer` (`id_manufacturer` ,`name` ,`date_add` ,`date_upd` ,`active`)"; $sql .= " VALUES (NULL , '" . $marca . "', '" . date("Y-m-d H:i:s") . "', '" . date("Y-m-d H:i:s") . "', '1');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro insertado en ps_manufacturer con exito "; } //Debemos de comprobar el id que acabamos de crear $id_marca = comprobarMarcaExistente($marca); //Insertamos la marca en la tabla ps_manufacturer_lang $sql = "INSERT INTO `meycalco_presta`.`ps_manufacturer_lang` (`id_manufacturer` ,`id_lang`)"; $sql .= " VALUES ('" . $id_marca . "' , '3');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro insertado en ps_manufacturer_lang con exito "; } //Insertamos la marca en la tabla ps_manufacturer_shop $sql = "INSERT INTO `meycalco_presta`.`ps_manufacturer_shop` (`id_manufacturer` ,`id_shop`)"; $sql .= " VALUES ('" . $id_marca . "' , '1');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro insertado en ps_manufacturer_shop con exito "; } } //Aqui empiezan las comprobaciones de las categorias $id_categoria = comprobarCategoriaExistente($categoria); if (!$id_categoria) { echo "La categoria no existe"; $categoria = str_replace("Dreamlovevalentineday", "San Valentin", $categoria); $categoria = str_replace("/", "y", $categoria); $sql = "INSERT INTO `meycalco_presta`.`ps_category` (`id_category` ,`id_parent` ,`id_shop_default`,`level_depth`,`date_add` ,`date_upd` ,`active`,`is_root_category`)"; $sql .= " VALUES (NULL , '2','1','3','" . date("Y-m-d H:i:s") . "', '" . date("Y-m-d H:i:s") . "', '1', '0');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); //Debemos de comprobar el id que acabamos de crear $id_categoria = mysql_insert_id(); $state = true; if ($state) { echo "Registro de categoria insertado en ps_category con exito "; } //Insertamos la categoria en la tabla ps_category_group $sql = "INSERT INTO `meycalco_presta`.`ps_category_group` (`id_category` ,`id_group`)"; $sql .= " VALUES ('" . $id_categoria . "' , '1');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro de categoria de grupo insertado en ps_category_group con exito "; } //Insertamos la categoria en la tabla ps_category_group $sql = "INSERT INTO `meycalco_presta`.`ps_category_group` (`id_category` ,`id_group`)"; $sql .= " VALUES ('" . $id_categoria . "' , '2');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro 2 de categoria de grupo insertado en ps_category_group con exito "; } //Insertamos la categoria en la tabla ps_category_group $sql = "INSERT INTO `meycalco_presta`.`ps_category_group` (`id_category` ,`id_group`)"; $sql .= " VALUES ('" . $id_categoria . "' , '3');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro 3 de categoria de grupo insertado en ps_category_group con exito "; } //Insertamos la categoria en la tabla ps_category_lang $url_categoria = strtolower($categoria); $url_categoria = str_replace(" ", "-", $url_categoria); $sql = "INSERT INTO `meycalco_presta`.`ps_category_lang` (`id_category` ,`id_shop`,`id_lang` ,`name`,`link_rewrite`)"; $sql .= " VALUES ('" . $id_categoria . "' , '1','3','" . $categoria . "','" . $url_categoria . "');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro de categoria insertado en ps_category_lang con exito "; } //Insertamos la categoria en la tabla ps_category_shop $url_categoria = strtolower($categoria); $url_categoria = str_replace(" ", "-", $url_categoria); $sql = "INSERT INTO `meycalco_presta`.`ps_category_shop` (`id_category` ,`id_shop`)"; $sql .= " VALUES ('" . $id_categoria . "' , '1');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro de categoria insertado en ps_category_shop con exito "; } } //Comprobar si existe la subcategoria y si no crearla, similar al proceso anterior $id_categoria = comprobarCategoriaExistente($categoria); $id_subcategoria = comprobarCategoriaExistente($subcategoria); if ($id_subcategoria > 0) { echo "Hay subcategoria"; $id_subcategoria = comprobarCategoriaExistente($subcategoria); } if ((!$id_subcategoria) && (!empty($subcategoria))) { echo "La subcategoria no existe"; $sql = "INSERT INTO `meycalco_presta`.`ps_category` (`id_category` ,`id_parent` ,`id_shop_default`,`level_depth`,`date_add` ,`date_upd` ,`active`,`is_root_category`)"; $sql .= " VALUES (NULL , '" . $id_categoria . "','1','3','" . date("Y-m-d H:i:s") . "', '" . date("Y-m-d H:i:s") . "', '1', '0');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); //Debemos de comprobar el id que acabamos de crear $id_categoria = mysql_insert_id(); $state = true; if ($state) { echo "Registro de subcategoria insertado en ps_category con exito "; } //Insertamos la categoria en la tabla ps_category_group $sql = "INSERT INTO `meycalco_presta`.`ps_category_group` (`id_category` ,`id_group`)"; $sql .= " VALUES ('" . $id_categoria . "' , '1');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro de subcategoria de grupo insertado en ps_category_group con exito "; } //Insertamos la categoria en la tabla ps_category_group $sql = "INSERT INTO `meycalco_presta`.`ps_category_group` (`id_category` ,`id_group`)"; $sql .= " VALUES ('" . $id_categoria . "' , '2');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro 2 de subcategoria de grupo insertado en ps_category_group con exito "; } //Insertamos la categoria en la tabla ps_category_group $sql = "INSERT INTO `meycalco_presta`.`ps_category_group` (`id_category` ,`id_group`)"; $sql .= " VALUES ('" . $id_categoria . "' , '3');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro 3 de subcategoria de grupo insertado en ps_category_group con exito "; } //Insertamos la categoria en la tabla ps_category_lang $url_subcategoria = strtolower($subcategoria); $url_subcategoria = str_replace(" ", "-", $url_subcategoria); $sql = "INSERT INTO `meycalco_presta`.`ps_category_lang` (`id_category` ,`id_shop`,`id_lang` ,`name`,`link_rewrite`)"; $sql .= " VALUES ('" . $id_categoria . "' , '1','3','" . $subcategoria . "','" . $url_subcategoria . "');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro de subcategoria insertado en ps_category_lang con exito "; } //Insertamos la categoria en la tabla ps_category_shop $url_categoria = strtolower($categoria); $url_categoria = str_replace(" ", "-", $url_categoria); $sql = "INSERT INTO `meycalco_presta`.`ps_category_shop` (`id_category` ,`id_shop`)"; $sql .= " VALUES ('" . $id_categoria . "' , '1');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro de subcategoria insertado en ps_category_shop con exito "; $id_subcategoria = comprobarCategoriaExistente($subcategoria); } } if (empty($subcategoria)) { echo "No hay subcategoria"; $id_subcategoria = comprobarCategoriaExistente($categoria); } } //Comprobar si existe la subcategoria y si no crearla, similar al proceso anterior $id_subcategoria = comprobarCategoriaExistente($subcategoria); $id_subsubcategoria = comprobarCategoriaExistente($subsubcategoria); if ($id_subsubcategoria > 0) { echo "Hay subcategoria"; $id_subsubcategoria = comprobarCategoriaExistente($subsubcategoria); } if ((!$id_subsubcategoria) && (!empty($subsubcategoria))) { echo "La subcategoria no existe"; $sql = "INSERT INTO `meycalco_presta`.`ps_category` (`id_category` ,`id_parent` ,`id_shop_default`,`level_depth`,`date_add` ,`date_upd` ,`active`,`is_root_category`)"; $sql .= " VALUES (NULL , '" . $id_subcategoria . "','1','3','" . date("Y-m-d H:i:s") . "', '" . date("Y-m-d H:i:s") . "', '1', '0');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); //Debemos de comprobar el id que acabamos de crear $id_subcategoria = mysql_insert_id(); $state = true; if ($state) { echo "Registro de subcategoria insertado en ps_category con exito "; } //Insertamos la categoria en la tabla ps_category_group $sql = "INSERT INTO `meycalco_presta`.`ps_category_group` (`id_category` ,`id_group`)"; $sql .= " VALUES ('" . $id_subcategoria . "' , '1');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro de subcategoria de grupo insertado en ps_category_group con exito "; } //Insertamos la categoria en la tabla ps_category_group $sql = "INSERT INTO `meycalco_presta`.`ps_category_group` (`id_category` ,`id_group`)"; $sql .= " VALUES ('" . $id_subcategoria . "' , '2');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro 2 de subcategoria de grupo insertado en ps_category_group con exito "; } //Insertamos la categoria en la tabla ps_category_group $sql = "INSERT INTO `meycalco_presta`.`ps_category_group` (`id_category` ,`id_group`)"; $sql .= " VALUES ('" . $id_subcategoria . "' , '3');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro 3 de subcategoria de grupo insertado en ps_category_group con exito "; } //Insertamos la categoria en la tabla ps_category_lang $url_subsubcategoria = strtolower($subsubcategoria); $url_subsubcategoria = str_replace(" ", "-", $url_subsubcategoria); $sql = "INSERT INTO `meycalco_presta`.`ps_category_lang` (`id_category` ,`id_shop`,`id_lang` ,`name`,`link_rewrite`)"; $sql .= " VALUES ('" . $id_subcategoria . "' , '1','3','" . $subsubcategoria . "','" . $url_subsubcategoria . "');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro de subcategoria insertado en ps_category_lang con exito "; } //Insertamos la categoria en la tabla ps_category_shop $url_subcategoria = strtolower($subcategoria); $url_subcategoria = str_replace(" ", "-", $url_subcategoria); $sql = "INSERT INTO `meycalco_presta`.`ps_category_shop` (`id_category` ,`id_shop`)"; $sql .= " VALUES ('" . $id_subcategoria . "' , '1');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro de subcategoria insertado en ps_category_shop con exito "; $id_subsubcategoria = comprobarCategoriaExistente($subsubcategoria); } } if (empty($subsubcategoria)) { echo "No hay subcategoria"; $id_subsubcategoria = comprobarCategoriaExistente($subcategoria); } } if (!$id_articulo_bd) { //definimos las variables del stock if ($stock == '1') { $visibilidad_producto = 1; $disponibilidad = "Disponble"; $total_stock = $stock_disponible; } else { $visibilidad_producto = 0; $disponibilidad = "No disponible"; $total_stock = 0; } echo " Vamos a crear el producto en la base de datos<br><br> "; echo "El producto no existe "; $sql = "INSERT INTO `meycalco_presta`.`ps_product` (`id_product` ,`id_supplier` ,`id_manufacturer`,`id_category_default`,`id_shop_default`,`id_tax_rules_group`,`on_sale`,`minimal_quantity`,`ean13`,`price`,`wholesale_price`,`reference`,`out_of_stock`,`available_for_order`,`condition`,`visibility`,`show_price`,`indexed`,`date_add` ,`date_upd` ,`active`)"; $sql .= " VALUES (NULL , '0','" . $id_marca . "','" . $id_subcategoria . "','1','1','0','1','" . $ean . "','" . $precio . "','" . $precio_tarifa . "','" . $id_articulo . "','2','" . $visibilidad_producto . "','new','both','1','1','" . date("Y-m-d H:i:s") . "', '" . date("Y-m-d H:i:s") . "', '1');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); //Debemos de comprobar el id que acabamos de crear $id_articulo_creado = mysql_insert_id(); $state = true; if ($state) { echo "Registro de producto insertado en ps_product con exito<br><br> "; } $url_producto_alias = strtolower($nombre); $url_producto_alias = str_replace(" ", "-", $url_producto_alias); $sql = "INSERT INTO `meycalco_presta`.`ps_product_lang` (`id_product` ,`id_shop`,`id_lang` ,`description`,`link_rewrite`,`name`,`available_now`)"; $sql .= " VALUES ('" . $id_articulo_creado . "' , '1','3','" . $descripcion . "','" . $url_producto_alias . "','" . $nombre . "','" . $disponibilidad . "');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro de producto insertado en ps_product_lang con exito<br><br> "; } //Aquí actualizamos el stock $sql = "INSERT INTO `meycalco_presta`.`ps_stock_available` (`id_stock_available`,`id_product` ,`id_product_attribute` ,`id_shop` ,`id_shop_group` ,`quantity` ,`depends_on_stock` ,`out_of_stock`)"; $sql .= " VALUES (NULL ,'" . $id_articulo_creado . "', '0','1','0','" . $total_stock . "','0','2');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro de producto insertado en ps_stock_available con exito<br><br> "; } echo "El id de la categoria es " . $id_subcategoria; $sql = "INSERT INTO `meycalco_presta`.`ps_product_shop` (`id_product`,`id_category_default`,`id_shop`,`id_tax_rules_group`,`on_sale`,`price`,`wholesale_price`,`available_for_order`,`condition`,`visibility`,`show_price`,`indexed`,`active`,`date_add` ,`date_upd` )"; $sql .= " VALUES ('" . $id_articulo_creado . "','" . $id_subcategoria . "','1','1','0','" . $precio . "','" . $precio_tarifa . "','1','new','" . $visibilidad_producto . "','1','1','1','" . date("Y-m-d H:i:s") . "', '" . date("Y-m-d H:i:s") . "');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); //Debemos de comprobar el id que acabamos de crear $state = true; if ($state) { echo "Registro de producto insertado en ps_product_shop con exito<br><br> "; } for($positionimg=0;$positionimg<10;$positionimg++){ if(!empty($image[$positionimg])){ //Primero recogemos la imagen del producto $url_image=$imagen[$positionimg]; if($positionimg==0){ $cover=1; }else{ $cover=0; } //Ahora se crean las imagenes del producto $sql = "INSERT INTO `meycalco_presta`.`ps_image` (`id_image`,`id_product` ,`position` ,`cover`)"; $sql .= " VALUES (NULL ,'".$id_articulo_creado."', '".($img+1)."','1');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; $id_foto_creado = mysql_insert_id(); if ($state) { echo "Registro de producto insertado en ps_image con exito<br><br> "; //save_img($url, $id_foto_creado);<- aquí es donde supongo que tiene que llamar a la función que guarda las imagenes } $sql = "INSERT INTO `meycalco_presta`.`ps_image_lang` (`id_image`,`id_lang`)"; $sql .= " VALUES ('".$id_foto_creado."' ,'3');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro de producto insertado en ps_image_lang con exito<br><br> "; } $sql = "INSERT INTO `meycalco_presta`.`ps_image_shop` (`id_product` ,`id_image`,`id_shop`,`cover`)"; $sql .= " VALUES ('".$id_articulo_creado."', '".$id_foto_creado."' ,'1','1');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro de producto insertado en ps_image_shop con exito<br><br><br> "; } } } $sql = "INSERT INTO `meycalco_presta`.`ps_category_product` (`id_category`,`id_product`)"; $sql .= " VALUES ('" . $id_subcategoria . "' ,'" . $id_articulo_creado . "');"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Registro de producto insertado en ps_category_product con exito<br><br> "; } } //si el articulo ya existia en la bd actualizamos disponibilidad, precio y stock if ($id_articulo_bd) { echo "El producto si que existe<br><br> "; //Si el producto ya existe comprobaremos el stock y el precio y modificaremos lo necesario if ($stock == '1') { $visibilidad_producto = 1; $disponibilidad = "Disponible"; $total_stock = $stock_disponible; } else { $visibilidad_producto = 0; $disponibilidad = "No Disponible"; $total_stock = $stock_disponible ; } $sql = "UPDATE `meycalco_presta`.`ps_product` SET `price` = '" . $precio . "', `wholesale_price` = '" . $precio_tarifa . "',`available_for_order` = '" . $visibilidad_producto . "',`show_price` = '1' WHERE `id_product` ='" . $id_articulo_bd . "'"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Actualizacion de producto en ps_product realizada<br><br> "; } $sql = "UPDATE `meycalco_presta`.`ps_stock_available` SET `quantity` = '" . $total_stock . "' WHERE `id_product` ='" . $id_articulo_bd . "'"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Actualizacion de producto en ps_stock_available realizada<br><br> "; } $sql = "UPDATE `meycalco_presta`.`ps_product_shop` SET `price` = '" . $precio . "',`wholesale_price` = '" . $precio_tarifa . "',`visibility` = '" . $visibilidad_producto . "',`show_price` = '1' WHERE `id_product` ='" . $id_articulo_bd . "'"; $res = mysql_query($sql, $dbhandle) or die(mysql_error()); $state = true; if ($state) { echo "Actualizacion de producto en ps_product_shop realizada<br><br> "; } } } //función para arreglar el arbol de categorias de prestashop /** * Re-calculate the values of all branches of the nested tree */ function regenerateEntireNtree() { $sql = ' SELECT c.`id_category`, c.`id_parent` FROM `ps_category` c LEFT JOIN `ps_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 1) ORDER BY c.`id_parent`, cs.`position` ASC'; $result = mysql_query($sql) or die("No se ha ejecturado la sentencia comprobarCategoriaExistente"); $categories = mysql_num_rows($result); $categories_array = array(); while ($category = mysql_fetch_array($result)) { //foreach ($categories as $category){ $categories_array[$category['id_parent']]['subcategories'][] = $category['id_category']; echo "loading $categories_array <br> "; } echo "var_dump <br> "; var_dump($categories_array); $n = 1; if (isset($categories_array[0]) && $categories_array[0]['subcategories']) { _subTree($categories_array, $categories_array[0]['subcategories'][0], $n); } return (TRUE); } //funcion recursiva de regenerateEntireNtree() function _subTree(&$categories, $id_category, &$n) { echo $n . " "; $left = $n++; if (isset($categories[(int) $id_category]['subcategories'])) { echo "we are here <br> "; foreach ($categories[(int) $id_category]['subcategories'] as $id_subcategory) { _subTree($categories, (int) $id_subcategory, $n); } echo "end foreach<br> "; } $right = (int) $n++; echo "UPDATE cat " . $id_category . " left " . $left . " right " . $right . "<br> "; $sql = ' UPDATE `meycalco_presta`.`ps_category` SET `nleft` = ' . (int) $left . ' , `nright` = ' . (int) $right . ' WHERE `id_category` = ' . (int) $id_category . ' '; echo $sql . "<br> "; $res = mysql_query($sql) or die(mysql_error() . "die you biatch"); return (TRUE); } //arreglamos inconsistencias en la tabla categorias de prestashop echo "regenerate tree<br>"; regenerateEntireNtree(); En primer lugar tengo unís includes que he ido probando pero como no llego a ese nivel pues no he conseguido nada. Lo.mismo sol.los archivos correctos pero......jajajaja He hecho una modificación al original ya que no funcionaba y he conseguido importar por lo menos los artículos sin fotos aunque las tablas referentes a las imágenes si que están escritas con sus id solo escribe una ya que como les he dicho no se nada o casi nada de PHP y MySQL no se como he conseguido hacer esto. Si alguien lo quiere probar solo cambiarle el nombre a los fatos de la conexión y en las consultas a la base de datos cambiar los prefijos si son diferentes a los de prestashop. Si alguien pudiera echarme una mano o por lo menos decirme cual es la función simeimage.PHP que no la encuentro en ningún directorio de prestashop y por otro lado donde esta la función que guarda las imágenes en su correspondiente carpeta. Supongo que donde llama a save_img en mi scrip es cuando tiene que guardarla pero.... Muchas gracias a todos por su atención y Disculpadme si no he escrito con mucha claridad. A ver si entre todos podemos hacer funcionar este script ya que hay gente como yo que no tenemos 180 euros para un modulo aunque no digo que en un futuro haiga que comprarlo. Muchas gracias Saludos

Bonjour, Suite à un message d'OVH me signalant que je devais faire évoluer ma version de PHP qui était en 5.6, je décide, sans connaissances sur le sujet, de passer à la 7.1, compatible avec Prestashop 1.6... A partir de là, plusieurs dysfonctionnements sont apparus sur le site : plus d'accès, puis plus d'accès aux modules... Je suis revenu en version 5.6, j'ai restauré une version antérieure mais ensuite j'ai un peu paniqué et je ne sais pas revenir à une version stable. Comme le problème semblait être une impossibilité d'écrire pour les modules, je suis allé modifier les attributs avec Filezilla pour mettre les permissions de tous les dossiers à 775 et les fichiers à 664. Maintenant, j'aurais besoin d'aide car ma boutique ne peut plus prendre de commandes et ce n'est pas la bonne période. Help

Bonjour, J'ai remarque en moins de 2 semaines la taille de mon mysql a dépasse plus de 18 Go. AU même moment le phpmyadmin m'affiche 7Go. pourquoi cette différence? comment résoudre ce probleme? merci

Ich würde gerne die Anzahl der Einträge in die ps_guest begrenzen, ohne alternativ die Statistik-Module zu deaktivieren oder die gesamte Tabelle leeren zu müssen. Gibt es eine Anweisung/Befehl in phpMyAdmin, eine bestimmte Anzahl von Einträgen beim Erreichen einer (definierten) Obergrenze automatisch zu löschen? Noch eleganter wäre es, wenn dies nur diejenigen Einträge betreffen würde, deren customer-ID 0 ist.

I have my own server, with 26 Gb RAM dual Xeon and what it will be a small bakery site and some small sites (WP). Not really significant traffic, but I want to be as fast as possible in serving the pages. Many info I've read are for previous versions of Prestashop, I have the newst version (1.7.6.4) I run on the server CentOS 7.7 Server software version: Apache 2.4.6 PHP version: 7.3.16 Memory limit: 512M Max execution time: 300 Upload Max File size: 128M info_outline Database information MySQL version: 5.7.29-32 PERCONA (INNODB) MySQL server: localhost MySQL engine: InnoDB MySQL driver: DbPDO I've installed Opcache and PHP 7.3 and configured like in the tutorials. I've also installed php-pecl-apcu module (caching) php.ini [Date] date.timezone = UTC [Session] session.auto_start = Off [PHP] short_open_tag = Off display_errors = Off magic_quotes_gpc = off memory_limit = 512M max_execution_time = 300 max_input_time = 300 upload_max_filesize = 20M post_max_size = 22M max_input_vars = 20000 allow_url_fopen = on opcache.ini opcache.revalidate_freq=0 ;opcache.validate_timestamps=0 - still developing, not production opcache.enable_file_override=1 opcache.interned_strings_buffer=64 opcache.memory_consumption=256 opcache.max_accelerated_files=20000 Quick questions: 1. Smarty cache: yes/no 2. If YES -> Caching type: File system or MySQL (Percona) 3. Use cache (CacheApc): yes/no (remember, I have OPCache) 4. Do I still need to visit each page of the site in order to create cache (script based on sitemap.xml)? 5. Should I also add this to my Percona SQL server? edit /etc/my.cnf end add: query_cache_limit = 128K query_cache_size = 32M query_cache_type = ON Other important settings are: table_open_cache = 1000 read_buffer_size = 2M read_rnd_buffer_size = 1M thread_cache_size = 80 join_buffer_size = 2M sort_buffer_size = 2M max_connections = 400 tmp_table_size = 32M max_heap_table_size = 32M table_definition_cache = 1000 performance_schema = OFF innodb_buffer_pool_size = 10G # (adjust value here, 50%-70% of total RAM) innodb_log_file_size = 256M innodb_flush_log_at_trx_commit = 1 # may change to 2 or 0 innodb_flush_method = O_DIRECT Thank you!

Hi I wanted to upgrade one of the client sites manually from 1.6,0,5, May I know what is the best version of PrestaShop 1.6 that is no need to change on database can run smoothly in PHP 1.6 and MySql 5.6.45.? Also i've been looking for prestashop release notes for this versions its already 404 on this site. Thank you all. ML

Bonjour, Je ne suis pas développeur mais je gère un site ecommerce. Depuis quelque temps, les clients ne peuvent plus s'inscrire ou passer commande. En inspectant la base de données, la table client ("customers" dans MySQL) affiche le message suivant : #1286 - unknown Storage storage engine" Impossible d'accéder ou modifier la table. Je fais appel à l'hébergeur qui regarder, mais leur réponse est : "Fichier corrompue depuis plusieurs mois.... impossible à récupérer... sauvegarde du site seulement de 7 jours". De plus, l'hébergeur a supprimer la table "customers". Toujours au point mort concernant les clients. Quelles sont les options ? Dois-je re-créer une table "customers" ? Dupliquer le site ? Repartir avec une installation vierge ? Faut-il également passer aux dernières versions PHP et MySQL (actuellement 5.6) ? > En pièce jointes, captures utiles des informations et alertes du site.

Bonjour, Depuis quelque temps, les clients ne peuvent plus s'inscrire ou passer commande. En inspectant la base de données, la table client ("customers" dans MySQL) affiche le message suivant : #1286 - unknown Storage storage engine" Impossible d'accéder ou modifier la table. Je fais appel à l'hébergeur qui regarder, mais leur réponse est : "Fichier corrompue depuis plusieurs mois.... impossible à récupérer... sauvegarde du site seulement de 7 jours". De plus, l'hébergeur a supprimer la table "customers". Toujours au point mort concernant les clients. Quelles sont les options ? Dois-je re-créer une table "customers" ? Dupliquer le site ? Repartir avec une installation vierge ? Faut-il également passer aux dernières versions PHP et MySQL (actuellement 5.6) ? > En pièce jointes, captures utiles des informations et alertes du site.