Page 1 of 1

Database Update error

Posted: Tue Oct 28, 2014 8:30 pm
by PICnico
Hi,

I get the following error due to the database update. I followed this instructions: https://www.phpbb.com/support/docs/en/3 ... /upgrade3/

Here is the error message:

Code: Select all

SQL ERROR [ mysqli ]

INDEX command denied to user 'web1970'@'localhost' for table 'phpbb_styles' [1142]

SQL

DROP INDEX imageset_id ON phpbb_styles

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: 194
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: 1960
CALL: phpbb\db\tools->_sql_run_sql()

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

FILE: [ROOT]/install/database_update.php
LINE: 206
CALL: phpbb\db\migrator->update()

Re: Database Update error

Posted: Tue Oct 28, 2014 8:55 pm
by Oyabun1
You need to set the privileges (permissions) for the database user so that they have the global index privilege. You may be able to adjust that using phpMyAdmin, else ask you host how to achieve it.

Re: Database Update error

Posted: Tue Oct 28, 2014 9:01 pm
by PICnico
Thanks. I will need to contact my provider :|

Is there a possibility to merge "old" database into a clean 3.1 installation by hand? Or is the database update the best solution to keep users, posts, ...?

Re: Database Update error

Posted: Tue Oct 28, 2014 9:19 pm
by Oyabun1
PICnico wrote:Is there a possibility to merge "old" database into a clean 3.1 installation by hand?
It would certainly be possible if you have the time an skill to extract all the necessary queries from the code. However, it wouldn't be a solution to your problem because the new tables need indexes.