lukasamd / MyBB-View_Unread_posts

View Unread Posts Plugin for MyBB

GNU General Public License v3.0

3 stars 7 forks source link

SQL Error #12

Closed thunderclap82 closed 7 years ago

thunderclap82 commented 7 years ago

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 commented 7 years ago

MyBB 1.6.x is not supported by this plugin.

lukasamd commented 7 years ago

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

lukasamd commented 7 years ago

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

thunderclap82 commented 7 years ago

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

thunderclap82 commented 7 years ago

I'm running MySQLi 5.7.17.

screen shot 2017-02-20 at 9 38 53 am

SvePu commented 7 years ago

@lukasamd - I've added a fix

13

thunderclap82 commented 7 years ago

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.

screen shot 2017-02-20 at 10 45 53 am

SvePu commented 7 years ago

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

SvePu commented 7 years ago

@thunderclap82 - Added template install fix to PR #13

thunderclap82 commented 7 years ago

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

SvePu commented 7 years ago

You're welcome!

lukasamd commented 7 years ago

@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 commented 7 years ago

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