Revcms Housekeeping help

[StreetMoney]

I go on my housekeeping page and this what i see



Table 'grove1.cms_housekeeping_logs' doesn't exist

What do i do here? please anyone can help

 

[DrPepper]

Need to find the SQL for creating table cms_housekeeping_logs then need to add it to grove1 database

 

[Lionches]

It's telling you that the table doesn't exist in your database.

 

[StreetMoney]

I think i need to create one because its not in the grove1 database what sql code do i put?

...

 

[DaLightz]

Edit your hk config to your database details.

 

[StreetMoney]

It still pops up?

 

[DaLightz]

It still pops up?

Then that table isn't present in your database. Try to refer to where you got the hk from, and ask for an sql for the missing tables.

 

[TyleRJc]

CREATE TABLE IF NOT EXISTS `cms_housekeeping_logs` (
    `id` int(11) NOT NULL auto_increment,
    `staff_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `page` varchar(999) NOT NULL,
    `note` text NOT NULL,
    `ip` varchar(999) NOT NULL,
    `timestamp` int(11) NOT NULL,
    PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

Run that into your database.

 

[DaLightz]

CREATE TABLE IF NOT EXISTS `cms_housekeeping_logs` (
    `id` int(11) NOT NULL auto_increment,
    `staff_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `page` varchar(999) NOT NULL,
    `note` text NOT NULL,
    `ip` varchar(999) NOT NULL,
    `timestamp` int(11) NOT NULL,
    PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

Run that into your database.

This.

 

[StreetMoney]

Lool Now it says

Unknown column 'userid' in 'field list'

 

[Lionches]

Lool Now it says

Unknown column 'userid' in 'field list'

Delete it, if you're not using it.

 

[StreetMoney]

i do wanna use the hk its just that

 

[TyleRJc]

Use this SQL then.

CREATE TABLE IF NOT EXISTS `cms_housekeeping_logs` (
    `id` int(11) NOT NULL auto_increment,
    `staff_id` int(11) NOT NULL,
    `userid` int(11) NOT NULL,
    `page` varchar(999) NOT NULL,
    `note` text NOT NULL,
    `ip` varchar(999) NOT NULL,
    `timestamp` int(11) NOT NULL,
    PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

(Yes, it has changed. userid was user_id)

 

[StreetMoney]

Sorry for the inconvience This is what poped up Unknown column 'extra_data' in 'field list'

 

[iExplicit]

Run this query

DROP TABLE IF EXISTS `cms_housekeeping_logs`;
CREATE TABLE `cms_housekeeping_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) DEFAULT NULL,
  `ip_address` varchar(125) DEFAULT NULL,
  `page` varchar(50) DEFAULT NULL,
  `time` varchar(75) DEFAULT NULL,
  `extra_data` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=306 DEFAULT CHARSET=latin1;

 

[Jeffrey]

The Original SQL File was deleted but it's quite easy to replicate it. Use the Above SQL and it should be running smooth and secure.
None the less remember to run my sql if you havent for housekeeping pin!

 

[Jerry]

Lmao, bumping a thread from two years ago.

 

[Jeffrey]

Lmao, bumping a thread from two years ago.

Lol, But this still will count because The Original SQLS For Sledmore's Release were removed. This will still help other people

 

[Jerry]

Lol, But this still will count because The Original SQLS For Sledmore's Release were removed. This will still help other people

Yeah, I know.

 

[Zvo]

Anyone know the problem to this ;

You must be registered for see links

after I log in i get that