ERROR IN MY SQL

[Ryan095]

im using tfs 1.2

I keep having a error for
[Error - mysql_store_result] Query: SELECT * FROM z_ots_guildcomunication
Message: Table 'fortera.z_ots_guildcomunication' doesn't exist

I have put this into my database and still getting the error

CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `login` 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 ;

 

[mengueh]

im using tfs 1.2

I keep having a error for
[Error - mysql_store_result] Query: SELECT * FROM z_ots_guildcomunication
Message: Table 'fortera.z_ots_guildcomunication' doesn't exist

I have put this into my database and still getting the error
CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`login` 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 ;

z_ots_guildcomunication' doesn't exist

You'r creating z_ots_comunication not z_ots_guildcomunication

 

[Ryan095]

okay i will try to try it diffrently

 

[Fablow]

CREATE TABLE `z_ots_guildcomunication` (
  `id` int(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` int(2) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

[Ryan095]

Probelem fixed!! Thanks

 

[Ryan095]

How do I show you pictures on here. I want to show you the error I'm getting in my console.
https://imgur.com/a/huXVs

 

[Znote]

How do I show you pictures on here. I want to show you the error I'm getting in my console.
https://imgur.com/a/huXVs

The text editor here allows for embedding images to posts if the image url directly links to the image.
Not direct: https://imgur.com/a/huXVs
Direct: https://i.imgur.com/pLm86Z8.png

Those errors does not seem to be related to mysql. The console seems to notify you when it parses items.xml that it has found unsupported attributes.