Eberg

Anyone who maybe has a solution? I'm willing to pay for a good export.

Hey Gabdara, the thing is the website was hacked and the provider put the website offline until all malware was cleaned. This happend when i was on vacation, otherwise i would just have put back a backup, but wen i got back from vacation the oldest backup was already of a infected website, so it was worthless to me. I cleaned a lot of files, but since I mainly work with Wordpress + WC I'm not sure of all files. The websites works again now, but I cant login.. Thats why I thought exporting the database would be the fasted option. the website is Binocrea.com.

Hello, for a friend of my i'm trying to export his old prestashop website that has not been updates since i think 2013. I have used a number of SQL queries, but I keep having a few problems and my knowledge my Mysql is not big, so i hope somebody can help. If I use the following query I get all usefull info except the category is a number and all info is a bit messed up i think. For example most ID's are shown twice with different other column info. Every time one has a description and the other is empty. (see image) SELECT p.id_product AS 'ID', p.active AS 'Active (0/1)', pl.name AS 'Name', p.id_category_default AS 'Default Category', p.price AS 'Price tax excl.', p.id_tax_rules_group AS 'Tax rules ID', p.wholesale_price AS 'Wholesale price', p.on_sale AS 'On sale (0/1)', p.reference AS 'Reference #', p.supplier_reference AS 'Supplier reference #', sl.description AS 'Supplier', ml.description AS 'Manufacturer', p.ean13 AS 'EAN13', p.upc AS 'UPC', p.ecotax AS 'Ecotax', p.weight AS 'Weight', p.quantity AS 'Quantity', pl.description_short AS 'Short description', pl.description AS 'Description', pl.meta_title AS 'Meta-title', pl.meta_keywords AS 'Meta-keywords', pl.meta_description AS 'Meta-description', pl.link_rewrite AS 'URL rewritten', pl.available_now AS 'Text when in stock', pl.available_later AS 'Text when backorder allowed', p.available_for_order AS 'Available for order', p.date_add AS 'Product creation date', p.show_price AS 'Show price', p.online_only AS 'Available online only', p.condition AS 'Condition' FROM ps_product p INNER JOIN ps_product_lang pl ON p.id_product = pl.id_product LEFT JOIN ps_supplier_lang sl ON p.id_supplier = sl.id_supplier LEFT JOIN ps_manufacturer_lang ml ON p.id_manufacturer = ml.id_manufacturer If I use the query below I get better results only the short description and description is missing for all the normal products, strange thing is that the example products do get exported.see image below and the query SELECT p.id_product, p.active, pl.name, GROUP_CONCAT(DISTINCT(cl.name) SEPARATOR ",") as categories, p.price, p.id_tax_rules_group, p.wholesale_price, p.reference, p.supplier_reference, p.id_supplier, p.id_manufacturer, p.upc, p.ecotax, p.weight, p.quantity, pl.description_short, pl.description, pl.meta_title, pl.meta_keywords, pl.meta_description, pl.link_rewrite, pl.available_now, pl.available_later, p.available_for_order, p.date_add, p.show_price, p.online_only, p.condition, p.id_shop_default FROM ps_product p LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product) LEFT JOIN ps_category_product cp ON (p.id_product = cp.id_product) LEFT JOIN ps_category_lang cl ON (cp.id_category = cl.id_category) LEFT JOIN ps_category c ON (cp.id_category = c.id_category) LEFT JOIN ps_product_tag pt ON (p.id_product = pt.id_product) WHERE pl.id_lang = 1 AND cl.id_lang = 1 AND p.id_shop_default = 1 AND c.id_shop_default = 1 GROUP BY p.id_product Hope someone can help