Illuminia CMS help

[Ian2456]

Got this error when looking at staff members:

LightCMS MySQLi Engine Error
Unknown column 'position' in 'field list'

Also got this error when pulling up the client:

Table 'u929765734_hotel.user_tickets' doesn't exist

In profile:

LightCMS MySQLi Engine Error
Unknown column 'block_trade' in 'field list'

 

[Evilsmoothie]

Try:
ALTER table users ADD column position VARCHAR(999);
ALTER table users ADD column block_trade INT(1);

Try to create a table called user_tickets in your database and see which errors comes up next.

 

[Ian2456]

I got it.

closed please.

 

[Evilsmoothie]

I got it.

closed please.

Would be nice if you posted your solution if others got the same problem.

 

[Ian2456]

this user said:

DROP TABLE IF EXISTS `user_tickets`;
CREATE TABLE `user_tickets` (
`userid` int(10) unsigned NOT NULL,
`sessionticket` varchar(100) NOT NULL,
`ipaddress` varchar(20) NOT NULL,
PRIMARY KEY (`sessionticket`,`ipaddress`),
UNIQUE KEY `index_id` (`userid`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=latin1;