vb.org Archive - help: need to fix word.MYD

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

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - help: need to fix word.MYD (https://vborg.vbsupport.ru/showthread.php?t=40715)

sung	07-05-2002 10:45 PM

help: need to fix word.MYD

in a very freak of nature-ish way, my my "word" table got deleted and i need to restore it... is it possible for somebody to give me the query information for the table so i can add it back thru mySQLadmin?

thank you.

Quote:

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT wordid,title FROM word WHERE title IN ('test')
mysql error: Unknown column 'wordid' in 'field list'

mysql error number: 1054

Date: Friday 05th of July 2002 07:44:57 PM
Script: http://www.drsnyltd.com/sung/sung/newreply.php
Referer: http://drsnyltd.com/sung/newreply.ph...&threadid=2255

g-force2k2

07-05-2002 10:50 PM

PHP Code:


		
			
CREATE TABLE word (

   wordid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,

   title char(50) NOT NULL,

   PRIMARY KEY (wordid)

)



ALTER TABLE word ADD UNIQUE (title)

You have to run these to quiries :) hope that helps ;)

g-force2k2

Steve Machol

07-05-2002 11:35 PM

sung, please go to this page and enter your username, to show you are licensed. (you will need to use your customer number and password to access that page)
Thank you.

All times are GMT. The time now is 01:37 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01034 seconds Memory Usage 1,718KB 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_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)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: