[Help] RevCMS House Keeping error

[Matthewza]

Hi,

Everytime I enter my username and password I get this sql error. Unknown column 'userid' in 'field list', I can't figure out how to fix this.

 

[Detox]

check if the userid is in the column of the database

 

[Matthewza]

check if the userid is in the column of the database

There is no userid column in the database. Would this fix it?

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;

 

[RyanzRetros]

Is this housekeeping or registration?

 

[Matthewza]

Housekeeping, every time I type my username and password I get the error.

 

[RyanzRetros]

Ok, can you do this format?
Error:
Emulator:
Screenshot of the error:

Thanks.

 

[Matthewza]

You must be registered for see links

Phoenix

 

[RyanzRetros]

Ok. Try going to field list (IDK which table but users, or a housekeeping one) and deleting 'user_id'.

 

[Matthewza]

Isn't there a mysql query to do to remove user_id

 

[RyanzRetros]

Isn't there a mysql query to do to remove user_id

I am not the best with SQL's but creating off the top of my head, try this:
UPDATE FIELD `field list` DELETE `user_id`;
Most likely wont work so just post error...

 

[Matthewza]

gives me a white blank page

 

[RyanzRetros]

gives me a white blank page

Clear cache?? Glad the SQL worked though. Make sure all links are connected and housekeeping works... Also, make sure to have filled in "databaseconfig.php"

 

[Matthewza]

When I cleared my cache it gave me user_id error again....

 

[RyanzRetros]

When I cleared my cache it gave me user_id error again....

mmmmmmm... SQL ran correctly?

 

[Yadz]

A table in your database is missing the column 'userid'. Not sure which one tho.

 

[Matthewza]

A table in your database is missing the column 'userid'. Not sure which one tho.

Oh man :/

mmmmmmm... SQL ran correctly?

Nope gave me an error right after I inserted the query

 

[RyanzRetros]

Oh man :/



Nope gave me an error right after I inserted the query

Then tell em the error so I am able to fix it?

 

[Yadz]

Oh man :/



Nope gave me an error right after I inserted the query

Check the PHP files in your hk folder. You should find the right table.

 

[RyanzRetros]

AFK - RECREATING THE CLASS.TEMPLATE.PHP AND CONFIG.PHP FILE

Good luck.