SQL Syntax Error

SQL Syntax Error

by Julia Kulla-Mader -
Number of replies: 1

I keep getting an error with my SQL syntax. I was able to install Moodle once on my server before having a different problem. Now, I can't get to that stage. What do I do to fix a SQL syntax error easily? Below is what I keep getting.

Thanks,

Julia

(mysql): INSERT INTO kullamader_com_-_log_display VALUES ('course', 'user report', 'user', 'CONCAT(firstname, " ", lastname)')  

1064: You have an error in your SQL syntax near '-_log_display VALUES ('course', 'user report', 'user', 'CONCAT(firstname," ",las' at line 1
      
  
Average of ratings: -
In reply to Julia Kulla-Mader

Re: SQL Syntax Error

by Martin Dougiamas -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers
Your database table prefix (in your config.php file) seems to be "kullamader_com_-_" ... which is very strange.  Try something simpler like "kull_".
Average of ratings: -