Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
Allright guys,
Been trying to use the picasa function of this mod on drupal 7.12 with the 7.1.1 release. Once installed, the tag filter added, updates and even cron run (didn't know if it'll help, thought what the hell) I keep being presented with the following
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'zonedout_drup6.drup_brilliant_gallery_image_arrays' doesn't exist: SELECT COUNT(*) FROM {brilliant_gallery_image_arrays} WHERE hash = 'c59f471463d30a59cc6299bb969bb98b'; Array ( ) in brilliant_gallery_image_properties_set() (line 117 of /home/zonedout/public_html/tandem/modules/brilliant_gallery/functions.inc).
The website encountered an unexpected error. Please try again later.
I've taken a peek at the functions.inc file and it does state on line 115
// Let's keep the array in cache. Check if it is in cache. If not, write it.
// TODO Please convert this statement to the D7 database API syntax.
I am trying to provide as much info as I possibly can, this mod is practically perfect for what i'm after. (first report so play nice ;) )
Comments
Comment #1
Vacilando CreditAttribution: Vacilando commentedIs it a fresh installation or update from a previous version (which)?
Comment #2
Athrun CreditAttribution: Athrun commentedFresh installation both drupal and this mod
Comment #3
Vacilando CreditAttribution: Vacilando commentedFixed in 7.x-1.2.
Comment #4
Athrun CreditAttribution: Athrun commentedvery nice, cheers guys :)
Comment #6
swashbuck CreditAttribution: swashbuck commentedI am having this issue with version 7.x 1.2. Fresh install of the module, not an upgrade. This is a D7 site that was upgraded from a D6 site. The D6 site had Brilliant Gallery installed, but it was removed after upgrading the site to D7.
After installing the module, the only table I see in the database is brilliant_gallery_checklist. So, it fails when I run update.php and it tries to alter brilliant_gallery_image_arrays, which doesn't exist.
Failed: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table '---------.brilliant_gallery_image_arrays' doesn't exist: ALTER TABLE {brilliant_gallery_image_arrays} RENAME {brilliant_gallery_image_arrays_old};; Array ( ) in brilliant_gallery_update_7101() (line 89 of ---------/sites/all/modules/brilliant_gallery/brilliant_gallery.install).
Comment #7
postak CreditAttribution: postak commentedgetting similar error during every brilliant gallery cron run:
PDOException: SQLSTATE[HY000]: General error in brilliant_gallery_clean_table_image_arrays() (line 29 of /sites/all/modules/brilliant_gallery/cron.inc).
moreover, cache for Picasa pictures seems to be corrupted then
once it seemed that just manual "clear cache" helped, but after another occurrence I had to completely rebuild BG cache (new directory created)
tried to use drupal_flush_all_caches (which is called by manual cache clearing) instead of cache_clear_all in BG cron, but pages stopped responding completely...
only workaround I found is to use local pictures instead of Picasa
(fresh install of D7.15 + BG 7.x-1.2)
Comment #8
robbdavis CreditAttribution: robbdavis commentedGetting similar error:
PDOException: SQLSTATE[HY000]: General error in brilliant_gallery_clean_table_image_arrays() (line 29 of /pathto/sites/all/modules/brilliant_gallery/cron.inc).
Comment #9
luisky CreditAttribution: luisky commentedDrupal 7.22, Brilliant Gallery 1.5. Fresh install both drupal and the module
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table '___.brilliant_gallery_image_arrays' doesn't exist: SELECT COUNT(*) FROM {brilliant_gallery_image_arrays} WHERE hash = '716fee6902b450a88143fa1df6f95404'; Array ( ) en brilliant_gallery_image_properties_set() (line 122 ____modules/brilliant_gallery/functions.inc).