Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers
Reload this Page MYSQL help plz :D

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 09-26-2007, 01:19 AM
daryl
Fire Beetle
  
Join Date: Jun 2005
Posts: 24
Angry MYSQL help plz :D
high all i trying to update my database with

`id` int(11) NOT NULL default '0',
`minstatus` smallint(5) NOT NULL default '0',
`Name` varchar(64) NOT NULL default '',


but am getting mysql> source test.sql;
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near 'column add
`id` int(11) NOT NULL default '0',
`minstatus` sma
mysql>

anyone can help me fix it plz dont really know much/anything about mysql lol

also how can i get that danasoft crap below off plz ?
Reply With Quote
  #2  
Old 09-26-2007, 02:31 AM
daryl
Fire Beetle
  
Join Date: Jun 2005
Posts: 24
Angry
this is what i wanna do

alter table items add
`id` int(11) NOT NULL default '0',
`minstatus` smallint(5) NOT NULL default '0',
`Name` varchar(64) NOT NULL default '',
`aagi` int(11) NOT NULL default '0',
`ac` int(11) NOT NULL default '0',
`accuracy` int(11) NOT NULL default '0',
`acha` int(11) NOT NULL default '0',
`adex` int(11) NOT NULL default '0',
`aint` int(11) NOT NULL default '0',
`artifactflag` tinyint(3) unsigned NOT NULL default '0',
`asta` int(11) NOT NULL default '0',
`astr` int(11) NOT NULL default '0',
`attack` int(11) NOT NULL default '0',
`augrestrict` int(11) NOT NULL default '0',
`augslot1type` tinyint(3) NOT NULL default '0',
`augslot1unk` int(11) NOT NULL default '0',
`augslot2type` tinyint(3) NOT NULL default '0',
`augslot2unk` int(11) NOT NULL default '0',
`augslot3type` tinyint(3) NOT NULL default '0',
`augslot3unk` int(11) NOT NULL default '0',
`augslot4type` tinyint(3) NOT NULL default '0',
`augslot4unk` int(11) NOT NULL default '0',
`augslot5type` tinyint(3) NOT NULL default '0',
`augslot5unk` int(11) NOT NULL default '0',
`augtype` int(11) NOT NULL default '0',
`avoidance` int(11) NOT NULL default '0',
`awis` int(11) NOT NULL default '0',
`bagsize` int(11) NOT NULL default '0',
`bagslots` int(11) NOT NULL default '0',
`bagtype` int(11) NOT NULL default '0',
`bagwr` int(11) NOT NULL default '0',
`banedmgamt` int(11) NOT NULL default '0',
`banedmgraceamt` int(11) NOT NULL default '0',
`banedmgbody` int(11) NOT NULL default '0',
`banedmgrace` int(11) NOT NULL default '0',
`bardtype` int(11) NOT NULL default '0',
`bardvalue` int(11) NOT NULL default '0',
`book` int(11) NOT NULL default '0',
`casttime` int(11) NOT NULL default '0',
`casttime_` int(11) NOT NULL default '0',
`charmfile` varchar(32) NOT NULL default '',
`charmfileid` varchar(32) NOT NULL default '',
`classes` int(11) NOT NULL default '0',
`color` int(10) unsigned NOT NULL default '0',
`combateffects` varchar(10) NOT NULL default '',
`extradmgskill` int(11) NOT NULL default '0',
`extradmgamt` int(11) NOT NULL default '0',
`price` int(11) NOT NULL default '0',
`cr` int(11) NOT NULL default '0',
`damage` int(11) NOT NULL default '0',
`damageshield` int(11) NOT NULL default '0',
`deity` int(11) NOT NULL default '0',
`delay` int(11) NOT NULL default '0',
`augdistiller` int(11) NOT NULL default '0',
`dotshielding` int(11) NOT NULL default '0',
`dr` int(11) NOT NULL default '0',
`clicktype` int(11) NOT NULL default '0',
`clicklevel2` int(11) NOT NULL default '0',
`elemdmgtype` int(11) NOT NULL default '0',
`elemdmgamt` int(11) NOT NULL default '0',
`endur` int(11) NOT NULL default '0',
`factionamt1` int(11) NOT NULL default '0',
`factionamt2` int(11) NOT NULL default '0',
`factionamt3` int(11) NOT NULL default '0',
`factionamt4` int(11) NOT NULL default '0',
`factionmod1` int(11) NOT NULL default '0',
`factionmod2` int(11) NOT NULL default '0',
`factionmod3` int(11) NOT NULL default '0',
`factionmod4` int(11) NOT NULL default '0',
`filename` varchar(32) NOT NULL default '',
`focuseffect` int(11) NOT NULL default '0',
`fr` int(11) NOT NULL default '0',
`fvnodrop` int(11) NOT NULL default '0',
`haste` int(11) NOT NULL default '0',
`clicklevel` int(11) NOT NULL default '0',
`hp` int(11) NOT NULL default '0',
`regen` int(11) NOT NULL default '0',
`icon` int(11) NOT NULL default '0',
`idfile` varchar(30) NOT NULL default '',
`itemclass` int(11) NOT NULL default '0',
`itemtype` int(11) NOT NULL default '0',
`ldonprice` int(11) NOT NULL default '0',
`ldontheme` int(11) NOT NULL default '0',
`ldonsold` int(11) NOT NULL default '0',
`light` int(11) NOT NULL default '0',
`lore` varchar(80) NOT NULL default '',
`loregroup` int(11) NOT NULL default '0',
`magic` int(11) NOT NULL default '0',
`mana` int(11) NOT NULL default '0',
`manaregen` int(11) NOT NULL default '0',
`enduranceregen` int(11) NOT NULL default '0',
`material` int(11) NOT NULL default '0',
`maxcharges` int(11) NOT NULL default '0',
`mr` int(11) NOT NULL default '0',
`nodrop` int(11) NOT NULL default '0',
`norent` int(11) NOT NULL default '0',
`pendingloreflag` tinyint(3) unsigned NOT NULL default '0',
`pr` int(11) NOT NULL default '0',
`procrate` int(11) NOT NULL default '0',
`races` int(11) NOT NULL default '0',
`range` int(11) NOT NULL default '0',
`reclevel` int(11) NOT NULL default '0',
`recskill` int(11) NOT NULL default '0',
`reqlevel` int(11) NOT NULL default '0',
`sellrate` float NOT NULL default '0',
`shielding` int(11) NOT NULL default '0',
`size` int(11) NOT NULL default '0',
`skillmodtype` int(11) NOT NULL default '0',
`skillmodvalue` int(11) NOT NULL default '0',
`slots` int(11) NOT NULL default '0',
`clickeffect` int(11) NOT NULL default '0',
`spellshield` int(11) NOT NULL default '0',
`strikethrough` int(11) NOT NULL default '0',
`stunresist` int(11) NOT NULL default '0',
`summonedflag` tinyint(3) unsigned NOT NULL default '0',
`tradeskills` int(11) NOT NULL default '0',
`favor` int(11) NOT NULL default '0',
`weight` int(11) NOT NULL default '0',
`unknown002` int(11) NOT NULL default '0',
`unknown003` int(11) NOT NULL default '0',
`unknown005` int(11) NOT NULL default '0',
`unknown007` int(11) NOT NULL default '0',
`unknown018` int(11) NOT NULL default '0',
`unknown019` int(11) NOT NULL default '0',
`unknown020` int(11) NOT NULL default '0',
`UNK012` int(11) NOT NULL default '0',
`UNK013` int(11) NOT NULL default '0',
`benefitflag` int(11) NOT NULL default '0',
`unknown061` int(11) NOT NULL default '0',
`UNK054` int(11) NOT NULL default '0',
`unknown067` int(11) NOT NULL default '0',
`unknown069` int(11) NOT NULL default '0',
`UNK059` int(11) NOT NULL default '0',
`UNK061` int(11) NOT NULL default '0',
`unknown081` int(11) NOT NULL default '0',
`unknown105` int(11) NOT NULL default '0',
`booktype` int(11) NOT NULL default '0',
`unknown122` int(11) NOT NULL default '0',
`unknown123` varchar(11) NOT NULL default '0',
`unknown124` varchar(11) NOT NULL default '0',
`recastdelay` int(11) NOT NULL default '0',
`recasttype` int(11) NOT NULL default '0',
`guildfavor` int(11) NOT NULL default '0',
`unknown128` varchar(11) NOT NULL default '0',
`UNK123` int(11) NOT NULL default '0',
`UNK124` int(11) NOT NULL default '0',
`attuneable` int(11) NOT NULL default '0',
`nopet` int(11) NOT NULL default '0',
`unknown133` varchar(11) NOT NULL default '0',
`updated` datetime NOT NULL default '0000-00-00 00:00:00',
`comment` varchar(255) NOT NULL default '',
`UNK127` int(11) NOT NULL default '0',
`pointtype` int(11) NOT NULL default '0',
`potionbelt` int(11) NOT NULL default '0',
`potionbeltslots` int(11) NOT NULL default '0',
`stacksize` int(11) NOT NULL default '0',
`notransfer` int(11) NOT NULL default '0',
`stackable` int(11) NOT NULL default '0',
`UNK134` varchar(255) NOT NULL default '',
`UNK137` int(11) NOT NULL default '0',
`proceffect` int(11) NOT NULL default '0',
`proctype` int(11) NOT NULL default '0',
`proclevel2` int(11) NOT NULL default '0',
`proclevel` int(11) NOT NULL default '0',
`UNK142` int(11) NOT NULL default '0',
`worneffect` int(11) NOT NULL default '0',
`worntype` int(11) NOT NULL default '0',
`wornlevel2` int(11) NOT NULL default '0',
`wornlevel` int(11) NOT NULL default '0',
`UNK147` int(11) NOT NULL default '0',
`focustype` int(11) NOT NULL default '0',
`focuslevel2` int(11) NOT NULL default '0',
`focuslevel` int(11) NOT NULL default '0',
`UNK152` int(11) NOT NULL default '0',
`scrolleffect` int(11) NOT NULL default '0',
`scrolltype` int(11) NOT NULL default '0',
`scrolllevel2` int(11) NOT NULL default '0',
`scrolllevel` int(11) NOT NULL default '0',
`UNK157` int(11) NOT NULL default '0',
`serialized` datetime default NULL,
`verified` datetime default NULL,
`serialization` text,
`source` varchar(20) NOT NULL default '',
`UNK033` int(11) NOT NULL default '0',
UNIQUE KEY `ID` (`id`),
KEY `name_idx` (`Name`),
KEY `lore_idx` (`lore`)


trying to get the missing columns in my database but i getting errors in mysql :(
anyone can help me figure whats wrong plz ?
Reply With Quote
  #3  
Old 09-26-2007, 11:03 AM
Lalolyen
Banned
  
Join Date: Aug 2007
Location: Sneeking up behind a admin IRL
Posts: 169
Default
Quote:
Originally Posted by daryl View Post
high all i trying to update my database with

`id` int(11) NOT NULL default '0',
`minstatus` smallint(5) NOT NULL default '0',
`Name` varchar(64) NOT NULL default '',


but am getting mysql> source test.sql;
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for the right syntax to use near 'column add
`id` int(11) NOT NULL default '0',
`minstatus` sma
mysql>

anyone can help me fix it plz dont really know much/anything about mysql lol

also how can i get that danasoft crap below off plz ?
Remove either the "NOT NULL" or zero default and it should work.
Reply With Quote
  #4  
Old 09-26-2007, 12:54 PM
Angelox
AX Classic Developer
  
Join Date: May 2006
Location: filler
Posts: 2,049
Default
Quote:
Originally Posted by daryl View Post
also how can i get that danasoft crap below off plz ?
How'd you get it on? It's in your signature, just have to edit your settings and remove it.
Reply With Quote
  #5  
Old 09-27-2007, 12:50 AM
Theeper
Discordant
  
Join Date: May 2004
Posts: 290
Default
NOT NULL and zero default is ok, the problem is that you haven't specified that it's columns you are adding. The syntax should be like this ..

ALTER TABLE items ADD COLUMN `id` int(11) NOT NULL DEFAULT 0, ADD COLUMN `minstatus` int (11) NOT NULL DEFAULT 0 ... etc
Reply With Quote
  #6  
Old 09-28-2007, 01:20 AM
daryl
Fire Beetle
  
Join Date: Jun 2005
Posts: 24
Thumbs up
thanks Theeper
had to change the '0', to just 0 lol but could only get one to work at a time took a while but its sorted now
thanks again man
now on to the rest of the db
Reply With Quote
  #7  
Old 09-28-2007, 01:21 AM
daryl
Fire Beetle
  
Join Date: Jun 2005
Posts: 24
Default
Quote:
Originally Posted by Angelox View Post
How'd you get it on? It's in your signature, just have to edit your settings and remove it.


i did nothing lol its just appeared :( gonna go look if i can take it off
Reply With Quote
  #8  
Old 09-28-2007, 01:27 AM
daryl
Fire Beetle
  
Join Date: Jun 2005
Posts: 24
Default
Quote:
Originally Posted by daryl View Post
i did nothing lol its just appeared :( gonna go look if i can take it off


guess i am wrong just noticed am logged in an old account lol must have put it on years ago lol
Reply With Quote
Reply

« Previous Thread | Next Thread »

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 -4. The time now is 01:54 AM.

EQEmulator - Archive - Top

 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3