Closed (fixed)
Project:
Gallery Assist
Version:
6.x-1.9
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
10 Apr 2010 at 09:25 UTC
Updated:
9 May 2010 at 07:10 UTC
Hi,
After update process, this error message appeared:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' data = 'a:6:s:8:"ga_align";s:6:"center";s:9:"gap_align";s:6:"center";s:10:"t_ga' at line 1 query: UPDATE gallery_assist set show_in_homepage_block = , data = 'a:6:s:8:"ga_align";s:6:"center";s:9:"gap_align";s:6:"center";s:10:"t_ga_float";s:4:"none";s:10:"p_ga_float";s:4:"none";s:11:"show_layout";s:4:"grid";s:6:"shadow";s:1:"0";' WHERE gref = 1 in /Applications/MAMP/htdocs/tuktok/sites/all/modules/gallery_assist/gallery_assist.install on line 550.
Comments
Comment #1
jcmc commentedFixed in 1.10.
Explanation of the posible cause
The field show_in_homepage_block is formated as int. The values in the settings are boleans.
The database wait for a value 0 or 1. The bolean variables containing 'nothing' or TRUE.
Comment #2
brulain commentedThanks a lot jcmc,
The 1.10 works fine !