- The version shown in the ACP is 3.1.10-dev. I looked at the migrations table and all the migrations seem to be there. The value for version in the phpbb_config table is 3.3.3. Purging the cache doesn't change this. This has worked in the past. Any idea?
- Clicking on some links, like the UCP link returns this error:
But the post_visibility column is in the phpbb_posts table and is properly defined and populated (all have the value 1). The SQL fails in phpBB but enter the same thing in phpMyAdmin and it works fine.SQL ERROR [ mysqli ]
Unknown column 'post_visibility' in 'where clause' [1054]
SQL
SELECT forum_id, COUNT(post_id) AS num_posts FROM phpbb_posts WHERE poster_id = 2 AND post_postcount = 1 AND ((forum_id IN (2, 3, 4, 5, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29) OR (post_visibility = 1 AND 1=0))) GROUP BY forum_id ORDER BY num_posts DESC LIMIT 1
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1023
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 195
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: 296
CALL: phpbb\db\driver\mysql_base->_sql_query_limit()
FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 337
CALL: phpbb\db\driver\driver->sql_query_limit()
FILE: [ROOT]/includes/functions_display.php
LINE: 1201
CALL: phpbb\db\driver\factory->sql_query_limit()
FILE: [ROOT]/includes/ucp/ucp_main.php
LINE: 222
CALL: display_user_activity()
FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: ucp_main->main()
FILE: [ROOT]/ucp.php
LINE: 440
CALL: p_master->load_active()
The only odd thing about this board is that content is mostly in Cyrillic.
Any ideas??