Jump to content

Whats wrong with this table?

IamSuchANoob

By IamSuchANoob
in MySQL Help

 Share

Recommended Posts

IamSuchANoob Member

IamSuchANoob

Posted
Posted

    Mod_Security 2.5.9 enabled

    MySQL client version: 5.0.51a

    PHP extension: mysqli

 

CREATE TABLE IF NOT EXISTS `users` (
  `user_name` varchar(200) NOT NULL DEFAULT 'None',
  `pwd` varchar(220) NOT NULL DEFAULT 'None',
  `Level` int(11) NOT NULL DEFAULT '0',
  `user_level` tinyint(4) NOT NULL DEFAULT '0',
  `PlayerDefaultSkin` int(11) NOT NULL DEFAULT '26',
  `PlayerMoney` int(11) NOT NULL DEFAULT '4500',
  `Local` int(11) NOT NULL DEFAULT '9999',
  `Zone` int(11) NOT NULL DEFAULT '9999',
  `House` int(11) NOT NULL DEFAULT '9999',
  `Team` int(11) NOT NULL DEFAULT '1',
  `MoneyInBank` int(11) NOT NULL DEFAULT '0',
  `HaveBankAccount` int(11) NOT NULL DEFAULT '0',
  `approved` int(1) NOT NULL DEFAULT '0',
  `Gender` varchar(50) NOT NULL DEFAULT 'None',
  `Age` int(11) NOT NULL DEFAULT '0',
  `Country` varchar(24) NOT NULL DEFAULT 'None',
  `PhoneBox` int(11) NOT NULL DEFAULT '0',
  `TraceName` varchar(200) NOT NULL DEFAULT 'None',
  `Job` int(11) NOT NULL DEFAULT '0',
  `PostSkill` int(11) NOT NULL DEFAULT '0',
  `Armour` float NOT NULL DEFAULT '0',
  `Tickets` int(11) NOT NULL DEFAULT '0',
  `MaxCars` int(11) NOT NULL DEFAULT '2',
  `Busniness` int(11) NOT NULL DEFAULT '0',
  `Government` int(11) NOT NULL DEFAULT '0',
  `Faction` int(11) NOT NULL DEFAULT '0',
  `Interior` int(11) NOT NULL DEFAULT '0',
  `DutySkin` int(11) NOT NULL DEFAULT '0',
  `Rank` int(11) NOT NULL DEFAULT '0',
  `RankName` varchar(24) NOT NULL DEFAULT 'None',
  `PlaneLic` int(11) NOT NULL DEFAULT '0',
  `WantedPoints` int(11) NOT NULL DEFAULT '0',
  `WantedLevel` int(11) NOT NULL DEFAULT '0',
  `Jail` int(11) NOT NULL DEFAULT '0',
  `JailTime` int(11) NOT NULL DEFAULT '0',
  `File` varchar(24) NOT NULL DEFAULT 'None',
  `Arrests` int(11) NOT NULL DEFAULT '0',
  `LastTicket` varchar(256) NOT NULL DEFAULT 'None',
  `CrimesCom` int(11) NOT NULL DEFAULT '0',
  `Kills` int(11) NOT NULL DEFAULT '0',
  `Hobby` varchar(200) NOT NULL DEFAULT '0',
  `DefaultSpawn` int(11) NOT NULL DEFAULT '0',
  `Motel` int(11) NOT NULL DEFAULT '0',
  `Hotel` int(11) NOT NULL DEFAULT '0',
  `Number` int(11) NOT NULL DEFAULT '0',
  `Pocket1` int(11) NOT NULL DEFAULT '0',
  `Pocket2` int(11) NOT NULL DEFAULT '0',
  `Pocket3` int(11) NOT NULL DEFAULT '0',
  `Pocket4` varchar(24) NOT NULL DEFAULT 'None',
  `Pocket5` int(11) NOT NULL DEFAULT '0',
  `GunLic` int(11) NOT NULL DEFAULT '0',
  `Scripter` int(11) NOT NULL DEFAULT '0',
  `Points` int(11) NOT NULL DEFAULT '0',
  `PointsNeed` int(11) NOT NULL DEFAULT '8',
  `PayCheck` int(11) NOT NULL DEFAULT '0',
  `Salary` int(11) NOT NULL DEFAULT '0',
  `banned` int(1) NOT NULL DEFAULT '0',
  `PWSkill` int(11) NOT NULL DEFAULT '0',
  `SPWSkill` int(11) NOT NULL DEFAULT '0',
  `DPWSkill` int(11) NOT NULL DEFAULT '0',
  `SHWSkill` int(11) NOT NULL DEFAULT '0',
  `MPWSkill` int(11) NOT NULL DEFAULT '0',
  `AKWSkill` int(11) NOT NULL DEFAULT '0',
  `M4WSkill` int(11) NOT NULL DEFAULT '0',
  `SNWSkill` int(11) NOT NULL DEFAULT '0',
  `Condom` int(11) NOT NULL DEFAULT '0',
  `FightStyle` int(11) NOT NULL DEFAULT '6',
  `GunParts` int(11) NOT NULL DEFAULT '0',
  `Drugs` int(11) NOT NULL DEFAULT '0',
  `CarLic` int(5) NOT NULL DEFAULT '0',
  `MoneyAvailable` int(11) NOT NULL DEFAULT '0',
  `Deposit` int(11) NOT NULL DEFAULT '0',
  `DepositTime` int(11) NOT NULL DEFAULT '0',
  `DepositValue` float NOT NULL DEFAULT '0',
  `Withdraw` int(11) NOT NULL DEFAULT '0',
  `DepositPassed` int(11) NOT NULL DEFAULT '0',
  `BikeLic` int(5) NOT NULL DEFAULT '0',
  `HeavyLic` int(5) NOT NULL DEFAULT '0',
  `BoatLic` int(5) NOT NULL DEFAULT '0',
  `Company` int(11) NOT NULL DEFAULT '0',
  `RacesWin` int(11) NOT NULL DEFAULT '0',
  `Garage` int(11) NOT NULL DEFAULT '0',
  `AfterMedic` int(11) NOT NULL DEFAULT '0',
  `Hospital` int(11) NOT NULL DEFAULT '0',
  `Phone` varchar(24) NOT NULL DEFAULT 'None',
  `PType` int(11) NOT NULL DEFAULT '0',
  `PCredit` int(11) NOT NULL DEFAULT '0',
  `PAfterPay` int(11) NOT NULL DEFAULT '0',
  `GoodCop` int(11) NOT NULL DEFAULT '0',
  `BadCop` int(11) NOT NULL DEFAULT '0',
  `CanRobGas` int(11) NOT NULL DEFAULT '0',
  `CanRobBank` int(11) NOT NULL DEFAULT '0',
  `HackSkill` int(11) NOT NULL DEFAULT '0',
  `Mod` int(5) NOT NULL DEFAULT '0',
  `CrashX` float NOT NULL DEFAULT '0',
  `CrashY` float NOT NULL DEFAULT '0',
  `CrashZ` float NOT NULL DEFAULT '0',
  `CrashVW` int(11) NOT NULL DEFAULT '0',
  `CrashInt` int(11) NOT NULL DEFAULT '0',
  `Duty` int(5) NOT NULL DEFAULT '0',
  `EnterID` int(11) NOT NULL DEFAULT '9999',
  `Crashed` int(11) NOT NULL DEFAULT '0',
  `PlayerSes` int(11) NOT NULL DEFAULT '0',
  `CrashDis` int(11) NOT NULL DEFAULT '1',
  `DutyArmour` float NOT NULL DEFAULT '0',
  `Gold` int(11) NOT NULL DEFAULT '0',
  `FlighTime` int(11) NOT NULL DEFAULT '0',
  `GPowder` int(11) NOT NULL DEFAULT '0',
  `Metal` int(11) NOT NULL DEFAULT '0',
  `GReady` int(11) NOT NULL DEFAULT '0',
  `SerVer` int(11) NOT NULL DEFAULT '0',
  `LastIP` varchar(24) NOT NULL DEFAULT 'None',
  `Priest` int(11) NOT NULL DEFAULT '0',
  `Married` varchar(24) NOT NULL DEFAULT 'None',
  `MarHouse` int(11) NOT NULL DEFAULT '0',
  `RPSkill` int(11) NOT NULL DEFAULT '0',
  `Mask` int(11) NOT NULL DEFAULT '0',
  `PetrolCan` int(11) NOT NULL DEFAULT '0',
  `Tut` int(11) NOT NULL DEFAULT '0',
  `TempReg` int(11) NOT NULL DEFAULT '0',
  `Weed` int(11) NOT NULL DEFAULT '0',
  `Seeds` int(11) NOT NULL DEFAULT '0',
  `MarReady` int(11) NOT NULL DEFAULT '0',
  `MarAmount` int(11) NOT NULL DEFAULT '0',
  `Paper` int(11) NOT NULL DEFAULT '0',
  `Lighter` int(11) NOT NULL DEFAULT '0',
  `Cigar` int(11) NOT NULL DEFAULT '0',
  `AdminCode` varchar(150) NOT NULL DEFAULT 'None',
  `Helmet` int(11) NOT NULL DEFAULT '0',
  `PlayerHealth` float NOT NULL DEFAULT '100',
  `TimeInJob` int(11) NOT NULL DEFAULT '0',
  `TmpFaction` int(11) NOT NULL DEFAULT '0',
  `Resign` int(11) NOT NULL DEFAULT '0',
  `Helper` int(11) NOT NULL DEFAULT '0',
  `SkinProLap` int(11) NOT NULL DEFAULT '0',
  `SkinVictim` int(11) NOT NULL DEFAULT '0',
  `SkinSub` int(11) NOT NULL DEFAULT '0',
  `SkinZip` int(11) NOT NULL DEFAULT '0',
  `SkinBin` int(11) NOT NULL DEFAULT '0',
  `SkinDid` int(11) NOT NULL DEFAULT '0',
  `LastLogin` varchar(24) NOT NULL DEFAULT 'None',
  `Bag` int(11) NOT NULL DEFAULT '0',
  `Rope` int(11) NOT NULL DEFAULT '0',
  `Pizza` int(11) NOT NULL DEFAULT '0',
  `Icecream` int(11) NOT NULL DEFAULT '0',
  `Hotdog` int(11) NOT NULL DEFAULT '0',
  `Sprunk` int(11) NOT NULL DEFAULT '0',
  `Apples` int(11) NOT NULL DEFAULT '0',
  `Berries` int(11) NOT NULL DEFAULT '0',
  `OPrison` varchar(128) NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `RingName` varchar(32) NOT NULL DEFAULT 'None',
  `RangeIP` varchar(64) NOT NULL DEFAULT 'None',
  `md5_id` varchar(200) NOT NULL DEFAULT 'None',
  `user_email` varchar(200) NOT NULL DEFAULT 'None',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1841 ;

 

 

Simply after creating it, trying to view structure or entries of the table I get errors in phpmyadmin.

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Link to comment
Share on other sites
Muddy_Funster Regular Member

Muddy_Funster

Posted
Posted

The SQL seems fine, ran it on a test database and it made the table without a problem.  All I can suggest is that you make sure that your user has create privilges for the database that you are in, and that you have chosen your database first.

 

I aslo give strong recomendation to normalising that data structure - you should be using WAY more than one table for all that.

Link to comment
Share on other sites
IamSuchANoob Member

IamSuchANoob

Posted
  • Author
Posted

The SQL seems fine, ran it on a test database and it made the table without a problem.  All I can suggest is that you make sure that your user has create privilges for the database that you are in, and that you have chosen your database first.

 

I aslo give strong recomendation to normalising that data structure - you should be using WAY more than one table for all that.

 

I have way more tables than that, as this is only users.  Every other works fine.

Did you try editing or adding values into it? And what version is your mysql?

Link to comment
Share on other sites
PFMaBiSmAd Advanced Member

PFMaBiSmAd

Posted
Posted

The phpmyadmin script is failing and outputting nothing. You should have error_reporting set to E_ALL and display_errors set to ON or have log_errors set to ON so that you can get information about any php detected errors.

 

Have you checked the web server error log file -

More information about this error may be available in the server error log
Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.