Support Forums

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

Your Time: Our Time:

Error while placing Fimes in Highlight in SP Moview

Featured Lock Resolved Bug
Hello friends I am facing a annoying problem, when I create a movie in the component database, if I do not check the option in HIGHLIGHT inside a movie, it works normal, more when I put in HIGHLIGHT to be able to appear in FRONT-END.
The following screen appears when I update to the start of the site.

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

Below I will leave the Print with the error, the error happens only when I put a featured movie!

10 Answers

Sifat - Staff

More than a month ago #Permalink
Hi,
Thanks for your query. Yes i also found that issue. I'm informing this to our development team. Don't worry we'll solve this in the next update.

-Best Regards

Rifat Wahid Alif - Staff

More than a month ago #Permalink
Hi,
Please open the following file /modules/mod_spmoviedb_tab/helper.php on 58 to 63 no line you will get:


foreach ($items as &$item) {
$item->genres = $model::getGenries($item->genres);
$item->url = JRoute::_('index.php?option=com_spmoviedb&view=movie&id=' . $item->spmoviedb_movie_id . ':' . $item->slug . SpmoviedbHelper::getItemid('movies'));
$item->turls = $model::GenerateTrailers($item->spmoviedb_movie_id);
$item->ratings = self::getRatings($item->spmoviedb_movie_id);
}

replace it by:

foreach ($items as &$item) {
$item->genres = ($item->genres && $item->genres != '[]') ? $model->getGenries($item->genres) : array();
$item->url = JRoute::_('index.php?option=com_spmoviedb&view=movie&id=' . $item->spmoviedb_movie_id . ':' . $item->slug . SpmoviedbHelper::getItemid('movies'));
$item->turls = $model->GenerateTrailers($item->spmoviedb_movie_id);
$item->ratings = self::getRatings($item->spmoviedb_movie_id);
}


again open /modules/mod_spmoviedb_movie/helper.php on 41 to 48 no line you will get:

foreach ($items as &$item) {
$item->genres = $model->getGenries($item->genres);
$item->actors = $model->getCelebrities($item->actors);
$item->url = JRoute::_('index.php?option=com_spmoviedb&view=movie&id=' . $item->spmoviedb_movie_id . ':' . $item->slug . SpmoviedbHelper::getItemid('movies'));
$item->turls = $model->GenerateTrailers($item->spmoviedb_movie_id);
$item->ratings = self::getRatings($item->spmoviedb_movie_id);

}

replace it by:

foreach ($items as &$item) {
$item->genres = ($item->genres && $item->genres != '[]') ? $model->getGenries($item->genres) : array();
$item->actors = ($item->actors && $item->actors != '[]') ? $model->getCelebrities($item->actors) : array();
$item->url = JRoute::_('index.php?option=com_spmoviedb&view=movie&id=' . $item->spmoviedb_movie_id . ':' . $item->slug . SpmoviedbHelper::getItemid('movies'));
$item->turls = $model->GenerateTrailers($item->spmoviedb_movie_id);
$item->ratings = self::getRatings($item->spmoviedb_movie_id);
}


- Thanks

Junior

More than a month ago #Permalink
Thanks for the code friend, everything worked out solved my problem. Thank you and Strong Hug!

Rifat Wahid Alif - Staff

More than a month ago #Permalink
Hi,
I am really happy to see that, your problem is solved, Could you please accept answer the reply which solved your problem. In this case, maybe you need to unresolve the post first, then you will get accept answer option.

- Thanks

Junior

More than a month ago #Permalink
Hi,
Please open the following file /modules/mod_spmoviedb_tab/helper.php on 58 to 63 no line you will get:


foreach ($items as &$item) {
$item->genres = $model::getGenries($item->genres);
$item->url = JRoute::_('index.php?option=com_spmoviedb&view=movie&id=' . $item->spmoviedb_movie_id . ':' . $item->slug . SpmoviedbHelper::getItemid('movies'));
$item->turls = $model::GenerateTrailers($item->spmoviedb_movie_id);
$item->ratings = self::getRatings($item->spmoviedb_movie_id);
}

replace it by:

foreach ($items as &$item) {
$item->genres = ($item->genres && $item->genres != '[]') ? $model->getGenries($item->genres) : array();
$item->url = JRoute::_('index.php?option=com_spmoviedb&view=movie&id=' . $item->spmoviedb_movie_id . ':' . $item->slug . SpmoviedbHelper::getItemid('movies'));
$item->turls = $model->GenerateTrailers($item->spmoviedb_movie_id);
$item->ratings = self::getRatings($item->spmoviedb_movie_id);
}


again open /modules/mod_spmoviedb_movie/helper.php on 41 to 48 no line you will get:

foreach ($items as &$item) {
$item->genres = $model->getGenries($item->genres);
$item->actors = $model->getCelebrities($item->actors);
$item->url = JRoute::_('index.php?option=com_spmoviedb&view=movie&id=' . $item->spmoviedb_movie_id . ':' . $item->slug . SpmoviedbHelper::getItemid('movies'));
$item->turls = $model->GenerateTrailers($item->spmoviedb_movie_id);
$item->ratings = self::getRatings($item->spmoviedb_movie_id);

}

replace it by:

foreach ($items as &$item) {
$item->genres = ($item->genres && $item->genres != '[]') ? $model->getGenries($item->genres) : array();
$item->actors = ($item->actors && $item->actors != '[]') ? $model->getCelebrities($item->actors) : array();
$item->url = JRoute::_('index.php?option=com_spmoviedb&view=movie&id=' . $item->spmoviedb_movie_id . ':' . $item->slug . SpmoviedbHelper::getItemid('movies'));
$item->turls = $model->GenerateTrailers($item->spmoviedb_movie_id);
$item->ratings = self::getRatings($item->spmoviedb_movie_id);
}


- Thanks
Thanks, with this code the problem is solved immediately! Strong hug !

Rifat Wahid Alif - Staff

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

And

More than a month ago #Permalink
Hello,

I had the same problem, I used this code and everything worked again and I was very happy to have found this post on the forum.:o

This again planted !
I used this code again, it did not work.
I re-install page builder, it did not work too.

I had to install a back-up of my SQL database to put back the site !!!
I lost 2 days of work, which is deplorable ..:o

There is a lot of post on the forum about this, with this problem on the template Moview !! :o :o

The problem seems "persistent" :( :(

Rifat Wahid Alif - Staff

More than a month ago #Permalink
Hi,
Thanks for your reply. Are you still facing any issue, please?

- Thanks

And

More than a month ago #Permalink
Hello,

After too many problems on this template, because little creative possibility, too closed and frozen in the customization of the pages.

Ex: If we do not put any "Genre" movie or no "Actor" nothing works ..... :(

I initialized my FTP and my database, then bought another pack like shaper_aresmurphy

More simple and more creative for its layout and option (activation or deactivation).

Cordially

Rifat Wahid Alif - Staff

More than a month ago #Permalink
Hi,
Please send us a list of what issues are you facing, then we will discuss with the team and we will improve this on the upcoming update.

- Thanks


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Leaderboard (30 days)

Paul Frankowski

Paul Frankowski

Total Accepted Answers: 105
Sifat

Sifat

Total Accepted Answers: 104
Toufiq

Toufiq

Total Accepted Answers: 36
Pavel

Pavel

Total Accepted Answers: 4
J

johnny

Total Accepted Answers: 3

100+

Templates

200,000+

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