Error in your SQL syntax

Started by Atomixx, April 12, 2017, 02:53:28 PM

Previous topic - Next topic

Atomixx

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


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


Illori

Quote from: Atomixx on April 12, 2017, 02:53:28 PM

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.

Quote from: Arantor on March 31, 2017, 02:35:31 AM
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:

SELECT version, themes_installed, db_changes

to

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

to see if that helps.

Atomixx

Quote from: Illori on April 12, 2017, 03:09:58 PM
Quote from: Atomixx on April 12, 2017, 02:53:28 PM

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.

Quote from: Arantor on March 31, 2017, 02:35:31 AM
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:

SELECT version, themes_installed, db_changes

to

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

to see if that helps.

Yep! Works thanks  :D

Advertisement: