Simple Machines Community Forum

SMF Support => Server Performance and Configuration => Topic started by: filipdimovski on May 14, 2017, 09:56:56 AM

Title: You have an error in your SQL syntax; check the manual that corresponds to your
Post by: filipdimovski on May 14, 2017, 09:56:56 AM
help me what is 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 smf_log_packages
WHERE package_id = '[SiNaN]:SimplePortal'
AND install' at line 2
File: /storage/h13/759/1667759/public_html/Sources/Packages.php
Line: 248
Title: Re: You have an error in your SQL syntax; check the manual that corresponds to your
Post by: Kindred on May 14, 2017, 10:31:20 AM
Are you using mariaDB?
Title: Re: You have an error in your SQL syntax; check the manual that corresponds to your
Post by: filipdimovski on May 14, 2017, 10:32:51 AM
lol whats that idk
Title: Re: You have an error in your SQL syntax; check the manual that corresponds to your
Post by: Kindred on May 14, 2017, 10:36:02 AM
It's the database. Check with your host...

Smf officially supports mysql, postgre and sqlite.
MariaDb  can be used, but requires some code changes
Title: Re: You have an error in your SQL syntax; check the manual that corresponds to your
Post by: filipdimovski on May 14, 2017, 10:40:16 AM
how can i check that i made the forum from 000webhost
Title: Re: You have an error in your SQL syntax; check the manual that corresponds to your
Post by: Illori on May 14, 2017, 11:01:34 AM
Kindred, the error message answers your question.

take a look at https://www.simplemachines.org/community/index.php?topic=553821.0 to fix the issue at hand.
Title: Re: You have an error in your SQL syntax; check the manual that corresponds to your
Post by: filipdimovski on May 14, 2017, 11:15:29 AM
still cant fix at line 845
Title: Re: You have an error in your SQL syntax; check the manual that corresponds to your
Post by: Arantor on May 14, 2017, 11:19:27 AM
I think you need to read all of that thread, there's several places that need changing which should all be done.

If you still have issues please provide the full error message you get.
Title: Re: You have an error in your SQL syntax; check the manual that corresponds to your
Post by: filipdimovski on May 14, 2017, 11:21:15 AM
oh i fixed it close it
Title: Re: You have an error in your SQL syntax; check the manual that corresponds to your
Post by: Colin on May 14, 2017, 12:05:25 PM
Done.