Support Online : Mon - Fri / 10am - 6pm (GMT +6)

Your Time: Our Time:

Something wrong with Movie Database

Featured Lock Resolved
I get this:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 3 SQL=SELECT a.* FROM `#__spmoviedb_genres` AS `a` WHERE `a`.`spmoviedb_genre_id` IN ()

Can anyone help?

Thanks

19 Answers

Rifat Wahid Alif - Staff

More than a month ago #Permalink
Hi,
Make sure that you have items in movie and genre.

- Thanks

jedmed

More than a month ago #Permalink
Do I need to pay something so that anyone from the devs will respond?

jedmed

More than a month ago #Permalink
Thank you.

I am currently populating my movie database, but there appears to be some issue with the layout. Can you look:

http://psycho-drama.com/reviews

Also, how can I insert the disqus comment?

Rifat Wahid Alif - Staff

More than a month ago #Permalink
Hi,
I have attached a file, please replace it to following location: /components/com_spmoviedb/views/movies/tmpl/

- Thanks

Attachments (1)

  • default.zip 2.1 KB

jedmed

More than a month ago #Permalink
Rifat Wahid Alif wrote:

Hi,
I have attached a file, please replace it to following location: /components/com_spmoviedb/views/movies/tmpl/

- Thanks


Thank you, it works perfect!

Rifat Wahid Alif - Staff

More than a month ago #Permalink
you are always welcome :)

Juan

More than a month ago #Permalink
Hi
Thanks for your time.
I am working with sp movie database and when I click on "more details" the error is 403 denied access. Can you pelase help me?
Thanks

Rifat Wahid Alif - Staff

More than a month ago #Permalink
Hi,
you will get Link URL filed in Advanced Title addon in sp pagebuilder. make sure that Link URL is working url.

- Thanks

Juan

More than a month ago #Permalink
Hi
Thanks for your answer.
I dont know when I can find the URL? components >> SP MOVIE DATABASE >> Movie >> Selecting the tittle >> ???
Can I change the txt "More details" for "Más Informacion" Also, where I could removed the bottom?
Thanks


Rifat Wahid Alif wrote:

Hi,
you will get Link URL filed in Advanced Title addon in sp pagebuilder. make sure that Link URL is working url.

- Thanks

Juan

More than a month ago #Permalink
Hi
Thanks for your answer.
I dont know when I can find the URL? components >> SP MOVIE DATABASE >> Movie >> Selecting the tittle >> ???
Can I change the txt "More details" for "Más Informacion" Also, where I could removed the bottom?
Thanks


Rifat Wahid Alif wrote:

Hi,
you will get Link URL filed in Advanced Title addon in sp pagebuilder. make sure that Link URL is working url.

- Thanks

Rifat Wahid Alif - Staff

More than a month ago #Permalink
Hi,
Please turned off your Search Engine Friendly URLs and then go frontend > go to your desired menu and then your will full url of your desired page, check it here: http://prntscr.com/cp5nvr just paste it without our base url something like: index.php?option=com_spmoviedb&view=movies&Itemid=556

Please make sure that, which bottom did you mentioned?

- Thanks

Juan

More than a month ago #Permalink
Hi Rifat again.
You are very kind and provide a great information.
I dont know where I need to paste the url in the componen?
1. Movies: Basic information? or Movie links? or Trailer links? and where?
2. Celebrities.
3. Genres
4. Reviews

Please check the picture attachment. The circles mean where if I click the result is 403, the bottom i: more details. How I could re-edit the bottom?
The rectangles are links as well. Can I removed that links?
hanks Rifat


Rifat Wahid Alif wrote:

Hi,
Please turned off your Search Engine Friendly URLs and then go frontend > go to your desired menu and then your will full url of your desired page, check it here: http://prntscr.com/cp5nvr just paste it without our base url something like: index.php?option=com_spmoviedb&view=movies&Itemid=556

Please make sure that, which bottom did you mentioned?

- Thanks

Attachments (1)

  • Captura de pantalla 2016-10-09 a las 0.37.40.png
    Captura de pantalla 2016-10-09 a las 0.37.40.png 1010.7 KB

Rifat Wahid Alif - Staff

More than a month ago #Permalink
It should working. could you please pm me your admin access with website admin url ?

Juan

More than a month ago #Permalink
Hi
Thanks
my url is http://theinfinitynz.com
the videos are:
http://theinfinitynz.com/videos-de-nueva-zelanda

How could I send you the access? I mean, I dont want to post this info for everybody :)

Rifat Wahid Alif wrote:

It should working. could you please pm me your admin access with website admin url ?

Toufiq - Staff

More than a month ago #Permalink
joom wrote:

Hi
Thanks
my url is http://theinfinitynz.com
the videos are:
http://theinfinitynz.com/videos-de-nueva-zelanda

How could I send you the access? I mean, I dont want to post this info for everybody :)

Rifat Wahid Alif wrote:

It should working. could you please pm me your admin access with website admin url ?


Hi, Thanks for your reply. Please come to live chat. I want to know in details that you want to do. Before come to live chat. Please inform me via pm & [email protected] Thanks

Qalandar

More than a month ago #Permalink
Also, how can I insert the disqus comment?
was this question answered?

Qalandar

More than a month ago #Permalink
Also, how can I insert the disqus comment?
was this question answered?
Hello? Anyone?

Toufiq - Staff

More than a month ago #Permalink
Also, how can I insert the disqus comment?
was this question answered?
Hello? Anyone?


Hi there, Please create a new forum post and include this forum post. Also, mention your problem. Thanks


There are no replies made for this post yet.
Be one of the first to reply to this post!

Leaderboard (30 days)

Paul Frankowski

Paul Frankowski

Total Accepted Answers: 98
Toufiq

Toufiq

Total Accepted Answers: 51
Sifat

Sifat

Total Accepted Answers: 38
Ofi Khan

Ofi Khan

Total Accepted Answers: 21
Mehtaz Afsana Borsha

Mehtaz Afsana Borsha

Total Accepted Answers: 21

119

Templates

306696

Community Users

Newsletter

Don’t miss any updates of our new templates and extensions and all the astonishing offers we bring for you.
We never spam

Joomla! ® name is used under a limited license from Open Source Matters in the United States and other countries. JoomShaper.com is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.

Connect Us