Support Forums

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

Your Time: Our Time:

404 Error when put a movie on featured

Featured Lock Resolved Bug
Why everytime i turn a movie to featured, it's gone to 404 Error?

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 ')' at line 3

18 Answers

Yofie Setiawan

More than a month ago #Permalink
Hi Toufiq, thanks, it seems we actually need only to fill in all director, actors, and genre, can't leave it blank..

Toufiq - Staff

More than a month ago #Permalink
Hi there,

Please update the Moview Extension & go to extension > manage > database > http://prntscr.com/j13mwl

-Thanks

Yofie Setiawan

More than a month ago #Permalink
Hi,

Sorry but this doesn't solve the problem, please check http://moviewme.com/nu/

I already made 1 movie featured, and it goes to 404 error page...

Yofie Setiawan

More than a month ago #Permalink
And there is this message on Other Information

Database schema version (in #__schemas): 3.8.6-2018-02-14.
Update version (in #__extensions): 3.8.6.
Database driver: mysqli.
150 database changes were checked.
185 database changes did not alter table structure and were skipped.

Toufiq - Staff

More than a month ago #Permalink
Hi there, Please keep a backup and uninstall first then reinstall the extension. Thanks

Yofie Setiawan

More than a month ago #Permalink
Hi,

I already backup and reinstall the SP Movie Database component, but now seems all the basic setup for the modules are gone... What should i do? I can't confirm if the problem solved or not since the featured module is also gone from the homepage.

http://moviewme.com/nu/

Toufiq - Staff

More than a month ago #Permalink
Hi there,

Please send me a backup copy of google drive link via PM.

-Thanks

Yofie Setiawan

More than a month ago #Permalink
Hi,

Sent via pm...

Toufiq - Staff

More than a month ago #Permalink
Hi,

You can download here

files : http://moviewme.com/nu/backup20180405.zip
database : https://www.dropbox.com/s/9w0m49bci7acwue/moview3_nu.sql


Hi, I need to time fix it. Thanks

Toufiq - Staff

More than a month ago #Permalink
Hi,

Download the file and replace the below file location to fix the problem.

modules/mod_spmoviedb_movie/helper.php

-Thanks

Attachments (1)

  • helper.zip 1.4 KB

Yofie Setiawan

More than a month ago #Permalink
Hi Toufiq,

Thank you very much, the error seems not there anymore. But when i put the movie on featured, shouldn't it suppose to appear on that area under the header? It seems the movie i put on featured, doesnt appear there... Can you please check?

http://moviewme.com/nu/

Toufiq - Staff

More than a month ago #Permalink
Hi, Give me administrator access via pm. Thanks

Yofie Setiawan

More than a month ago #Permalink
Hi, i already pm...

Toufiq - Staff

More than a month ago #Permalink
Hi, Please check now. Thanks

Toufiq - Staff

More than a month ago #Permalink
Hi Toufiq, thanks, it seems we actually need only to fill in all director, actors, and genre, can't leave it blank..


Yes

And

More than a month ago #Permalink
Hi,

So the trick is to leave all the fields in activation :

Directors, Actors and Genres!
To avoid the Bug ??? :o

Toufiq - Staff

More than a month ago #Permalink
Hi,

So the trick is to leave all the fields in activation :

Directors, Actors and Genres!
To avoid the Bug ??? :o


Hi there, This is not a bug. You have to put those fields. You can't keep it empty. Thanks


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

Leaderboard (30 days)

Sifat

Sifat

Total Accepted Answers: 122
Paul Frankowski

Paul Frankowski

Total Accepted Answers: 90
Toufiq

Toufiq

Total Accepted Answers: 33
J

johnny

Total Accepted Answers: 3
Pavel

Pavel

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