Quote:
Originally Posted by empereur
Code:
A Database Error Occurred
Error Number: 1146
Table 'demo.rules' doesn't exist
SELECT * FROM (`rules`) ORDER BY `rule_order` asc
|
if you right looking, then you see, that the table "rules" fail in your database.
Code:
CREATE TABLE IF NOT EXISTS `rules` (
`id` int(11) NOT NULL auto_increment,
`rule_order` int(11) NOT NULL,
`rule_data` text NOT NULL,
PRIMARY KEY (`id`)
) ;
little fixes:
for rules problem, add in database:
Code:
CREATE TABLE IF NOT EXISTS `rules` (
`id` int(11) NOT NULL auto_increment,
`rule_order` int(11) NOT NULL,
`rule_data` text NOT NULL,
PRIMARY KEY (`id`)
) ;
for profile display problem:
Code:
ALTER TABLE users ADD avatar VARCHAR(100) NOT NULL DEFAULT '';
for news display problem:
edit file
./Brightswitch/application/models/news_model.php
and add in line
57 the missing entry
as example must see:
Code:
public function get_news()
{
$this->db->select('news.id, news.news_title, news.news_content, news.date_added, news.user_added, users.username')
->join('users', 'users.id = news.user_added')
->order_by('news.id', 'desc');
$query = $this->db->get('news');
. . .