发生数据库错误 [英] A Database Error Occurred
问题描述
无法使用提供的设置连接到数据库服务器。
Unable to connect to your database server using the provided settings.
文件名:
C:\wamp\ www\bdwey-flowrank-f557ab5e422d\system\database\DB_driver.php
Filename: C:\wamp\www\bdwey-flowrank-f557ab5e422d\system\database\DB_driver.php
行号:124
数据库设置是否正确
$active_group = 'default';
$active_record = TRUE;
$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = 'sqlpass';
$db['default']['database'] = 'myDBName';
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;`
当从
中删除密码时$ $ db ['default'] ['password'] ='';
生成此错误
and when remove password from
$db['default']['password'] = '';
generate this error
发生数据库错误
A Database Error Occurred
错误号码:1017
找不到档案:'.\flowrank\use @ 0009rs.frm'(errno:22)
Can't find file: '.\flowrank\use@0009rs.frm' (errno: 22)
SELECT items.image, CONCAT(users.fname,' ',users.lname) AS full_user_name, competition.competition_id,competition.title,competition.votes FROM items AS items LEFT JOIN competitions AS competition ON competition.competition_id = items.competition_id LEFT JOIN users AS users ON competition.user_id = users.user_id GROUP BY items.competition_id ORDER BY items.votes ASC LIMIT 5
文件名:
C:\wamp\www\bdwey-flowrank-f557ab5e422d \system\database\ DB_driver.php
Filename: C:\wamp\www\bdwey-flowrank-f557ab5e422d\system\database\DB_driver.php
行号:330
问题在哪里? / p>
Where the problem?
推荐答案
看起来问题不是代码问题,而是您的MySQL服务器。
Looks like the problem is not a code problem but your MySQL server.
尝试修复您的mysql表。请在这里阅读: http://dev.mysql.com/ doc / refman / 5.0 / en / rebuilding-tables.html
Try repairing your mysql tables. Have a read here: http://dev.mysql.com/doc/refman/5.0/en/rebuilding-tables.html
这篇关于发生数据库错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!