SQL Issue when installing mod

Started by Exodus11, July 06, 2017, 08:34:50 PM

Previous topic - Next topic

Exodus11

Hey guys, you're all really helpful, so thank you!
My issue is I have a SQL Problem and get this:

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 1stRVR_log_packages
WHERE package_id = 'smf:smf-2.0.14'
AND install_st' at line 2
File: /storage/ssd2/456/1411456/public_html/Forum/Sources/Packages.php
Line: 248

When i try to install any mod and even the update of SMF.
Is anyone able to list step by step instructions?

Thanks guys

Kindred

Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Illori

that is what the error message says.
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.

shawnb61

It's acting as if one of those is a reserved word - likely "version".

I wonder if there is an extension can make "version" a reserved word?
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

vbgamer45

That was my guess not listed as a reserved in mariadb though
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Exodus11

Hi lads! Thank you for your replies, sorry it's taken me so long to get back to you all. I have been on holidays xD

So yes it is MariaDB but I honestly don't have any clue to fix it

Does anyone have anymore instructions or ideas?

Illori

did you try the fix that is posted above?

Advertisement: