Support Forums

Support Offline : Mon - Fri / 10am - 6pm (GMT +6)

Your Time: Our Time:

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 '' at line 2

Featured Lock Resolved Bug
I am trying to install the sp_lms extension to my site http://www.ebeing.net and get the above error while trying to do so. The full response is: JInstaller: :Install: Error SQL 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 '' at line 2
Extension Update: SQL error processing query: DB function failed with error number 1064
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 '' at line 2
SQL =
IF NOT EXISTS(SELECT NULL FROM `#__splms_certificates` WHERE COLUMN_NAME = 'issue_date') THEN
ALTER TABLE `#__splms_certificates` ADD issue_date date DEFAULT NULL;

This is from com_splms_fullpacksge_v3.2.zip though older versions also give the same error.

1 Answers

Toufiq - Staff

More than a month ago #Permalink
Hi there,

The LMS was installed in your site before? Please let me know. If yes, please send me the database access & Joomla administrator access via PM. Maybe there are some tables name conflicts.

-Thanks


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Leaderboard (30 days)

Paul Frankowski

Paul Frankowski

Total Accepted Answers: 106
Sifat

Sifat

Total Accepted Answers: 102
Toufiq

Toufiq

Total Accepted Answers: 41
Pavel

Pavel

Total Accepted Answers: 4
J

johnny

Total Accepted Answers: 3

100+

Templates

200,000+

Community Users

Newsletter

Don’t miss any updates of our new templates and extensions and all the astonishing offers we bring for you.
We never spam

Joomla! ® name is used under a limited license from Open Source Matters in the United States and other countries. JoomShaper.com is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.

Connect Us