search

legumeinfo / jira-issues

placeholder repo for issues migrating from JIRA system, to be moved to their appropriate places later
0 stars 0 forks source link

Brilliant Gallery Module: Saving page as 'Full Html' with 'bg tag' fails with 'unexpected error at website' #560

Closed adf-ncgr closed 8 years ago

adf-ncgr commented 8 years ago

To reproduce the problem:
At peanutbase-dev go to http://peanutbase-dev/germplasm/images/from_ds
(This is a new drupal test page I created with exact same code from a very functional page, 'http://peanutbase-dev/germplasm/images/Flowers')
and try to save it with Text Format as 'Full HTML'.

Shows:' Error
The website encountered an unexpected error. Please try again later. '

The brilliant gallery tag '[bg|NoelleBarkley/Flowers]' appears to be the cause-- when I save the page with some other simple code, it saves okay as 'Full HTML'.

Question:
Why it doesn't elicit an error in the preexisting page but only in the new page when saved as 'Full HTML'??

Error from /var/log/message in the next comment.

[LEGUME-594] created by sdash-legume

adf-ncgr commented 8 years ago

Error from /var/log/message:
-------------------------------------

Jun 21 16:05:23 peanutbase-dev drupal: http://localhost:7500|1466543123|php|129.186.136.154|http://localhost:7500/node/554186/edit|http://localhost:7500/node/554186/edit|5||Notice: Trying to get property of non-object in drupal_alter() (line 1136 of /usr/local/www/drupal7/includes/module.inc).
Jun 21 16:05:23 peanutbase-dev drupal: http://localhost:7500|1466543123|php|129.186.136.154|http://localhost:7500/node/554186/edit|http://localhost:7500/node/554186/edit|5||Notice: Undefined variable: filenames in brilliant_gallery_get_picasa_hidden_imagenames() (line 540 of /usr/local/www/drupal7/sites/all/modules/brilliant_gallery/brilliant_gallery_functions.inc).
Jun 21 16:05:23 peanutbase-dev drupal: http://localhost:7500|1466543123|php|129.186.136.154|http://localhost:7500/node/554186/edit|http://localhost:7500/node/554186/edit|5||Warning: in_array() expects parameter 2 to be array, null given in load_dir_to_array() (line 37 of /usr/local/www/drupal7/sites/all/modules/brilliant_gallery/brilliant_gallery_functions.inc).
Jun 21 16:05:23 peanutbase-dev drupal: http://localhost:7500|1466543123|php|129.186.136.154|http://localhost:7500/node/554186/edit|http://localhost:7500/node/554186/edit|5||Warning: in_array() expects parameter 2 to be array, null given in load_dir_to_array() (line 37 of /usr/local/www/drupal7/sites/all/modules/brilliant_gallery/brilliant_gallery_functions.inc).
Jun 21 16:05:23 peanutbase-dev drupal: http://localhost:7500|1466543123|php|129.186.136.154|http://localhost:7500/node/554186/edit|http://localhost:7500/node/554186/edit|5||Warning: in_array() expects parameter 2 to be array, null given in load_dir_to_array() (line 37 of /usr/local/www/drupal7/sites/all/modules/brilliant_gallery/brilliant_gallery_functions.inc).
Jun 21 16:05:23 peanutbase-dev drupal: http://localhost:7500|1466543123|php|129.186.136.154|http://localhost:7500/node/554186/edit|http://localhost:7500/node/554186/edit|5||Notice: Trying to get property of non-object in drupal_alter() (line 1136 of /usr/local/www/drupal7/includes/module.inc).
Jun 21 16:05:23 peanutbase-dev postgres[22389]: [5-1] ERROR: value "7128767123" is out of range for type integer at character 140
Jun 21 16:05:23 peanutbase-dev postgres[22389]: [5-2] STATEMENT: INSERT INTO cache (cid, serialized, created, expire, data) VALUES ('bg_gallery_table_2b8e8bf727b82d69049732e802c0d602', '0', '1466543123', '7128767123',
Jun 21 16:05:23 peanutbase-dev postgres[22389]: [5-3] '\x3c756c207374796c653d22666f6e742d73697a653a203070783b206d617267696e3a203070783b2070616464696e673a203070783b2077696474683a2036323470783b223e3c6c.... .... ....

Jun 21 16:05:23 peanutbase-dev postgres[22389]: [5-7] 3435326134322e6a706722202f3e3c2f613e0a3c2f6c693e0a3c2f756c3e0a3c646976207374796c653d22636c6561723a20626f74683b223e3c2f6469763e0a')
Jun 21 16:05:23 peanutbase-dev postgres[22389]: [6-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
Jun 21 16:05:23 peanutbase-dev postgres[22389]: [6-2] STATEMENT: SELECT 1 AS expression
Jun 21 16:05:23 peanutbase-dev postgres[22389]: [6-3] FROM
Jun 21 16:05:23 peanutbase-dev postgres[22389]: [6-4] cache cache
Jun 21 16:05:23 peanutbase-dev postgres[22389]: [6-5] WHERE ( (cid = 'bg_gallery_table_2b8e8bf727b82d69049732e802c0d602') )
Jun 21 16:05:23 peanutbase-dev postgres[22389]: [7-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
Jun 21 16:05:23 peanutbase-dev postgres[22389]: [7-2] STATEMENT: SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('bg_gallery_table_2b8e8bf727b82d69049732e802c0d602')
Jun 21 16:05:23 peanutbase-dev postgres[22389]: [8-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
Jun 21 16:05:23 peanutbase-dev postgres[22389]: [8-2] STATEMENT: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES ('5', 'php', '%type: !message in %function (line %line of %file).', '\x613a363a7b733a353a222574797065223b733a363a224e6f74696365223b733a383a22216d657373616765223b733a32393a22556e646566696e6564207661726961626c653a2066696c656e616d6573223b733a393a222566756e6374696f6e223b733a34383a226272696c6c69616e745f67616c6c6572795f6765745f7069636173615f68696464656e5f696d6167656e616d65732829223b733a353a222566696c65223b733a39303a222f7573722f6c6f63616c2f7777772f64727570616c372f73697465732f616c6c2f6d6f64756c65732f6272696c6c69616e745f67616c6c6572792f6272696c6c69616e745f67616c6c6572795f66756e6374696f6e732e696e63223b733a353a22256c696e65223b693a3534303b733a31343a2273657665726974795f6c6576656c223b693a353b7d', '5', '', 'http://localhost:7500/node/554186/edit',

by sdash-legume

adf-ncgr commented 8 years ago

Sudhansu,

The SQL is being generated at the code /usr/local/www/drupal7/sites/all/modules/brilliant_gallery/brilliant_gallery_functions.inc:430 . If I understand the code correctly, it's taking the value of brilliant_gallery_cache_duration (in days), translating it to seconds, and adding it to the time create (in seconds).

In the Brilliant Gallery config (http://peanutbase-dev.agron.iastate.edu/admin/config/brilliant_gallery), the expiration time is set to 65535 days. This is 5662224000 seconds, which, when added to the created time (1466543123), == 7128767123.

To fix, I suggest reducing the "Expiration time of the gallery cache (in days)" in the above menu to a sane value (the default is apparently 90).

by nathanweeks

adf-ncgr commented 8 years ago

Brilliant detective work on the Brilliant Gallery. Changing to 1 day in BG config, as suggested by Nathan, helped to save in 'Full HTML' format.

Although, I am not able to wrap my head around how reducing the cache duration is related to saving the drupal page in 'Full HTML' text format.
Thanks.
Sudhansu

by sdash-legume