musicmaster

You might have a look at the config file of my free script Copy_shopdata: https://www.prestashop.com/forums/topic/445453-copy-shopdata-script-for-copying-shop-content-for-upgrade/ It is really a long list. Going from multi to single store shouldn't be a problem. You should watch out for language id conflicts. And for maintaining passwords it is necessary that you maintain the same keys in the config file. If you get unique key errors you didn't make the transit from 1.6.0 to 1.6.1 the right way. These are just some remarks for inspiration. You can try to use the script. And otherwise you can try posting details of your problems. "Strange results" is a bit vague.

I would love to see this "module" released from its composer encapsulation so that it becomes easier to see how much of the job is done and what still needs attention.

I think the more effort you put in it the better it goes: - adding a feature is basically just one sql line like: INSERT INTO psfeatureproduct SET idproduct='113',idfeature='18',idfeaturevalue='810' - the point is of course that you need to know the numbers. If you have a table that links "black" to feature "18" and feature_value "810" then it is simple. - the thing to watch for is conflicting values. If you try to assign the same color twice or a different color to something that already has a color assigned you will get an error. - with such a table and a bit of php you could achieve what you want.

I will have to think about that. If I have an idea I will let you know.

@foolab said in Prestools - the mass edit toolset: I don't want to do it by a plain sql query because I'm afraid to mess up with the DB... prestools do that with an plain sql query? It would help if you could give a more concrete example. I really don't understand what you with "adding features from a product name search". Features are quite complicated so it will take you some study if you want to do it yourself with sql queries. Of course in the end you always end up with sql queries and if you turn verbose on you can see exactly which ones Prestools uses.

@foolab said in Prestools - the mass edit toolset: is it possible to configure a cronjob that run a specific prestools mass edit? No, that is not possible. Of course Prestools has quite a lot of different functions and it depends what you want to do. But in general it is not possible.

I get "Too many redirects" when I visit your website. Can you publish the error messages and warnings you get and also mention non-standard modules you use?

As far as I can see you have 6 stone colors and 126 clam names. But you have assigned them separately. So you have 6 "combinations" with one stone color attribute and 126 "combinations" with one clan name attribute - resulting in a total of 132 "combinations". What you should have are 6x126=756 combinations that each have both one stone color AND one clan name attribute.

I made in Prestools a function for listing the overrides of a shop. When I researched it I found a wide variety of ways in which modules store their overrides. So Traumflugs method for detecting modules with overrides will detect many of them but certainly not all.

Just wondering: how works the fall through? If you have a Flemish language (nl-be) and it misses some words: will those then be filled in from the Dutch or from the English version?

@Pedalman: there is no project with the name FileOptimizer at SourceForge and your link leads only to its homepage. So it is not clear to me what you mean. ImageMagic works only when you have the PHP module and the program installed. An alternative that works without those conditions would be welcome.

There is nothing in the Apache error log file either.

Nope. Nothing in the error logs either.

Did you empty the cache? I do note that the urls to your images look slightly different than those in a fresh TB installation. In your shop I see: www.pewterjewellery.co.uk/c/en-default-mediumdefault/winged.jpg In a fresh installation I see: www.myshop.com/c/3-categorydefault/koffie-en-thee.jpg So it looks like you made some changes...

If those images don't show up there is likely something with the link. The first thing you might try is disabling pretty urls. Then they should become visible.

I don't understand what you want. If you don't want to show the category image the logical thing would be to adapt the template.

Unzipping can also fail because the PHP zip module isn't loaded.

I made a modification in a query in classes/order/orderInvoice.php. I made some mistake in the process. The result was no error message (despite dev mode on). Instead I got a white page when I tried to generate an invoice or a delivery slip. Predictably it took me much longer to find out what caused this bug then would have happened if there had been an error message. So my questions are: why does this happen? And can this be fixed? BTW. What I did was that I replaced the function getProductsDetail() with the following: public function getProductsDetail() { return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS( (new DbQuery()) ->select('od.*,p.*,ps.*,m.name AS manufacturer') ->from('order_detail', 'od') ->leftJoin('product', 'p', 'p.`id_product` = od.`product_id`') ->leftJoin('product_shop', 'ps', 'ps.id_product = p.id_product AND ps.id_shop = od.id_shop') ->leftJoin('manufacturer', 'm', p.'id_manufacturer` = m.`id_manufacturer`') ->where('od.`id_order` = '.(int) $this->id_order) ->where($this->id && $this->number ? 'od.`id_order_invoice` = '.(int) $this->id : '') ->orderBy('od.`product_name`') ); } So I added a line for the manufacturer but in that line I put the quotes wrong.

It looks like it has something to do with an installation automatically going to PHP 7.2. Probably not a TB problem.

I decided to look at my TB 1.04 shop in an incognito window of my Chrome browser and got the following error: Undefined class constant 'MYSQL_ATTR_USE_BUFFERED_QUERY' at line 73 in file classes/db/DbPDO.php An 1.07 installation seemed to work well but I would prefer not to upgrade. How can I solve this?

As far as I can see they are still here: https://www.prestashop.com/en/previous-versions

Sorry to make a correction. It is the psorderdetail table (or tborderdetail).

@australisagencies said in Catalog totally trashed: Another issue I wsa having was that I was importing database tables from the new installation, but not renaming them properly. I had tables called “tbsicategoryshop” and I was copying them over “tbg8categoryshop”. Are you really deleting categories directly in the database? That is almost impossible to do right. Not only should you delete all the related tables and take care that no orphaned categories remain but you should also set the nleft and nright fields correctly.

If you deleted the Home category then all bets are off. Much of the software assumes there is a home category.

Looking closer it was the product image that caused the 404. Regenerating .htaccess solved that problem. Strange. I never before needed to do that after downloading a shop. One thing that still puzzles me is that those 500 errors often happen when I go from one tab to another within the product-edit page. That puzzles me: I thought that all tabs were loaded at once so that switching between tabs is a matter of hiding and unhiding some html.