Illumina CMS help

When I got into my hotel's client
I get this error:

Quote:

---

LightCMS MySQLi Engine ErrorTable '(username).user_tickets' doesn't exist

---

anyone want to help me on this?
if this works then I can start running my
hotel and advise it (Unless one more error
come up again)

thanks.

Ian/GreenLink/Ian2458

It's pretty simple, isn't it?
The table 'user_tickets' doesn't exist, so you have to create it.

I'll send you the structure now for you x]

Code:

---

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;

---

Quote:

---

Originally Posted by Spheral

I'll send you the structure now for you x]

Code:

---

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;

---

---

I will try it.

OK!
I try it and now I'm getting this when
I pull the client up:

Quote:

---

There was no user found with your session ticket

---

Quote:

---

Originally Posted by Ian2458

I will try it.

OK!
I try it and now I'm getting this when
I pull the client up:

---

truncate the user tables or session tables

Quote:

---

Originally Posted by Stanleh

truncate the user tables or session tables

---

I don't know what that means.

No help? :(