i have an error trying to installing a package

[Kindred]

the error is not triggered in the PACKAGE...
and the issue is related to the fact that, apparently, MariaDB does not subscribe fully to the same code format/standards as mySQL...

and SMF was built for mySQL (and SQLite and PostGRE SQL) not MariaDB...

so, some tweaks are going to be needed to make it work on MariaDB -- or you can ask your host to switch to mySQL

[Madirex]

the error is not triggered in the PACKAGE...
and the issue is related to the fact that, apparently, MariaDB does not subscribe fully to the same code format/standards as mySQL...

and SMF was built for mySQL (and SQLite and PostGRE SQL) not MariaDB...

so, some tweaks are going to be needed to make it work on MariaDB -- or you can ask your host to switch to mySQL

Hi, I can do anything in my forum, except to install a package, what else do I have to modify?

---
EDIT: https://www.simplemachines.org/community/index.php?topic=553048.0

He uses MariaDB and came to fix it! and I do not!

[Kindred]

well, obviously, you version of MariaDB has forked even further away from mySQL...

So, if you actually made te changes, and they just triggered another, different error message, then you either have to find MORE tweaks... or switch to mySQL.

I don't think that SMF claims to fully support MaraiDB, in our minimum requirements page
https://wiki.simplemachines.org/smf/SMF2.0:Requirements_and_recommendations

nope...   mySQL, PostGRE and SQLite are the three that we officially support

we can work with you... but curb your impatience, because - as noted- what you are asking for support for is not part of the stadard offering and may take MANY tweaks, depending on how far MariaDB has shifted away fro mySQL standard

[Madirex]

well, obviously, you version of MariaDB has forked even further away from mySQL...

So, if you actually made te changes, and they just triggered another, different error message, then you either have to find MORE tweaks... or switch to mySQL.

I don't think that SMF claims to fully support MaraiDB, in our minimum requirements page
https://wiki.simplemachines.org/smf/SMF2.0:Requirements_and_recommendations

nope...   mySQL, PostGRE and SQLite are the three that we officially support

we can work with you... but curb your impatience, because - as noted- what you are asking for support for is not part of the stadard offering and may take MANY tweaks, depending on how far MariaDB has shifted away fro mySQL standard

Only 2 or 3 more lines would be needed, since it only affects the packages.ini ...

All other files and functions work perfectly!

[Arantor]

The problem is, you're literally the only person that has seen these new changes so far. We don't know how many more changes will be needed yet and no-one here on the dev side runs MariaDB because we don't claim to support it.

[Madirex]

And there is some place to ask for help and to change the mysql format code to mariadb that?

[Arantor]

Not anywhere other than here, no.

[Madirex]

I fixed manually!!

Changing...
SELECT package_id, install_state, db_changes

to

SELECT `package_id`, `install_state`, `db_changes`

[Kindred]

if that was the problem, then it is likely that you are going to encounter the same issue at dozens of other points in the code...

[Elmacik]

if that was the problem, then it is likely that you are going to encounter the same issue at dozens of other points in the code...

Then maybe SMF should consider using backtics in the next version as SQL standard recommends.

[SleePy]

backticks are not sql standard.  Read here: https://stackoverflow.com/questions/10573922/what-does-the-sql-standard-say-about-usage-of-backtick
As well, Postgresql mentions its not sql compliant: https://wiki.postgresql.org/wiki/Things_to_find_out_about_when_moving_from_MySQL_to_PostgreSQL

We don't officially support it in 2.0 and in 2.1 we acknowledge it in the support section but don't officially support it still.  I've tested MariaDB myself on CentOS7 and haven't been able to reproduce this error.  Another dev uses MariaDB themselves without any issues.  This seems like a server configuration issue and without knowing what configuration setting is causing it, there isn't much to go on here.

[Elmacik]

@SleePy, maybe it's all MySQL messing with SQL standards, not sure if I've read this in the SQL standard recommendation itself; but I remember having read this in so many places. Like Google says;

https://cloud.google.com/bigquery/docs/reference/standard-sql/lexical

As I read it again now, I remember that it's mostly about the reserved keywords. Because if you use reserved keywords as column names or as such; you will have to enclose those words with backticks or something else.

[VenomBurke]

I made a post about this awhile ago as well, and I'm still getting the same problems, this is my error. 

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 = 'LHVWB:CustomFormMod'
AND install_' at line 2
File: /storage/ssd2/677/2224677/public_html/Sources/Packages.php
Line: 247

[Kindred]

Yes... as I said, mariadb is not officially uspported and needs some tweaks to several areas of code in order to work