Warning: The author of this contribution does not provide support for it anymore.

ACP Announcement Centre

I get this 'General Error' when installing - ACP Announcement Centre

I get this 'General Error' when installing

by Alon_A » Sat Jan 25, 2014 5:50 pm

After did all the neccesery modification, i get this error when trying to install:

Code: Select all

General Error

Index name 'announcement_first_last_post_gen' on table 'phpbb_announcement_centre' is too long. The maximum auto increment column length is 26 characters.

BACKTRACE


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

FILE: [ROOT]/includes/db/db_tools.php
LINE: 482
CALL: trigger_error()

FILE: [ROOT]/install/index.php
LINE: 91
CALL: phpbb_db_tools->sql_create_table()


How can I solve it ? please help...

Thanks !
Alon_A
Registered User
Posts: 3
Joined: Sat Jan 25, 2014 5:45 pm
Contact:

Re: I get this 'General Error' when installing

by 5hocK » Sun Jan 26, 2014 3:50 pm

Which version are you using?
5hocK
Registered User
Posts: 3139
Joined: Wed Nov 23, 2011 7:00 pm
Location: UK
Contact:

Re: I get this 'General Error' when installing

by Alon_A » Sun Jan 26, 2014 7:50 pm

I'm using PHPBB 3.0.12 and Annoucment center 1.2.2

I've tried to apply the fix from This thread, but it didnt work.

I cant find version 1.2.5 to install (As this is also mentioned there as a solution).

BTW, if i need to install 1.2.5, what should i do with the modifications i did for 1.2.2 (I did all the modification by the instructions, but didn't install because it was failed).

Thanks.
Alon_A
Registered User
Posts: 3
Joined: Sat Jan 25, 2014 5:45 pm
Contact:

Re: I get this 'General Error' when installing

by macbroadcast » Fri Feb 07, 2014 3:26 am

hey there acp_announcement_centre_125 installed , changed like discribed above , but same error

:(



SQL ERROR [ mysqli ]

Table 'cjdnsforum.ANNOUNCEMENTS_CENTRE_TABLE' doesn't exist [1146]

SQL

SELECT * FROM ANNOUNCEMENTS_CENTRE_TABLE

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: 189
CALL: dbal->sql_error()

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

FILE: [ROOT]/includes/acp/acp_announcements_centre.php
LINE: 46
CALL: acp_announcements_centre->announcements()

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

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


macbroadcast
Registered User
Posts: 1
Joined: Fri Feb 07, 2014 3:21 am
Contact:

Re: I get this 'General Error' when installing

by manzoor » Tue Apr 15, 2014 8:17 am

same here
manzoor
Registered User
Posts: 30
Joined: Sat Mar 15, 2014 4:48 am
Contact:

Re: I get this 'General Error' when installing

by 5hocK » Tue Apr 15, 2014 9:08 am

With 125 there's no need to change anything, it works fine with 3.0.12
5hocK
Registered User
Posts: 3139
Joined: Wed Nov 23, 2011 7:00 pm
Location: UK
Contact: