SQL oddity
Permalink
I've been trying to work out a strange issue I'm having with the Loader::db. I uploaded via phpmyadmin a table into the C5 database that contains a list of words and associated information organized by id numbers. Most of the words can be queried just fine using their ids. However some of them don't turn up at all. I am able to query these problematic words without any problem via the command line and phpmyadmin, so the problem seems to be happening with the Loader::db. Any suggestions?
That is just used to load adodb a db abstraction layer, so that wouldn't really be c5 what's the query you are trying to run??
Thanks for the response. I know that loader::db is just an abstraction layer. However I'm not really familiar with adodb and hope that I can solve the issue through C5. If you have any suggestions about how to approach adodb from outside of C5 I am happy to try. As to your question, the query is a standard: "SELECT ... (data columns) ... FROM ... (data base) ... WHERE wordID = ... (id number)"
I managed to get Loader::db to log the queries to adodb_logsql in the database. I looked over the log and it only confirms that the same queries are supplied, only with different ids. I know that most entries consistently work and that the others consistently don't. There is no significant difference between the data in one versus the other. Does any one have any suggestions? I've had the table repaired and it has not helped.
I've also found that the problematic entries seem to not be subject to updates. That is, if I run an update via phpmyadmin, it will say that 0 row(s) were affected.
