Sorted this:

Permalink
I upgraded to 5.4 and upgrded the gallery block.

When I placed it the page blew up and now I cant delete the page.

When I try to visit the page:

An unexpected error occurred.
mysql error: [1146: Table 'broadway.FileAttributeKeys' doesn't exist] in EXECUTE("SELECT fakID FROM FileAttributeKeys WHERE akName = 'height' LIMIT 1")

When I try to delete the page:

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table 'broadway.FileAttributeKeys' doesn't exist] in EXECUTE("SELECT fakID FROM FileAttributeKeys WHERE akName = 'height' LIMIT 1") ' in /var/www/vhosts/touch-akl.com/subdomains/dev/httpdocs/broadway/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /var/www/vhosts/touch-akl.com/subdomains/dev/httpdocs/broadway/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1146, 'Table 'broadway...', 'SELECT fakID FR...', false, Object(ADODB_mysql)) #1 /var/www/vhosts/touch-akl.com/subdomains/dev/httpdocs/broadway/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('SELECT fakID FR...', false) #2 /var/www/vhosts/touch-akl.com/subdomains/dev/httpdocs/broadway/concrete/libraries/3rdparty/adodb/drivers/adodb-mysql.inc.php(497): ADOConnection->Execute('SELECT fakID FR...', false) #3 /var/www/vhosts/touch-akl.com/subdomains/dev/httpdocs/broadway/concrete/libraries/3r in /var/www/vhosts/touch-akl.com/subdomains/dev/httpdocs/broadway/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78


Any brave soul have any an idea??

Nige

nige
 
cleverington replied on at Permalink Reply
cleverington
I had the same problem and resolved it by removing all instances of the Gallery block from the site. I know it is a bit drastic, but it was a better option than re-building the entire site.

Login, go to the add functionality page in the dashboard. Edit the Block. Click the 'remove' button.

Hope this helps.
nige replied on at Permalink Reply
nige
Yes the gallery definitely needs to be re-installed after this type of thing. I placed the broken page into a parent and deleted the parent. Then it disappeared. Then I reinstalled the updated gallery.

I think a lot of these things are cache issues browser cache and concrete cache. I've learnt to clear both thoroughly before any upgrade of core or block files.

N