[ic] stumped on another sql query

Aaron Hazelton interchange-users@icdevgroup.org
Fri Sep 6 14:56:23 2002


--fixed top-quoting--

Scott Andreas wrote:
> Aaron Hazelton wrote:
> 
> Hi All,
> 
> You may recall that I was working on a [query sql.....]
> yesterday to get the no-match to work.
> 
> I have taken the same exact results page code from the
> local server that I was testing it on and put it on a production
> server and you *never* get results.  inputting the exact
> query string into the production servers mysql command
> line provides results with no problems and logged in as the
> same user that IC is set up with.
> 
> the only differences are:
> production server IC 4.8.3, mysql 3.23.36
> local server IC 4.8.6, mysql 3.23.52
> 
> any ideas where im off?
> 
> thanks,
> Aaron
> 
> sounds like a mysql permission problem to me. double check 
> them, make sure
> you have access rights and check the mysql log file as that 
> will give you
> hints as to what is happening.
> 
> Scott
> 
As I said, I can log into mysql using the *exact same* user/
password that is set in IC and it works just fine.  Also, all of 
the other searches set to st=db work also, wouldn't they fail
too??  there is no IC error either.

thanks again,
Aaron