Error trying to installing a package

[haynus]

Fresh Newbie here. Dont be afraid to dumb down your answer.

I have similar issue after a fresh install ...
I installed the theme "Bad_Company_3_2.0", set it as default theme.
then tryed to install "SMFPacks.com Shoutbox, Chat"
I get this error...

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 = 'nibogo:shoutBox'
AND install_stat' at line 2
File: /storage/ssd5/371/2075371/public_html/forum/Sources/Packages.php
Line: 246

my host uses SQL data base not MariaDB. What can I do to fix?

[Arantor]

What version of database?

[Illori]

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version

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.

[Arantor]

Yes but the user said he was using SQL... oh wait, MariaDB really is the DB server on that host.

[haynus]

Yes but the user said he was using SQL... oh wait, MariaDB really is the DB server on that host.

I made a mistake ...looked up spec from host...
Database is limited to: 1 GB of data and 150 tables.

Default database engine: InnoDB on MariaDB 10.1

Manage databases at hxxp:databases.000webhost.com [nonactive]

Use localhost as connection hostname

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version

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.

applied fix : now 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 = 'nibogo:shoutBox'
AND install_stat' at line 2
File: /storage/ssd5/371/2075371/public_html/forum/Sources/Packages.php
Line: 246

then I switched back to the default theme .. still same error.

[haynus]

in case you may need this for reference to my problem, here is my Packages.php... thanks in Advance.

Fixed ...

manualy searched for all instances of this..

Code Select Expand


SELECT version, themes_installed, db_changes


Then replaced with this...

Code Select Expand


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


Thanks @Illori for putting me on the right track.
all is good now.