4
Tablespaces are used to define the physical file location of one (or more) tables - chances are if you were using them for something beyond the default innodb space, you'd know about it. It's likely safe to ignore.
The error will have started when MySQL was updated to 5.7.something, they introduced a breaking change in a minor version because it addressed a ...
1
is there any method to check if the connection is available or not?
If you mean class method, then no, because it wouldn’t be necessary. You can simply catch the exception, which will tell you immediately that the connection was not successful:
try {
// Code using a database connection
} catch (ConnectionNotDefinedException $e) {
// No database for you
}...
1
Here is the documentation on joins which should put you on the right path to answering the question.
Untested, but something like this should work:
$query = db_select('node', 'n');
$query->join('comment', 'c', 'n.nid = c.nid');
$query
->fields('n', array('nid', 'title'))
->condition('n.type', 'page')
->condition('n.status', '1')
->...
Only top voted, non community-wiki answers of a minimum length are eligible
