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

Please login to view replies.

Leaderboard (30 days)

Paul Frankowski

Paul Frankowski

Total Accepted Answers: 209
Sifat

Sifat

Total Accepted Answers: 66
Toufiq

Toufiq

Total Accepted Answers: 34
Pavel

Pavel

Total Accepted Answers: 5
R

rabiahshahad

Total Accepted Answers: 2

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