Announcement on Index

Error Code - Announcement on Index

Error Code

by moonshine » Mon Mar 23, 2015 3:49 pm

Having installed this extension on my test forum it runs absolutely fine.

Same thing on my live forum after configuring a notice and submitting I'm getting the following error:


Duplicate entry 'announcement_bitfield' for key 1 [1062]

SQL

INSERT INTO phpbb_config_text (config_name, config_value) VALUES ('announcement_bitfield', 'RA==')
moonshine
Registered User
Posts: 60
Joined: Mon Mar 09, 2015 11:55 am
Contact:

Re: Error Code

by david63 » Mon Mar 23, 2015 3:59 pm

That is nothing to do with this extension as it does not use the phpbb_config_text table
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored
User avatar
david63
Registered User
Posts: 16095
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Error Code

by moonshine » Mon Mar 23, 2015 4:06 pm

David, any suggestions as to where I might look?
moonshine
Registered User
Posts: 60
Joined: Mon Mar 09, 2015 11:55 am
Contact:

Re: Error Code

by david63 » Mon Mar 23, 2015 4:10 pm

Do you have any other extensions installed?
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored
User avatar
david63
Registered User
Posts: 16095
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Error Code

by moonshine » Mon Mar 23, 2015 4:16 pm

None.
moonshine
Registered User
Posts: 60
Joined: Mon Mar 09, 2015 11:55 am
Contact:

Re: Error Code

by moonshine » Mon Mar 23, 2015 4:23 pm

If it's any use, here's the whole of the error code:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Duplicate entry 'announcement_bitfield' for key 1 [1062]

SQL

INSERT INTO phpbb_config_text (config_name, config_value) VALUES ('announcement_bitfield', 'RA==')

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/mysqli.php
LINE: 194
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]/phpbb/config/db_text.php
LINE: 111
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/phpbb/boardannouncements/acp/board_announcements_module.php
LINE: 142
CALL: phpbb\config\db_text->set_array()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: phpbb\boardannouncements\acp\board_announcements_module->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
moonshine
Registered User
Posts: 60
Joined: Mon Mar 09, 2015 11:55 am
Contact:

Re: Error Code

by david63 » Mon Mar 23, 2015 4:32 pm

That error message is coming from the Board Announcements extension not the Announcement on Index extension.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored
User avatar
david63
Registered User
Posts: 16095
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Error Code

by moonshine » Mon Mar 23, 2015 4:36 pm

I do have 'announcement' permission set on one board.
So I can't have both?
moonshine
Registered User
Posts: 60
Joined: Mon Mar 09, 2015 11:55 am
Contact:

Re: Error Code

by david63 » Mon Mar 23, 2015 6:42 pm

moonshine wrote:I do have 'announcement' permission set on one board.
So I can't have both?
Why not?

Announcement on Index does not have its own permissions - not sure about Board Announcements, but either way it makes no difference.

The error is being generated by Board Announcements
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored
User avatar
david63
Registered User
Posts: 16095
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Error Code

by moonshine » Mon Mar 23, 2015 11:15 pm

So how do I get some help on this?

As you saw, I posted up on the 3.1 board after your reply about it being a Board Announcement error but your colleague there thinks the post should be moved.

This extension is just perfect for my purpose and I really would like to get it working.
moonshine
Registered User
Posts: 60
Joined: Mon Mar 09, 2015 11:55 am
Contact:

Re: Error Code

by david63 » Tue Mar 24, 2015 7:07 am

moonshine wrote:So how do I get some help on this?
Post in the Board Announcements topic
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored
User avatar
david63
Registered User
Posts: 16095
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Error Code

by moonshine » Tue Mar 24, 2015 12:25 pm

Thanks David, there is a solution already there.

Just one question to ask so I'll post it up on that board.
moonshine
Registered User
Posts: 60
Joined: Mon Mar 09, 2015 11:55 am
Contact: