Forum Replies Created

Viewing 7 replies - 31 through 37 (of 37 total)
  • Thread Starter minamt

    (@minamt)

    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

    Thread Starter minamt

    (@minamt)

    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 1 year, 11 months ago by minamt.
    Thread Starter minamt

    (@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.

    Thread Starter minamt

    (@minamt)

    @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?

    Thread Starter minamt

    (@minamt)

    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.

    Thread Starter minamt

    (@minamt)

    Hi 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 key

    Thread Starter minamt

    (@minamt)

    Hi 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

Viewing 7 replies - 31 through 37 (of 37 total)