Steve Holdoway
2010-09-21 22:24:17 UTC
I don't habitually use this software, and am setting some stuff up for
my father, who's doing some data cleaning using it.
The problem I've got is that for some tables, using the 'Search' option
to retrieve a record, the generated sql is illegal, as it's decided to
add a blank 'ORDER BY' clause.
Has anyone else come up with this problem? I can't find anything with
google...
I've updated to latest 3.3.7, am running on debian 32 bit, php 5.2.6,
mysql 5.0.51a, and have ascertained it's not a permissions problem.
I have a horible feeling that it's because he's used spaces in the table
and column names, but that's not been verified yet. It certainly works
fine on tables without any in them.
Am I going to have to start having the code??? I hope not!
Any suggestions gratefully received...
Steve
my father, who's doing some data cleaning using it.
The problem I've got is that for some tables, using the 'Search' option
to retrieve a record, the generated sql is illegal, as it's decided to
add a blank 'ORDER BY' clause.
Has anyone else come up with this problem? I can't find anything with
google...
I've updated to latest 3.3.7, am running on debian 32 bit, php 5.2.6,
mysql 5.0.51a, and have ascertained it's not a permissions problem.
I have a horible feeling that it's because he's used spaces in the table
and column names, but that's not been verified yet. It certainly works
fine on tables without any in them.
Am I going to have to start having the code??? I hope not!
Any suggestions gratefully received...
Steve
--
Steve Holdoway <***@greengecko.co.nz>
http://www.greengecko.co.nz
MSN: ***@greengecko.co.nz
Skype: sholdowa
Steve Holdoway <***@greengecko.co.nz>
http://www.greengecko.co.nz
MSN: ***@greengecko.co.nz
Skype: sholdowa