musicmaster

I uploaded a new version. Zip files is somehow an imperfect technology that keeps giving problems.

Did you try what happens when you set quantities with Prestools?

This is starting to sound like you have a problem with the naming that leads to confusion.

Don't worry. You don't have any character set/collation problem. utf8mb4 is just preferred for Thirty Bees. There is no obligation. Anyone who has migrated from Prestashop has an utf8 variant. Prestashop only switched to utf8mb4 with 1.7.6 or 1.7.7. That latin_swedish collation isn't a problem either. Some modules that have their own tables make them in the format that they prefer. And that is ok.

The Alter Table command tells me that two records have been added to this table. But I don't see those added records in your list. The "wrong/swapped" issue is only becoming fuzzier to me. What is the problem? Do you have wrong values for quantities or are they only swapped between variants?

I don't see anything suspicious that could explain anything. But I am puzzled by the tags, the initially empty redirect field in the ps_product_shop table and by the Alter Table command. It looks like more is happening than you tell. That "wrong/swapped" is a kind of fuzzy language that doesn't help.

Thank you for your report. I fixed it.

A trick that might help is comparing database exports. - Export a shop database. - change a quantity in the backoffice - export the database again - compare the two exports with a program like Winmerge. - now do the same when changing a quantity in Store Manager

I don't have time to research this myself. But it shouldn't be that difficult if you are prepared to get dirty hands in Phpmyadmin: - in the first post of this thread you mention a product that shows 1799 stock while it is not in the settings. So do a database search for any field in any table with the content "1799". - stock is in many tables: ps_product, ps_product_shop and ps_stock_available. Only the last should count. But in cases like this it might be that things get mixed up. So you should check for that. - with profiling you can see the database queries that were made. That can provide leads were things go wrong.

On closer look I saw that it is the module psseobooster that contains a call to mysql_error(). What happened was that there was some kind of error in this module. This module had proper error handling but it used this outdated function for it. And so you saw only the error that this outdated function didn't exist instead of the real problem that this function should have displayed. I don't see what Thirty Bees could have done to help you in this case.

First step: look in the HTML code in your browser whether those images are linked there or not. Second step: look for a shop with the WH theme that does have those images (might be their demo shop) and look how those links go.

I don't understand why TB flags these "problems". As far as I can see none is really a problem. The order of the fields doesn't matter and a field size of "int" instead of int(11) will only become a problem when you sell more than 2 billion products.

Short analysis: - It looks like it comes from the module ets_superspeed. Try removing it from below the /modules directory and then clear the cache. - A call to a function mysql_error() looks really weird. The standard has become mysqli_error() years ago.

I don't see any problem here. The highest id_cart in ps_orders is lower than the highest id in ps_cart - as it should be.

If you are exporting you don't need to truncate. You can also just export the structure and not the data of those tables.

One tip on reducing database size: besides the usual suspects like ps_connections*, ps_guest, ps_page , ps_pagenotfound and ps_sekeyword you can also choose to truncate ps_search_index and ps_search_word. You just will need to regenerate them later on. ps_pagenotfound registers when people try to access a non-existing page on your site. ps_sekeyword registers with which keywords people found your site via the search engines.

What is the problem with Winmerge? I regularly use it. Export the structure or the whole database from two databases and comparing the resulting sql files usually works. Occasionally I need to put the sql file in a database to change all the prefixes when they aren't the same. Jumping between places with differences I usually find those differences that are relevant for my problem rather quick.

As you may well aware Prestashop reduced that functionality in its 1.7 version. They provided two motives. One was that their stock management software had quite a few bugs. The other was that the stock management needs of companies are so diverse that it is better to focus on having good interfaces/modules for specialized stock management software packages.

Thank you for the link. That shows indeed room for improvement. However, I doubt that this explains my problem. Amsterdam is working. And there is the very strange phenomena that I am working in the backoffice or Prestools and it works. And then I click there a link to the webshop and I get this DNS_PROBE_FINISHED_NXDOMAIN page.

I almost daily see the error "DNS_PROBE_FINISHED_NXDOMAIN" on my TB 1.1 website. Refreshing the page or just waiting solves the problem. But of course first impressions count. The problem may also be restricted to Chrome - I am not sure about that The puzzling thing is that it only happens in the shop. When I run the backoffice or Prestools it works. That suggests that this may be a problem of the shopping software and not the hosting. Does anyone know what causes this and how it can be fixed?

I have some trouble with the hosting. The website is still there but sometimes it initially says that it is down. When you refresh the page you will see that it is still there.

is this due to the "disable non-Thirty Bees modules" flag?

I did some experiments on your site and placed a test order. I saw quite a lot of warnings. On the first page I got the notice: Undefined offset: 2 in classes/tax/TaxCalculator.php at line 155 On later pages I got many times two notices from php-debug.js at line 53, 38 and 57: Notice: Trying to get property 'value' of non-object in themes/panda/./header.tpl Notice: Undefined index: sttheme in themes/panda/./header.tpl Another error that I got was this: When after the order I clicked on the logo to go to the homepage I only got the logo and for the rest a white page. This page has the familiar php-debug.js notice duo many times repeated. So I tried some other things. First I went into my user account. That worked. Then I tried a random "page": just the url followed by some random characters. That triggered an error page that allowed me to search on the site. So I searched for "caja". Now I got a real debug mode error page: I am not sure what this all means. Maybe Datakick recognizes what happens here.

The type of attribute is not a property of the product but a property of the attribute.

Is this discussion also relevant for Thirty Bees? https://www.prestashop.com/forums/topic/1045112-is-prestashop-able-to-cope-with-new-european-tax-laws/ Implementation would mean that you can set the price incl VAT while the price for each EU would be different depending on its VAT rate.