cloudpro
Member
I can do that if you wish.I don’t accept bitcoin I only have PayPal
I can do that if you wish.I don’t accept bitcoin I only have PayPal
Any chance you can add the addon to my account and ill simply send you BTC for the value as I need the addon ASAP.
Hope he gets it done soon I need to launch my new community this week I really wanted a decent giveaway system ready. Wouldn't mind chucking some money his way for the troubles.Painbaker still hasn’t ported this over to his site, he’s been quite busy.
Which one, if I can ask? Thanks.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.

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.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
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 guyI 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`;
We use essential cookies to make this site work, and optional cookies to enhance your experience.