vb.org Archive - Lottery problem

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- RPG Integration Hack (https://vborg.vbsupport.ru/forumdisplay.php?f=102)

- - Lottery problem (https://vborg.vbsupport.ru/showthread.php?t=76677)

nirmah

02-20-2005 10:12 AM

Lottery problem

The whole lottery seems to not work. :/

Code:

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

02-20-2005 10:51 AM

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

02-20-2005 11:03 AM

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

Revan

02-20-2005 04:03 PM

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

02-20-2005 10:42 PM

Thanks Revan, but there seems to be an error.

Quote:

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

02-21-2005 01:00 AM

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

02-21-2005 08:39 AM

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

All times are GMT. The time now is 08:39 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01911 seconds Memory Usage 1,728KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: