Raised This Month: $ Target: $400
 0% 

Issue [SOLVED] Getting The Error Number: 1054


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
The Unusual Gold
Member
Join Date: Jun 2014
Location: The Unusual Island
Old 07-19-2015 , 07:51   [SOLVED] Getting The Error Number: 1054
Reply With Quote #1

Hello there.

I've been trying to get the Store Webpanel to work three times now and it still doesn't work.
I have tried doing everything the F.A.Q said, still doesn't work.
This happens whenever I try to import ANYTHING into the webpanel.
Everything is fully updated according to the F.A.Q and other pages on this forum.

Quote:
A Database Error Occurred

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, 'Trails that follow your character.', 'trails', NULL, 'FFD700')

Filename: /home/www/creepysuperzombie.com/store-webpanel-master/models/categories_model.php

Line Number: 82
Quote:
Error Number: 1054
Unknown column 'acquire_method / flags / aquire_method' in 'field list'
Known as: "I want to use a outdated database / store plugin"-Error
Also Known as: "Unable to update my stuff"-Error
Caused by: A User who is unable to update his database / store plugin or who is unable to download the correct version of the store plugin / database
Fixed by (acquire_method): Renaming the column aquire method to acquire method or by deleting the current db and downloading the most recent version of it
Fixed by (aquire_method): Using the current version of the store plugin (Anything after May 2013 is fine)
Fixed by (flags): Adding the flags column to the database
__________________
Something about me:
My website - My YouTube Channel

Last edited by The Unusual Gold; 07-19-2015 at 12:22.
The Unusual Gold is offline
Drixevel
AlliedModders Donor
Join Date: Sep 2009
Location: Somewhere headbangin'
Old 07-19-2015 , 08:02   Re: Getting The Error Number: 1054
Reply With Quote #2

https://github.com/SourceMod-Store/s...upgrade.sql#L2

Execute lines 2 & 3 into your SQL database.
Drixevel is offline
The Unusual Gold
Member
Join Date: Jun 2014
Location: The Unusual Island
Old 07-19-2015 , 12:22   Re: Getting The Error Number: 1054
Reply With Quote #3

Quote:
Originally Posted by r3dw3r3w0lf View Post
https://github.com/SourceMod-Store/s...upgrade.sql#L2

Execute lines 2 & 3 into your SQL database.
That worked, thanks for the help!
__________________
Something about me:
My website - My YouTube Channel
The Unusual Gold is offline
Reply



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 22:47.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode