Troubleshooting: SQL error after editing user account.

VERSIONS AFFECTED: 7/8/10 and later.

WHAT IT LOOKS LIKE
This error looks like " 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 '' at line 1" and occurs directly after submitting the form after editing an appraiser, admin, or client account, but only if you have the Company Divisions feature enabled.

SOLUTION
The solution is either to: 1) make sure you've always selected at least one Company Division for the user before submitting the form, or 2) disable the Company Divisions feature under Site Settings > Misc Site Options.

 

For more information or if you have any questions please email info@valuedwebsites.com

^ Back to Top   < Knowledge Base

Request Information

Call Me         Email Me

"We really are impressed with your work and love the site. Thanks again."

Livo T. - Torlai Appraisal Service ^
- more testimonials

FREE for 15 days then:


Plus options. 30 day guarantee. No contracts.

GET STARTED

REBATE OFFER

Sign up for online payment processing with Authorize.net through Valued Websites, clients pay you online, and we'll rebate up to the full amount of your monthly service fee! MORE INFO

Already have a website?

We'll transfer all your page contents and email addresses for you at no extra cost.

Rebate Offer