Search the Community
Showing results for tags 'syntax error'.
Found 2 results
-
When i am trying to active a specific module. it's showing this error... Addon Module ActivatedSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT COLLATE utf8mb3_unicode_ci' at line 16 Mysql,,,, Database server Server: Localhost via UNIX socket Server type: MySQL Server version: 8.0.30-cll-lve - MySQL Community Server - GPL Protocol version: 10 WHMCS version.. 8.5.1General Release8.5.1-release.1 now how can I fix this error??? is that problem with module? -
I've been having an odd issue with multiple email templates. It seems like using an {else} results in the following errors in the activity log: Smarty Error: Syntax error in template "mailMessage:mailMessage:plaintext" on line 33 "{$signature}" unclosed {if} tag I'm getting this with at least two different email templates. Here's one such template in plaintext for "Invoice Created" the one that the above error is specifically referring to: <p>Hey {$client_name},</p> {if $ticket_department eq "Sales"}Since you normally pay with PayPal, you should already have a subscription which will automatically renew on {$invoice_date_due}. If your subscription was previously canceled, then you should use the link below to complete payment manually.{else}According to our records, you normally complete payment with {$invoice_payment_method}, however {$invoice_payment_method} does not support automatic renewal! This means you will need to click the link below to complete payment manually for every invoice we create for you. If you'd like your invoices to automatically renew, without your intervention, we suggest switching your default payment method to a Credit Card or a PayPal Subscription. Just <a href="[snipped]/clientarea.php?action=details">click here to change your default payment method</a>for all invoices within your account. If you'd prefer to continue paying with {$invoice_payment_method}, simply click the link below to proceed.{/if} <p><strong>Invoice Details</strong></p> <p>Invoice #{$invoice_num}<br />Default Payment Method: {$invoice_payment_method}<br />Amount Due: {$invoice_total}<br />Date Created: {$invoice_date_created}<br />Due Date: {$invoice_date_due}</p> <p><strong>Invoice Items</strong></p> <p>{$invoice_html_contents} <br /> ------------------------------------------------------</p> <p>You can login to your client area to view and pay the invoice here: {$invoice_link}</p> <p>{$signature}</p> Yet the messages seem to send and display just fine. Is it possible the syntax parser is reading the word "if" in the body and thinking it's another {if} statement?
