Precise Similar Topics

Bug in 1.4.0 Creating/Updating Forums - Precise Similar Topics

Bug in 1.4.0 Creating/Updating Forums

by M.O.B. » Tue Jan 03, 2017 8:27 pm

I am currently having an issue with my phpBB 3.1.10 forum.

After updating this extension, I cannot create a new subforum. I get this error:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Field 'similar_topic_forums' doesn't have a default value [1364]
Please let me know how to fix this? The only solution I think I can do is disable/delete the data of this extension and then perhaps reinstall the older version prior to 1.4.0 update, since that one didn't cause me this issue.

UPDATE:

I can confirm after disabling and deleting the data I was able to create my subforum. First I tried disabling the extension, but that didn't help.

Please advise.

UPDATE 2:

After I reinstalled the extension, I tried to create a new test subforum, and got the same error. So I can now confirm there is something wrong with the 1.4.0 update. :(

UPDATE 3:

Reverted to 1.3.2 and that one allows me to create new subforums without an issue.

P.S. what's with the double spacing for each paragraph above? The new forum software [3.2.x] may have bugs -- it creates two <br />. :)
Image
User avatar
M.O.B.
Registered User
Posts: 927
Joined: Tue Jan 04, 2005 1:07 am
Location: San Diego CA USA
Contact:

Re: Bug in 1.0.4 ?

by VSE » Wed Jan 04, 2017 12:26 am

Yep that's a bug. Gonna need to submit another update. (The fix is to simply change the similar_topic_forums column in the forums table to allow NULL).

PS: We are aware of the issues posting in titania.
Dictated but not read.
Official phpBB Extensions My Extensions & MODs
Please do not PM me for support.
User avatar
VSE
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 4882
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Contact:

Error Creating Category or Forum on a fresh install

by PhilDiscuss » Mon Jan 09, 2017 2:20 pm

Hello,

My bad. I posted somewhere, :)
viewtopic.php?f=466&t=2400501

Please take a look

Version: 1.4.0
tblprfx=pldscss_


Thank you
Professionally develop phpBB Premium Style and Extension.

The Philippines Discussions Website
PhilDiscuss
Registered User
Posts: 155
Joined: Fri Aug 19, 2016 8:44 am
Contact:

Anyone try creating a new forum with ext active on 3.2 yet?

by kaspir » Sun Jan 15, 2017 1:52 pm

Because I get this:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Field 'similar_topic_forums' doesn't have a default value [1364]

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 999
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/includes/acp/acp_forums.php
LINE: 1149
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/includes/acp/acp_forums.php
LINE: 199
CALL: acp_forums->update_forum_data()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_forums->main()

FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()
World of Phaos RPG online is making it's come back! Play free now!
Check out phpBB contributions & extension downloads. :P
kaspir
Registered User
Posts: 203
Joined: Sun Jul 27, 2008 5:05 am
Name: Greg
Contact:

SQL Error when creating a new forum

by takufner » Mon Jan 16, 2017 8:55 pm

Hello,

I use this extension a lot :) Thanks for the good job, it is amazing!

Doing some administration in my forum, I tried to create a new forum. There was an error! And it looks like it is related to this extension:

Code: Select all

 SQL ERROR [ mysqli ]

Field 'similar_topic_forums' doesn't have a default value [1364]

SQL

INSERT INTO phpbb_forums (parent_id, forum_type, forum_status, forum_parents, forum_name, forum_link, forum_desc, forum_desc_uid, forum_desc_options, forum_desc_bitfield, forum_rules, forum_rules_uid, forum_rules_options, forum_rules_bitfield, forum_rules_link, forum_image, forum_style, display_subforum_list, display_on_index, forum_topics_per_page, enable_indexing, enable_icons, enable_prune, enable_shadow_prune, prune_days, prune_viewed, prune_freq, prune_shadow_days, prune_shadow_freq, forum_recent_topics, forum_allow_solve, forum_allow_unsolve, forum_lock_solved, forum_solve_text, forum_solve_color, forum_options, forum_flags, left_id, right_id) VALUES (0, 0, 0, '', 'Comunicação com Usuários', '', 'Este fórum é o local para a comunicação da administração do fórum com os usuários da comunidade e também para uma comunicação geral mútua dos usuários.', '', 7, '', '', '', 7, '', '', '', 0, 1, 0, 0, 1, 0, 0, 0, 7, 7, 1, 7, 1, 1, 1, 1, 0, '', '', 0, 48, 79, 80)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 852
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/includes/acp/acp_forums.php
LINE: 1141
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/includes/acp/acp_forums.php
LINE: 199
CALL: acp_forums->update_forum_data()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: acp_forums->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
First I disabled this extension and tried to create the forum again. No success.

After disabling AND deleting the data from the extension that I was able to create the forum.

Is this something related to my own MySQL configuration?

Kind regards,
User avatar
takufner
Registered User
Posts: 209
Joined: Mon Oct 23, 2006 10:39 am
Location: Rio de Janeiro - Brasil
Name: Prof. Caju
Contact:

Re: Bug in 1.0.4 Creating/Updating Forums

by Binano » Wed Jan 18, 2017 12:33 pm

I have the same thing :cry:

Code: Select all

Erreur générale
SQL ERROR [ mysql4 ]

Field 'similar_topic_forums' doesn't have a default value [1364]

SQL

INSERT INTO phpbb_forums (parent_id, forum_type, forum_status, forum_parents, forum_name, forum_link, forum_desc, forum_desc_uid, forum_desc_options, forum_desc_bitfield, forum_rules, forum_rules_uid, forum_rules_options, forum_rules_bitfield, forum_rules_link, forum_image, forum_style, display_subforum_list, display_on_index, forum_topics_per_page, enable_indexing, enable_icons, enable_prune, enable_shadow_prune, prune_days, prune_viewed, prune_freq, prune_shadow_days, prune_shadow_freq, forum_recent_topics, forum_options, forum_flags, left_id, right_id) VALUES (9, 1, 0, '', 'Tests et retours', '', 'Tests matériels, retours, avis et reviews réalisés par les membres du forum.', '', 7, '', '', '', 7, '', '', 'images/forumicons/tests_retours.png', 0, 1, 0, 0, 1, 0, 0, 0, 7, 7, 1, 7, 1, 1, 0, 112, '41', 42)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysql.php
LINE: 181
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysql->sql_query()

FILE: [ROOT]/includes/acp/acp_forums.php
LINE: 1141
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/includes/acp/acp_forums.php
LINE: 199
CALL: acp_forums->update_forum_data()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: acp_forums->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
User avatar
Binano
Registered User
Posts: 58
Joined: Thu Jun 25, 2015 9:24 am
Contact:

Re: Bug in 1.4.0 Creating/Updating Forums

by Nully » Sat Jan 28, 2017 6:29 pm

I have same error :

Code: Select all

Erreur générale
SQL ERROR [ mysqli ]

Field 'similar_topic_forums' doesn't have a default value [1364]
Nully
Registered User
Posts: 453
Joined: Thu Jan 29, 2009 10:11 pm
Location: France
Contact:

Re: Bug in 1.4.0 Creating/Updating Forums

by deanmoke » Sat Jan 28, 2017 10:58 pm

VSE's fix above worked for me.
Dean
deanmoke
Registered User
Posts: 23
Joined: Tue May 20, 2008 9:05 am
Contact:

Re: Bug in 1.4.0 Creating/Updating Forums

by Nully » Sun Jan 29, 2017 7:58 am

I see the fix now)
Anyway I don't know how to
change the similar_topic_forums column in the forums table to allow NULL
To create new category and forum I uninstalled extension, cleared data. Then I installed again extension.
The strange thing is that on local forum with Wampserver I did not have this problem.
Nully
Registered User
Posts: 453
Joined: Thu Jan 29, 2009 10:11 pm
Location: France
Contact:

Re: Bug in 1.4.0 Creating/Updating Forums

by Galixte de EzCom » Mon Jan 30, 2017 9:58 pm

The 1.4.1 version in development is here: https://github.com/VSEphpbb/similartopics.
Communau EzCom
📖 « Traductions d’extensions & styles pour phpBB 3.1.x & 3.2.x ».
📋 Lists of all extensions identified for phpBB 3.1.x & 3.2.x.
📋 Lists of all styles identified for phpBB 3.1.x & 3.2.x.
Image Tu as un forum et tu veux aussi un site web ? Regarde par ici.
User avatar
Galixte de EzCom
Registered User
Posts: 1028
Joined: Mon Oct 04, 2004 11:14 pm
Location: France
Name: Raphaël M.
Contact:

Field 'similar_topic_forums' doesn't have a default value

by pierredu » Tue Jan 31, 2017 9:05 am

Hello,

Version 3.2.0

When trying to add a forum to a test board, I get following error :
Field 'similar_topic_forums' doesn't have a default value [1364]

I tried to put 0 and NULL in the column definition, but this is not the solution.

Any clues ?
User avatar
pierredu
Registered User
Posts: 930
Joined: Thu Nov 01, 2012 8:04 am
Location: Paris (France)
Contact:

Re: Bug in 1.4.0 Creating/Updating Forums

by 1nv1s1bl3 » Fri Feb 03, 2017 9:50 am

Galixte de EzCom wrote:The 1.4.1 version in development is here: https://github.com/VSEphpbb/similartopics.
Indeed. It works fine on 1.4.1.
1nv1s1bl3
Registered User
Posts: 115
Joined: Fri Nov 26, 2010 11:03 am
Contact:

Re: Bug in 1.4.0 Creating/Updating Forums

by John connor » Wed Feb 15, 2017 1:55 pm

N/M
User avatar
John connor
Registered User
Posts: 2179
Joined: Fri Nov 14, 2014 5:14 pm
Location: U S Of A
Name: Aaron
Contact:

Can't create new forum when the extension is installed

by jstMusa » Thu May 04, 2017 1:10 pm

After installing this extension I cannot create a new forum. It gives me the error below;

Code: Select all

SQL ERROR [ mysqli ]

Field 'similar_topic_forums' doesn't have a default value [1364]

SQL

INSERT INTO phpbb_forums (parent_id, forum_type, forum_status, forum_parents, forum_name, forum_link, forum_desc, forum_desc_uid, forum_desc_options, forum_desc_bitfield, forum_rules, forum_rules_uid, forum_rules_options, forum_rules_bitfield, forum_rules_link, forum_image, forum_style, display_subforum_list, display_on_index, forum_topics_per_page, enable_indexing, enable_icons, enable_prune, enable_shadow_prune, prune_days, prune_viewed, prune_freq, prune_shadow_days, prune_shadow_freq, forum_recent_topics, forum_options, forum_flags, left_id, right_id) VALUES (3, 1, 0, '', 'Good', '', '', '', 7, '', '', '', 7, '', '', '', 0, 1, 0, 0, 1, 0, 0, 0, 7, 7, 1, 7, 1, 1, 0, 48, '24', 25)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 999
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/includes/acp/acp_forums.php
LINE: 1149
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/includes/acp/acp_forums.php
LINE: 199
CALL: acp_forums->update_forum_data()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_forums->main()

FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()
jstMusa
Registered User
Posts: 40
Joined: Tue Feb 25, 2014 1:19 pm
Contact:

Re: Can't create new forum when the extension is installed

by VSE » Thu May 04, 2017 3:56 pm

You have to use the latest version of this extension.
Dictated but not read.
Official phpBB Extensions My Extensions & MODs
Please do not PM me for support.
User avatar
VSE
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 4882
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Contact: