search

risingisland / Easy-2-Gallery

A MODx Evolution 1.1+ image gallery
4 stars 4 forks source link

Did an update and on front-end I get an Error #2

Closed fourroses666 closed 7 years ago

fourroses666 commented 7 years ago 
451 : #1064 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 ') AND (SELECT count(*) FROM modx_easy2_files F WHERE F.dir_id IN (SELECT A.cat_i' at line 1
SELECT COUNT(DISTINCT d.cat_id) FROM modx_easy2_dirs AS d WHERE d.parent_id IN () AND (SELECT count(*) FROM modx_easy2_files F WHERE F.dir_id IN (SELECT A.cat_id FROM modx_easy2_dirs A, modx_easy2_dirs B WHERE (B.cat_id = d.cat_id AND A.cat_left >= B.cat_left AND A.cat_right <= B.cat_right AND A.cat_level >= B.cat_level AND A.cat_visible = 1)))<>0 AND d.cat_visible=1
552 : #1064 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 ') AND (SELECT count(*) FROM modx_easy2_files F WHERE F.dir_id IN (SELECT A.cat_i' at line 1
SELECT d.* FROM modx_easy2_dirs AS d WHERE d.parent_id IN () AND (SELECT count(*) FROM modx_easy2_files F WHERE F.dir_id IN (SELECT A.cat_id FROM modx_easy2_dirs A, modx_easy2_dirs B WHERE (B.cat_id = d.cat_id AND A.cat_left >= B.cat_left AND A.cat_right <= B.cat_right AND A.cat_level >= B.cat_level AND A.cat_visible = 1)))<>0 AND d.cat_visible=1 ORDER BY cat_id DESC LIMIT 0, 9
fourroses666 commented 7 years ago

Might be missing some `` or FROM when looking on Google

Breezer commented 7 years ago

After update did you use the sync function in the gallery module? Also try going into evo admin and open either the e2g snippet, plugin, or module in edit mode, then save. A similar issue happened before and that solved it.

fourroses666 commented 7 years ago

Ah thanks, will have a look at it tomorrow. Didn't spent too much time on it after install.

fourroses666 commented 7 years ago

After Synchronize I get an error:

1575 : #1054 Unknown column 'cat_tag' in 'field list'
SELECT DISTINCT cat_tag FROM modx_easy2_dirs
fourroses666 commented 7 years ago

Have changed the snippet call. Blank page now on front-end. Upgrade from such old version might be an issue. I have to rethink this. Or a new blank install or use an other Galleryscript.