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

phpBB Digests

SQL Error with 3.0.7 on 3.1.10 - phpBB Digests

SQL Error with 3.0.7 on 3.1.10

by platima » Wed Jan 11, 2017 2:13 am

Hi,

Updated from 3.0.6 which was running pretty smoothly last week, and did so following the instructions provided.

After activation, a lot of the settings don't work - not to mention the digests. When I click on Customise -> Edit Subscribers, I get this error, which is similar to many others I'm seeing:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Unknown column 'user_digest_send_hour_gmt' in 'field list' [1054]

SQL

SELECT *, CASE WHEN user_digest_send_hour_gmt + 8 >= 24 THEN user_digest_send_hour_gmt + 8 - 24 WHEN user_digest_send_hour_gmt + 8 < 0 THEN user_digest_send_hour_gmt + 8 + 24 ELSE user_digest_send_hour_gmt + 8 END AS send_hour_board FROM (phpbbec_users u) WHERE user_type <> 2 ORDER BY lower(username) ASC LIMIT 20

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/mysql_base.php
LINE: 45
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 261
CALL: phpbb\db\driver\mysql_base->_sql_query_limit()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 321
CALL: phpbb\db\driver\driver->sql_query_limit()

FILE: [ROOT]/ext/phpbbservices/digests/acp/main_module.php
LINE: 347
CALL: phpbb\db\driver\factory->sql_query_limit()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: phpbbservices\digests\acp\main_module->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
Thoughts/help?

Cheers
-KP
platima
Registered User
Posts: 5
Joined: Wed Jan 11, 2017 2:09 am

Re: SQL Error with 3.0.7 on 3.1.10

by MarkDHamill » Thu Mar 23, 2017 11:22 pm

Did you run digests_install.php? It should add any new columns that are required.
Need phpBB services or a phpBB consultant? I offer most phpBB services. Getting lost managing phpBB? Buy my book, Mastering phpBB Administration. Covers through phpBB 3.3.7. eBook and paper versions available.
User avatar
MarkDHamill
Registered User
Posts: 4933
Joined: Fri Aug 02, 2002 12:36 am
Location: Florence, MA USA

Re: SQL Error with 3.0.7 on 3.1.10

by platima » Mon May 29, 2017 8:12 am

Hey so I've got pretty much this EXACT error.

Just upgraded from... Something (possibly phpBB 3.1 to 3.2 and digests to RC10). Cannot find a 'digests_install.php' file though?

Thanks
platima
Registered User
Posts: 5
Joined: Wed Jan 11, 2017 2:09 am

Re: SQL Error with 3.0.7 on 3.1.10

by platima » Mon May 29, 2017 8:20 am

Wow I'm having a slow day. Replied to my own thread like a new user.

Anyway tried moving to 3.2.3 RC10 on phpBB 3.2.0 but same error. Also getting
Unknown column 'user_digest_type' in 'where clause' [1054]

Found the migrations folder so reading through that code and might try out the release_3_0_6.php file
platima
Registered User
Posts: 5
Joined: Wed Jan 11, 2017 2:09 am

Re: SQL Error with 3.0.7 on 3.1.10

by MarkDHamill » Wed May 31, 2017 1:36 am

This is in the wrong thread. The digest extension thread is at:

viewtopic.php?f=456&t=2354426
Need phpBB services or a phpBB consultant? I offer most phpBB services. Getting lost managing phpBB? Buy my book, Mastering phpBB Administration. Covers through phpBB 3.3.7. eBook and paper versions available.
User avatar
MarkDHamill
Registered User
Posts: 4933
Joined: Fri Aug 02, 2002 12:36 am
Location: Florence, MA USA