Lottery problem

The whole lottery seems to not work. :/

Database error in vBulletin 3.0.7:

Invalid SQL: 
		INSERT INTO
			rpg_lottery 
				(lotteryid,
				lotteryname,
				lotterym,
				prize,
				dateset,
				dateend,
				cost,
				sold,
				active) 
			VALUES 
				(NULL,
				'Lottery Boost!',
				'Win 1000% of your ticket cost! Prize money: 1500! Get your ticket now!',
				'1500',
				'1108896591',
				'03-20-2005',
				'150',
				'0',
				'1')
	
mysql error: Table 'chyrule_forums.rpg_lottery' doesn't exist

mysql error number: 1146

That's what I get when I try to create a new lottery through the ACP.

Any help would be appreciated. Thank you.

[Revan]

Check to see if the table exists.
You can figure this out by going to Maintenance in your ACP, and "Repair/Optimize Tables".
If you see this table in the list of tables, then its there.

[nirmah]

Nope. The closest thing to it is rpg_lottery_tickets. How can I get rpg_lottery?

[Revan]

By running this in the ACP:
[sql]CREATE TABLE `rpg_lottery` (
`lotteryid` int(5) NOT NULL auto_increment,
`lotteryname` varchar(20) NOT NULL default '',
`lotterym` varchar(50) NOT NULL default '',
`prize` int(10) NOT NULL default '0',
`dateset` varchar(35) NOT NULL default '',
`dateend` varchar(35) NOT NULL default '',
`cost` int(6) NOT NULL default '0',
`sold` int(5) NOT NULL default '0',
`active` int(2) NOT NULL default '0',
`editing` int(5) NOT NULL default '',
PRIMARY KEY (`lotteryid`,`lotteryid`)
) TYPE=MyISAM;
[/sql]

Remember to add a table prefix if you use one.

[nirmah]

Thanks Revan, but there seems to be an error.

MySQL said:

#1060 - Duplicate column name 'lotteryid'

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/common.lib.php on line 682

[Revan]

of course
Im rather embarrassed....
[sql]CREATE TABLE `rpg_lottery` (
`lotteryid` int(5) NOT NULL auto_increment,
`lotteryname` varchar(20) NOT NULL default '',
`lotterym` varchar(50) NOT NULL default '',
`prize` int(10) NOT NULL default '0',
`dateset` varchar(35) NOT NULL default '',
`dateend` varchar(35) NOT NULL default '',
`cost` int(6) NOT NULL default '0',
`sold` int(5) NOT NULL default '0',
`active` int(2) NOT NULL default '0',
`editing` int(5) NOT NULL default '',
PRIMARY KEY (`lotteryid`)
) TYPE=MyISAM;[/sql]
Theres the correct code.
To my own defence I didnt write the lottery hack and it was probs the author of this hack who did it and its all his fault and and and....
*goes away*



//peace

[nirmah]

No problem at all Revan. Will test it out now. Thanks for all the help although I may come again soon.