Page 1 of 1

MYSQL Database problem wıth s9y v2.4 beta1, PHP8 and XAMPP.

Posted: Thu Feb 10, 2022 10:12 am
by Ömer
Trying to install serendipity on XAMPP. Wouldn't install but returns an error trace. Tried with new empty databases several times but same problem (this here done with database named cfx):
Fatal error: Uncaught mysqli_sql_exception: Table 'cfx.cfx_authors' doesn't exist in C:\xampp\htdocs\serendipity\include\db\mysqli.inc.php:66 Stack trace: #0 C:\xampp\htdocs\serendipity\include\db\mysqli.inc.php(66): mysqli_query(Object(mysqli), 'SELECT * FROM c...') #1 C:\xampp\htdocs\serendipity\include\admin\installer.inc.php(325): serendipity_db_query('SELECT * FROM c...', false, 'both', false, false, false, true) #2 C:\xampp\htdocs\serendipity\serendipity_admin.php(260): require('C:\\xampp\\htdocs...') #3 {main} thrown in C:\xampp\htdocs\serendipity\include\db\mysqli.inc.php on line 66

Re: MYSQL Database problem wıth s9y v2.4 beta1, PHP8 and XAMPP.

Posted: Thu Feb 10, 2022 9:22 pm
by onli
That's sadly one error too far. In the one you show, it can't find the authors table. The most likely explanation for that is it wasn't created, likely because of a prior error. Did you see one? Maybe it is still in the php/apache log?

Re: MYSQL Database problem wıth s9y v2.4 beta1, PHP8 and XAMPP.

Posted: Sat Feb 12, 2022 7:21 pm
by Ömer
Had a quick dig around in the code and found the issue in it. Issue was a specific try,clause block which doesn't catch mysql errors, only PDO ones. I caught all exceptions and the installation went smooth as silk.

Then went to GitHub to report the issue there and found the issue(and you too). The issue is this: https://github.com/s9y/Serendipity/issues/772 and from the conversation there it seems you are already aware.
better get the issue fixed fast, at least merge Matt's mysqli exception for now.

Re: MYSQL Database problem wıth s9y v2.4 beta1, PHP8 and XAMPP.

Posted: Sat Feb 12, 2022 10:39 pm
by onli
Ah, right. Sorry, didn't think of that known bug.

I merged the PR now as suggested.