Individual posts per page

Got an error when trying to install - Individual posts per page

Got an error when trying to install

by PineSmokes » Wed Mar 09, 2016 4:57 am

I know my version is a little ahead of the version supported, my phpBB version is 3.1.8.
Not too important I'll live without this mod but this is the error I get when I try to enable the extension:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Unknown column 'user_topics_sortby_dir' in 'phpbb_users' [1054]

SQL

ALTER TABLE `phpbb_users` ADD COLUMN `user_topics_per_page` smallint(4) UNSIGNED DEFAULT '0' NOT NULL AFTER user_topics_sortby_dir

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: 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]/phpbb/db/tools.php
LINE: 1428
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/phpbb/db/tools.php
LINE: 1814
CALL: phpbb\db\tools->_sql_run_sql()

FILE: [ROOT]/phpbb/db/tools.php
LINE: 802
CALL: phpbb\db\tools->sql_column_add()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\tools->perform_schema_changes()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 550
CALL: call_user_func_array()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 496
CALL: phpbb\db\migrator->run_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 305
CALL: phpbb\db\migrator->process_data_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 202
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 185
CALL: phpbb\db\migrator->update_do()

FILE: [ROOT]/phpbb/extension/base.php
LINE: 80
CALL: phpbb\db\migrator->update()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 187
CALL: phpbb\extension\base->enable_step()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 177
CALL: phpbb\extension\manager->enable_step()

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

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
PineSmokes
Registered User
Posts: 7
Joined: Mon Mar 07, 2016 7:33 pm
Contact:

Re: Got an error when trying to install

by inkofdeath » Thu Mar 17, 2016 1:52 am

Similar error here when trying to activate:

Code: Select all

SQL ERROR [ mysqli ]

Unknown column 'user_topics_sortby_dir' in 'phpbb_users' [1054]

SQL

ALTER TABLE `phpbb_users` ADD COLUMN `user_topics_per_page` smallint(4) UNSIGNED DEFAULT '0' NOT NULL AFTER user_topics_sortby_dir

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: 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]/phpbb/db/tools.php
LINE: 1428
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/phpbb/db/tools.php
LINE: 1814
CALL: phpbb\db\tools->_sql_run_sql()

FILE: [ROOT]/phpbb/db/tools.php
LINE: 802
CALL: phpbb\db\tools->sql_column_add()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\tools->perform_schema_changes()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 550
CALL: call_user_func_array()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 496
CALL: phpbb\db\migrator->run_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 305
CALL: phpbb\db\migrator->process_data_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 262
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 202
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 185
CALL: phpbb\db\migrator->update_do()

FILE: [ROOT]/phpbb/extension/base.php
LINE: 80
CALL: phpbb\db\migrator->update()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 187
CALL: phpbb\extension\base->enable_step()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 177
CALL: phpbb\extension\manager->enable_step()

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

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
inkofdeath
Registered User
Posts: 12
Joined: Sat Dec 03, 2011 4:25 am
Contact:

Re: Got an error when trying to install

by RMcGirr83 » Thu Mar 17, 2016 10:24 am

It is because of this line in the migration file

Code: Select all

'user_topics_per_page'    => array('USINT'0'after' => 'user_topics_sortby_dir'


it should be

Code: Select all

'user_topics_per_page'    => array('USINT'0'after' => 'user_topic_sortby_dir'

notice the lack of 's' in user_topic's'
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then buy me a beerImage
User avatar
RMcGirr83
Former Team Member
Posts: 21684
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Got an error when trying to install

by Bruce Banner » Wed Feb 22, 2017 1:51 am

I searched for that line in both files in the migrations folder but couldn't find it.
Bruce Banner
Registered User
Posts: 833
Joined: Thu Sep 25, 2014 10:36 am
Contact:

Re: Got an error when trying to install

by Elsensee » Thu Mar 02, 2017 2:01 am

Ah right, I have to submit a new revision, still... :D

Can you do me a favor and replace your migrations/release_1_0_0_rc1.php with this one? https://raw.githubusercontent.com/Elsen ... _0_rc1.php

It should now be enablable.
Development Team Member
I don't make bugs - I make features
User avatar
Elsensee
Former Team Member
Posts: 122
Joined: Sat May 07, 2011 11:04 am
Location: Hamburg, Germany
Name: Oliver Schramm
Contact:

Re: Got an error when trying to install

by mike2003 » Sun Apr 30, 2017 7:03 pm

I have the error too. Bad extension.
mike2003
Registered User
Posts: 91
Joined: Sun Mar 20, 2016 12:10 am
Contact:

Re: Got an error when trying to install

by Web_Star » Sun Jun 23, 2019 1:25 pm

Elsensee wrote:Ah right, I have to submit a new revision, still... :D

Can you do me a favor and replace your migrations/release_1_0_0_rc1.php with this one? https://raw.githubusercontent.com/Elsen ... _0_rc1.php

It should now be enablable.
Thanks. This really fix the problem, but why you didn't changed this file in the extension pack?
Web_Star
Registered User
Posts: 3
Joined: Sun Nov 25, 2018 12:54 pm
Contact: