[XB] TMDb Movie Thread Starter [Paid] 2.2.4 Patch Level 2

[hello2029]

I am encountering the following error, how can I fix it?
You are trying to post a TV show in a movie forum

 

[Ozzy47]

You can’t post a tv show in the movie addon.

 

[hello2029]

You can’t post a tv show in the movie addon.

 

[hello2029]

I checked the server log and found the following error message, but I'm not sure what the reason is.

Server error log

• XF\Db\Exception: Job Snog\Movies:MovieCommunityChangesApply: MySQL statement prepare error [1146]: Table 'almalinux_todo1987.xf_snog_tv_thread' doesn't exist
• src/XF/Db/AbstractStatement.php:230
• Generated by: Unknown account
• 5 June 2023 at 7:08 AM

Stack trace​

SELECT thread_id
FROM xf_snog_tv_thread
WHERE thread_id > ? AND tmdb_last_change_date < ?
ORDER BY thread_id

LIMIT 100
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 1146, '42S02')
#1 src/XF/Db/Mysqli/Statement.php(41): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1146, '42S02')
#2 src/XF/Db/Mysqli/Statement.php(56): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(172): XF\Db\AbstractAdapter->query('
SELECT thr...', Array)
#5 src/addons/Snog/Movies/Job/MovieCommunityChangesApply.php(29): XF\Db\AbstractAdapter->fetchAllColumn('
SELECT thr...', Array)
#6 src/XF/Job/AbstractRebuildJob.php(30): Snog\Movies\Job\MovieCommunityChangesApply->getNextIds(0, 100)
#7 src/addons/Snog/Movies/Job/MovieCommunityChangesApply.php(15): XF\Job\AbstractRebuildJob->run(3.65555)
#8 src/XF/Job/Manager.php(260): Snog\Movies\Job\MovieCommunityChangesApply->run(3.65555)
#9 src/XF/Job/Manager.php(202): XF\Job\Manager->runJobInternal(Array, 3.65555)
#10 src/XF/Job/Manager.php(86): XF\Job\Manager->runJobEntry(Array, 3.65555)
#11 job.php(43): XF\Job\Manager->runQueue(false, 8)
#12 {main}

 

[mcatze]

@Ozzy47 That is an issue in src/addons/Snog/Movies/Job/MovieCommunityChangesApply.php line 22 - 28

SELECT thread_id
FROM xf_snog_tv_thread
WHERE thread_id > ? AND tmdb_last_change_date < ?
ORDER BY thread_id

Should be...

SELECT thread_id
FROM xf_snog_movie_thread
WHERE thread_id > ? AND tmdb_last_change_date < ?
ORDER BY thread_id

 

[Painbaker]

I checked the server log and found the following error message, but I'm not sure what the reason is.

Will be fixed in next update

 

[hello2029]

@Painbaker Does this add-on include an automatic function to post all movies from the database of https://www.themoviedb.org/? If it does, that would be perfect.

 

[Painbaker]

Does this add-on include an automatic function to post all movies from the database of https://www.themoviedb.org/? If it does, that would be perfect.

No

But we can add tool to bulk add movies/tv shows based on their API filters, if someone is willing to fund the work.

 

[hello2029]

No

But we can add tool to bulk add movies/tv shows based on their API filters, if someone is willing to fund the work.

What would be the estimated cost for building a tool that can automatically update the movie database and check for new movies from https://www.themoviedb.org/?

 

[Max Taxable]

What would be the estimated cost for building a tool that can automatically update the movie database and check for new movies from https://www.themoviedb.org/?

That's scraping... Sounds like you want it to act as a content scraper.

 

[hello2029]

That's scraping... Sounds like you want it to act as a content scraper.

I am unsure of its specific name, but I desire a feature that can automatically post updates about the latest movies every day. Currently, I have to perform this task manually.

 

[Max Taxable]

I am unsure of its specific name, but I desire a feature that can automatically post updates about the latest movies every day. Currently, I have to perform this task manually.

Not sure they would appreciate automated scraping of their content. Would need to be investigated.

 

[hello2029]

Not sure they would appreciate automated scraping of their content. Would need to be investigated.

In fact, this add-on is doing the same thing.

I simply require the procedure for entering the movie's link. The add-on will then take care of fetching and updating any additional content automatically.

 

[Max Taxable]

In fact, this add-on is doing the same thing.

Your original request leaves the impression you want to use automation to scrape their entire content and any updates to same. This product doesn't do that.

 

[Kevin]

Two items...

1) Any thoughts on why the streaming providers would not be pulled in? Example: https://wlt80s.com/threads/the-pumaman-1980.1068/ vs https://www.themoviedb.org/movie/31278-l-uomo-puma/watch?locale=US -- In this case PlutoTV did not get pulled as one of the available streaming services. I tried all of the various 'rebuild' options in the ACP with no success.​

​

2) In the template snog_movie_post_macros it should check to see if $company.homepage is blank. Some production companies, like Virgin Films (which did, for example, Electric Dreams, back in the 80's) no longer exist. TMDB ends up with some entries then have the company name listed but without any associated homepage.​

 

[hello2029]

When do you guys handle this.

 

[Max Taxable]

When do you guys handle this.

View attachment 288132

When we see the entire error with stack trace? Try clicking on the error for details and paste them here.

 

[hello2029]

When we see the entire error with stack trace? Try clicking on the error for details and paste them here.

[XB] TMDb Movie Thread Starter [Paid]

I am encountering the following error, how can I fix it? You are trying to post a TV show in a movie forum

xenforo.com

I posted here.

 

[Max Taxable]

[XB] TMDb Movie Thread Starter [Paid]

I am encountering the following error, how can I fix it? You are trying to post a TV show in a movie forum

xenforo.com

I posted here.

Answered.

Will be fixed in next update

Update not yet ready for release.

 

[hello2029]

Answered.
Update not yet ready for release.

Thank you for your info.

I have observed the response that will resolve the issue in the upcoming update.

My concern is, when can I expect it to be addressed?

I believe as a customer, I have the right to ask the same question.