[XB] Raffles: Contests, Giveaways & Rewards

[XB] Raffles: Contests, Giveaways & Rewards [Paid] 2.1.0 Release Candidate 1

No permission to buy ($25.00)
How is this working for everyone? I have a competitor's addon which is fine but not particularly feature rich so entertaining giving this a go.
 
Getting a ton of errors creating a raffle after upgrading from XF 1.5.x. I was asked to create a ticket and to see what can be done. The company who did the migration told me this. "The add-on has improperly created the table(s) it needs. Every field in a database table needs a default, value and it looks like they missed one.".

Here is the error. Any advice?IMG_4816.webp
 
Getting a ton of errors creating a raffle after upgrading from XF 1.5.x. I was asked to create a ticket and to see what can be done. The company who did the migration told me this. "The add-on has improperly created the table(s) it needs. Every field in a database table needs a default, value and it looks like they missed one.".

Here is the error. Any advice?View attachment 328898
I don't have the XF 1.x version of the add-on and can't test what might have gone wrong, but these columns should have been deleted during the 2.0.0 upgrade 1 phase only after successful data import.
Did you encounter any errors during the add-on upgrade?

If not, and all data has been successfully migrated, delete the old columns manually using an SQL query:

SQL:
ALTER TABLE xf_snog_raffles
DROP COLUMN `usergroups`,
DROP COLUMN `badusergroups`,
DROP COLUMN `messages`,
DROP COLUMN `clocktype`,
DROP COLUMN `start_month`,
DROP COLUMN `start_day`,
DROP COLUMN `start_year`,
DROP COLUMN `draw_month`,
DROP COLUMN `draw_day`,
DROP COLUMN `draw_year`,
DROP COLUMN `drawtime`,
DROP COLUMN `stop_month`,
DROP COLUMN `stop_day`,
DROP COLUMN `stop_year`,
DROP COLUMN `lasttime`,
DROP COLUMN `announced`,
DROP COLUMN `posterid_temp`,
DROP COLUMN `pmid_temp`,
DROP COLUMN `announce_posterid_temp`;
 
I don't have the XF 1.x version of the add-on and can't test what might have gone wrong, but these columns should have been deleted during the 2.0.0 upgrade 1 phase only after successful data import.
Did you encounter any errors during the add-on upgrade?

If not, and all data has been successfully migrated, delete the old columns manually using an SQL query:

SQL:
ALTER TABLE xf_snog_raffles
DROP COLUMN `usergroups`,
DROP COLUMN `badusergroups`,
DROP COLUMN `messages`,
DROP COLUMN `clocktype`,
DROP COLUMN `start_month`,
DROP COLUMN `start_day`,
DROP COLUMN `start_year`,
DROP COLUMN `draw_month`,
DROP COLUMN `draw_day`,
DROP COLUMN `draw_year`,
DROP COLUMN `drawtime`,
DROP COLUMN `stop_month`,
DROP COLUMN `stop_day`,
DROP COLUMN `stop_year`,
DROP COLUMN `lasttime`,
DROP COLUMN `announced`,
DROP COLUMN `posterid_temp`,
DROP COLUMN `pmid_temp`,
DROP COLUMN `announce_posterid_temp`;
I don't have the XF 1.x version of the add-on and can't test what might have gone wrong, but these columns should have been deleted during the 2.0.0 upgrade 1 phase only after successful data import.
Did you encounter any errors during the add-on upgrade?

If not, and all data has been successfully migrated, delete the old columns manually using an SQL query:

SQL:
ALTER TABLE xf_snog_raffles
DROP COLUMN `usergroups`,
DROP COLUMN `badusergroups`,
DROP COLUMN `messages`,
DROP COLUMN `clocktype`,
DROP COLUMN `start_month`,
DROP COLUMN `start_day`,
DROP COLUMN `start_year`,
DROP COLUMN `draw_month`,
DROP COLUMN `draw_day`,
DROP COLUMN `draw_year`,
DROP COLUMN `drawtime`,
DROP COLUMN `stop_month`,
DROP COLUMN `stop_day`,
DROP COLUMN `stop_year`,
DROP COLUMN `lasttime`,
DROP COLUMN `announced`,
DROP COLUMN `posterid_temp`,
DROP COLUMN `pmid_temp`,
DROP COLUMN `announce_posterid_temp`;
nothing related to the raffle so it was odd. Appreciate yoe response and I will send this to my server guy
 
Painbaker updated [XB] Raffles: Contests, Giveaways & Rewards with a new update entry:

2.1.0 Release Candidate 1

View attachment 340805

⚠️ This is a release candidate version. Please take a full backup before installing it on a production site.

🎉 A major update focused on performance, reliability, and raffle management! This release modernizes the add-on with database and architecture improvements, new permissions, enhanced raffle tracking, and numerous fixes to make raffles more stable and easier to manage.

✨ New...​


Read the rest of this update entry...
 
Back
Top Bottom