Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #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
Reply


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:27 AM.


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.04825 seconds
  • Memory Usage 2,188KB
  • Queries Executed 11 (?)
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
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)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_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