[OzzModz] Raffles for XenForo

[OzzModz] Raffles for XenForo [Paid] 2.0.15

No permission to buy ($30.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
 
Back
Top Bottom