Unknown column 'album_auth_access' in 'field list

[nickvergessen]

Oops, fixed one line, please retry (although the result should be "Added 0 missing columns" now, it should be fixed)

[meamore]

Still the same error, after re-upload en vissit install/force_update.php

Code: Select all

SQL ERROR [ mysqli ]

Duplicate key name 'id_uid' [1061]

SQL

CREATE UNIQUE INDEX id_uid ON phpbb_gallery_rates(rate_image_id, rate_user_id)

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/db/db_tools.php
LINE: 1401
CALL: dbal_mysqli->sql_query()

FILE: includes/db/db_tools.php
LINE: 2086
CALL: phpbb_db_tools->_sql_run_sql()

FILE: install/force_update.php
LINE: 62
CALL: phpbb_db_tools->sql_create_unique_index()

[nickvergessen]

Okay one last try,
can you open install/force_update.php
find:

Code: Select all

if (!$umil->table_index_exists(GALLERY_RATES_TABLE, 'id_uid'))
{
   $umil->db_tools->sql_create_unique_index(GALLERY_RATES_TABLE, 'id_uid', array('rate_image_id', 'rate_user_id'));
}

and replace it with:

Code: Select all

$db->sql_return_on_error(true);
$umil->db_tools->sql_create_unique_index(GALLERY_RATES_TABLE, 'id_uid', array('rate_image_id', 'rate_user_id'));
$db->sql_return_on_error(false);

[meamore]

Now i get this,

Code: Select all

Add missing columns script v1.1.4

Added 5 missing columns


And after visiting gallery/index.php ik get this error.

Code: Select all

SQL ERROR [ mysqli ]

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

SQL

UPDATE phpbb_gallery_users SET user_permissions = '0:0:0::-2:-3:414:293:280', user_permissions_changed = 1323696702 WHERE user_id = 3

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/gallery/auth/auth.php
LINE: 423
CALL: dbal_mysqli->sql_query()

FILE: includes/gallery/auth/auth.php
LINE: 163
CALL: phpbb_gallery_auth::set_user_permissions()

FILE: includes/gallery/auth/auth.php
LINE: 81
CALL: phpbb_gallery_auth->query_auth_data()

FILE: includes/gallery/gallery.php
LINE: 72
CALL: phpbb_gallery_auth->phpbb_gallery_auth()

FILE: gallery/index.php
LINE: 20
CALL: phpbb_gallery::setup()

Because my forum doesn't works a have to take a backup sql so that my forum can run normaly, that was days ago. The problem is when this error is and can be solved i can't put back the sql dump with the errors where working on because i mis a day or 10 then in users and messages.

For this reason i want to leave it as is is and the delete the sql database with the errors. If you want any information to try to fix this error for someone else just let me know, otherwise i delete the files and database.

[nickvergessen]

If you don't mind, I'd like to have a backup of that "broken" database for further investigation

[meamore]

No i don't mind, just to help you improve your support for others.
Can i backup the DB without the phpbb_users table and the private message table?

[nickvergessen]

Well basically phpbb_gallery_* should be enough for me.
And could you keep a backup of the files? That would be pretty awesome if I'd need them later.

[nickvergessen]

Again a little bug in my script:
find:

Code: Select all

   if (!$umil->table_column_exists($data[0], $data[1]))
   {
      $umil->table_column_exists($data[0], $data[1], $data[2]);
      $added++;
   }

replace with:

Code: Select all

   if (!$umil->table_column_exists($data[0], $data[1]))
   {
      $umil->table_column_add($data[0], $data[1], $data[2]);
      $added++;
   }

Thanks for your help. I hope you get your board fixed soon.