[Issue] Error 1054

hexxy3 · **Author**

I've done some googling, and I have tried everything people have suggested. Updating the db and reinstalling the webpanel. I even reinstalled the Store on the gameserver.

Quote:

Error Number: 1054

Unknown column 'priority' in 'field list'

INSERT INTO `store_categories` (`display_name`, `priority`, `description`, `require_plugin`, `web_description`, `web_color`) VALUES ('Trails', 0, 'Magical trails that follow your character.', 'trails', NULL, 'FFD700')

Filename: /usr/www/hexx/public/store-webpanel-master/models/categories_model.php

Line Number: 82

hexxy3 · 07-27-2016 , 21:30 Re: Error 1054

I created a priority column in "store_categories" and am now getting this error. Completely stumped on this one.

Quote:

A Database Error Occurred

Error Number: 1054

Unknown column 'priority' in 'field list'

INSERT INTO `store_items` (`attrs`, `category_id`, `description`, `display_name`, `expiry_time`, `is_buyable`, `is_refundable`, `is_tradeable`, `loadout_slot`, `name`, `price`, `priority`, `type`, `web_description`) VALUES ('{\"material\":\"materials/sprites/store/trails/8bitmushroom.vmt\"}',13,NULL,'8-bit Mushroom',NULL,'1','1','1','trails','trail_8b itmushroom','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/8bitpow.vmt\"}',13,NULL,'8-bit Pow',NULL,'1','1','1','trails','trail_8bitpow ','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/abstract.vmt\"}',13,NULL,'Abstract',NULL,'1', '1','1','trails','trail_abstract','300',0,'tr ails',NULL), ('{\"material\":\"materials/sprites/store/trails/airforce.vmt\"}',13,NULL,'Airforce',NULL,'1', '1','1','trails','trail_airforce','300',0,'tr ails',NULL), ('{\"material\":\"materials/sprites/store/trails/airforce2.vmt\"}',13,NULL,'Airforce 2',NULL,'1','1','1','trails','trail_airforce2 ','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/apple.vmt\"}',13,NULL,'Apple',NULL,'1','1','1 ','trails','trail_apple','300',0,'trails',NUL L), ('{\"material\":\"materials/sprites/store/trails/arrowrainbow.vmt\"}',13,NULL,'Arrow Rainbow',NULL,'1','1','1','trails','trail_arr owrainbow','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/arrows.vmt\"}',13,NULL,'Arrows',NULL,'1','1', '1','trails','trail_arrows','300',0,'trails', NULL), ('{\"material\":\"materials/sprites/store/trails/assasin.vmt\"}',13,NULL,'Assasin',NULL,'1','1 ','1','trails','trail_assasin','300',0,'trail s',NULL), ('{\"material\":\"materials/sprites/store/trails/awesome.vmt\"}',13,NULL,'Awesome',NULL,'1','1 ','1','trails','trail_awesome','300',0,'trail s',NULL), ('{\"material\":\"materials/sprites/store/trails/awesomeface.vmt\"}',13,NULL,'Awesome Face',NULL,'1','1','1','trails','trail_awesom eface','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/awesome_sad.vmt\"}',13,NULL,'Awesome Sad',NULL,'1','1','1','trails','trail_awesome _sad','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/babyand.vmt\"}',13,NULL,'Babyand',NULL,'1','1 ','1','trails','trail_babyand','300',0,'trail s',NULL), ('{\"material\":\"materials/sprites/store/trails/banknote.vmt\"}',13,NULL,'Banknote',NULL,'1', '1','1','trails','trail_banknote','300',0,'tr ails',NULL), ('{\"material\":\"materials/sprites/store/trails/barcalona.vmt\"}',13,NULL,'Barcelona',NULL,'1 ','1','1','trails','trail_barcelona','300',0, 'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/batman.vmt\"}',13,NULL,'Batman',NULL,'1','1', '1','trails','trail_batman','300',0,'trails', NULL), ('{\"material\":\"materials/sprites/store/trails/battlefield.vmt\"}',13,NULL,'Battlefield',NUL L,'1','1','1','trails','trail_battlefield','3 00',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/beermug.vmt\"}',13,NULL,'Beermug',NULL,'1','1 ','1','trails','trail_beermug','300',0,'trail s',NULL), ('{\"material\":\"materials/sprites/store/trails/biohazard.vmt\"}',13,NULL,'Biohazard',NULL,'1 ','1','1','trails','trail_biohazard','300',0, 'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/blade.vmt\"}',13,NULL,'Blade',NULL,'1','1','1 ','trails','trail_blade','300',0,'trails',NUL L), ('{\"material\":\"materials/sprites/store/trails/bluelightning.vmt\"}',13,NULL,'Blue Lightning',NULL,'1','1','1','trails','trail_b luelightning','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/bmwlogo.vmt\"}',13,NULL,'BMW logo',NULL,'1','1','1','trails','trail_bmwlog o','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/bombomb.vmt\"}',13,NULL,'Bombomb',NULL,'1','1 ','1','trails','trail_bombomb','300',0,'trail s',NULL), ('{\"material\":\"materials/sprites/store/trails/boo.vmt\"}',13,NULL,'Boo',NULL,'1','1','1','t rails','trail_boo','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/bulletbill.vmt\"}',13,NULL,'Bulletbill',NULL, '1','1','1','trails','trail_bulletbill','300' ,0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/bullets.vmt\"}',13,NULL,'Bullets',NULL,'1','1 ','1','trails','trail_bullets','300',0,'trail s',NULL), ('{\"material\":\"materials/sprites/store/trails/canadaflag.vmt\"}',13,NULL,'Canada Flag',NULL,'1','1','1','trails','trail_canada flag','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/candies.vmt\"}',13,NULL,'Candies',NULL,'1','1 ','1','trails','trail_candies','300',0,'trail s',NULL), ('{\"material\":\"materials/sprites/store/trails/ccole.vmt\"}',13,NULL,'Ccole',NULL,'1','1','1 ','trails','trail_ccole','300',0,'trails',NUL L), ('{\"material\":\"materials/sprites/store/trails/cereal-guy.vmt\"}',13,NULL,'Cereal Guy',NULL,'1','1','1','trails','trail_cereal-guy','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/challenge.vmt\"}',13,NULL,'Challenge',NULL,'1 ','1','1','trails','trail_challenge','300',0, 'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/chopped_pyro.vmt\"}',13,NULL,'Chopped Pyro',NULL,'1','1','1','trails','trail_choppe d_pyro','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/chrislight.vmt\"}',13,NULL,'Chrislight',NULL, '1','1','1','trails','trail_chrislight','300' ,0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/christlights.vmt\"}',13,NULL,'Christ Lights',NULL,'1','1','1','trails','trail_chri stlights','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/cocacola.vmt\"}',13,NULL,'Coca Cola',NULL,'1','1','1','trails','trail_cocaco la','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/cocacola2.vmt\"}',13,NULL,'Coca Cola 2',NULL,'1','1','1','trails','trail_cocacola2 ','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/colorbolt.vmt\"}',13,NULL,'Colorbolt',NULL,'1 ','1','1','trails','trail_colorbolt','300',0, 'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/cookies.vmt\"}',13,NULL,'Cookies',NULL,'1','1 ','1','trails','trail_cookies','300',0,'trail s',NULL), ('{\"material\":\"materials/sprites/store/trails/crackedbeam.vmt\"}',13,NULL,'Cracked Beam',NULL,'1','1','1','trails','trail_cracke dbeam','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/creed.vmt\"}',13,NULL,'Creed',NULL,'1','1','1 ','trails','trail_creed','300',0,'trails',NUL L), ('{\"material\":\"materials/sprites/store/trails/creeper.vmt\"}',13,NULL,'Creeper',NULL,'1','1 ','1','trails','trail_creeper','300',0,'trail s',NULL), ('{\"material\":\"materials/sprites/store/trails/crown.vmt\"}',13,NULL,'Crown',NULL,'1','1','1 ','trails','trail_crown','300',0,'trails',NUL L), ('{\"material\":\"materials/sprites/store/trails/damnimgood.vmt\"}',13,NULL,'Damn Im Good',NULL,'1','1','1','trails','trail_damnim good','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/danishflag.vmt\"}',13,NULL,'Danish Flag',NULL,'1','1','1','trails','trail_danish flag','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/darkknight.vmt\"}',13,NULL,'Dark Knight',NULL,'1','1','1','trails','trail_dark knight','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/deadmau5.vmt\"}',13,NULL,'Deadmau5',NULL,'1', '1','1','trails','trail_deadmau5','300',0,'tr ails',NULL), ('{\"material\":\"materials/sprites/store/trails/deadmau52.vmt\"}',13,NULL,'Deadmau5 2',NULL,'1','1','1','trails','trail_deadmau52 ','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/deadmau53.vmt\"}',13,NULL,'Deadmau5 3',NULL,'1','1','1','trails','trail_deadmau53 ','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/deadmau54.vmt\"}',13,NULL,'Deadmau5 4',NULL,'1','1','1','trails','trail_deadmau54 ','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/deadpool.vmt\"}',13,NULL,'Deadpool',NULL,'1', '1','1','trails','trail_deadpool','300',0,'tr ails',NULL), ('{\"material\":\"materials/sprites/store/trails/devil_smiley.vmt\"}',13,NULL,'Devil Smiley',NULL,'1','1','1','trails','trail_devi l_smiley','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/dirt.vmt\"}',13,NULL,'Dirt',NULL,'1','1','1', 'trails','trail_dirt','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/disorderdragonv2.vmt\"}',13,NULL,'Disorder Dragon',NULL,'1','1','1','trails','trail_diso rderdragonv2','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/disorderlogo2.vmt\"}',13,NULL,'Disorder Logo',NULL,'1','1','1','trails','trail_disord erlogo2','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/disordertext10.vmt\"}',13,NULL,'Disorder Text',NULL,'1','1','1','trails','trail_disord ertext10','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/dna2.vmt\"}',13,NULL,'DNA',NULL,'1','1','1',' trails','trail_dna2','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/dollars.vmt\"}',13,NULL,'Dollars',NULL,'1','1 ','1','trails','trail_dollars','300',0,'trail s',NULL), ('{\"material\":\"materials/sprites/store/trails/donuts.vmt\"}',13,NULL,'Donuts',NULL,'1','1', '1','trails','trail_donuts','300',0,'trails', NULL), ('{\"material\":\"materials/sprites/store/trails/doublerainbow.vmt\"}',13,NULL,'Double Rainbow',NULL,'1','1','1','trails','trail_dou blerainbow','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/dragon.vmt\"}',13,NULL,'Dragon',NULL,'1','1', '1','trails','trail_dragon','300',0,'trails', NULL), ('{\"material\":\"materials/sprites/store/trails/dragondisorder.vmt\"}',13,NULL,'Dragon Disorder',NULL,'1','1','1','trails','trail_dr agondisorder','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/eafifa.vmt\"}',13,NULL,'EA FIFA',NULL,'1','1','1','trails','trail_eafifa ','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/ealogo.vmt\"}',13,NULL,'Ealogo',NULL,'1','1', '1','trails','trail_ealogo','300',0,'trails', NULL), ('{\"material\":\"materials/sprites/store/trails/earth.vmt\"}',13,NULL,'Earth',NULL,'1','1','1 ','trails','trail_earth','300',0,'trails',NUL L), ('{\"material\":\"materials/sprites/store/trails/energy.vmt\"}',13,NULL,'Energy',NULL,'1','1', '1','trails','trail_energy','300',0,'trails', NULL), ('{\"material\":\"materials/sprites/store/trails/energyball.vmt\"}',13,NULL,'Energyball',NULL, '1','1','1','trails','trail_energyball','300' ,0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/epicsax.vmt\"}',13,NULL,'Epic Sax',NULL,'1','1','1','trails','trail_epicsax ','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/facebookicon.vmt\"}',13,NULL,'Facebook',NULL, '1','1','1','trails','trail_facebookicon','30 0',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/fapface.vmt\"}',13,NULL,'Fap Face',NULL,'1','1','1','trails','trail_fapfac e','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/faxekondi.vmt\"}',13,NULL,'Faxe Kondi',NULL,'1','1','1','trails','trail_faxek ondi','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/ferrari.vmt\"}',13,NULL,'Ferrari',NULL,'1','1 ','1','trails','trail_ferrari','300',0,'trail s',NULL), ('{\"material\":\"materials/sprites/store/trails/fire.vmt\"}',13,NULL,'Fire',NULL,'1','1','1', 'trails','trail_fire','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/fire1.vmt\"}',13,NULL,'Fire 2',NULL,'1','1','1','trails','trail_fire1','3 00',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/firefox.vmt\"}',13,NULL,'FireFox',NULL,'1','1 ','1','trails','trail_firefox','300',0,'trail s',NULL), ('{\"material\":\"materials/sprites/store/trails/fireman.vmt\"}',13,NULL,'Fire Man',NULL,'1','1','1','trails','trail_fireman ','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/fire_line.vmt\"}',13,NULL,'Fire Line',NULL,'1','1','1','trails','trail_fire_l ine','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/footprint.vmt\"}',13,NULL,'Footprint',NULL,'1 ','1','1','trails','trail_footprint','300',0, 'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/foreveralone.vmt\"}',13,NULL,'Forever Alone',NULL,'1','1','1','trails','trail_forev eralone','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/fuu1.vmt\"}',13,NULL,'Fuu 1',NULL,'1','1','1','trails','trail_fuu1','30 0',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/fuu2.vmt\"}',13,NULL,'Fuu 2',NULL,'1','1','1','trails','trail_fuu2','30 0',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/fyeah.vmt\"}',13,NULL,'Fyeah',NULL,'1','1','1 ','trails','trail_fyeah','300',0,'trails',NUL L), ('{\"material\":\"materials/sprites/store/trails/germanflag.vmt\"}',13,NULL,'German Flag',NULL,'1','1','1','trails','trail_german flag','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/golden_mushroom.vmt\"}',13,NULL,'Golden Mushroom',NULL,'1','1','1','trails','trail_go lden_mushroom','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/googlechrome.vmt\"}',13,NULL,'Google Chrome',NULL,'1','1','1','trails','trail_goog lechrome','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/goomba.vmt\"}',13,NULL,'Goomba',NULL,'1','1', '1','trails','trail_goomba','300',0,'trails', NULL), ('{\"material\":\"materials/sprites/store/trails/grenade.vmt\"}',13,NULL,'Grenade',NULL,'1','1 ','1','trails','trail_grenade','300',0,'trail s',NULL), ('{\"material\":\"materials/sprites/store/trails/gummybears.vmt\"}',13,NULL,'Gummybears',NULL, '1','1','1','trails','trail_gummybears','300' ,0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/gusta.vmt\"}',13,NULL,'Gusta',NULL,'1','1','1 ','trails','trail_gusta','300',0,'trails',NUL L), ('{\"material\":\"materials/sprites/store/trails/halflife.vmt\"}',13,NULL,'Half-Life',NULL,'1','1','1','trails','trail_halfli fe','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/handgun.vmt\"}',13,NULL,'Handgun',NULL,'1','1 ','1','trails','trail_handgun','300',0,'trail s',NULL), ('{\"material\":\"materials/sprites/store/trails/headshot.vmt\"}',13,NULL,'Headshot',NULL,'1', '1','1','trails','trail_headshot','300',0,'tr ails',NULL), ('{\"material\":\"materials/sprites/store/trails/heart.vmt\"}',13,NULL,'Heart',NULL,'1','1','1 ','trails','trail_heart','300',0,'trails',NUL L), ('{\"material\":\"materials/sprites/store/trails/hellokitty.vmt\"}',13,NULL,'Hello Kitty',NULL,'1','1','1','trails','trail_hello kitty','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/hex.vmt\"}',13,NULL,'Hex',NULL,'1','1','1','t rails','trail_hex','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/hypnotic.vmt\"}',13,NULL,'Hypnotic',NULL,'1', '1','1','trails','trail_hypnotic','300',0,'tr ails',NULL), ('{\"material\":\"materials/sprites/store/trails/hypnotoad.vmt\"}',13,NULL,'Hypnotoad',NULL,'1 ','1','1','trails','trail_hypnotoad','300',0, 'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/ice.vmt\"}',13,NULL,'Ice',NULL,'1','1','1','t rails','trail_ice','300',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/ice1.vmt\"}',13,NULL,'Ice 2',NULL,'1','1','1','trails','trail_ice1','30 0',0,'trails',NULL), ('{\"material\":\"materials/sprites/store/trails/icloud.vmt\"}',13,NULL,'iCloud',NULL,'1','1', '1','trails','trail_icloud','300',0,'trails', NULL), ('{\"material\":\"materials/sprites/store/trails/invisible_bike.vmt\"}',13,NULL,'Invisible Bike',NULL,'1','1','1','trails','trail_invisi ble_bike','300',0,'trails',NULL)

Filename: /usr/www/hexx/public/store-webpanel-master/models/items_model.php

Line Number: 214