Solved [WEB] - ZnoteAAC table to database (helpdesk)

[therrax]

Hi.
TFS 1.0
I have small problem with help desk
What should I add to my database to repair this?

string(89) "SELECT id,subject,creation,status FROM znote_tickets WHERE owner=1 ORDER BY creation DESC"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'db.znote_tickets' doesn't exist

Greets

 

[Thosh]

Is this helpdesk a plugin? If yes could you please paste me the link to the thread?


Nvm, paste following into the database SQL field:

CREATE TABLE IF NOT EXISTS `znote_tickets` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`owner` int(11) NOT NULL,
`username` varchar(32) CHARACTER SET latin1 NOT NULL,
`subject` text CHARACTER SET latin1 NOT NULL,
`message` text CHARACTER SET latin1 NOT NULL,
`ip` int(11) NOT NULL,
`creation` int(11) NOT NULL,
`status` varchar(20) CHARACTER SET latin1 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `znote_tickets_replies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tid` int(11) NOT NULL,
`username` varchar(32) CHARACTER SET latin1 NOT NULL,
`message` text CHARACTER SET latin1 NOT NULL,
`created` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

 

[therrax]

Thanks
@Thosh https://github.com/Znote/ZnoteAAC/commit/048794a3200dd0252f89ae5f1110688983407011

 

[Znote]

https://github.com/Znote/ZnoteAAC/blob/master/engine/database/connect.php#L227-246

 

[Thosh]

Found That yesterday, too, but was confused because I Downloaded the Version on otland First and didn't realised that there is a dev Version out.

 

[Demnish]

When you update Znote AAC, remember to always check https://github.com/Znote/ZnoteAAC first and foremost.
Btw, change title to "Solved", good luck on your project.

 

[therrax]

@Znote Why I cant write polish words in HelpDesk? Is it hard to repair? And why Admin cant close or delete ticket?

 

[Znote]

The helpdesk system was coded by https://github.com/RhuanGonzaga . Could be he forgot to code some of the functionality.