Fixed 2.3.0 Beta 5 Install Bug

[Daveo16]

Affected version

2.3.0 Beta 4

I get this error when trying to install XF 2.3.0 Beta 4 as a fresh install, at Step 2...

XF\Db\InvalidQueryException: MySQL statement prepare error [1064]: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 15 in src/XF/Db/AbstractStatement.php at line 230

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 40
3. XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 56
4. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
5. XF\Db\AbstractAdapter->query() in src/XF/Install/Helper.php at line 352
6. XF\Install\Helper->insertDefaultData() in src/XF/Install/Controller/Install.php at line 179
7. XF\Install\Controller\Install->actionStep2() in src/XF/Mvc/Dispatcher.php at line 352
8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2588
12. XF\App->run() in src/XF.php at line 532
13. XF::runApp() in install/index.php at line 14

 

[Paul B]

What SQL flavour and version is installed on your dev site?

 

[Daveo16]

MariaDB 10.6.16

 

[Daveo16]

2.3.0 Beta 3 fresh install worked fine, but fresh install of 2.3.0 Beta 4 gets above error.

 

[Daveo16]

Any news on whether this is a confirmed bug, as I see a similar bug report and that's marked as Confirmed.

 

[Chris D]

Yes my apologies. I can suggest a code fix to try if you feel comfortable, bear with me.

 

[Chris D]

In src/XF/Install/Data/MySql.php find:

('forum_overview_share_page',            'share_page',            '[]',    '{\"forum_list_sidebar\":\"50\",\"forum_new_posts_sidebar\":\"50\"}', '', ''),

And replace with:

('forum_overview_share_page',            'share_page',            '[]',    '{\"forum_list_sidebar\":\"50\",\"forum_new_posts_sidebar\":\"50\"}', '', '')

(Essentially remove the comma from that line).

The install should then work.

 

[Daveo16]

Many thanks.

I can confirm this fixed the issue.

 

[Kevin 🚀]

Hello,
Work fine for me also
Thanks

 

[XF Bug Bot]

Thank you for reporting this issue, it has now been resolved. We are aiming to include any changes that have been made in a future XF release (2.3.0 Beta 5).

Change log:

Fix data query for new installs

There may be a delay before changes are rolled out to the XenForo Community.

 

[Simon2]

The issue is still present in Beta 5. Removing the comma at the end resolved the issue for me.

I am using Laragon along with PHP 8.3.6 and HeidiSQL Portable 12.1.0.6537 (MySQL 8.0.30).

 

[XF Bug Bot]

Thank you for reporting this issue, it has now been resolved. We are aiming to include any changes that have been made in a future XF release (2.3.0 Beta 6).

Change log:

Fix data query for new installs (again)

There may be a delay before changes are rolled out to the XenForo Community.