Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
Prev Previous Post   Next Post Next
  #1  
Old 08-15-2002, 04:56 PM
DanIAm's Avatar
DanIAm DanIAm is offline
 
Join Date: Aug 2002
Posts: 43
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default New to MySQL Query process/getting erorr

I have never done a MYSQL Query and am trying my best to learn how to do with by reading as much as I can. I am using the SQL Query from Control Panel hack found at:

https://vborg.vbsupport.ru/showthrea...threadid=33731

Right now I am trying to install the Tetris hack found at: https://vborg.vbsupport.ru/showthrea...threadid=42293

And it tells me to run a query with this listed:

"CREATE TABLE `arcade` (
`scoreid` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL
default '0',
`game` varchar(50) NOT NULL default '',
`score` int(11) NOT NULL default '0',

`comment` varchar(70) NOT NULL default 'No comment',
PRIMARY KEY (`scoreid`)
) TYPE=MyISAM;"

I have pasted this information as seen above, click run query, and I get this error:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: CREATE TABLE `arcade` (
`scoreid` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL
default '0',
`game` varchar(50) NOT NULL default '',
`score` int(11) NOT NULL default '0',

`comment` varchar(70) NOT NULL default 'No comment',
PRIMARY KEY (`scoreid`)
) TYPE=MyISAM;
mysql error: Table 'arcade' already exists

mysql error number: 1050

Date: Thursday 15th of August 2002 10:56:09 AM
Script: http://www.mentalmingle.com/forums/f...dmin/query.php
Referer:

What does this mean, what am I doing wrong? Please help...

Thanks in advance, Dan
Reply With Quote
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 02:38 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04097 seconds
  • Memory Usage 2,244KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_threadedmode.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete