Joomla install SQL file (DB function failed with error number 1064)

原创 2011年01月10日 20:27:00

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

CACTI 不画图 ,报错 Poller[0] ERROR: SQL Assoc Failed,解决办法!

1、CACTI 不画图 类似报错 Poller[0] ERROR: SQL Assoc Failed!, Error:'1017' 2013年10月09日 14:30:06 ...
  • wangxiaofei2006
  • wangxiaofei2006
  • 2014-01-02 13:47:10
  • 8056

mysql error code '1064' 排查过程

下午自测代码,在这个update上卡了一个半小时,大大的降低了开发的生产力,把排查过程发出来,好的士兵不会掉进同一个陷阱。先把异常堆栈打出来。 2016-03-28 17:23:38.420 main...
  • bruce128
  • bruce128
  • 2016-03-28 18:02:59
  • 15828

mysql error:1064解决

症状:用创建表时用中文属性出现Error:1064。解决方法:中文属性不能设成VARCHAR,设成VARCHAR(45)或VARCHAR(100)等就可以建表了。当然mysql的默认charset已设...
  • shamaya
  • shamaya
  • 2007-07-26 15:17:00
  • 11134

joomla错误 Fatal error: Call to undefined function simplexml_load_file() 解决办法!

1.先说一下对于一些框架的bug调试的方法 前提是我们要安装php xdebug 然后打开程序的debug开关,看是否有错误日志打印出来 2.如果打开程序的debug还是空白页的话, ...
  • incloud_anke
  • incloud_anke
  • 2017-02-08 15:01:37
  • 1039

mysql 存储过程中limit(#1064 You have an error in your SQL syntax)

转载地址:点击打开链接 如下: delimiter //     create procedure getFNCommentView(         in pNoteID int,    ...
  • amohan
  • amohan
  • 2015-06-13 23:48:48
  • 1220

hibernate操作mysql无法实例到库中<mysql SQL Error: 1064, SQLState: 42000>

mysql SQL Error: 1064, SQLState: 42000
  • oJanus1
  • oJanus1
  • 2017-02-07 17:06:11
  • 1558

WARN: SQL Error: 1064, SQLState: 42000

WARN: SQL Error: 1064, SQLState: 42000 三月 30, 2017 6:18:05 下午 org.hibernate.engine.jdbc.spi.SqlExce...
  • J_mani
  • J_mani
  • 2017-03-30 18:18:47
  • 954

joomla查询数据库操作

$db = JFactory::getDbo(); //工厂模式获得JDatabaseDriver数据库实例 // Calculate number of guests and users ...
  • masofeng
  • masofeng
  • 2015-04-30 15:42:35
  • 1105

mysql创建存储过程时ERROR 1064 (42000)的解决办法

转载自:http://blog.chinaunix.net/uid-20263484-id-110165.html 郁闷了我半天,才发现mysql自作聪明的把;看成是procedure的结束...
  • ostar_liang
  • ostar_liang
  • 2014-10-31 16:52:32
  • 3587

完美解决 ERROR 1064 (42000): You have an error in your SQL syntax ... near …

在MySQL命令行使用sql语句进行建表时,MySQL 报错,这个问题之前遇到过几次,但是总是会因为疏忽又相遇,今天把这个问题写出来,加深印象吧。sql语句:CREATE TABLE 'lrs_aud...
  • jdjdndhj
  • jdjdndhj
  • 2017-04-19 16:23:48
  • 36650
收藏助手
不良信息举报
您举报文章:Joomla install SQL file (DB function failed with error number 1064)
举报原因:
原因补充:

(最多只允许输入30个字)