Recent upgrade broke Gallery block
Permalink
I recently upgraded to the latest Concrete. I had been using the Gallery block on my site. The upgrade went fine, but afterwards any page that used the Gallery block failed with a SQL exception. I tried to delete the pages and put new ones in their place, but when I attempt to delete, I get the following:
Exception Occurred: mysql error: [1146: Table 'cupcakes_c5.FileAttributeKeys' doesn't exist] in EXECUTE("SELECT fakID FROM FileAttributeKeys WHERE akName = 'height' LIMIT 1")
#0 /home/ender27182818/http://www.sweetcharitys.com/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1146, 'Table 'cupcakes...', 'SELECT fakID FR...', false, Object(ADODB_mysql))
#1 /home/ender27182818/http://www.sweetcharitys.com/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('SELECT fakID FR...', false)
#2 /home/ender27182818/http://www.sweetcharitys.com/concrete/libraries/3rdparty/adodb/drivers/adodb-mysql.inc.php( ADOConnection->Execute('SELECT fakID FR...', false)
#3 /home/ender27182818/http://www.sweetcharitys.com/concrete/libraries/3rdparty/adodb/drivers/adodb-mysql.inc.php( ADODB_mysql->SelectLimit('SELECT fakID FR...', 1, -1, false)
#4 /home/ender27182818/http://www.sweetcharitys.com/concrete/libraries/database.php(73): ADODB_mysql->GetOne('SELECT fakID FR...')
#5 /home/ender27182818/http://www.sweetcharitys.com/packages/gallery/blocks/gallery/controller.php(110): Database->__call(Array, Array)
#6 /home/ender27182818/http://www.sweetcharitys.com/packages/gallery/blocks/gallery/controller.php(110): Database->getOne('getOne', Array)
#7 /home/ender27182818/http://www.sweetcharitys.com/packages/gallery/blocks/gallery/controller.php(46): GalleryBlockController->loadFileSet('SELECT fakID FR...')
#8 /home/ender27182818/http://www.sweetcharitys.com/concrete/models/block.php(122): GalleryBlockController->__construct()
#9 /home/ender27182818/http://www.sweetcharitys.com/concrete/models/collection.php(637): Block::getByID(Object(Block))
#10 /home/ender27182818/http://www.sweetcharitys.com/concrete/libraries/view.php(723): Collection->getBlocks('49', Object(Page), 'Content')
#11 /home/ender27182818/http://www.sweetcharitys.com/concrete/dispatcher.php(236): View->render()
#12 /home/ender27182818/http://www.sweetcharitys.com/index.php(2): require('/home/ender2718...')
#13 {main}
On another site I had this problem, and found that if I update the Gallery block, the problem went away. However, this site doesn't appear to have an update option with the Gallery block. I assume it's because I bought the block and used it on multiple sites back when that was allowed, and now my first site has the block associated with it, and I'd need to purchase the new block on the new site.
I'd rather just get rid of the block altogether.
Got any help on how to delete the pages with the block, the block itself, and get things up and running?
Exception Occurred: mysql error: [1146: Table 'cupcakes_c5.FileAttributeKeys' doesn't exist] in EXECUTE("SELECT fakID FROM FileAttributeKeys WHERE akName = 'height' LIMIT 1")
#0 /home/ender27182818/http://www.sweetcharitys.com/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1146, 'Table 'cupcakes...', 'SELECT fakID FR...', false, Object(ADODB_mysql))
#1 /home/ender27182818/http://www.sweetcharitys.com/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('SELECT fakID FR...', false)
#2 /home/ender27182818/http://www.sweetcharitys.com/concrete/libraries/3rdparty/adodb/drivers/adodb-mysql.inc.php( ADOConnection->Execute('SELECT fakID FR...', false)
#3 /home/ender27182818/http://www.sweetcharitys.com/concrete/libraries/3rdparty/adodb/drivers/adodb-mysql.inc.php( ADODB_mysql->SelectLimit('SELECT fakID FR...', 1, -1, false)
#4 /home/ender27182818/http://www.sweetcharitys.com/concrete/libraries/database.php(73): ADODB_mysql->GetOne('SELECT fakID FR...')
#5 /home/ender27182818/http://www.sweetcharitys.com/packages/gallery/blocks/gallery/controller.php(110): Database->__call(Array, Array)
#6 /home/ender27182818/http://www.sweetcharitys.com/packages/gallery/blocks/gallery/controller.php(110): Database->getOne('getOne', Array)
#7 /home/ender27182818/http://www.sweetcharitys.com/packages/gallery/blocks/gallery/controller.php(46): GalleryBlockController->loadFileSet('SELECT fakID FR...')
#8 /home/ender27182818/http://www.sweetcharitys.com/concrete/models/block.php(122): GalleryBlockController->__construct()
#9 /home/ender27182818/http://www.sweetcharitys.com/concrete/models/collection.php(637): Block::getByID(Object(Block))
#10 /home/ender27182818/http://www.sweetcharitys.com/concrete/libraries/view.php(723): Collection->getBlocks('49', Object(Page), 'Content')
#11 /home/ender27182818/http://www.sweetcharitys.com/concrete/dispatcher.php(236): View->render()
#12 /home/ender27182818/http://www.sweetcharitys.com/index.php(2): require('/home/ender2718...')
#13 {main}
On another site I had this problem, and found that if I update the Gallery block, the problem went away. However, this site doesn't appear to have an update option with the Gallery block. I assume it's because I bought the block and used it on multiple sites back when that was allowed, and now my first site has the block associated with it, and I'd need to purchase the new block on the new site.
I'd rather just get rid of the block altogether.
Got any help on how to delete the pages with the block, the block itself, and get things up and running?
did you update the gallery block? i assume your using the one made by the c5 core team
As far as I know, I am using the gallery block from the core team. It says I'm at version 1.5, and that there are no updates available. However, my other site, which had a problem that was resolved by upgrading the block, says the block is at version 1.6.4.
did you try manually upgrading the block? remember, only i license per site!
Right, I got the one license per site thing - how would I go about manually upgrading it anyways? At this point, I'd rather just get rid of the block rather than having to pay on a per-site basis. Thing is, I can't uninstall it, I can't delete the page that uses it, I can't navigate to the page that uses it...in short, I can't do anything.
But, how would I manually upgrade?
But, how would I manually upgrade?
