Quote items Blank!

[anthonyt]

Hello,

 

I have been struggling with a problem in WHMCS. My quote system is problematic, I will explain as best I can what the problem is and I will also link a screen grab I made to show whats going on.

 

What Happens?

Create Quote - OK

Select Client or Add new Client - OK

Add product from ( Pre-defined Products ) - Nothing happens, remains blank.

Manually enter a description & price - Description stays blank, price updates.

 

[video=youtube_share;rG94wveqhI0]

 

I have contacted hostgator but they have not helped. I use a reseller licence from hostgator of WHMCS. I hope someone can help me.

 

Regards,

Anthony

[WHMCS John]

Hi,

This could indicate a MySQL error is occurring inserting data into the WHMCS database. Please:

 

• Navigate to Setup > General Settings > Other tab
  
• Enable the MySQL Debug option
  
• Reproduce the problem
  
• Disable the MySQL Debug option
  
• Navigate to Utilities > Logs > Activity Log and look for any MySQL error entries.
  

 

Then post any errors here for us to review.

[anthonyt]

Date Description

 

26/04/2017 18:23

General Settings Modified. Changes made: SQL Error Reporting Disabled.

 

26/04/2017 18:23

Modified Quote - Quote ID: 128

 

26/04/2017 18:23

SQL Error: - Full Query: INSERT INTO tblquoteitems (`quoteid`,`description`,`quantity`,`unitprice`,`discount`,`taxable`) VALUES ('128','Sample description in quote.','1','200','0.00','1')

 

26/04/2017 18:23

SQL Error: Unknown column 'quantity' in 'field list' - Full Query: INSERT INTO tblquoteitems (`quoteid`,`description`,`quantity`,`unitprice`,`discount`,`taxable`) VALUES ('128','Sample description in quote.','1','200','0.00','1')

 

26/04/2017 18:21

General Settings Modified. Changes made: SQL Error Reporting Enabled.

[anthonyt]

SQL Error: - Full Query: INSERT INTO tblquoteitems (`quoteid`,`description`,`quantity`,`unitprice`,`discount`,`taxable`) VALUES ('128','Sample description in quote.','1','200','0.00','1')

SQL Error: Unknown column 'quantity' in 'field list' - Full Query: INSERT INTO tblquoteitems (`quoteid`,`description`,`quantity`,`unitprice`,`discount`,`taxable`) VALUES ('128','Sample description in quote.','1','200','0.00','1')

[brian!]

Anthony,

 

it's probably also worth mentioning that you (with a reseller license) can still contact WHMCS Reseller Support for help with this.

[WHMCS ChrisD]

It does sound like there is a database issue here, opening a support ticket would be your best option here.

[anthonyt]

Thankyou Brian and Chris for your prompt responses. Unfortunately Hostgator only supplied me with the license key via their support ticket and I won't have a WHMCS account with an active package. So getting support would mean going back and forth for days just to verify.

 

Further more I took a stab and resolved my own issue. It had three missing fields in tblquoteitems one of which was posted in my earlier reply. I appreciate the time you guys have taken out to respond to me.

 

Have a great weekend.

[brian!]

Thankyou Brian and Chris for your prompt responses. Unfortunately Hostgator only supplied me with the license key via their support ticket and I won't have a WHMCS account with an active package. So getting support would mean going back and forth for days just to verify.

you wouldn't need a WHMCS account with an active package to contact Reseller Support (nor would you even need to login) - they'd be able to tell if you were running a licensed installation on your WHMCS anyway just from the domain.

 

Further more I took a stab and resolved my own issue. It had three missing fields in tblquoteitems one of which was posted in my earlier reply. I appreciate the time you guys have taken out to respond to me.

often the quickest way! i'm glad you found the answer.

[WHMCS ChrisD]

Thankyou Brian and Chris for your prompt responses. Unfortunately Hostgator only supplied me with the license key via their support ticket and I won't have a WHMCS account with an active package. So getting support would mean going back and forth for days just to verify.

 

Further more I took a stab and resolved my own issue. It had three missing fields in tblquoteitems one of which was posted in my earlier reply. I appreciate the time you guys have taken out to respond to me.

 

Have a great weekend.

 

Hi Anthonyt,

 

Thanks for your post, so you know you can simply go to whmcs.com/resellersupport/ to open a support ticket with us you'll need to include your License ID and the issue.

[anthonyt]

Thanks Chris, I will surely in the future if I am ever stuck!

 

Have a great day