[NickoSLH]

Originally Posted by empereur

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.

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:

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:

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

news.user_added,

as example must see:

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');
. . .