Do someone know this error?

[Druiden Keso]

[08/04/2014 17:05:27] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM "z_ots_comunication" WHERE "type" = 'login'


Iam using Sqlite!

 

[WibbenZ]

Add this query:

CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`type` varchar(255) NOT NULL,
`action` varchar(255) NOT NULL,
`param1` varchar(255) NOT NULL,
`param2` varchar(255) NOT NULL,
`param3` varchar(255) NOT NULL,
`param4` varchar(255) NOT NULL,
`param5` varchar(255) NOT NULL,
`param6` varchar(255) NOT NULL,
`param7` varchar(255) NOT NULL,
`delete_it` int(2) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=230 ;

 

[Druiden Keso]

Add this query:

CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`type` varchar(255) NOT NULL,
`action` varchar(255) NOT NULL,
`param1` varchar(255) NOT NULL,
`param2` varchar(255) NOT NULL,
`param3` varchar(255) NOT NULL,
`param4` varchar(255) NOT NULL,
`param5` varchar(255) NOT NULL,
`param6` varchar(255) NOT NULL,
`param7` varchar(255) NOT NULL,
`delete_it` int(2) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=230 ;

Error while executing query: near "AUTO_INCREMENT": syntax error

 

[WibbenZ]

Error while executing query: near "AUTO_INCREMENT": syntax error

CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`type` varchar(255) NOT NULL,
`action` varchar(255) NOT NULL,
`param1` varchar(255) NOT NULL,
`param2` varchar(255) NOT NULL,
`param3` varchar(255) NOT NULL,
`param4` varchar(255) NOT NULL,
`param5` varchar(255) NOT NULL,
`param6` varchar(255) NOT NULL,
`param7` varchar(255) NOT NULL,
`delete_it` int(2) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

That one workes for me.


Edit:
Oh you are using SQLite, I think there is a diffrent query for that. But you can not use a webpage and sqlite I think. Either remove the dirr/data/globalevents/scripts/shop.lus and the xml line or start using MySQL.

 

[Ninja]

CREATE TABLE `z_ots_comunication` (
   `id` INTEGER(11) NOT NULL,
   `name` VARCHAR(255) NOT NULL,
   `type` VARCHAR(255) NOT NULL,
   `action` VARCHAR(255) NOT NULL,
   `param1` VARCHAR(255) NOT NULL,
   `param2` VARCHAR(255) NOT NULL,
   `param3` VARCHAR(255) NOT NULL,
   `param4` VARCHAR(255) NOT NULL,
   `param5` VARCHAR(255) NOT NULL,
   `param6` VARCHAR(255) NOT NULL,
   `param7` VARCHAR(255) NOT NULL,
   `delete_it` INTEGER(2) NOT NULL DEFAULT '1',
   PRIMARY KEY (`id`)
)

 

[Druiden Keso]

CREATE TABLE `z_ots_comunication` (
   `id` INTEGER(11) NOT NULL,
   `name` VARCHAR(255) NOT NULL,
   `type` VARCHAR(255) NOT NULL,
   `action` VARCHAR(255) NOT NULL,
   `param1` VARCHAR(255) NOT NULL,
   `param2` VARCHAR(255) NOT NULL,
   `param3` VARCHAR(255) NOT NULL,
   `param4` VARCHAR(255) NOT NULL,
   `param5` VARCHAR(255) NOT NULL,
   `param6` VARCHAR(255) NOT NULL,
   `param7` VARCHAR(255) NOT NULL,
   `delete_it` INTEGER(2) NOT NULL DEFAULT '1',
   PRIMARY KEY (`id`)
)

Thanks!