LG LiveLook...........breaks upon pressing 'preview'
Development and Programming
Hello
This gets displayed when pressing Preview on a publish form
MySQL ERROR: Error Number: 1054
Description: Unknown column ‘Array’ in ‘where clause’
Query: SELECT r.rel_id, r.rel_child_id, wt.title FROM exp_relationships r, exp_weblog_titles wt, exp_weblogs w WHERE r.rel_id IN (Array) AND wt.entry_id = r.rel_child_id AND w.weblog_id = wt.weblog_id AND wt.entry_date < 1260804138 AND (wt.expiration_date = 0 OR wt.expiration_date > 1260804138) AND wt.status NOT IN (“closed”)
I initially thought it was just Playa making it break but it does it even ona simple text change.
On an EE 1.6.8 I have these running: MultiSiteManager….with 5 sites Playa Live Look TinyMCE/TinyBrowser Publish Plus FieldFrame LG Sitename LG Social Bookmarks Structure LG HT Access Gen JQuery …..and a fair few plugins, Image Sizer, FLV player….etc…etc
Please!!!
Someone must have an idea
This si the rror that comes up in the LiveLook window
Error Number: 1054
Description: Unknown column ‘Array’ in ‘where clause’
Query: SELECT r.rel_id, r.rel_child_id, wt.title FROM exp_relationships r, exp_weblog_titles wt, exp_weblogs w WHERE r.rel_id IN (Array) AND wt.entry_id = r.rel_child_id AND w.weblog_id = wt.weblog_id AND wt.entry_date < 1262597477 AND (wt.expiration_date = 0 OR wt.expiration_date > 1262597477) AND wt.status NOT IN (“closed”)
Hi Kreate,
Can you grab the latest version of LG LIve Look from Github and let me know how it goes?
http://github.com/newism/lg.live_look.ee_addon
Hi Leevi
Thanks for getting back.
I have looked a the page you sent. We were missing some files, that were not in the installation pack. i have put these on now, but still get the below error mesaage upon pressing preview.
Also, with these new settings I can only seem to have it where the previewindow appears as a tab and on the publish form…I wish only to have the sepearate tab.
thanks again
Kreate
MySQL ERROR:
Error Number: 1054
Description: Unknown column ‘Array’ in ‘where clause’
Query: SELECT r.rel_id, r.rel_child_id, wt.title FROM exp_relationships r, exp_weblog_titles wt, exp_weblogs w WHERE r.rel_id IN (Array) AND wt.entry_id = r.rel_child_id AND w.weblog_id = wt.weblog_id AND wt.entry_date < 1263814621 AND (wt.expiration_date = 0 OR wt.expiration_date > 1263814621) AND wt.status NOT IN (“closed”)
I don’t think this is a live look issue. The sql you posted looks like it’s a relationships error. What happens if you disable Playa?