Raise exceptions on error

[jonocodes]

🗣 Suggestion

This conversation started here: #977 (comment)

Concerning PDO error modes php.watch/versions/8.0/PDO-default-errmode.

It appears php 7.x defaulted to make them silent, but 8.x is making them throw exceptions. This would have very different behaviors in the way cypht uses them since it is not explicitly setting a mode. So I recommend setting it explicitly.

That being said, I agree with the decision to have it default to throw exceptions. I came upon this when trying to figure out why some database operations were not working while I was developing. cypht seems to capture and hide the actual errors as you can see here:

cypht/scripts/create_account.php

Lines 43 to 50 in 2cf7a0a

	if ($auth->create($user, $pass) === 2) {
	die("User '" . $user . "' created\n\n");
	}
	else {
	print_r(Hm_Debug::get());
	print_r(Hm_Msgs::get());
	die("An error occured when creating user '" . $user . "'\n\n");
	}

Unless there is another way to expose these errors (perhaps via a debug mode log) you cant see what the issue is, which is needed in order to fix it.

In my testing I was able to turn the above into a single line:

	$auth->create($user, $pass);

I explicitly ask for exceptions to happen when setting up the connection:

self::$dbh[$key]->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

That way the (error) logs are actionable.