minamt
Forum Replies Created
-
Forum: Plugins
In reply to: [Depicter — Popup & Slider Builder] Unable to Import TemplatesHi,
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 * FROMwp_depicter_documentsORDER BYidDESC 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 *FROMwp_depicter_documentsWHEREslug= 'document-1' ANDidNOT 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 * FROMwp_depicter_documentsWHEREwp_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 INTOwp_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 * FROMwp_depicter_documentsWHEREwp_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 378Hi,
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:
- Create a backup of your database
- 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
- Remove the trouble tables by executing the DROP function on them
- Go to Settings -> TranslatePress -> General tab and Save Settings. This will regenerate the tables using your current SQL server.
- 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
- 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 ONwp_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 TABLEwp_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 FROMwp_trp_dictionary_en_us_fr_frWHERE original IN ( ‘Video Placeholder’ )date_time2024-11-03 10:45:19timestamp1730630719- This reply was modified 1 year, 11 months 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?
Forum: Plugins
In reply to: [PDF Invoices & Packing Slips for WooCommerce] Empty access keyHi @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.Forum: Plugins
In reply to: [PDF Invoices & Packing Slips for WooCommerce] Empty access keyHi Darren,
I already set Document link access type to ‘Full’ from the advanced settings, I didn’t use hooks, I just used a shortcode for document download and it worked fine, but when I add a button to print the document or to email it, I get a message that I’m missing the access keyHi Darren,
The value of the custom fields appear blank only when sent as an attachment in email, otherwise in preview, generated manually or using the download or link shortcode it’s appearing fine