Doesn't work with PostgreSQL

[davwheat]

When trying to install the plugin, I run into the following error.

SQL Error:
0 - ERROR: syntax error at or near "NOT" LINE 1: CREATE TABLE IF NOT EXISTS `mybb_fc_forms` (
^
Query:
CREATE TABLE IF NOT EXISTS `mybb_fc_forms` ( `formid` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `active` tinyint(1) NOT NULL, `fid` int(11) NOT NULL, `tid` int(11) NOT NULL, `overridebutton` tinyint(1) NOT NULL, `class` varchar(255) DEFAULT NULL, `subjecttemplate` varchar(255) DEFAULT NULL, `messagetemplate` text DEFAULT NULL, `settings` text NOT NULL, PRIMARY KEY (`formid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[burnacid]

Sorry the plugin is not fully compatible with postgresql.

[davwheat]

You ought to update your requirements page then. https://github.com/burnacid/MyBB-Form-Creator/wiki/Getting-Started
PHP >= 5.6.0
MySQL >= 5.5, PostgreSQL >= 8.1 or SQLite >= 3

[burnacid]

Done sorry for the inconvenience. Will check if I find the time if I can fix this.

[davwheat]

Is there any chance it can be ported to work with PostgreSQL? I'd happily help to do this if you tell me what'd need to be changed.

[burnacid]

Ofcourse it is possible. I'm not well known with Postgresql. So I need to review what they do differently. Everything already uses the standard MyBB Datahandler for database which should it make easier. It now fails on creating of the tables for some reason. Not sure what part of the create table statement it doesn't accept. Again time is my issue sadly

[davwheat]

Okay. I'll look through the code and try to get it working on PostgreSQL.

…

On Thu, 19 Jul 2018, 21:31 Stefan Lenders, ***@***.***> wrote: Ofcourse it is possible. I'm not well known with Postgresql. So I need to review what they do differently. Everything already uses the standard MyBB Datahandler for database which should it make easier. It now fails on creating of the tables for some reason. Not sure what part of the create table statement it doesn't accept. Again time is my issue sadly — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#96 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AHEE5u4fWb2jujHg6UqAGMw7bd80JfGzks5uIOyMgaJpZM4VRyKJ> .