fenway

That's PHPMyAdmin -- but surely you're not giving your users access to add fields.

That's because you want a UNION, not a JOIN.

Not sure what you mean by doesn't work.

I respectfully disagree -- I've yet to find one that I would recommend.

Just remember that group_concat has a very small max length by default.

Since you're passing it a recordset, it necessarily pertains to that recordset. If you re-use a variable, then it's the last one -- so flowpaths can mess with you. Obviously, a cleaner code layout would help you see that. But different variables names will prevent scoping errors, too.

I'm not sure why you expect the EXPLAIN to be any different.

You're right -- then this board really isn't for you. But that error message is quite clear -- and what likely happened is that without the log, it decided to rollback, or otherwise remove, any data that it couldn't account for in the log.

Tiztag is terrible.

Try the EXPLAIN for the query withing ordering.

Since your script will be doing the substitution, mysql will have no idea -- and you can store any text you want in a string field.

Tally in what way?

Using it says "using password :YES/NO".

Fifth relative to what?

So no matter what you get for innodb_recovery, you get the same messge in the log? can't be.

OK -- so if you have the value from "val", then what's the problem?

Well, yes, that's significant -- did you follow the instructions in the link provided?

Sorry, didn't see that _object call -- bizarre. Table structure?

select * from table1 inner join table2 using ( recno) where recno = '<whatever>'

When's the last time you ran ANALYZE TABLE?

I don't see anything retrieving the column values.

By "can't", I mean conceptually.

I'm just wondering if somehow you have 2 datadirs, one of which isn't being referenced by the my.cnf file.

And you're certain that the innodb data dir is pointing to the correct place?

If "SHOW TABLE STATUS" doesn't show any innodb tables, then you don't have any. Does your my.cnf have "skip-innodb"?