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

关于Genymotion出现“An error occured while deploying the file.INSTALL_FAILED_INVALID_URI”问题的原因分析

一般出现这种问题的都是在用Genymotion神器的人,以前是APP开发直接把源码打包加载到Genymotion上,但是今天直接装apk的时候就不行了(直接将apk文件拖拽到Genymotion模拟器...
  • LC1356
  • LC1356
  • 2015年04月03日 10:29
  • 9116

MySQL5.7.10 初始化失败error(mysqld --initialize / mysql_install_db) 没有创建系统数据库(prematurely with errno= 32)

问题在一个备份机上创建多个数据库实例,以此同步部分正式环境的数据库,用于备份等其他用途。 mysql_install_db 命令:/usr/local/mysql5710/bin/mysql_inst...
  • saife
  • saife
  • 2016年04月12日 14:41
  • 13370

mongodb启动不了:child process failed, exited with error number 100

今天在启动mongodb的时候,发现起不来,报错:child process failed, exited with error number 100;发现—–> 然后去官方文档一查看,嗯??是的 ...

MongoDB错误1_启动mongodb时遇到child process failed,existed with error number 1错误

在进行安装配置mongodb实验时,按照以下的步骤进行:   启动mongodb: cd /usr/local/mongodb/mongodb/bin 进入每个mongodb节点的bin目录下 ./m...

mongodb启动不了:child process failed, exited with error number 100

原文链接mongodb启动不了:child process failed, exited with error number 100 http://f.dataguru.cn/thread-1073...

MongoDB错误2_启动mongodb时遇到child process failed,existed with error number 100错误

今天在启动mongodb的时候,发现起不来,报错:child process failed, exited with error number 100然后先去/var/log/mongo/mongo...

【Linux运维入门】MongoDb启动报错:ERROR: child process failed, exited with error number xx

解决启动报错问题今天启动服务器的MongoDb服务时报错 出现这种错误的原因:大部分是因为mongodb 服务的不正常关闭,导致mongod 被锁,想想可能是上次服务器断电维护时,没有手动关闭Mong...

mongodb启动时报错ERROR: child process failed, exited with error number 1

转 http://www.cnblogs.com/zlslch/p/6932368.html     不多说,直接上干货!         root@zhouls-virtual-machine...

Installation error: INSTALL_FAILED_CONFLICTING_PROVIDER

Installation error: INSTALL_FAILED_CONFLICTING_PROVIDER

关于Installation error: INSTALL_FAILED_INSUFFICIENT_STORAGE的报错的最有效的解决方法

好久没有在真的Android机子上运行程序了,
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:Joomla install SQL file (DB function failed with error number 1064)
举报原因:
原因补充:

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