Error after upgrading to 1.0.5

[bc2005]

Gallery Version: 1.0.5
phpBB Version: 3.0.7
Gallery-Link: http://www.bonsaicafe.be/forum/gallery/index.php

PHP Version: latest
Database Version: MySQL client version: 5.0.32


Error message:

Code: Select all

PERMISSION_SYSTEM_FAILURE_01

Error description and message
Tried to update to 1.0.5 today, but something went wrong during the third step of the installation. (Updating)
When I returned to my forum, I got this error notice: PERMISSION_SYSTEM_FAILURE_01

Now I can't go to the gallery settings in my ACP, because I get the same error over there. Meanwhile I have switched off my Board3 portal, so now I can get back on the forum. Is there a quick solution here, or do I have to replace everyting with a backup?

Thx in advance...

[bc2005]

Becuase the update went wrong, I now did install the gallery instead of updating. The PERMISSION_SYSTEM_FAILURE_01 error is now gone, but when I go to my gallery, I now get this SQL error:

Code: Select all

SQL ERROR [ mysqli ]

Table 'bonsaicafe_be.GALLERY_CONTESTS_TABLE' doesn't exist [1146]

SQL

SELECT a.*, at.mark_time, c.contest_marked FROM (phpbb_gallery_albums a) LEFT JOIN phpbb_gallery_albums_track at ON (at.user_id = 2 AND a.album_id = at.album_id) LEFT JOIN GALLERY_CONTESTS_TABLE c ON (c.contest_album_id = a.album_id) WHERE a.album_user_id = 0 ORDER BY a.album_user_id, a.left_id

BACKTRACE

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

FILE: gallery/includes/functions_display.php
LINE: 161
CALL: dbal_mysqli->sql_query()

FILE: gallery/index.php
LINE: 37
CALL: display_albums()   

It seems all albums of my old gallery are gone now. If i look in my database on phpmyadmin, i can see this:

# phpbb_gallery_albums
# phpbb_gallery_albums_track
# phpbb_gallery_comments
# phpbb_gallery_config
# phpbb_gallery_contests
# phpbb_gallery_favorites
# phpbb_gallery_images
# phpbb_gallery_modscache
# phpbb_gallery_permissions
# phpbb_gallery_rates

So this table is in my database???

[bc2005]

Hmm, seems I made an error when I was editing the constants.php file..

Gallery is now working... But I still can't reach the old gallery files. Is there any way I can link the new gallery to the old gallery files again?

[bc2005]

If i look into my database with phpMyAdmin, I still can see the old tables of the older albums. But the old tables of the gallery were named like this:

# bonsaicaf_album
# bonsaicaf_album_cat
# bonsaicaf_album_comment
# bonsaicaf_album_config
# bonsaicaf_album_rate
# bonsaicaf_album_sp_config

After I installed phpbbgallery 1.0.5 and Gallery block 1.4.1 I can't acces these tables anymore, now the gallery links to these tables:

# phpbb_gallery_albums
# phpbb_gallery_albums_track
# phpbb_gallery_comments
# phpbb_gallery_config
# phpbb_gallery_contests
# phpbb_gallery_favorites
# phpbb_gallery_images
# phpbb_gallery_modscache
# phpbb_gallery_permissions
# phpbb_gallery_rates
# phpbb_gallery_reports
# phpbb_gallery_roles
# phpbb_gallery_users
# phpbb_gallery_watch

Clearly something went wrong. The prefixes are changed. Is there a way to fix this so the gallery links again to the older albums?

Thx!

[bc2005]

Is it possible to retrieve the data of my old gallery in MySQL from phpmyadmin, and add this data to the new tables (which were created during the update) on my database?

Or can I rename # bonsaicaf_album to # phpbb_gallery_albums, # bonsaicaf_album_cat to ???, # bonsaicaf_album_comment to # phpbb_gallery_comments, etc...?