Error in your SQL syntax

[Atomixx]

Trying to install some mods onto my forum but every time I Click "Install Mod" I get

Code Select Expand


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 'FROM smf_log_packages
WHERE package_id = 'Arantor:PM_to_Groups'
AND install' at line 2
File: /storage/h7/475/1127475/public_html/Sources/Packages.php
Line: 248


The only mod that I've been able to install successfully has been Simpleportal. I don't know if it's just a problem with the 3 mods I'm trying to install or something else. Mod's I've been trying to install are

Good Post/Bad Post Mod
Default Avatar by Username
Personal Messages to Membergroups

I've emulated to previous versions of SMF for the mods, if that helps

[Arantor]

Are you running MariaDB?

[Illori]

Code Select Expand


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 'FROM smf_log_packages


the error message confirms so.

Not right now because it's a bug in core SMF that no-one is quite sure why it happens.

You could try editing Sources/Packages.php somewhere around line 835:

Code Select Expand

SELECT version, themes_installed, db_changes

to

Code Select Expand

SELECT `version`, `themes_installed`, `db_changes`

to see if that helps.

[Atomixx]

Code Select Expand


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 'FROM smf_log_packages


the error message confirms so.

Not right now because it's a bug in core SMF that no-one is quite sure why it happens.

You could try editing Sources/Packages.php somewhere around line 835:

Code Select Expand

SELECT version, themes_installed, db_changes

to

Code Select Expand

SELECT `version`, `themes_installed`, `db_changes`

to see if that helps.

Yep! Works thanks