# 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.

Good luck~~

btw, here is another reference link, maybe useful:

http://forum.joomla.org/viewtopic.php?p=1267578

• 本文已收录于以下专栏：

举报原因： 您举报文章：Joomla install SQL file (DB function failed with error number 1064) 色情 政治 抄袭 广告 招聘 骂人 其他 (最多只允许输入30个字)