FROM smf_log_packages SQL syntax error?

[mikedude43]

Hi there hope this is the right place to post and if anyone can advise/help me?

I'm running the latest forum software and I am trying to install mods - I can't install any mods without this error appearing...

Code Select Expand

> Database 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 = 'grafitus:SimpleColorizer'
> AND ins' at line 2
> File: /storage/h1/021/434021/public_html/forum/Sources/Packages.php
> Line: 248


Forgive me I am not 100% computer savvy so if I have missed anything I do apolgize.

[Irisado]

Welcome to SMF .

Could you please confirm the exact version of the software you are using.

[Kindred]

It also seems that your issue is related to the installation of the simple colorized mod...   in which case, you really should be asking the questions in the support topic dedicated to supporting that specific mod.

[Illori]

i dont think this is a mod related error.

Code Select Expand

// See if it is installed?
$request = $smcFunc['db_query']('', '
SELECT version, themes_installed, db_changes
FROM {db_prefix}log_packages
WHERE package_id = {string:current_package}
AND install_state != {int:not_installed}
ORDER BY time_installed DESC
LIMIT 1',
array(
'not_installed' => 0,
'current_package' => $packageInfo['id'],
)
); this seems to be the query causing the issue. i think there is an issue with the ops log_packages table and that needs to be resolved.

[Kindred]

Ah, good catch...

[Arantor]

If there were a table problem, you wouldn't get "syntax error in query". I wonder what version of MariaDB the OP's host is using and whether some of these column names are now reserved keywords.

[vbgamer45]

List https://mariadb.com/kb/en/mariadb/reserved-words/
dont' see version on there but there is a function https://mariadb.com/kb/en/mariadb/version/

[Arantor]

Interestingly the query works fine on MariaDB so it's not that. I wonder what the actual query being sent to the DB is that's causing it to choke, turning on 'log the DB error' option would help at this point, I feel.

[mikedude43]

2.0.12 is the version I'm running.

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 = 'AJCollins:group-color-in-posts-and-p' at line 2
File: /storage/h1/021/434021/public_html/forum/Sources/Packages.php
Line: 845

Is another code I am getting now.


I'll have a look at turning on log the DB error now...