[XFA] Media Of The Month [Paid] 3.6.0

[Donny]

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'xfa_motm_winner' in 'where clause' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, Today at 12:13 PM

Any idea what could cause this?

 

[XFA]

Seems like the field is missing in the table.

Did you perform an upgrade or a clean install ?

 

[Donny]

Upgraded from TC version to XFA version. Following the guide and using the data transfer add on thing.
My cron doesn't seem to be running either.

Is it worth me uninstalling it fully (I assume it keeps the data all in tact?) and re-installing a fresh?

 

[XFA]

No, uninstalling removes the datas.

Could you check in xenresource_media and xenresource_album which xfa_* fields are present ?

 

[Donny]

In the database yeah?

Edit: no mustn't mean the database the tables are named xf_resource etc

I'm lost, where do I check for that?

 

[XFA]

Yes in the database.

Sorry, I meant xengallery_media and xengallery_album.

 

[Donny]

Yes in the database.

Sorry, I meant xengallery_media and xengallery_album.

Sorry I should have worked it out that you didn't mean the resource! It has been a long 24 hours!



This is what's there.

 

[XFA]

Hum ?! The field is there in the table, are you sure you are giving me the information from the right database ?
That error shouldn't show up. Is it a recurrent one ?

Do you have the full error log ?

 

[Donny]

I've cleared the error logs now as I had some related to bounced emails and it was looking messy.

I can change the time for the cron job and run it again perhaps?
Maybe I could give you my forum login details and you take a look? I bet you can find the problem in seconds?

 

[XFA]

Do not change ! The cron must run every night.

The media of the month album is created when the cron runs if you had set it to generate on that particular day through the options.

 

[Donny]

Okay so it's set for the 1st, and it didn't run. The tables are there. I've upgraded to 2.0. Anything else I can try?

 

[XFA]

It's set for the 1st, but you apparently had issue by that time.

We are currently the 20th of october so not the 1st hence it won't create.

Either set it to generate on the 21st eg. or wait for the 1st of next month. Up to you.

 

[XFA]

XFA updated [XFA] Media Of The Month with a new update entry:

New features

New features:

• Configurable number of votes per user per MOTM session (option, registered when MOTM contest start)
• Link to MOTM thread (if set to single) in album sidebar information block
• 2 working modes:
  • Mode 1: Monthly album generation allowing user to submit medias for vote with submission/voting phases (initial mode)
  • Mode 2: No dedicated album, each month users votes for any medias in the gallery, most voted one awarded,...

Read the rest of this update entry...

 

[XFA]

When changing of mode in the new version, be sure to have read the FAQ HERE.

 

[Alpha1]

Please add a setting to use the default rating function instead.

 

[popr]

Indeed... the issue is that it's how the xenforo media gallery add-on works, when you submit multiple medias, there is no firing of a controller event for each media but at the end of the all medias process...

So I don't have an easy way to know which image has been uploaded in that potential multiple upload process when the controller is fired.

I would buy 3 copies immediately if you do find a way to have it display the images in the thread.

 

[XFA]

Please add a setting to use the default rating function instead.

With a reset of the ratings each month ?

I would buy 3 copies immediately if you do find a way to have it display the images in the thread.

I'll investigate.

 

[Alpha1]

With a reset of the ratings each month ?

Media added in the last month with the highest ratings get automatically nominated for MotM. Then users can add to the ratings. No reset needed.

 

[XFA]

You mean the highest rated media that was added during last month is awarded ?

 

[Alpha1]

No. Like this:

The X number of highest rating media entries posted in the last calendar month are added/copied to the MotM album on the first day of the month.
The MotM thread is posted and displays hotlinked thumbs of these X media entries.
From then members have a Y days to add votes to the media entries.
After Y days the MotM content ends and the MotM is awarded to the highest rated entry.

This would work well for sites that already have activity and media is already rated. But it will also increase ratings to all media entries.