Windows Install

[mattjenkins]

Hi,

 

I am trying to install a trial licence on a Windows Server and I'm getting the following two errors during the installation process:

 

ERROR: INSERT INTO `tblemailtemplates` (type,name,subject,message) VALUES ( 'invoice', 'Second Invoice Overdue Notice', 'Second Invoice Overdue Notice', '

 

Dear [CustomerName],

 

This is the second billing notice that your invoice no. [invoiceNo] which was generated on [invoiceDate] is now overdue.

 

Your payment method is: [PaymentMethod]

 

Invoice: [invoiceNo]

Amount Due: [AmountDue]

Due Date: [DueDate]

 

You can login to your client area to view and pay the invoice at [invoiceLink]

 

Your login details are as follows:

 

Email Address: [CustomerEmail]

Password: [CAPassword]

 

[signature]

') Failed - Please contact WHMCS Support with this error message

ERROR: INSERT INTO `tblemailtemplates` (type,name,subject,message) VALUES ( 'invoice', 'Third Invoice Overdue Notice', 'Third Invoice Overdue Notice', '

 

Dear [CustomerName],

 

This is the third and final billing notice that your invoice no. [invoiceNo] which was generated on [invoiceDate] is now overdue. Failure to make payment will result in account suspension.

 

Your payment method is: [PaymentMethod]

 

Invoice: [invoiceNo]

Amount Due: [AmountDue]

Due Date: [DueDate]

 

You can login to your client area to view and pay the invoice at [invoiceLink]

 

Your login details are as follows:

 

Email Address: [CustomerEmail]

Password: [CAPassword]

 

[signature]

') Failed - Please contact WHMCS Support with this error message

I'm using PHP 5.2.4 and MySQL 5.0.45. Any help gratefully received.

 

<edit> Actually - what's the deal with the funny quotes (`) in the commands above? Could that be the problem?

 

Also, what NTFS permissions should be applied to the whmcs folder - "777" or "644" doesn't mean a lot to me.

 

Thanks,

Matt

[support@shopwebsecure.com]

coz you installed WHMCS before...you have to create a new database...

[Nick]

 

<edit> Actually - what's the deal with the funny quotes (`) in the commands above? Could that be the problem?

 

Also, what NTFS permissions should be applied to the whmcs folder - "777" or "644" doesn't mean a lot to me.

 

Thanks,

Matt

 

The 'funny quotes' are backticks, they're part of MySQL's syntax.

 

Where WHMCS' install documentation says to change permissions to 777, they should be world writeable, normal permissions for everything else.