Joomla install SQL file (DB function failed with error number 1064)
Starting to learn Joomla recently, and here is a self-tutorial.
I tried the "Hello world" component. at first, it runs ok, but after i tried to add on the database, it always shows error:
SQL error... DB function failed with error number 1064.
(here is the tutorial link: http://docs.joomla.org/Developing_a_Model-View-Controller_Component_-_Part_3_-_Using_the_Database)
At first, I could not find out where is the error because I had compare with my install.sql with the example word by word. they are exactly the same.
Here is my own install.sql:
this is the example install.sql:
but finally I realized where is the error:
the first line after "DROP TABLE IF EXISTS", the single quotation mark.
it must be `#__hello`, cannot be '#__hello '.
it took me almost 2 hours to find it out this 'error', hope it will help.
btw, here is another reference link, maybe useful: