writ3it

Hi again @walpap!

Please, provide me few information about your test woocommerce. You can find them here: Wp-admin => Woocommerce => (box) Server environment.

– Server info
– PHP version
– MySQL version (number with name f.e. 5.5.5-10.2.27-MariaDB-log)

Did any errors occur during installation?

@timon72

If will still not working try to regenerate lookup tables at Woocommerce (Wp-admin => woocommerce => status => tools (tab) => at “Product lookup tables” click “Regenerate”. It will redirect you to jobs queue where all of them should be complete).

Do you use custom ways to import / update product prices? Do you use prices exclusive or inclusive of tax?

Hi @ryanandersonweb

I released new version with public properties. I am convinced that change makes correct overriding while inheritance. Please, let me know if it solved the problem.

Hi @walpap!

Thank you for your message. I was thinking about mensmaximus solution and I think this is a workaround and has some imperfection. (You can choose filter range between two variants prices and product will still in results even if range not contain any variant price.)

Today I released version 1.0.2. I changed sql column type for “price map” (opt_properties_float) because floats makes some issues with price comparison.

If will still not working try to regenerate lookup tables at Woocommerce (Wp-admin => woocommerce => status => tools (tab) => at “Product lookup tables” click “Regenerate”. It will redirect you to jobs queue where all of them should be complete).

Do you use custom ways to import / update product prices? Do you use prices exclusive or inclusive of tax?

Hi

I cannot reproduce the bug with my woocommerce instance. I need some information more. Which version of WordPress, woocommerce, mysql and PHP are you using? You can check it here: WP-admin > left menu > woocommerce > status.

Thank you for the bug report and reposting it from github.

@ryanandersonweb

Hi,

i tried to reproduce error. There is my test (I decided to confirm every issue with test) https://github.com/writ3it/the-best-price-filter-for-woocommerce/blob/bug-1/tests/Features/OptFloatPropertiesTableCreationTest.php. I used php 7.3.10. Test is passed so the error is at another place.

I belive that problem is in SQL. Diffrent servers can use diffrent standards of SQL Queries. Could you send me a log file generated while you are installing?

You can generate file following instructions below:
1. Remove plugin (and remove table manually in DB).
2. Change WP_DEBUG in wp-config.php to TRUE.
3. Add line
define( ‘WP_DEBUG_LOG’, true );
at wp-config.php
4. Try to install plugin.
5. Send me ([email protected]) wp-content/debug.log

Sometimes debug.log doesn’t contains errors from table creation (it’s strange) so, please attach me dump of $sql content in OptProperties::create method and information about your mysql server (version).

Hi

thank you for the information. I need few days for preparing the bugfix.

@ryanandersonweb Thank you for detailed bug report. Which PHP version are you using? I will prepare bugfix.

@ut4utc Hi!
I am not sure that I understand your example but I prepared solution to the problem described by Jesse Pearson at Github Issue. Check my plugin.

• This reply was modified 5 years, 4 months ago by writ3it.

@ut4utc I prepared plugin that is resolving this problem. Now is awaiting for code review in official plugins catalog. I will inform you, when plugin will be approved.