SQLSTATE

Hi Carlos,

Is this a new 1.6.2 installation? When do you get this message?
On 18 Jul 2014 16:02, "Carlos Costa" <email address hidden>
wrote:

> New question #251842 on Xibo:
> https://answers.launchpad.net/xibo/+question/251842
>
> what is this error:
>
> SQLSTATE[42S02]: Base table or view not found: 1146 Table
> 'admin_digital.lkdatasetlayout' doesn't exist
>
>
>
>
>
> --
> You received this question notification because you are a member of Xibo
> Developers, which is an answer contact for Xibo.
>

There was a problem with the installation files for fresh installs - if you can, you will need to run this SQL in phpmyadmin or similar:

ALTER TABLE `dataset` ADD `LastDataEdit` INT NOT NULL DEFAULT '0';

CREATE TABLE IF NOT EXISTS `lkdatasetlayout` (
  `LkDataSetLayoutID` int(11) NOT NULL AUTO_INCREMENT,
  `DataSetID` int(11) NOT NULL,
  `LayoutID` int(11) NOT NULL,
  `RegionID` varchar(50) NOT NULL,
  `MediaID` varchar(50) NOT NULL,
  PRIMARY KEY (`LkDataSetLayoutID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

hello, yes is in 1.6.2 version... when i try to schedule a presentation...

where i can run in phpmyadmin?

Do you have Xibo running on your own machine or on some hosting? If you are using XAMPP/WAMP then phpmyadmin is usually on http://yourmachinename/phpmyadmin/

Seeing as this was entirely my fault, i'd be happy to help you out if you can give me access to your Server machine (send details to <email address hidden> - not on here)

Hi Dan,

I had the same problem, is ok now!!!

Best regards,
Marius

PS. I like your team work and this project