MyBB Community Forums

Full Version: how to install success MySEO plugin in new sql and mybb version
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
when i want to install MySEO plugin i receive many sql errors for NULL value and 
plugin not installed
plugin link https://community.mybb.com/mods.php?action=view&pid=359
Open inc/plugins/myseo.php and suppress folowing lines:
#87 : 'gid' => 'NULL',
(multiple): 'sid' => 'NULL',
(2024-02-20, 10:41 PM)Crazycat Wrote: [ -> ]Open inc/plugins/myseo.php and suppress folowing lines:
#87 : 'gid' => 'NULL',
(multiple): 'sid' => 'NULL',

SQL Error:

1364 - Field 'value' doesn't have a default value
Query:
INSERT INTO mybb_settings (name,title,description,optionscode,disporder,gid) VALUES ('miniDescripcion','Write a mini-description of your forum.','Write a mini-description of your forum, with a maximum of 65 characters. This limit can be exceeded if the title of the forum is short (the two together should not exceed 65 characters for correct visualization in search engines)','textarea','1',68)

(2024-02-20, 10:41 PM)Crazycat Wrote: [ -> ]Open inc/plugins/myseo.php and suppress folowing lines:
#87 : 'gid' => 'NULL',
(multiple): 'sid' => 'NULL',

SQL Error:

1366 - Incorrect integer value: 'no' for column crackfor_forum.mybb_settinggroups.isdefault at row 1
Query:
INSERT INTO mybb_settinggroups (name,title,description,disporder,isdefault) VALUES ('myseo','[Plugin MySEO] Settings of SEO OnPage','Configure your data for On-Page SEO.','1','no')


this error too
(2024-02-21, 12:32 AM)crackings Wrote: [ -> ]SQL Error:
1364 - Field 'value' doesn't have a default value
Query:
INSERT INTO mybb_settings (name,title,description,optionscode,disporder,gid) VALUES ('miniDescripcion','Write a mini-description of your forum.','Write a mini-description of your forum, with a maximum of 65 characters. This limit can be exceeded if the title of the forum is short (the two together should not exceed 65 characters for correct visualization in search engines)','textarea','1',68)
In each block $setting = array(...);, add 'value' => '', if there is no line beginning with 'value' in it.


(2024-02-21, 12:32 AM)crackings Wrote: [ -> ]SQL Error:
1366 - Incorrect integer value: 'no' for column crackfor_forum.mybb_settinggroups.isdefault at row 1
Query:
INSERT INTO mybb_settinggroups (name,title,description,disporder,isdefault) VALUES ('myseo','[Plugin MySEO] Settings of SEO OnPage','Configure your data for On-Page SEO.','1','no')

Replace line #92 'isdefault' => 'no' with 'isdefault' => 0
(2024-02-21, 09:34 AM)Crazycat Wrote: [ -> ]
(2024-02-21, 12:32 AM)crackings Wrote: [ -> ]SQL Error:
1364 - Field 'value' doesn't have a default value
Query:
INSERT INTO mybb_settings (name,title,description,optionscode,disporder,gid) VALUES ('miniDescripcion','Write a mini-description of your forum.','Write a mini-description of your forum, with a maximum of 65 characters. This limit can be exceeded if the title of the forum is short (the two together should not exceed 65 characters for correct visualization in search engines)','textarea','1',68)
In each block $setting = array(...);, add 'value' => '', if there is no line beginning with 'value' in it.


(2024-02-21, 12:32 AM)crackings Wrote: [ -> ]SQL Error:
1366 - Incorrect integer value: 'no' for column crackfor_forum.mybb_settinggroups.isdefault at row 1
Query:
INSERT INTO mybb_settinggroups (name,title,description,disporder,isdefault) VALUES ('myseo','[Plugin MySEO] Settings of SEO OnPage','Configure your data for On-Page SEO.','1','no')

Replace line #92 'isdefault' => 'no' with 'isdefault' => 0

thanks 
now plugin installed but inactive and when i click on activate
i receive this error page but i see settings and can modify in configuration
This page isn’t working

is currently unable to handle this request.
HTTP ERROR 500

but settings saved and just show in plugin configuration
when i check website description and keywords not added

@crazycat can you send fixed and installable file please
(2024-02-21, 09:34 AM)Crazycat Wrote: [ -> ]
(2024-02-21, 12:32 AM)crackings Wrote: [ -> ]SQL Error:
1364 - Field 'value' doesn't have a default value
Query:
INSERT INTO mybb_settings (name,title,description,optionscode,disporder,gid) VALUES ('miniDescripcion','Write a mini-description of your forum.','Write a mini-description of your forum, with a maximum of 65 characters. This limit can be exceeded if the title of the forum is short (the two together should not exceed 65 characters for correct visualization in search engines)','textarea','1',68)
In each block $setting = array(...);, add 'value' => '', if there is no line beginning with 'value' in it.


(2024-02-21, 12:32 AM)crackings Wrote: [ -> ]SQL Error:
1366 - Incorrect integer value: 'no' for column crackfor_forum.mybb_settinggroups.isdefault at row 1
Query:
INSERT INTO mybb_settinggroups (name,title,description,disporder,isdefault) VALUES ('myseo','[Plugin MySEO] Settings of SEO OnPage','Configure your data for On-Page SEO.','1','no')

Replace line #92 'isdefault' => 'no' with 'isdefault' => 0

?
Same

can not install