minamt

Hi,
here is the Zip file, the json file is damaged
https://drive.google.com/file/d/1tx23itW17MajT9vbeGsNZbSFaEwcMxPT/view?usp=sharing

Hi @hjogiupdraftplus,
You were right, there was an option disabling that password input, I enabled it back, now it’s working, I enabled the manual approval as well, so the users can’t log in until I approve the account, but I would prefer if they receive an email when I approve so they’ll know their account is active but is All in One Security is blocking that? Can you help me do that?

Hello,

Thank you for your reply.

Yes, I was referring to the Manage Stock option under WooCommerce > Settings > Products > Inventory. I’m not sure if this is causing the problem.

As for the other active plugins or custom code, I’ve gathered a list of the plugins currently installed and activated on the website:

All-in-One WP Migration With Import: version: 6.77, author: ServMask, Mises à jour auto désactivées
All In One WP Security: version: 5.3.8, author: TeamUpdraft, DavidAnderson, Mises à jour auto désactivées
Checkout Field Editor for WooCommerce: version: 2.1.2, author: ThemeHigh, Mises à jour auto désactivées
Classic Editor: version: 1.6.7, author: WordPress Contributors, Mises à jour auto désactivées
CMP - Coming Soon & Maintenance Plugin: version: 4.1.13, author: NiteoThemes, Mises à jour auto désactivées
Contact Form 7: version: 6.0.3, author: Takayuki Miyoshi, Mises à jour auto désactivées
Depicter: version: 3.6.1, author: Depicter Slider and Popup by Averta, Mises à jour auto désactivées
Elementor: version: 3.27.2, author: Elementor.com (latest version: 3.27.3), Mises à jour auto désactivées
Elementor Pro: version: 3.27.1, author: Elementor.com, Mises à jour auto désactivées
FiboSearch - AJAX Search for WooCommerce: version: 1.30.0, author: FiboSearch Team, Mises à jour auto désactivées
Health Check & Troubleshooting: version: 1.7.1, author: The www.ads-software.com community, Mises à jour auto désactivées
LiteSpeed Cache: version: 6.5.4, author: LiteSpeed Technologies, Mises à jour auto activées
MC4WP: Mailchimp for WordPress: version: 4.10.1, author: ibericode, Mises à jour auto désactivées
Ovic: Import Demo: version: 1.6.3, author: Ovic Team, Mises à jour auto désactivées
Ovic: Product Bundle: version: 1.1.2, author: Ovic Team, Mises à jour auto désactivées
Ovic Addon Toolkit: version: 2.6.0, author: Ovic Team, Mises à jour auto désactivées
Rank Math SEO: version: 1.0.237, author: Rank Math SEO, Mises à jour auto désactivées
Solid Security Basic: version: 9.3.6, author: SolidWP, Mises à jour auto désactivées
WCFM - WooCommerce Frontend Manager: version: 6.7.15, author: WC Lovers, Mises à jour auto désactivées
WCFM - WooCommerce Frontend Manager - Analytics: version: 2.2.5, author: WC Lovers, Mises à jour auto désactivées
WCFM - WooCommerce Frontend Manager - Delivery: version: 1.3.1, author: WC Lovers, Mises à jour auto désactivées
WCFM - WooCommerce Frontend Manager - Groups & Staffs: version: 3.4.10, author: WC Lovers, Mises à jour auto désactivées
WCFM - WooCommerce Frontend Manager - Ultimate: version: 6.7.5, author: WC Lovers, Mises à jour auto désactivées
WCFM - WooCommerce Multivendor Marketplace: version: 3.6.13, author: WC Lovers, Mises à jour auto désactivées
WCFM - WooCommerce Multivendor Marketplace - Elementor: version: 3.0.4, author: WC Lovers, Mises à jour auto désactivées
WCFM - WooCommerce Multivendor Membership: version: 2.11.6, author: WC Lovers, Mises à jour auto désactivées
WooCommerce: version: 9.6.1, author: Automattic, Mises à jour auto désactivées
WP Activity Log: version: 5.2.2, author: Melapress, Mises à jour auto désactivées
WP Crontrol: version: 1.18.0, author: John Blackbourn, Mises à jour auto désactivées

Now I’ve set a staging website to test different possibilities without affectiong the live website, I’ll get back to you once I’ve done that.

Hi,

I wanted to update you that another product was deleted after I re-enabled WooCommerce stock management. Could this be linked to the issue, as that was the only change I made recently.

Looking forward to your thoughts on this.

Thank you for your response and the helpful recommendations.

I reached out to my hosting provider, and they’ve confirmed that there’s nothing on their side that could be causing the issue. They suggested it might be related to WooCommerce itself.

Following your suggestions, I made several changes: I updated all plugins and the theme, deactivated the WCFM REST API plugin, turned off stock management, and kept only one admin account active. After testing for a week, I noticed that no products were removed during this period.

I’ve now re-enabled stock management and am monitoring the situation with the WP Activity Log plugin to see if any changes occur.

Regarding the logs, I checked WooCommerce > Status > Logs, and all I found was wc_logger. In the Scheduled Actions section, I didn’t find any actions related to product deletions.

I’ll continue monitoring closely and let you know if I see any further issues.

I found that there is indeed a WCFM Rest API plugin, I deactivated it, I still didn’t get a reply from WCFM team, but can the Rest API be the cause?, I can’t be sure as the products are permanently deleted and won’t come back

No I don’t have any Rest API key, and Legacy API is off, but I’m using a multivendor plugin, WCFM could it have some interference?

Here is a screenshot of it: https://ibb.co/mF1BVxs

I’ve already used an activity log plugin, it’s not done manually it shows me that the products were deleted by woocommerce system with the IP adress of the hosting server. And there are no admin accounts I don’t recongize

Hi,
I’ve used both Cryptocompare aggregator and Currency conversion API, same thing it’s 4DKK https://i.imgur.com/7DACp74.jpeg

Hi,
Thank you for your response.
This is what the error log file shows after trying to import a template:

[14-Nov-2024 08:37:18 UTC] WordPress database error Table 'chrouabah_repmanorg.wp_depicter_documents' doesn't exist for query SELECT * FROM wp_depicter_documents ORDER BY id DESC LIMIT 1 OFFSET 0 made by do_action('wp_ajax_depicter-assets-document-templates-import'), WP_Hook->do_action, WP_Hook->apply_filters, WPEmerge\Kernels\HttpKernel->actionAjax, WPEmerge\Kernels\HttpKernel->handle, WPEmerge\Kernels\HttpKernel->run, WPEmerge\Kernels\HttpKernel->executeMiddleware, call_user_func_array, WPEmerge\Flash\FlashMiddleware->handle, WPEmerge\Kernels\HttpKernel->WPEmerge\Middleware\{closure}, WPEmerge\Kernels\HttpKernel->executeMiddleware, call_user_func_array, WPEmerge\Input\OldInputMiddleware->handle, WPEmerge\Kernels\HttpKernel->WPEmerge\Middleware\{closure}, WPEmerge\Kernels\HttpKernel->executeMiddleware, call_user_func_array, Depicter\Middleware\CsrfAPIMiddleware->handle, WPEmerge\Kernels\HttpKernel->WPEmerge\Middleware\{closure}, WPEmerge\Kernels\HttpKernel->executeMiddleware, WPEmerge\Kernels\HttpKernel->WPEmerge\Kernels\{closure}, WPEmerge\Kernels\HttpKernel->executeHandler, call_user_func_array, WPEmerge\Helpers\Handler->execute, call_user_func_array, Depicter\Controllers\Ajax\CuratedAPIAjaxController->importDocumentTemplate, Depicter\Database\Repository\DocumentRepository->create, Depicter\Database\Repository\DocumentRepository->makeSlug, Depicter\Database\Repository\DocumentRepository->getLastDocument, TypeRocket\Models\Model->first, TypeRocket\Database\Query->first, TypeRocket\Database\Query->get, TypeRocket\Database\Query->runQuery
[14-Nov-2024 08:37:18 UTC] WordPress database error Table 'chrouabah_repmanorg.wp_depicter_documents' doesn't exist for query SELECT COUNT(*) FROM (SELECT *FROM wp_depicter_documents WHERE slug = 'document-1' AND id NOT LIKE 0) as tr_count_derived1 made by do_action('wp_ajax_depicter-assets-document-templates-import'), WP_Hook->do_action, WP_Hook->apply_filters, WPEmerge\Kernels\HttpKernel->actionAjax, WPEmerge\Kernels\HttpKernel->handle, WPEmerge\Kernels\HttpKernel->run, WPEmerge\Kernels\HttpKernel->executeMiddleware, call_user_func_array, WPEmerge\Flash\FlashMiddleware->handle, WPEmerge\Kernels\HttpKernel->WPEmerge\Middleware\{closure}, WPEmerge\Kernels\HttpKernel->executeMiddleware, call_user_func_array, WPEmerge\Input\OldInputMiddleware->handle, WPEmerge\Kernels\HttpKernel->WPEmerge\Middleware\{closure}, WPEmerge\Kernels\HttpKernel->executeMiddleware, call_user_func_array, Depicter\Middleware\CsrfAPIMiddleware->handle, WPEmerge\Kernels\HttpKernel->WPEmerge\Middleware\{closure}, WPEmerge\Kernels\HttpKernel->executeMiddleware, WPEmerge\Kernels\HttpKernel->WPEmerge\Kernels\{closure}, WPEmerge\Kernels\HttpKernel->executeHandler, call_user_func_array, WPEmerge\Helpers\Handler->execute, call_user_func_array, Depicter\Controllers\Ajax\CuratedAPIAjaxController->importDocumentTemplate, Depicter\Database\Repository\DocumentRepository->create, Depicter\Database\Repository\DocumentRepository->makeSlug, Depicter\Database\Repository\DocumentRepository->checkSlug, TypeRocket\Models\Model->count, TypeRocket\Database\Query->countDerived, TypeRocket\Database\Query->runQuery
[14-Nov-2024 08:37:18 UTC] WordPress database error Table 'chrouabah_repmanorg.wp_depicter_documents' doesn't exist for query SELECT * FROM wp_depicter_documents WHERE wp_depicter_documents.id = 0 LIMIT 1 OFFSET 0 made by do_action('wp_ajax_depicter-assets-document-templates-import'), WP_Hook->do_action, WP_Hook->apply_filters, WPEmerge\Kernels\HttpKernel->actionAjax, WPEmerge\Kernels\HttpKernel->handle, WPEmerge\Kernels\HttpKernel->run, WPEmerge\Kernels\HttpKernel->executeMiddleware, call_user_func_array, WPEmerge\Flash\FlashMiddleware->handle, WPEmerge\Kernels\HttpKernel->WPEmerge\Middleware\{closure}, WPEmerge\Kernels\HttpKernel->executeMiddleware, call_user_func_array, WPEmerge\Input\OldInputMiddleware->handle, WPEmerge\Kernels\HttpKernel->WPEmerge\Middleware\{closure}, WPEmerge\Kernels\HttpKernel->executeMiddleware, call_user_func_array, Depicter\Middleware\CsrfAPIMiddleware->handle, WPEmerge\Kernels\HttpKernel->WPEmerge\Middleware\{closure}, WPEmerge\Kernels\HttpKernel->executeMiddleware, WPEmerge\Kernels\HttpKernel->WPEmerge\Kernels\{closure}, WPEmerge\Kernels\HttpKernel->executeHandler, call_user_func_array, WPEmerge\Helpers\Handler->execute, call_user_func_array, Depicter\Controllers\Ajax\CuratedAPIAjaxController->importDocumentTemplate, Depicter\Database\Repository\DocumentRepository->create, Depicter\Database\Repository\DocumentRepository->findOrCreate, TypeRocket\Models\Model->findOrCreate, TypeRocket\Models\Model->findById, TypeRocket\Database\Query->get, TypeRocket\Database\Query->runQuery
[14-Nov-2024 08:37:18 UTC] WordPress database error Table 'chrouabah_repmanorg.wp_depicter_documents' doesn't exist for query INSERT INTO wp_depicter_documents (modified_at,name,status,author,slug,type,created_at)  VALUES  ( '2024-11-14 08:37:18','Slider','draft',129,'document-1','custom','2024-11-14 08:37:18' )  made by do_action('wp_ajax_depicter-assets-document-templates-import'), WP_Hook->do_action, WP_Hook->apply_filters, WPEmerge\Kernels\HttpKernel->actionAjax, WPEmerge\Kernels\HttpKernel->handle, WPEmerge\Kernels\HttpKernel->run, WPEmerge\Kernels\HttpKernel->executeMiddleware, call_user_func_array, WPEmerge\Flash\FlashMiddleware->handle, WPEmerge\Kernels\HttpKernel->WPEmerge\Middleware\{closure}, WPEmerge\Kernels\HttpKernel->executeMiddleware, call_user_func_array, WPEmerge\Input\OldInputMiddleware->handle, WPEmerge\Kernels\HttpKernel->WPEmerge\Middleware\{closure}, WPEmerge\Kernels\HttpKernel->executeMiddleware, call_user_func_array, Depicter\Middleware\CsrfAPIMiddleware->handle, WPEmerge\Kernels\HttpKernel->WPEmerge\Middleware\{closure}, WPEmerge\Kernels\HttpKernel->executeMiddleware, WPEmerge\Kernels\HttpKernel->WPEmerge\Kernels\{closure}, WPEmerge\Kernels\HttpKernel->executeHandler, call_user_func_array, WPEmerge\Helpers\Handler->execute, call_user_func_array, Depicter\Controllers\Ajax\CuratedAPIAjaxController->importDocumentTemplate, Depicter\Database\Repository\DocumentRepository->create, Depicter\Database\Repository\DocumentRepository->findOrCreate, TypeRocket\Models\Model->findOrCreate, Averta\WordPress\Database\Entity\Model->create, TypeRocket\Models\Model->create, TypeRocket\Database\Query->create, TypeRocket\Database\Query->runQuery
[14-Nov-2024 08:37:18 UTC] WordPress database error Table 'chrouabah_repmanorg.wp_depicter_documents' doesn't exist for query SELECT * FROM wp_depicter_documents WHERE wp_depicter_documents.id = '' LIMIT 1 OFFSET 0 made by do_action('wp_ajax_depicter-assets-document-templates-import'), WP_Hook->do_action, WP_Hook->apply_filters, WPEmerge\Kernels\HttpKernel->actionAjax, WPEmerge\Kernels\HttpKernel->handle, WPEmerge\Kernels\HttpKernel->run, WPEmerge\Kernels\HttpKernel->executeMiddleware, call_user_func_array, WPEmerge\Flash\FlashMiddleware->handle, WPEmerge\Kernels\HttpKernel->WPEmerge\Middleware\{closure}, WPEmerge\Kernels\HttpKernel->executeMiddleware, call_user_func_array, WPEmerge\Input\OldInputMiddleware->handle, WPEmerge\Kernels\HttpKernel->WPEmerge\Middleware\{closure}, WPEmerge\Kernels\HttpKernel->executeMiddleware, call_user_func_array, Depicter\Middleware\CsrfAPIMiddleware->handle, WPEmerge\Kernels\HttpKernel->WPEmerge\Middleware\{closure}, WPEmerge\Kernels\HttpKernel->executeMiddleware, WPEmerge\Kernels\HttpKernel->WPEmerge\Kernels\{closure}, WPEmerge\Kernels\HttpKernel->executeHandler, call_user_func_array, WPEmerge\Helpers\Handler->execute, call_user_func_array, Depicter\Controllers\Ajax\CuratedAPIAjaxController->importDocumentTemplate, Depicter\Database\Repository\DocumentRepository->create, TypeRocket\Models\Model->findById, TypeRocket\Database\Query->get, TypeRocket\Database\Query->runQuery
[14-Nov-2024 08:37:18 UTC] PHP Fatal error:  Uncaught Error: Call to a member function rename() on null in /home/chrouabah/repman.pro/wp-content/plugins/depicter/app/src/Database/Repository/DocumentRepository.php:378
Stack trace:
#0 /home/chrouabah/repman.pro/wp-content/plugins/depicter/app/src/Controllers/Ajax/CuratedAPIAjaxController.php(211): Depicter\Database\Repository\DocumentRepository->create()
#1 [internal function]: Depicter\Controllers\Ajax\CuratedAPIAjaxController->importDocumentTemplate(Object(WPEmerge\Requests\Request), '', 'depicter-assets...')
#2 /home/chrouabah/repman.pro/wp-content/plugins/depicter/vendor/averta/wpemerge/src/Helpers/Handler.php(167): call_user_func_array(Array, Array)
#3 [internal function]: WPEmerge\Helpers\Handler->execute(Object(WPEmerge\Requests\Request), '', 'depicter-assets...')
#4 /home/chrouabah/repman.pro/wp-content/plugins/depicter/vendor/averta/wpemerge/src/Kernels/HttpKernel.php(177): call_user_func_array(Array, Array)
#5 /home/chrouabah/repman.pro/wp-content/plugins/depicter/vendor/averta/wpemerge/src/Kern in /home/chrouabah/repman.pro/wp-content/plugins/depicter/app/src/Database/Repository/DocumentRepository.php on line 378

Hi,
I’ve tried it on another website hosted in the same server, it worked fine.
in the settings menu it is showing me this error: ” TranslatePress encountered SQL errors. Check out the errors.”
Here are the errors:

Why are these errors occuring

If TranslatePress detects something wrong when executing queries on your database, it may disable the Automatic Translation feature in order to avoid any extra charging by Google/DeepL. Automatic Translation needs to be manually turned on, after you solve the issues.

The SQL errors detected can occur for various reasons including missing tables, missing permissions for the SQL user to create tables or perform other operations, problems after site migration or changes to SQL server configuration.What you can do in this situationPlan A.

Go to Settings -> TranslatePress -> General tab and Save Settings. This will regenerate the tables using your current SQL settings. Check if no more errors occur while browsing your website in a translated language. Look at the timestamps of the errors to make sure you are not seeing the old errors. Only the most recent 5 errors are displayed.Plan B.

If your problem isn’t solved, try the following steps:

1. Create a backup of your database
2. Create a copy of each translation table where you encounter errors. You can copy the table within the same database (trp_dictionary_en_us_es_es_COPY for example) — perform this step only if you want to keep the current translations
3. Remove the trouble tables by executing the DROP function on them
4. Go to Settings -> TranslatePress -> General tab and Save Settings. This will regenerate the tables using your current SQL server.
5. Copy the relevant content from the duplicated tables (trp_dictionary_en_us_es_es_COPY for example) in the newly generated table (trp_dictionary_en_us_es_es) — perform this step only if you want to keep the current translations
6. Test it to see if everything is working. If something went wrong, you can restore the backup that you’ve made at the first step. Check if no more errors occur while browsing your website in a translated language. Look at the timestamps of the errors to make sure you are not seeing the old errors. Only the most recent 5 errors are displayed.

Plan C.

If your problem still isn’t solved, try asking your hosting about your errors. The most common issue is missing permissions for the SQL user, such as the Create Tables permission.Logged errors

These are the most recent 5 errors logged by TranslatePress:1last_errorUnknown character set: ‘utf’disable_automatic_translationsYesurlhttps://mywebsite.pro/wp-admin/options.phpdetailsError creating gettext strings tableslast_queryCREATE TABLE wp_trp_gettext_ar( id bigint(20) AUTO_INCREMENT NOT NULL PRIMARY KEY, original longtext NOT NULL, translated longtext, domain longtext, status int(20), original_id bigint(20), plural_form int(20), UNIQUE KEY id (id) ) DEFAULT CHARACTER SET utfdate_time2024-11-03 10:46:40timestamp17306308002last_errordisable_automatic_translationsYesurlhttps://mywebsite.pro/wp-admin/options.phpdetailsError creating regular strings tableslast_querySHOW TABLES LIKE ‘wp_trp_dictionary_en_us_ar’date_time2024-11-03 10:46:40timestamp17306308003last_errorTable ‘chroua_reporg.wp_trp_dictionary_en_us_ar’ doesn’t existdisable_automatic_translationsYesurlhttps://mywebsite.pro/wp-admin/options.phpdetailsError creating regular tableslast_queryCREATE INDEX block_type ON wp_trp_dictionary_en_us_ar (block_type);date_time2024-11-03 10:46:40timestamp17306308004last_errorUnknown character set: ‘utf’disable_automatic_translationsYesurlhttps://mywebsite.pro/wp-admin/options.phpdetailsError creating gettext strings tableslast_queryCREATE TABLE wp_trp_gettext_en_us( id bigint(20) AUTO_INCREMENT NOT NULL PRIMARY KEY, original longtext NOT NULL, translated longtext, domain longtext, status int(20), original_id bigint(20), plural_form int(20), UNIQUE KEY id (id) ) DEFAULT CHARACTER SET utfdate_time2024-11-03 10:46:40timestamp17306308005last_errorTable ‘chroua_reporg.wp_trp_dictionary_en_us_fr_fr’ doesn’t existdisable_automatic_translationsYesurlhttps://mywebsite.pro/wp-admin/admin-ajax.phpdetailsError running get_string_rows()last_querySELECT id, original, translated, status, block_type FROM wp_trp_dictionary_en_us_fr_fr WHERE original IN ( ‘Video Placeholder’ )date_time2024-11-03 10:45:19timestamp1730630719

• This reply was modified 4 months, 2 weeks ago by minamt.

Hi,
All I’ve found in the console about Translatepress is this message: Notice: TranslatePress trp-ajax request uses fall back to admin ajax.

@dwpriv,
Sure here’s the code I added to the custom invoice template

<?php 
$approval_code = $order_key->get_meta('approval_code');
$transaction_id = $order_key->get_meta('transaction_id');
$transaction_time = $order_key->get_meta('transaction_time');
$orderNumber = $order_key->get_meta('orderNumber');
?>

<table class="cib-data">
	<tr>
		<td class = "order-data">
            Transaction ID: <?php echo $transaction_id; ?>
		</td>
	</tr>
    <tr>
		<td class = "order-data">
            Order number: <?php echo $orderNumber; ?>
		</td>
	</tr>
    <tr>
		<td class = "order-data">
            Approval code: <?php echo $approval_code; ?>
		</td>
	</tr>
    <tr>
		<td class = "order-data">
            Transaction time: <?php echo $transaction_time; ?>
		</td>
	</tr>
</table>
<?php do_action( 'wpo_wcpdf_before_order_details', $this->get_type(), $this->order ); ?>

Is it the way the action is added?

Hi @yordansoares,
I made a custom thank you page to display my custom fields after order payment, and I used [wcpdf_document_link] shortcode to get the PDF link, then using the link I wrote JS scripts to print and send the document as an email.
For the custom fields I created a custom PDF template by copying files to child theme.