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

Having trouble installing serendipity?
Post Reply
Ömer
Posts: 2
Joined: Thu Feb 10, 2022 9:54 am

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

Post 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
onli
Regular
Posts: 2822
Joined: Tue Sep 09, 2008 10:04 pm
Contact:

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

Post 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?
Ömer
Posts: 2
Joined: Thu Feb 10, 2022 9:54 am

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

Post 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.
onli
Regular
Posts: 2822
Joined: Tue Sep 09, 2008 10:04 pm
Contact:

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

Post by onli »

Ah, right. Sorry, didn't think of that known bug.

I merged the PR now as suggested.
Post Reply