-
Bug
-
Resolution: Fixed
-
Blocker
-
3.1.0-dev
-
None
-
PostgreSQL 8.3.18
https://github.com/phpbb/phpbb/blob/develop/phpBB/phpbb/db/migration/data/v310/notification_options_reconvert.php#L23
PostgreSQL throws error on updating database.
General Error
SQL ERROR [ postgres ]
ERROR: syntax error at end of input LINE 4: LIMIT 250 OFFSET ^ []
SQL
SELECT user_id, user_notify_type, user_notify_pm FROM phpbb_users ORDER BY user_id LIMIT 250 OFFSET
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 803
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/postgres.php
LINE: 197
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/postgres.php
LINE: 252
CALL: phpbb\db\driver\postgres->sql_query()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 163
CALL: phpbb\db\driver\postgres->_sql_query_limit()
FILE: [ROOT]/phpbb/db/migration/data/v310/notification_options_reconvert.php
LINE: 55
CALL: phpbb\db\driver\driver->sql_query_limit()
FILE: [ROOT]/phpbb/db/migration/data/v310/notification_options_reconvert.php
LINE: 37
CALL: phpbb\db\migration\data\v310\notification_options_reconvert->perform_conversion()
FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\migration\data\v310\notification_options_reconvert->convert_notifications()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 451
CALL: call_user_func_array()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 397
CALL: phpbb\db\migrator->run_step()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 241
CALL: phpbb\db\migrator->process_data_step()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 196
CALL: phpbb\db\migrator->try_apply()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 147
CALL: phpbb\db\migrator->try_apply()
FILE: [ROOT]/install/database_update.php
LINE: 214
CALL: phpbb\db\migrator->update()