Custom SQL Query issue

I have an issue and not sure how to fix. I am entering a custom query into the Custom SQL Query box and it returns and error that states:
Invalid JSON: 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 'SELECT * FROM pm1_users' at line 1. Any ideas?

what is the entire query you are entering?

SELECT * FROM pm1_users

literally just that.

I figured it out... feel like an idiot...just realized that I am supposed to add the criteria for the search, not the whole query.

OK, glad to hear you got it sorted.

I added a new column to the pm1_users table named UserCompany, but am unable to use it in an audience filter. Adding a WHERE clause such as below in the Custom SQL Query box, yields Invalid JSON syntax errors.

WHERE UserCompany LIKE 'Widget Corp'
or
WHERE UserCompany CONTAINS 'Widget Corp'
or
WHERE UserCompany = 'Widget Corp'

I tried double quotes ("") and escaping the single quotes with slashes (\').

Can't seem to use the LIKE operator with an already existing text column either.

Edit: Perhaps it's related to how quotes are escaped.
This filter:
WHERE UserCity LIKE 'Houston'
produces this error:
Invalid JSON: 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 '\'Houston\'' at line 1

sounds like you have the magic_quotes_gpc option enabled on your PHP server. magic_quotes_gpc is depricated in newer versions of PHP and should be turned off in the php.ini file.

contact your host to have them disable the magic_quotes_gpc setting in the php.ini.

Originally Said By: Jason Byrnes

  sounds like you have the magic_quotes_gpc option enabled on your PHP server. magic_quotes_gpc is depricated in newer versions of PHP and should be turned off in the php.ini file.

contact your host to have them disable the magic_quotes_gpc setting in the php.ini.  

I'm on a shared-hosting server. They are not going to disable it on the server. They may have other clients requiring it, even if it is deprecated. I need a work-around.

add the following code to line 1 of the webassist/globals/globals.php file:

<?php

if (get_magic_quotes_gpc()) {

    if($_SERVER['REQUEST_METHOD'] == "POST") {

        foreach($_POST as $k => $v) {

            $_POST[$k] = stripslashes($v);

        }

    }

}

?>