SQL Error

[thunderclap82]

I deactivated the plugin the install the 1.6 update, and when I went to activate it I keep getting the following error:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1366 - Incorrect integer value: 'NULL' for column 'gid' at row 1
Query:
INSERT INTO mybb_settinggroups (`gid`,`name`,`title`,`description`,`disporder`,`isdefault`) VALUES ('NULL','unreadPosts','View Unread Posts','Settings for plugin \"View Unread Posts\"',105,'0')

Any ideas how to resolve this?

I'm running MyBB 1.8.10 on Ubuntu 16.04 and PHP7.

[lukasamd]

MyBB 1.6.x is not supported by this plugin.

[lukasamd]

Sorry, do you mean plugin 1.6 version, or MyBB 1.6?

[lukasamd]

And what database do you use (type and version)?

[thunderclap82]

I amended my first post. Plugin version 1.6 on MyBB 1.8.10. The server is running Ubuntu 16.04 with PHP7.

[thunderclap82]

I'm running MySQLi 5.7.17.

[SvePu]

@lukasamd - I've added a fix
#13

[thunderclap82]

Thank you for such a quick investigation into this. Unfortunately, I just tried installing the new version you posted here and the error is still showing.

[SvePu]

@thunderclap82 - this is from another file ... I'll take a look

[SvePu]

@thunderclap82 - Added template install fix to PR #13

[thunderclap82]

That did it. Thank you so much for your quick turnaround.

[SvePu]

You're welcome!

[lukasamd]

@SvePu Thanks for very fast help for other user. I will fix it, but I don't want change my code structure and convention, so I must reject that merge request.

[SvePu]

@lukasamd - no problem.....it's your party ;)