Database create table then insert gives 'Invalid table' error

[ScreenRes]

I’m running a script that check if a table exists, if it doesn’t I create it, then either way data is added to it.

First time I run the script (when the table doesn’t exist) the table is created (checked this in PHPmyAdmin) but an error is thrown when adding data.
InvalidArgumentException Invalid table: nc_districts_notts
(Kirby/src/Database/Query.php - 259).
I’m guessing this means the table doesn’t exist as it’s validating the table?

If i run the script again (Now table exists) it runs fine and data is added.

Am I missing something?
Do I need to do something before the adding the data to the table?

Script sections below:
This is all within the page controller.

The table is checked via the Db::select() method.

// The Page
$county_page = page($region);
// Table Abbreviation
$county_table_abb = $county_page->county_abb()->value();
// The Table
$db_district_table = 'nc_districts_' . $county_table_abb;
//
$district_table_exists = true;
try {
	$selectResult = Db::select( $db_district_table );
} catch(Exception $error) {
	$district_table_exists = false;
}

Then create the table if it doesn’t exist via the Db::execute() method:

if ( !$district_table_exists ) {
			//
	$create_districts_table_query = "CREATE TABLE `$db_district_table` (";
	$create_districts_table_query.= "`id` int(11) NOT NULL AUTO_INCREMENT,";
	$create_districts_table_query.= "PRIMARY KEY (`id`),";
	$create_districts_table_query.= "`district_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,";
	$create_districts_table_query.= "`district_slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,";
	$create_districts_table_query.= "`region_id` int(11) DEFAULT NULL";
	$create_districts_table_query.= ") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;";
	//
	$district_table_exists = Db::execute( $create_districts_table_query );
}

Then some logic to get and loop through the data and the Db::insert() method.

$district_id = Db::insert( $db_district_table, [
	'district_name' => $the_district,
	'district_slug' => strtolower( str_replace( ' ', '-', trim( $the_district ) ) ),
	'region_id' => $region_id
]);

[texnixe]

@ScreenRes

try {
	$selectResult = Db::select( $db_district_table );
} catch(Exception $error) {
	$district_table_exists = false;
}

This is not the right way to check if a table exists. I’m not sure what Db::select() returns when the table doesn’t exist, but I don’t think it throws an exception, so setting $district_table_exists = false; in the catch clause is a problem.

So check what $selectResult actually returns and act on that. Or check out $database->validateTable() | Kirby CMS.

[ScreenRes]

Db::select() returns an Error Exception when the table doesn’t exist ‘Invalid Table’ or results if is does exist. But my error occurs when I’m trying to use Db::insert() after first creating the table.
The validateTable() method seemed over kill after posting this:

Database Object

I’m playing around with Kirby and a MySQL DB. I’ve worked through the Cookbook, all made sense and the shortcut methods are great. My questions are just about creating a Database object in order to utilise some of the other methods available, in my case the validateTable method. As I have the DB details in my config.php am I fine instantiating the class like: $myDatabase = new Database( config::get('db') ); Or is there a better way? Also is it possible to create a global $database object m…

Seems like the Db::insert() can’t validate a table if it just been created.

[ScreenRes]

Quick update.

After finding some time to play with this again I’ve managed to get it all working as I’d expect.
I’ve ended up using the DB shortcut methods for adding, Db::insert(), and fetching, Db::select() or Db::first(), data.
I had to use the new database object to validate and create the table if required. Then revert back to shortcuts to insert data into the newly created table.