zomex

Today we are very happy to announce that our popular WHMCS theme Galaxy has now been updated with RTL support. This allows you to change the direction of text from left to right to right to left for languages of your choice. This is particularly important for languages such as Arabic. Galaxy has now made it to our RTL WHMCS templates directory. View RTL Demo | Learn More/Order Now

Today is a very special day at Zomex, after months of hard work we are happy to announce 2 brand new HTML Templates! Not only do these templates feature our best designs yet, they also come with a huge array of new features including 3 menu layouts, Google translate, support for 10 plans & much more! Each template is also available with automatic sync integration for WHMCS, Blesta & Clientexec. Glaze - New! Glaze is a fully responsive HTML theme designed for web hosting companies. This template also includes a optional WHMCS/Blesta/Clientexec integration with automatic sync. Price: $99.99 - optional $30/year per web hosting software sync template (WHMCS, Blesta & Clientexec) View Demo | Learn More/Order Stellar - New! Stellar is a fully responsive HTML theme designed for web hosting companies. This template also includes a optional WHMCS/Blesta/Clientexec integration with automatic sync. Price: $99.99 - optional $30/year per web hosting software sync template (WHMCS, Blesta & Clientexec) View Demo | Learn More/Order Mono - New! Mono is a fully responsive HTML theme designed for web hosting companies. This template also includes a optional WHMCS/Blesta/Clientexec integration with automatic sync. Price: $99.99 - optional $30/year per web hosting software sync template (WHMCS, Blesta & Clientexec) View Demo | Learn More/Order - These are just 3 of our many high quality HTML templates. HTML themes - full collection

I have seen this error once so far. It was due to the Facebook Javascript code, wrapping the <script> part of the code in {literal} {/literal} tags fixed the issue. Seeing as you have tested Six and it has the same issue this may not be the cause in your situation unless you are using a custom module which imports Javascript, for example a live chat module?

Today is a very special day at Zomex, after months of hard work we are happy to announce Stellar as our new WordPress web hosting theme! We developed Stellar from the ground up as the first of our next generation Wordpress theme with a new and automatic WHMCS sync. We've redeveloped the WHMCS sync integration, added many more shortcodes, new settings & more! View Stellar launch announcement View Demo | Learn More/Order Now

Glad it's sorted. Are you able to share the solution? May help others in the same situation.

That is understandable. I don't know why my EU VAT module was de-activated it must have happened within that week as the data was shown in the database from the weekly backup. Everything is working perfectly now. Thanks @WHMCS John @brian!

Thanks so much Brian! It worked perfectly after running the script. I then removed all of my manually setup VAT tax rules and then used the automatically add rules feature to replace them. Everything is now working well as expected. PS: At this point you should really be on WHMCS's payroll.

Thanks once again Brian. The reason why my value is so high is because I used to use a lot of custom fields for products within WHMCS. But I have changed to a better method for this and deleted those old custom fields. That is right :) > second, in 'TaxVatCustomFieldId', I entered '37' (my VAT number CCF) - this is basically what that query from the help docs does but I did it manually. Just to confirm when you say manually do you mean you manually edited the ID via the database or you run the SQL query provided by WHMCS? At this point I agree that it's best to backup and run but I just need some clarification regarding the manual change you made. As you can see databases are not my strong point, I am a front-end HTML/CSS/media queries/SEO kind of guy :)

See attached also for the issue regarding the tax configuration page. I am unable to select the custom field as it's disabled. I understand this is due to the EU VAT module being de-activated when I upgraded to v7.7 so it is certainly my fault. The question is how to correct the issue. Thanks.

Thanks Brian, I have just checked and it does exist. See attached. So that is the setting in the EU VAT addon that selects the custom field created for VAT. I have used 783 for the x replacement in the query. I assume this is correct and not using the ID of that field instead. Please confirm exactly which ID I should be using, see attached for my custom fields also. To confirm the custom field I have for VAT numbers contains the correct data. I see all of the custom fields exist.

To confirm the feild is still greyed out

Yes here was the error posted earlier: MySQL said: #1054 - Unknown column '‘TaxVatCustomFieldId’' in 'where clause' Running your new query shows value rows with no result. However, Checking under client profiles and the table tblcustomfieldsvalues I can see the VAT number for many profiles. So the data does exist. Perhaps TaxVatCustomFieldId doesn't exist. Is this new table supposed to be in the root of the WHMCS databse? I can see the row tax_id under the tblclients table (empty for all profiles thus far).

If you're seeing that error on the payment gateway page most of the time it is due to a payment gateway being outdated such as using a old version of Ioncube. Once errors are enabled you should be able to see exactly which gateway(s) are responsible.

Thanks Brian. Unfortunately still no luck. Hopfully WHMCS can confirm.

That query is not working: DELETE FROM tblconfiguration WHERE setting=‘TaxVatCustomFieldId’ MySQL said: #1054 - Unknown column '‘TaxVatCustomFieldId’' in 'where clause' Also please confirm: Lastly: Thanks