0
Welcome Guest! Login
0 items Join Now

500 Error on ROKGALLERY new install

Last Post
Search Topic

  • 500 Error on ROKGALLERY new install

    Posted 10 years 9 months ago
    • Hi Everyone,
      I installed rokgallery (twice) on a refraction template and I get a 500 error when I try to access the component.

      I say installed twice because when I installed it the first time, ROKGALLERY didn't show up in the list of components. The install seemed to go perfectly and now errors showed in the after install screen. I tried emtying the cashe but it didn't help so I tried reinstalling it and it now shows up in the component menu but I'm getting the 500 error when I try and do anything with it.

      Here's the syntax of the error:

      500 - An error has occurred.

      7 error(s) encountered during migration ======================================= Error #1 - SQLSTATE[42S02]: Base table or view not found: 1146 Table 'kevinw_nwahec.n2ue4_rokgallery_slices' doesn't exist. Failing Query: "ALTER TABLE n2ue4_rokgallery_slices ADD thumb_xsize INT UNSIGNED NOT NULL" #0 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'ALTER TABLE n2u...') #1 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Export.php(621): Doctrine_Connection->execute('ALTER TABLE n2u...') #2 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration/Process.php(89): Doctrine_Export->alterTable('n2ue4_rokgaller...', Array) #3 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedColumn(Array) #4 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 1) #5 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(2) #6 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine.php(33): Doctrine_Migration->migrate() #7 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine.php(22): RokGallery_Doctrine->__construct() #8 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine.php(45): RokGallery_Doctrine::getInstance() #9 /hsphere/local/home/kevinw/nwahecak.org/administrator/components/com_rokgallery/include.php(18): RokGallery_Doctrine::addModelPath('/hsphere/local/...') #10 /hsphere/local/home/kevinw/nwahecak.org/administrator/components/com_rokgallery/rokgallery.php(15): require_once('/hsphere/local/...') #11 /hsphere/local/home/kevinw/nwahecak.org/libraries/joomla/application/component/helper.php(380): require_once('/hsphere/local/...') #12 /hsphere/local/home/kevinw/nwahecak.org/libraries/joomla/application/component/helper.php(348): JComponentHelper::executeComponent('/hsphere/local/...') #13 /hsphere/local/home/kevinw/nwahecak.org/administrator/includes/application.php(153): JComponentHelper::renderComponent('com_rokgallery') #14 /hsphere/local/home/kevinw/nwahecak.org/administrator/index.php(46): JAdministrator->dispatch() #15 {main} Error #2 - SQLSTATE[42S02]: Base table or view not found: 1146 Table 'kevinw_nwahec.n2ue4_rokgallery_slices' doesn't exist. Failing Query: "ALTER TABLE n2ue4_rokgallery_slices ADD thumb_ysize INT UNSIGNED NOT NULL" #0 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'ALTER TABLE n2u...') #1 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Export.php(621): Doctrine_Connection->execute('ALTER TABLE n2u...') #2 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration/Process.php(89): Doctrine_Export->alterTable('n2ue4_rokgaller...', Array) #3 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedColumn(Array) #4 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 1) #5 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(2) #6 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine.php(33): Doctrine_Migration->migrate() #7 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine.php(22): RokGallery_Doctrine->__construct() #8 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine.php(45): RokGallery_Doctrine::getInstance() #9 /hsphere/local/home/kevinw/nwahecak.org/administrator/components/com_rokgallery/include.php(18): RokGallery_Doctrine::addModelPath('/hsphere/local/...') #10 /hsphere/local/home/kevinw/nwahecak.org/administrator/components/com_rokgallery/rokgallery.php(15): require_once('/hsphere/local/...') #11 /hsphere/local/home/kevinw/nwahecak.org/libraries/joomla/application/component/helper.php(380): require_once('/hsphere/local/...') #12 /hsphere/local/home/kevinw/nwahecak.org/libraries/joomla/application/component/helper.php(348): JComponentHelper::executeComponent('/hsphere/local/...') #13 /hsphere/local/home/kevinw/nwahecak.org/administrator/includes/application.php(153): JComponentHelper::renderComponent('com_rokgallery') #14 /hsphere/local/home/kevinw/nwahecak.org/administrator/index.php(46): JAdministrator->dispatch() #15 {main} Error #3 - SQLSTATE[42S02]: Base table or view not found: 1146 Table 'kevinw_nwahec.n2ue4_rokgallery_slices' doesn't exist. Failing Query: "ALTER TABLE n2ue4_rokgallery_slices ADD thumb_keep_aspect TINYINT(1) DEFAULT '1' NOT NULL" #0 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'ALTER TABLE n2u...') #1 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Export.php(621): Doctrine_Connection->execute('ALTER TABLE n2u...') #2 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration/Process.php(89): Doctrine_Export->alterTable('n2ue4_rokgaller...', Array) #3 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedColumn(Array) #4 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 1) #5 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(2) #6 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine.php(33): Doctrine_Migration->migrate() #7 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine.php(22): RokGallery_Doctrine->__construct() #8 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine.php(45): RokGallery_Doctrine::getInstance() #9 /hsphere/local/home/kevinw/nwahecak.org/administrator/components/com_rokgallery/include.php(18): RokGallery_Doctrine::addModelPath('/hsphere/local/...') #10 /hsphere/local/home/kevinw/nwahecak.org/administrator/components/com_rokgallery/rokgallery.php(15): require_once('/hsphere/local/...') #11 /hsphere/local/home/kevinw/nwahecak.org/libraries/joomla/application/component/helper.php(380): require_once('/hsphere/local/...') #12 /hsphere/local/home/kevinw/nwahecak.org/libraries/joomla/application/component/helper.php(348): JComponentHelper::executeComponent('/hsphere/local/...') #13 /hsphere/local/home/kevinw/nwahecak.org/administrator/includes/application.php(153): JComponentHelper::renderComponent('com_rokgallery') #14 /hsphere/local/home/kevinw/nwahecak.org/administrator/index.php(46): JAdministrator->dispatch() #15 {main} Error #4 - SQLSTATE[42S02]: Base table or view not found: 1146 Table 'kevinw_nwahec.n2ue4_rokgallery_slices' doesn't exist. Failing Query: "ALTER TABLE n2ue4_rokgallery_slices ADD thumb_background VARCHAR(12) DEFAULT 'transparent'" #0 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'ALTER TABLE n2u...') #1 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Export.php(621): Doctrine_Connection->execute('ALTER TABLE n2u...') #2 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration/Process.php(89): Doctrine_Export->alterTable('n2ue4_rokgaller...', Array) #3 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedColumn(Array) #4 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 1) #5 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(2) #6 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine.php(33): Doctrine_Migration->migrate() #7 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine.php(22): RokGallery_Doctrine->__construct() #8 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine.php(45): RokGallery_Doctrine::getInstance() #9 /hsphere/local/home/kevinw/nwahecak.org/administrator/components/com_rokgallery/include.php(18): RokGallery_Doctrine::addModelPath('/hsphere/local/...') #10 /hsphere/local/home/kevinw/nwahecak.org/administrator/components/com_rokgallery/rokgallery.php(15): require_once('/hsphere/local/...') #11 /hsphere/local/home/kevinw/nwahecak.org/libraries/joomla/application/component/helper.php(380): require_once('/hsphere/local/...') #12 /hsphere/local/home/kevinw/nwahecak.org/libraries/joomla/application/component/helper.php(348): JComponentHelper::executeComponent('/hsphere/local/...') #13 /hsphere/local/home/kevinw/nwahecak.org/administrator/includes/application.php(153): JComponentHelper::renderComponent('com_rokgallery') #14 /hsphere/local/home/kevinw/nwahecak.org/administrator/index.php(46): JAdministrator->dispatch() #15 {main} Error #5 - SQLSTATE[42S02]: Base table or view not found: 1146 Table 'kevinw_nwahec.n2ue4_rokgallery_slices' doesn't exist. Failing Query: "ALTER TABLE n2ue4_rokgallery_slices ADD ordering INT UNSIGNED NOT NULL" #0 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'ALTER TABLE n2u...') #1 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Export.php(621): Doctrine_Connection->execute('ALTER TABLE n2u...') #2 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration/Process.php(89): Doctrine_Export->alterTable('n2ue4_rokgaller...', Array) #3 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration.php(522): Doctrine_Migration_Process->processCreatedColumn(Array) #4 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 1) #5 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(2) #6 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine.php(33): Doctrine_Migration->migrate() #7 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine.php(22): RokGallery_Doctrine->__construct() #8 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine.php(45): RokGallery_Doctrine::getInstance() #9 /hsphere/local/home/kevinw/nwahecak.org/administrator/components/com_rokgallery/include.php(18): RokGallery_Doctrine::addModelPath('/hsphere/local/...') #10 /hsphere/local/home/kevinw/nwahecak.org/administrator/components/com_rokgallery/rokgallery.php(15): require_once('/hsphere/local/...') #11 /hsphere/local/home/kevinw/nwahecak.org/libraries/joomla/application/component/helper.php(380): require_once('/hsphere/local/...') #12 /hsphere/local/home/kevinw/nwahecak.org/libraries/joomla/application/component/helper.php(348): JComponentHelper::executeComponent('/hsphere/local/...') #13 /hsphere/local/home/kevinw/nwahecak.org/administrator/includes/application.php(153): JComponentHelper::renderComponent('com_rokgallery') #14 /hsphere/local/home/kevinw/nwahecak.org/administrator/index.php(46): JAdministrator->dispatch() #15 {main} Error #6 - SQLSTATE[42S02]: Base table or view not found: 1146 Table 'kevinw_nwahec.n2ue4_rokgallery_galleries' doesn't exist. Failing Query: "ALTER TABLE n2ue4_rokgallery_galleries CHANGE thumb_background thumb_background VARCHAR(12) DEFAULT 'transparent'" #0 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'ALTER TABLE n2u...') #1 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Export.php(621): Doctrine_Connection->execute('ALTER TABLE n2u...') #2 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration/Process.php(129): Doctrine_Export->alterTable('n2ue4_rokgaller...', Array) #3 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration.php(522): Doctrine_Migration_Process->processChangedColumn(Array) #4 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 1) #5 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(2) #6 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine.php(33): Doctrine_Migration->migrate() #7 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine.php(22): RokGallery_Doctrine->__construct() #8 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine.php(45): RokGallery_Doctrine::getInstance() #9 /hsphere/local/home/kevinw/nwahecak.org/administrator/components/com_rokgallery/include.php(18): RokGallery_Doctrine::addModelPath('/hsphere/local/...') #10 /hsphere/local/home/kevinw/nwahecak.org/administrator/components/com_rokgallery/rokgallery.php(15): require_once('/hsphere/local/...') #11 /hsphere/local/home/kevinw/nwahecak.org/libraries/joomla/application/component/helper.php(380): require_once('/hsphere/local/...') #12 /hsphere/local/home/kevinw/nwahecak.org/libraries/joomla/application/component/helper.php(348): JComponentHelper::executeComponent('/hsphere/local/...') #13 /hsphere/local/home/kevinw/nwahecak.org/administrator/includes/application.php(153): JComponentHelper::renderComponent('com_rokgallery') #14 /hsphere/local/home/kevinw/nwahecak.org/administrator/index.php(46): JAdministrator->dispatch() #15 {main} Error #7 - -18 #0 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine/Migrations/1318887392_version2.php(104): Version2->isInnoDBEngine('kevinw_nwahec', 'n2ue4_rokgaller...') #1 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration.php(504): Version2->preUp() #2 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration.php(479): Doctrine_Migration->_doMigrateStep('up', 2) #3 /hsphere/local/home/kevinw/nwahecak.org/libraries/rokcommon/Doctrine/Migration.php(328): Doctrine_Migration->_doMigrate(2) #4 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine.php(33): Doctrine_Migration->migrate() #5 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine.php(22): RokGallery_Doctrine->__construct() #6 /hsphere/local/home/kevinw/nwahecak.org/components/com_rokgallery/lib/RokGallery/Doctrine.php(45): RokGallery_Doctrine::getInstance() #7 /hsphere/local/home/kevinw/nwahecak.org/administrator/components/com_rokgallery/include.php(18): RokGallery_Doctrine::addModelPath('/hsphere/local/...') #8 /hsphere/local/home/kevinw/nwahecak.org/administrator/components/com_rokgallery/rokgallery.php(15): require_once('/hsphere/local/...') #9 /hsphere/local/home/kevinw/nwahecak.org/libraries/joomla/application/component/helper.php(380): require_once('/hsphere/local/...') #10 /hsphere/local/home/kevinw/nwahecak.org/libraries/joomla/application/component/helper.php(348): JComponentHelper::executeComponent('/hsphere/local/...') #11 /hsphere/local/home/kevinw/nwahecak.org/administrator/includes/application.php(153): JComponentHelper::renderComponent('com_rokgallery') #12 /hsphere/local/home/kevinw/nwahecak.org/administrator/index.php(46): JAdministrator->dispatch() #13 {main}
    • Kevin Whitcomb
      Blue Planet Photo Studio
      813.494.4960
      www.blueplanetps.com

      da mihi castitatem et continentiam, sed noli modo
    #1115495

  • Re: 500 Error on ROKGALLERY new install

    Posted 10 years 9 months ago
    • I just checked the ROKCANDY component and it also is getting a 500 error but with different syntax:

      Joomla!
      500 - An error has occurred.

      Table 'kevinw_nwahec.n2ue4_rokcandy' doesn't exist SQL=SELECT a.id, a.macro, a.html, a.checked_out, a.checked_out_time, a.catid, a.published, a.ordering,uc.name AS editor,c.title AS category_title FROM n2ue4_rokcandy AS a LEFT JOIN n2ue4_users AS uc ON uc.id=a.checked_out LEFT JOIN n2ue4_categories AS c ON c.id = a.catid WHERE (a.published = 0 OR a.published = 1) ORDER BY category_title asc, a.ordering asc Table 'kevinw_nwahec.n2ue4_rokcandy' doesn't exist SQL=SELECT a.id, a.macro, a.html, a.checked_out, a.checked_out_time, a.catid, a.published, a.ordering,uc.name AS editor,c.title AS category_title FROM n2ue4_rokcandy AS a LEFT JOIN n2ue4_users AS uc ON uc.id=a.checked_out LEFT JOIN n2ue4_categories AS c ON c.id = a.catid WHERE (a.published = 0 OR a.published = 1) ORDER BY category_title asc, a.ordering asc LIMIT 0, 20 Table 'kevinw_nwahec.n2ue4_rokcandy' doesn't exist SQL=SELECT a.id, a.macro, a.html, a.checked_out, a.checked_out_time, a.catid, a.published, a.ordering,uc.name AS editor,c.title AS category_title FROM n2ue4_rokcandy AS a LEFT JOIN n2ue4_users AS uc ON uc.id=a.checked_out LEFT JOIN n2ue4_categories AS c ON c.id = a.catid WHERE (a.published = 0 OR a.published = 1) ORDER BY category_title asc, a.ordering asc
    • Kevin Whitcomb
      Blue Planet Photo Studio
      813.494.4960
      www.blueplanetps.com

      da mihi castitatem et continentiam, sed noli modo
    #1115498

Time to create page: 0.061 seconds