Raised This Month: $ Target: $400
 0% 

Issue SQL Error on SQLCall_GetClientLoadouts


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
GabyEnragedGamers
Senior Member
Join Date: Mar 2016
Location: France, Bordeaux
Old 01-06-2017 , 09:29   SQL Error on SQLCall_GetClientLoadouts
Reply With Quote #1

Hi SourceMod Cummunity !
I use the store plugin and when I want install a module, there is this error :
Code:
[SM] Plugin store-skins.smx failed to reload: Could not find required plugin "store-loadout".
So, I have tried to check the plugin loadout.
When I do the commands !loadout our /loadout
There is theses errors on the loadout plugin :

Code:
 L 01/06/2017 - 09:27:40: [Store] SQL Error on SQLCall_GetClientLoadouts: Table 'database.store_users_loadouts' doesn't exist
L 01/06/2017 - 09:27:40: [Store] SQL Error on SQLCall_GetClientLoadouts: Table 'database.store_users_loadouts' doesn't exist
So, I need to create a table store_users_loadouts but I don't know what fields I need to create too :/


If someone can help me ;)

Thanks a lot for the amazing community

Gaby !


EDIT :

It's WTF !

In the sourcecode of store-core.sp, there are theses lines :

PHP Code:
char sQuery_GetClientLoadouts[] = "SELECT loadout_id FROM %s_users_loadouts WHERE user_id = '%d';"
PHP Code:
char sQuery_QueryEquippedLoadout[] = "SELECT eqp_loadout_id FROM %s_users WHERE auth = '%d';"
For the first line,
the table store_users_loadouts don't exist because the plugin don't create this table.

For the second line,
the field eqp_loadout_id doesn't exist.

If someone who participates in the development of the store is there, it would be cool to fix this

Last edited by GabyEnragedGamers; 01-07-2017 at 07:47.
GabyEnragedGamers is offline
Mike4Told
Member
Join Date: Sep 2013
Old 01-08-2017 , 16:55   Re: SQL Error on SQLCall_GetClientLoadouts
Reply With Quote #2

Give this a shot......

Code:
CREATE TABLE IF NOT EXISTS `store_users_loadouts` (
  `id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `loadout_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
__________________
Mike4Told is offline
GabyEnragedGamers
Senior Member
Join Date: Mar 2016
Location: France, Bordeaux
Old 01-11-2017 , 07:40   Re: SQL Error on SQLCall_GetClientLoadouts
Reply With Quote #3

Thanks man ! Why they don't add this in the store.sql ??

Thanks again,

Gaby !
GabyEnragedGamers 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 14:31.


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