Note: 'vanilla' is the name of the database.General Error
SQL ERROR [ mysqli ]
Table 'vanilla.subject_prefix_forums' doesn't exist [1146]
SQL
SELECT * FROM subject_prefix_forums
BACKTRACE
FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()
FILE: includes/mods/subject_prefix/subject_prefix_cache.php
LINE: 106
CALL: dbal_mysqli->sql_query()
FILE: includes/acp/acp_subject_prefix.php
LINE: 154
CALL: subject_prefix_cache->obtain_prefix_forum_list()
FILE: includes/functions_module.php
LINE: 507
CALL: acp_subject_prefix->main()
FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
READ MEVSE wrote:EDIT: I installed it... Created an ACP Module for it, and this error happened after trying to create a Prefix
thankst_backoff wrote:Check the NOTICE at the bottom of this post.
I can see that the URL being generated looks suspect:General Error
Module not accessible
Code: Select all
http://localhost:8888/phpbb3/mcp.php?i=subject_prefix&mode=subject_prefix_qc&f=2&t=1&redirect=.%2Fviewtopic.php
The last 3 don't make sense (of course there's a topics_table.SUBJECTPREFIX
PHP Version: 5.2.6
DBMS: MySQL(i) 5.0.51b-community-nt-log
phpBB3 Version: 3.0.7-PL1
Adding acp module: ACP_SUBJECT_PREFIX
ERROR: The parent category specified for this module does not exist.
Adding acp module: ACP_SUBJECT_PREFIX
ERROR: The parent category specified for this module does not exist.
Adding a new database table: SUBJECT_PREFIX_TABLE
SQL ERROR Invalid default value for 'prefix_id'
Adding a new column named subject_prefix_id to table TOPICS_TABLE
SQL ERROR Table 'phpbb3.topics_table' doesn't exist
Adding a key named topic_first_post_id to table TOPICS_TABLE
SQL ERROR Table 'phpbb3.topics_table' doesn't exist
Adding a key named subject_prefix_id to table TOPICS_TABLE
SQL ERROR Table 'phpbb3.topics_table' doesn't exist
message. It seems to only happen when I use the "change topic prefix" tool in viewtopic.The submitted form was invalid. Try submitting again.
Code: Select all
$language_file = 'mods/subject_prefix/subject_prefix_common.php';
Code: Select all
$language_file = 'mods/subject_prefix/subject_prefix_common';
Some of these problems are because constants need not be enclosed in quotes, ie:SUBJECTPREFIX
PHP Version: 5.2.11
DBMS: MySQL(i) 5.1.37
phpBB3 Version: 3.0.7-PL1
Adding a new database table: subject_prefix
SQL ERROR Invalid default value for 'prefix_id'
Adding a new column named subject_prefix_id to table TOPICS_TABLE
SQL ERROR Table 'vanilla.TOPICS_TABLE' doesn't exist
Adding a key named topic_first_post_id to table TOPICS_TABLE
SQL ERROR Table 'vanilla.TOPICS_TABLE' doesn't exist
Adding a key named subject_prefix_id to table TOPICS_TABLE
SQL ERROR Table 'vanilla.TOPICS_TABLE' doesn't exist
Code: Select all
'table_column_add' => array(
array('TOPICS_TABLE', 'subject_prefix_id', array('UINT', '0'))
Code: Select all
'table_column_add' => array(
array(TOPICS_TABLE, 'subject_prefix_id', array('UINT', '0'))
Finally, I can't find the ACP module... Because the parent module ACP_CAT_MODS should be ACP_CAT_DOT_MODSAdding a new database table: subject_prefix
SQL ERROR Invalid default value for 'prefix_id'
Code: Select all
</options>
Code: Select all
</option>
Looks like I did something wrong with moving stuff around in the installer :/. Lemme seet_backoff wrote:I'll have to manually add these, then I can test.
- I had to remove subject_prefix_core:: from line 72 and line 82 in install/install_versions.php
- I had to comment out the language_file line to get the installer to run (it said the file couldn't be opened, but I checked and it was there.
- I got a fail on the install, here is the file it gave me:
The last 3 don't make sense (of course there's a topics_table.SUBJECTPREFIX
PHP Version: 5.2.6
DBMS: MySQL(i) 5.0.51b-community-nt-log
phpBB3 Version: 3.0.7-PL1
Adding acp module: ACP_SUBJECT_PREFIX
ERROR: The parent category specified for this module does not exist.
Adding acp module: ACP_SUBJECT_PREFIX
ERROR: The parent category specified for this module does not exist.
Adding a new database table: SUBJECT_PREFIX_TABLE
SQL ERROR Invalid default value for 'prefix_id'
Adding a new column named subject_prefix_id to table TOPICS_TABLE
SQL ERROR Table 'phpbb3.topics_table' doesn't exist
Adding a key named topic_first_post_id to table TOPICS_TABLE
SQL ERROR Table 'phpbb3.topics_table' doesn't exist
Adding a key named subject_prefix_id to table TOPICS_TABLE
SQL ERROR Table 'phpbb3.topics_table' doesn't exist