Whats wrong here?

[Kryllster]

I just tried to upload this sql file to my phpadmin and now I cant get back in phpmyadmin and it says to check my error logs and there is nothing to do with phpadmin in any of my error logs. I did have a problem where php didnt have an error log and asked me if I wanted to create one so I did or thought I did. and way is there something wrong with my sql that would break it?

 

CREATE TABLE'ferentus_text`(
`player_id` INTEGER NOT NULL AUTO_INCREMENT ,
`username` TEXT NOT NULL ,
`password` TEXT NOT NULL ,
`email` TEXT NOT NULL ,
`sex` TEXT NOT NULL ,
`race` TEXT NOT NULL ,
`class` TEXT NOT NULL ,
`strength` INTEGER NOT NULL ,
`dexterity` INTEGER NOT NULL,
`intelligence` INTEGER NOT NULL ,
`vitality` INTEGER NOT NULL ,
`level` INTEGER NOT NULL ,
`advance` INTEGER NOT NULL ,
`hitpoints` INTEGER NOT NULL ,
`mana` INTEGER NOT NULL ,
`spirit` INTEGER NOT NULL ,
`copper` INTEGER NOT NULL ,
`silver` INTEGER NOT NULL ,
`gold` INTEGER NOT NULL ,
`platinum` INTEGER NOT NULL ,
`main_hand` TEXT NOT NULL ,
`main_power` INTEGER NOT NULL ,
`off_hand` TEXT NOT NULL ,
`off_power` TEXT NOT NULL ,
`off_defence` INTEGER NOT NULL ,
`twohand` TEXT NOT NULL ,
`twohand_power` INTEGER NOT NULL ,
`torso` TEXT NOT NULL ,
`torso_power` INTEGER NOT NULL ,
`pants` TEXT NOT NULL,
`pants_power` INTEGER NOT NULL ,
`gloves` TEXT NOT NULL,
`glove_power` INTEGER NOT NULL,
`boots` TEXT NOT NULL ,
`boot_power` INTEGER NOT NULL,
`necklace` TEXT NOT NULL ,
`necklace_bonus` INTEGER NOT NULL ,
`ring1` TEXT NOT NULL ,
`ring1_bonus` INTEGER NOT NULL ,
`ring2` TEXT NOT NULL ,
`ring2_bonus` INTEGER NOT NULL ,
`skill1` TEXT NOT NULL ,
`skill1_power` INTEGER NOT NULL ,
`skill2` TEXT NOT NULL ,
`skill2_power` INTEGER NOT NULL ,
`skill3` TEXT NOT NULL ,
`skill3_power` INTEGER NOT NULL ,
`skill4` TEXT NOT NULL ,
`skill4_power` INTEGER NOT NULL ,
`skill5` TEXT NOT NULL ,
`skill5_power` INTEGER NOT NULL ,
`skill6` TEXT NOT NULL ,
`skill6_power` INTEGER NOT NULL ,
`skill7` TEXT NOT NULL ,
`skill7_power` INTEGER NOT NULL ,
`skill8` TEXT NOT NULL ,
`skill8_power` INTEGER NOT NULL ,
`avatar` TEXT NOT NULL ,
`guild` TEXT NOT NULL ,
`offence` INTEGER NOT NULL ,
`defence` INTEGER NOT NULL ,
`bind_spot` TEXT NOT NULL
)

 

 

Thanks for any help on this,

[Maq]

I'm not sure why running this would have an effect on why you can't login but you should have a backtic here instead of a single quote:

'ferentus_text`

[Kryllster]

Thanks for pointing that out I fixed it and also fixed the problem with phpmyadmin. There was some sort of glitch or something I have it back now I have no idea really what it was. Thanks again.