troussel

The woocommerce update has made nothing, one of the product with many variations was again on “sold out” just after someone by one.

So i will try to update php on 7.4 this night.

For mariadb, there is no update available in yum, the last one we make was for 7 month.

it will take some time, i must make a snapshot, then the update, and if somthing goes wrong with php 7.4, then i must go back to 7.3 because we have many programms make with Marionette and we don’t have the sources. If i must ask for new programmations, than it will take some month.
I hope they go with 7.4.

I have made a test without any plugins and with storefront when the product was show “out of stock” and after i have swtich again all plugins on and the DIVI, because the site was not readable for people with storefront. And even on 12pm i have some call phoned that the site has a probleme.
And after the test, i have made the screenshot.

Yes we have try with the stock on product level and it is the same, we have made with 10000 in product level. The same. Sometimes, it goes on product sold out.

i have find many post in other forum with the same probleme, an many people seems to have this. for years.

it is the same as here https://www.ads-software.com/support/topic/out-of-stock-issue-even-though-all-the-product-variations-has-qty-more-then-10/

but i have try all the solutions i find in the web. there is many.

i have upgrade to the 6.3 , i will see if it is going.

For php 7.4 i must see, we have a other wp on the server with multisite and 60 sites on it, with many plugins, and other old tools to manage the people who was create in php for 8 or 10 years, so i must try if every thing goes with php 7.4.

i have copy only one variation, the 28 are the same, just price and stock are not the same.

https://snipboard.io/bLzurF.jpg
https://snipboard.io/fkJhKo.jpg
https://snipboard.io/swAPnZ.jpg
https://snipboard.io/v2Z83n.jpg
https://snipboard.io/ucOebS.jpg
https://snipboard.io/tbBezU.jpg
https://snipboard.io/45z0uA.jpg
https://snipboard.io/BhpQVg.jpg
https://snipboard.io/BIfoWP.jpg

no log , just test-log empty
and wc-image-regeneration, with no error inside

a last test, i have put again the stock to 300 for the variation, and update, it is normal now.
When i do this again and put the variation to null, it is also normal.

So it is not always. Sometime it make this and sometime no.

i forgot to sa that on the two product where we have problems , there is a combination of 4 attribute and we have on one 28 variations, and on the other 10 variations.

So i have switch to storefront , deasabled all plugins, and delete all cache, and it is the same.

This append most when 1 varaiotion has is stock on null. Just in front end on the product page.

In categorie page, the product is show , so like he is in stock.

In back end , he is “in stock” , only on product page he is markt as “This product is currently out of stock and unavailable.”.

in setting -> product we have

page : Shop

redirect to cart : off
Ajax cart : on (try with off) it is the same.
kg
cm

and review is off

It is our own server, and it is just to sell bedroom and googdies for an event from our association, so i can make it down for 2 hours. It’s not a commercial shop.

thanks for the answer, i will make this next night because the shop is running.

Best regards

### WordPress Environment ###

WordPress address (URL): https://emag22.fr
Site address (URL): https://emag22.fr
WC Version: 6.2.1
REST API Version: ? 6.2.1
WC Blocks Version: ? 6.7.3
Action Scheduler Version: ? 3.4.0
WC Admin Version: ? 3.1.0
Log Directory Writable: ?
WP Version: 5.9.1
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.3.26
PHP Post Max Size: 200 MB
PHP Time Limit: 300
PHP Max Input Vars: 3000
cURL Version: 7.29.0
NSS/3.53.1

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.0.38-MariaDB
Max Upload Size: 200 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.2.1
WC Database Prefix: wp_
Total Database Size: 19.59MB
Database Data Size: 15.96MB
Database Index Size: 3.63MB
wp_woocommerce_sessions: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.14MB + Index: 0.16MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 0.36MB + Index: 0.55MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 0.25MB + Index: 0.20MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.11MB + Index: 0.09MB + Engine InnoDB
wp_frmt_form_entry: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_frmt_form_entry_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_frmt_form_views: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 6.03MB + Index: 0.17MB + Engine InnoDB
wp_postmeta: Data: 1.34MB + Index: 0.55MB + Engine InnoDB
wp_posts: Data: 3.42MB + Index: 0.13MB + Engine InnoDB
wp_rm_custom_status: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rm_fields: Data: 0.36MB + Index: 0.00MB + Engine InnoDB
wp_rm_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rm_front_users: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rm_login: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rm_login_log: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_rm_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rm_paypal_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rm_paypal_logs: Data: 0.19MB + Index: 0.00MB + Engine InnoDB
wp_rm_resources: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rm_rows: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rm_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rm_sent_mails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rm_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rm_stats: Data: 0.17MB + Index: 0.00MB + Engine InnoDB
wp_rm_submissions: Data: 0.52MB + Index: 0.00MB + Engine InnoDB
wp_rm_submission_fields: Data: 0.17MB + Index: 0.00MB + Engine InnoDB
wp_rm_tasks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rm_task_exe_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_uam_accessgroups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_uam_accessgroup_to_object: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_usermeta: Data: 1.48MB + Index: 0.63MB + Engine InnoDB
wp_users: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmm_subscribers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

attachment: 141
custom_css: 1
customize_changeset: 5
et_pb_layout: 1
forminator_forms: 1
nav_menu_item: 14
page: 26
post: 9
product: 12
product_variation: 54
revision: 175
shop_coupon: 2
shop_order: 96
wp_global_styles: 1

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (12) ###

RegistrationMagic: by Registrationmagic – 5.1.0.0
ELEX WooCommerce Name Your Price: by ELEXtensions – 1.2.3
Forminator: by WPMU DEV – 1.15.11
Nav Menu Roles: by Kathy Darling – 2.1.0
RegistrationMagic Premium: by RegistrationMagic – 5.0.2.3
User Access Manager: by Alexander Schneider – 2.2.16
WooCommerce Stripe Gateway: by WooCommerce – 6.2.0
WooCommerce: by Automattic – 6.2.1
WP Fastest Cache: by Emre Vona – 0.9.9
WP Mail SMTP: by WPForms – 3.3.0
WP Maintenance Mode & Coming Soon: by Themeisle – 2.4.4
WPForms Lite: by WPForms – 1.7.2.1

### Inactive Plugins (4) ###

Akismet Anti-Spam: by Automattic – 4.2.2
Hello Dolly: by Matt Mullenweg – 1.7.2
New User Approve: by NewUserApprove – 2.1
WP Sheet Editor - WooCommerce Products: by WP Sheet Editor – 1.7.13

### Settings ###

API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: right_space
Thousand Separator: 
Decimal Separator: ,
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –

### WC Pages ###

Shop base: #120 - /shop/
Cart: #121 - /cart/
Checkout: #122 - /checkout/
My account: #123 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Divi
Version: 4.14.7
Author URL: https://www.elegantthemes.com
Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ?

### Templates ###

Overrides: –

### Action Scheduler ###

Complete: 1,256
Oldest: 2022-02-05 18:25:14 +0100
Newest: 2022-03-07 15:44:08 +0100

Pending: 5
Oldest: 2022-03-08 02:43:16 +0100
Newest: 2022-03-14 14:05:34 +0100

### Status report information ###

Generated at: 2022-03-07 17:09:06 +01:00

Log is empty

thank’s for the response,

but, it is nowhere. Is there a problem with avada theme ?

we are on a multisite wordpress 4.9.4 with Avada theme , fusion builder, fusion slider.

The cache is off.

Have you find how to fix the problem, i have the same, a “=” come at the end of get variable. Without get there is no problem. But when there is a get, wp-cassify put a = at the end, ans i have a “CAS athentification failed”.

the problem seems not to be solved in the realese : 2.0.11

The pdf are always downloded, and not show in browser.

When i desactivate the UAM, than the pdf are no more available, and the error page comme.

Update make, it doesn’t work, i have the same ip, but another user, and it doesn’t work, it say that the user has allready all his vote.

in code you have this :

$ip = $_SERVER[‘REMOTE_ADDR’];

$getRatingPicture = $wpdb->get_var( $wpdb->prepare(
”
SELECT COUNT(*) AS NumberOfRows
FROM $tablenameIP
WHERE pid = %d and GalleryID = %d and IP = %s
“,
$pictureID,$galeryID,$ip
) );

but what is when it is on the wpUserId based ??? This only test the ip.

And after there is also this test :

if(@$VotesPerUser!=0 AND @$VotesPerUser!=”){
$countVotesOfUserPerGallery = $wpdb->get_var( $wpdb->prepare(
”
SELECT COUNT(*) AS NumberOfRows
FROM $tablenameIP
WHERE GalleryID = %d and IP = %s
“,
$galeryID,$ip
) );
}

Here also there is only the ip on test. Perhaps you must also test the check on only registered user to make the test on wpUserId when it is check like you make with the “5 stern Prüfung” or “1 stern Prüfung”.