IlluminaCMS [HELP]

[1901]

Don't get me wrong, after working on Illumina CMS for a while now over the years slowly editing it - it proved to be a good CMS.
The client.. Not so sure.

Now.. I may seem a 'noob' asking these questions. However, I am currently using localhost to test the cms before releasing and keep encountering this issue on client.

LightCMS MySQLi Engine Error
Table 'hotel.user_tickets' doesn't exist


Anyone got a 'noob friendly' method on how to fix? I haven't worked on retros in a while and I was never too great at fixing things anyway.

If you could reply ASAP, i would appreciate the help.

 

[Wickd]

What emulator are you using?

 

[Cameron]

Butterfly emulator, as it is suitable for Illumina.

 

[Wickd]

Butterfly emulator, as it is suitable for Illumina.

Um run this SQL.

CREATE TABLE IF NOT EXISTS `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;

 

[Cameron]

Ok will get Ben to try this, thanks for the help.