Raised This Month: $51 Target: $400
 12% 

Store-Backend: Unknown Column aquire method


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
webz
Junior Member
Join Date: Jun 2012
Old 02-09-2015 , 19:02   Store-Backend: Unknown Column aquire method
Reply With Quote #1

I installed the store and everything is up to date SM MM..I added the trails plugin to it and when you can see the store work and see the trails same for the other plugin i used that goes with the store.
I get the when I chose the trail in my inv.

[store/store-backend.smx] ERROR | SQL Error on GiveItem: Unknown column 'aquire_method' in 'field list'

and I get this

L 02/09/2015 - 17:560: [SM] [0] Line 337, C:\Users\Alon\Documents\GitHub\store-trails\scripting\store-trails.sp::GiveTrail()
L 02/09/2015 - 17:564: [store\store-logging.smx] SQL Error on GiveItem: Unknown column 'aquire_method' in 'field list'
L 02/09/2015 - 17:569: [SM] Native "Store_GetClientLoadout" reported: Plugin owning this native is currently paused.
L 02/09/2015 - 17:569: [SM] Displaying call stack trace for plugin "store\store-inventory.smx":
L 02/09/2015 - 17:569: [SM] [0] Line 256, C:\Users\Alon\Documents\GitHub\store\scriptin g\store-inventory.sp::OpenInventoryCategory()
L 02/09/2015 - 17:569: [SM] [1] Line 223, C:\Users\Alon\Documents\GitHub\store\scriptin g\store-inventory.sp::InventoryMenuSelectHandle()



AND YES I SEARCHED before i posted this.


Thanks if some one can help me out
webz is offline
FrozenHaxor
Senior Member
Join Date: Jun 2009
Location: Poland
Old 02-09-2015 , 23:13   Re: Post bugs for me here please.
Reply With Quote #2

Quote:
Originally Posted by webz View Post
I installed the store and everything is up to date SM MM..I added the trails plugin to it and when you can see the store work and see the trails same for the other plugin i used that goes with the store.
I get the when I chose the trail in my inv.

[store/store-backend.smx] ERROR | SQL Error on GiveItem: Unknown column 'aquire_method' in 'field list'

and I get this

L 02/09/2015 - 17:560: [SM] [0] Line 337, C:\Users\Alon\Documents\GitHub\store-trails\scripting\store-trails.sp::GiveTrail()
L 02/09/2015 - 17:564: [store\store-logging.smx] SQL Error on GiveItem: Unknown column 'aquire_method' in 'field list'
L 02/09/2015 - 17:569: [SM] Native "Store_GetClientLoadout" reported: Plugin owning this native is currently paused.
L 02/09/2015 - 17:569: [SM] Displaying call stack trace for plugin "store\store-inventory.smx":
L 02/09/2015 - 17:569: [SM] [0] Line 256, C:\Users\Alon\Documents\GitHub\store\scriptin g\store-inventory.sp::OpenInventoryCategory()
L 02/09/2015 - 17:569: [SM] [1] Line 223, C:\Users\Alon\Documents\GitHub\store\scriptin g\store-inventory.sp::InventoryMenuSelectHandle()



AND YES I SEARCHED before i posted this.


Thanks if some one can help me out
You obviously didn't search well enough then, it's even in the FAQ...

https://forums.alliedmods.net/showpo...06&postcount=2
__________________
FrozenHaxor is offline
webz
Junior Member
Join Date: Jun 2012
Old 02-10-2015 , 21:43   Re: Post bugs for me here please.
Reply With Quote #3

Quote:
Originally Posted by FrozenHaxor View Post
You obviously didn't search well enough then, it's even in the FAQ...

https://forums.alliedmods.net/showpo...06&postcount=2

So I did all that says and have 2.0 installed and still getting I reinstalled the database 2 times

[store/store-backend.smx] ERROR | SQL Error on GiveItem: Unknown column 'aquire_method' in 'field list'

what I am using

https://github.com/alongubkin/store/tree/development
https://github.com/SourceMod-Store/store-webpanel

Last edited by webz; 02-10-2015 at 21:45.
webz is offline
Arrow768
Veteran Member
Join Date: Nov 2011
Location: Austria
Old 02-11-2015 , 15:56   Re: Post bugs for me here please.
Reply With Quote #4

Quote:
Originally Posted by webz View Post
So I did all that says and have 2.0 installed and still getting I reinstalled the database 2 times

[store/store-backend.smx] ERROR | SQL Error on GiveItem: Unknown column 'aquire_method' in 'field list'

what I am using

https://github.com/alongubkin/store/tree/development
https://github.com/SourceMod-Store/store-webpanel
As FrozenHaxor told you before:
READ THE F.A.Q.

I wrote it for a reason.
__________________
Arrow768 is offline
webz
Junior Member
Join Date: Jun 2012
Old 02-12-2015 , 11:48   Re: Post bugs for me here please.
Reply With Quote #5

Quote:
Originally Posted by Arrow768 View Post
As FrozenHaxor told you before:
READ THE F.A.Q.

I wrote it for a reason.
1.) Reinstalled it 5 times now and rewiped the database and reinstalled the server and SM and MM.
2.) I am using the most recent Store plugin and Web Panel.
3.)Added the Flags column but not need do to that I have a the up to date store plugin

1.)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
2,)Fixed by (aquire_method): Using the current version of the store plugin (Anything after May 2013 is fine)
3.)Fixed by (flags): Adding the flags column to the database

But its ok I brought a Store plugin from someone.But thanks for your guys help
webz is offline
Arrow768
Veteran Member
Join Date: Nov 2011
Location: Austria
Old 02-13-2015 , 12:26   Re: Post bugs for me here please.
Reply With Quote #6

Wow, you even quoted the solution, but you have not applied it.
Quote:
Originally Posted by webz View Post
[...]2,)Fixed by (aquire_method): Using the current version of the store plugin (Anything after May 2013 is fine)
[...]
Why are you using a version thats nearly more than two years old, when there is a recent release available ?
__________________

Last edited by Arrow768; 02-13-2015 at 12:29.
Arrow768 is offline
webz
Junior Member
Join Date: Jun 2012
Old 02-13-2015 , 19:12   Re: Post bugs for me here please.
Reply With Quote #7

Quote:
Originally Posted by Arrow768 View Post
Wow, you even quoted the solution, but you have not applied it.


Why are you using a version thats nearly more than two years old, when there is a recent release available ?
So where did I quot the solution at? The store links I used https://github.com/Drixevel/store/tree/master

https://github.com/SourceMod-Store/store-webpanel


So how am I using a outdated one?
webz is offline
Drixevel
AlliedModders Donor
Join Date: Sep 2009
Location: Somewhere headbangin'
Old 02-15-2015 , 03:40   Re: Post bugs for me here please.
Reply With Quote #8

Quote:
Originally Posted by webz View Post
So where did I quot the solution at? The store links I used https://github.com/Drixevel/store/tree/master

https://github.com/SourceMod-Store/store-webpanel


So how am I using a outdated one?
You originally quoted the default Github Repository by Alongub instead of mine, I'd try my version again but make sure you execute the correct SQL files.
Drixevel 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:13.


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