I have a phpbb install at www.ussjamesmadison627.com
It has been functioning well at 3.2.1
I attempted to do the auto update and ran into the noted timeout problem with mysql vs mysqli in the config.php file. I corrected that and tried again.
Then I got the following error when we reached the database update:
Code: Select all
General Error:
SQL ERROR [ mysqli ] [0]
SQL
No values specified for SQL IN comparison in file /home/rkholman/domains/ussjamesmadison627.com/public_html/install/update/new/phpbb/db/driver/driver.php on line 996
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: installer_msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 996
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 547
CALL: phpbb\db\driver\driver->sql_error()
FILE: /home/rkholman/domains/ussjamesmadison627.com/public_html/phpbb/db/driver/factory.php
LINE: 441
CALL: phpbb\db\driver\driver->sql_in_set()
FILE: [ROOT]/phpbb/db/migration/data/v32x/fix_user_styles.php
LINE: 48
CALL: phpbb\db\driver\factory->sql_in_set()
FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\migration\data\v32x\fix_user_styles->styles_fix()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 714
CALL: call_user_func_array()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 661
CALL: phpbb\db\migrator->run_step()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 436
CALL: phpbb\db\migrator->process_data_step()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 288
CALL: phpbb\db\migrator->try_apply()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 241
CALL: phpbb\db\migrator->update_do()
FILE: /home/rkholman/domains/ussjamesmadison627.com/public_html/phpbb/install/module/update_database/task/update.php
LINE: 160
CALL: phpbb\db\migrator->update()
FILE: /home/rkholman/domains/ussjamesmadison627.com/public_html/phpbb/install/module_base.php
LINE: 149
CALL: phpbb\install\module\update_database\task\update->run()
FILE: /home/rkholman/domains/ussjamesmadison627.com/public_html/phpbb/install/installer.php
LINE: 219
CALL: phpbb\install\module_base->run()
FILE: /home/rkholman/domains/ussjamesmadison627.com/public_html/phpbb/install/controller/update.php
LINE: 133
CALL: phpbb\install\installer->run()
FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\install\controller\update->phpbb\install\controller\{closure}()
FILE: /home/rkholman/domains/ussjamesmadison627.com/public_html/vendor/symfony/http-foundation/StreamedResponse.php
LINE: 111
CALL: call_user_func()
FILE: /home/rkholman/domains/ussjamesmadison627.com/public_html/vendor/symfony/http-foundation/Response.php
LINE: 377
CALL: Symfony\Component\HttpFoundation\StreamedResponse->sendContent()
FILE: /home/rkholman/domains/ussjamesmadison627.com/public_html/install/app.php
LINE: 62
CALL: Symfony\Component\HttpFoundation\Response->send()
Code: Select all
Installing Data: \phpbb\db\migration\data\v32x\fix_user_styles.
Skip “installer.update_filesystem.download_updated_files” task
Skip “installer.update_filesystem.update_files” task
Skip “installer.update_filesystem.show_file_status” task
Skip “installer.update_filesystem.diff_files” task
Skip “installer.update_filesystem.check_task” task
Skip “installer.obtain_data.update_ftp_settings” task
Skip “installer.obtain_data.update_files” task
Skip “installer.obtain_data.file_updater_method” task
After trying a couple of times with same results, I went back to the manual update where I u/l the 3.2.2 files (less config.php, /images/, /files/, and /store).
Attempts to run the update database only returns the error at the top of this post.
Any thoughts on just what I'm doing wrong?
(Earlier this week, I installed using the auto update on a different host on 5 different installs with no problem other than the change mysql to mysqli in config.php so I'm reasonably confident that I've been doing something right and am following instructions correctly.)
Thanks in advance.
Edited to change title to show recurrence and solution in 3.2.3 as well as 3.2.2