phpBB • Free and Open Source Forum Software

I installed this mod and now I can not create new forums. I get this error message. I tried the mysql_updater.php for v3.0.11. and it did not work.


Return to the index page
General Error
SQL ERROR [ mysqli ]

Field 'forum_last_poster_avatar' 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, prune_days, prune_viewed, prune_freq, forum_options, forum_flags, left_id, right_id) VALUES (0, 1, 0, '', 'Test', '', '', '', 7, '', '', '', 7, '', '', '', 0, 1, 0, 0, 1, 0, 0, 7, 7, 1, 0, 48, 39, 40)

BACKTRACE

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

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 182
CALL: dbal->sql_error()

FILE: [ROOT]/includes/acp/acp_forums.php
LINE: 1019
CALL: dbal_mysqli->sql_query()

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

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

FILE: [ROOT]/adm/index.php
LINE: 74
CALL: p_master->load_active()


I look forward to your reply as my site is live and active.

I have the same issue, I tried to update the column to have a default value but it wont let me. Says that it can't have a default value.

I add my issue here as it sounds similar.

This mod worked fine for quite a while. But after working on an issue of one of your other mods (QTE) I cannot create new topics now. Because of this error




This occurs when I want to create a new topic. Answering an existing topic is no problem.

I had to remove the mod in order to keep my board live and working, but I would like to have this mod back.

Has anyone solved this problem. This MOD has a serious issue because it corrupts things as the last person who posted described. Its completely useless until the issue is corrected. I had to remove the MOD from my board for this very reason.

Got it to work fine BUT.. the only problem I have is that you cannot create any new forums or sub forums... I get error messages as first post...

Like this mod but .. had to un-install so I could create more forums... is there a fix for this?

Yep I just checked mine and I get the same error. You would think this flaw would have been picked up earlier, and solved by someone else?

Ah sorry there's a fix for this I didnt notice

viewtopic.php?f=70&t=2162268

Implemented and tested and now I can create forums.

The fix for not being able to create forums is below.

includes/acp/acp_forums.php

Find:


Add Before:

Thank for the last post with the fix. saved me a lot of stress!

w5hro wrote:The fix for not being able to create forums is below.

includes/acp/acp_forums.php

Find:

Code: Select all

                    // On add, add empty forum_options... else do not consider it (not updating it)

Add Before:

Code: Select all

//-- mod : apiv ----------------------------------------------------------------
//-- add
                    $forum_data += array('forum_last_poster_avatar' => '');
//-- fin mod : apiv ------------------------------------------------------------

thanks you are great !