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

Vacilando’s picture

Assigned: Unassigned » Vacilando

Is it a fresh installation or update from a previous version (which)?

Athrun’s picture

Fresh installation both drupal and this mod

Vacilando’s picture

Component: Picasa gallery » Code
Status: Active » Fixed

Fixed in 7.x-1.2.

Athrun’s picture

very nice, cheers guys :)

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

swashbuck’s picture

Version: 7.x-1.1 » 7.x-1.2
Status: Closed (fixed) » Needs review

I 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).

postak’s picture

getting 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)

robbdavis’s picture

Getting 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).

luisky’s picture

Drupal 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() (li­ne 122 ____modules/brilliant_gallery/functions.inc).

  • Vacilando committed b11f5a4 on 7.x-2.x
    Fixing a fresh installation bug, see #1560174.