mClip - Movie Module

[Heckler]

This module is awesome, only problem is that it doesn't look good on dark themes, but other than that it's a really nice module

[rlgura]

Heckler wrote:

only problem is that it doesn't look good on dark themes,

It looks fine on my site (running same theme as yours ). I'm not running the latest code, so unless Mark changed something in the templates the last couple rounds... What's the problem - I didn't see Movie module on your site...

[IgorMM]

hi the module is the best.

only one problem i have, i get emails with sql errors itk show like this:

Code::

On /index.php?name=Movie&mid=6 While executing query " SELECT m.*, c.ctitle, c.cimage, t.tname, t.timage, t.tplayer, t.tmovies, t.thtml, t.tdefault FROM cms_movie_movie AS m LEFT JOIN cms_movie_cat AS c ON (c.cid=m.cid) LEFT JOIN cms_movie_type AS t ON (t.tid=m.tid) WHERE m.mid 6 AND m.cid IN (0,1,2,3,4,5) AND (m.mtags LIKE '%Jeff%' OR m.mtags LIKE '%Dunham%' OR m.mtags LIKE '%-%' OR m.mtags LIKE '%Achmed's%' OR m.mtags LIKE '%Jingle%' OR m.mtags LIKE '%Bombs%') AND m.mapprove = 1 ORDER BY m.datetime DESC LIMIT 3" the following error occured: 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 's%' OR m.mtags LIKE '%Jingle%' OR m.mtags LIKE '%Bombs%')

how to fix it?

thx

[Kendle]

Heckler wrote:

This module is awesome, only problem is that it doesn't look good on dark themes, but other than that it's a really nice module

There's some additional stuff added in v2.x for the rating script and some other AJAX/javascript stuff. There's a stylesheet in /themes/YOURTHEME/style/Movie you can play with to make it better integrated if you like.

Don't forget also the module is templated so you can play with those to customise the look and feel.

[Kendle]

IgorMM wrote:

hi the module is the best. only one problem i have, i get emails with sql errors itk show like this: Code:: On /index.php?name=Movie&mid=6 While executing query " SELECT m.*, c.ctitle, c.cimage, t.tname, t.timage, t.tplayer, t.tmovies, t.thtml, t.tdefault FROM cms_movie_movie AS m LEFT JOIN cms_movie_cat AS c ON (c.cid=m.cid) LEFT JOIN cms_movie_type AS t ON (t.tid=m.tid) WHERE m.mid 6 AND m.cid IN (0,1,2,3,4,5) AND (m.mtags LIKE '%Jeff%' OR m.mtags LIKE '%Dunham%' OR m.mtags LIKE '%-%' OR m.mtags LIKE '%Achmed's%' OR m.mtags LIKE '%Jingle%' OR m.mtags LIKE '%Bombs%') AND m.mapprove = 1 ORDER BY m.datetime DESC LIMIT 3" the following error occured: 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 's%' OR m.mtags LIKE '%Jingle%' OR m.mtags LIKE '%Bombs%') how to fix it? thx

I'm assuming that code is the SQL that looks up related movies, however I've just checked on my site and it works fine. The actual SQL statement has an error

WHERE m.mid 6

should be

WHERE m.mid <> 6


I can only suggest re-uploading the module files. As far as I can see the code in v2.1.2 is correct (the specific file is /modules/Movie/includes/movie.inc)

[Heckler]

Kendle wrote:

Heckler wrote: This module is awesome, only problem is that it doesn't look good on dark themes, but other than that it's a really nice module There's some additional stuff added in v2.x for the rating script and some other AJAX/javascript stuff. There's a stylesheet in /themes/YOURTHEME/style/Movie you can play with to make it better integrated if you like. Don't forget also the module is templated so you can play with those to customise the look and feel.

Good to know I just didn't like how the tabs looked, but I can change that now so it's all good.

@ rlgura you can't see it because it's a secret I can't see it on your site either...

[Kendle]

IgorMM wrote:

hi the module is the best. only one problem i have, i get emails with sql errors itk show like this: Code:: On /index.php?name=Movie&mid=6 While executing query " SELECT m.*, c.ctitle, c.cimage, t.tname, t.timage, t.tplayer, t.tmovies, t.thtml, t.tdefault FROM cms_movie_movie AS m LEFT JOIN cms_movie_cat AS c ON (c.cid=m.cid) LEFT JOIN cms_movie_type AS t ON (t.tid=m.tid) WHERE m.mid 6 AND m.cid IN (0,1,2,3,4,5) AND (m.mtags LIKE '%Jeff%' OR m.mtags LIKE '%Dunham%' OR m.mtags LIKE '%-%' OR m.mtags LIKE '%Achmed's%' OR m.mtags LIKE '%Jingle%' OR m.mtags LIKE '%Bombs%') AND m.mapprove = 1 ORDER BY m.datetime DESC LIMIT 3" the following error occured: 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 's%' OR m.mtags LIKE '%Jingle%' OR m.mtags LIKE '%Bombs%') how to fix it? thx

Actually, at 2nd glance there's another error. You have a search tag with a quote in it Achmed's. This needs to be escaped or else it's not valid SQL.

I've uploaded a new package, v2.1.3, please use the new package, it should fix your problem.

www.cmsdreams.co.uk/Do.../id=1.html

[Heckler]

Something I'd love to see added to this module would be categories accessable by only a certain group

[Kendle]

Heckler wrote:

Something I'd love to see added to this module would be categories accessable by only a certain group

Already available, but only in the commercial version:-

www.cmsdreams.co.uk/St...id=31.html

[Heckler]

ahhhhhh

[Bluefin221]

I noticed on the share part (great feature) you have

Facebook
Del.icio.us
Digg
Google
Y! MyWeb

I was wondering whether it was possible that bebo could be added, its hugely popular, I'd say 90% of my site have a bebo account.

[Kendle]

Probably, would you happen to know the URL / syntax to use to share / bookmark something on bebo?

[Bluefin221]

Kendle wrote:

Probably, would you happen to know the URL / syntax to use to share / bookmark something on bebo?

Here is the URL for bebo www.bebo.com/

I haven't looked for the syntax been away all weekend and have a seriously bad hangover so not functioning properly.

[layingback]

Might be easier if you can find an accessible site which has an option to log to bebo. If your vision's not to blurry, mate!

[IgorMM]

i have the version 2.1.3 and i have a problem with comments, when you klick submit, the site doesent refresh, and stands still.