[Issue] Encoding error - Page 3

rocknroll · 04-01-2013 , 23:30 Re: Encoding error

Quote:

Using 1.1-alpha because newer ones are not working correctly (menu just dissappears when I press "Shop" or "Inventory"). If someone helps me with installing newer version, it would be awesome!

Added Franc1sco at steam, will write you later!

rocknroll · 04-06-2013 , 15:56 Re: Encoding error

Finally, installed latest version. The same bug as written in first post. Everything is ok on server start, but after map change I can see "????" instead of categories names. There are NO errors in logs according store plugin.

Quote:

[SM] Displaying 15 extensions:
[01] Automatic Updater (1.5.0-dev+3793): Updates SourceMod gamedata files
[02] Webternet (1.5.0-dev+3793): Extension for interacting with URLs
[03] SMJansson (2.3.1/3): JSON parser/writer
[04] CS Tools (1.5.0-dev+3793): CS extended functionality
[05] BinTools (1.5.0-dev+3793): Low-level C/C++ Calling API
[06] SDK Tools (1.5.0-dev+3793): Source SDK Tools
[07] Top Menus (1.5.0-dev+3793): Creates sorted nested menus
[08] Client Preferences (1.5.0-dev+3793): Saves client preference settings
[09] SQLite (1.5.0-dev+3793): SQLite Driver
[10] SDK Hooks (1.5.0-dev+3793): Source SDK Hooks
[11] <FAILED> file "steamtools.ext.so": /home/tcagame/user160/158/css/cstrike/addons/sourcemod/extensions/steamtools.ext.so: cannot open shared object file: No such file or directory
[12] GeoIP (1.5.0-dev+3793): Geographical IP information
[13] <FAILED> file "geoipcity.ext.so": /home/tcagame/user160/158/css/cstrike/addons/sourcemod/extensions/geoipcity.ext.so: cannot open shared object file: No such file or directory
[14] Regex (1.5.0-dev+3793): Provides regex natives for plugins
[15] MySQL-DBI (1.5.0-dev+3793): MySQL driver implementation for DBI
[SM] Listing 49 plugins:
01 "Basic Comm Control" (1.5.0-dev+3793) by AlliedModders LLC
02 "SM SKINCHOOSER" (2.3) by Andi67
03 "SourceBans" (1.4.10) by SourceBans Development Team
04 "Jailbreak Team Balance" (3.0.7.1) by databomb
05 "weapons_parser.smx"
06 "Anti-Flood" (1.5.0-dev+3793) by AlliedModders LLC
07 "Admin Menu" (1.5.0-dev+3793) by AlliedModders LLC
08 "Basic Commands" (1.5.0-dev+3793) by AlliedModders LLC
09 "Last Request: FruitNinja" (1.1.0) by Elad Nava & CoMaNdO
10 "Player Commands" (1.5.0-dev+3793) by AlliedModders LLC
11 "SM_Hosties v2" (2.1.0) by databomb & dataviruset
12 "M3Motd - MOTD / Rules Display" (0.2.1) by M3Studios, Inc.
13 "Ban disconnected players" (1.04) by mad_hamster
14 "Fun Commands" (1.5.0-dev+3793) by AlliedModders LLC
15 "TeamSwitch" (1.4) by MistaGee (Modify by Snake 60)
16 "Connect Announce" (1.6) by Arg!
17 "SM Jail Teams" (1.0.3) by Elad Nava
18 "[Store] Core" (1.1.1-alpha) by alongub
19 "[Store] Gifting" (1.1.1-alpha) by alongub
20 "[Store] Distributor" (1.1.1-alpha) by alongub
21 "[Store] Inventory" (1.1.1-alpha) by alongub
22 "[Store] Refund" (1.1.1-alpha) by alongub
23 "[Store] Logging" (1.1.1-alpha) by alongub
24 "[Store] Backend" (1.1.1-alpha) by alongub
25 "[Store] Loadout" (1.1.1-alpha) by alongub
26 "[Store] Shop" (1.1.1-alpha) by alongub
27 "Welcome Sound" (0.0.1) by R-Hehl
28 "SM Hide Attacker" (b1.1) by Franc1sco Steam: franug
29 "Fun Votes" (1.5.0-dev+3793) by AlliedModders LLC
30 "Basic Votes" (1.5.0-dev+3793) by AlliedModders LLC
31 "Nextmap" (1.5.0-dev+3793) by AlliedModders LLC
32 "DM Health Kit" (1.0) by igodsewer
33 "JailBreak Warden" (1.7.0) by ecca
34 "char_parser.smx"
35 "Last Request: Shotgun Wars (sample)" (1.0.2) by databomb & dataviruset
36 "Admin Help" (1.5.0-dev+3793) by AlliedModders LLC
37 "MapChooser" (1.5.0-dev+3793) by AlliedModders LLC
38 "Basic Info Triggers" (1.5.0-dev+3793) by AlliedModders LLC
39 "RandomCycle" (1.5.0-dev+3793) by AlliedModders LLC
40 "Advertisements" (0.6) by Tsunami
41 "Reserved Slots" (1.5.0-dev+3793) by AlliedModders LLC
42 "Sound Commands" (1.5.0-dev+3793) by AlliedModders LLC
43 "Basic Chat" (1.5.0-dev+3793) by AlliedModders LLC
44 "Show Damage" (1.0.7) by exvel
45 "Drop Nades" (1.1) by wS / Schmidt
46 "Map Nominations" (1.5.0-dev+3793) by AlliedModders LLC
47 "Spray Tracer No Menu" (v5.8b) by Nican132, CptMoore, Lebson506th
48 "Client Preferences" (1.5.0-dev+3793) by AlliedModders LLC
49 "Admin File Reader" (1.5.0-dev+3793) by AlliedModders LLC
Listing 4 plugins:
[01] SourceMod (1.5.0-dev+3793) by AlliedModders LLC
[02] CS Tools (1.5.0-dev+3793) by AlliedModders LLC
[03] SDK Tools (1.5.0-dev+3793) by AlliedModders LLC
[04] SDK Hooks (1.5.0-dev+3793) by AlliedModders LLC
Loaded plugins:
---------------------
0: "Metamod:Source 1.9.2"
---------------------

rocknroll · 04-06-2013 , 16:31 Re: Encoding error

I'm going to donate 100$ to developer if he helps me with this god damn problem!!! Seriously!!!

rocknroll · 04-11-2013 , 00:06 Re: Encoding error

Anyone? Fuck, no way to fix?

alongub · 04-11-2013 , 14:11 Re: Encoding error

Try to execute the following SQL:

Code:

ALTER DATABASE <store_database_name> CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE store_items CHARACTER SET utf8 COLLATE utf8_general_ci;

Make sure to change <store_database_name> to your database name.

rocknroll · 04-12-2013 , 13:08 Re: Encoding error

Quote:

Originally Posted by alongub

Try to execute the following SQL:

Code:

ALTER DATABASE <store_database_name> CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE store_items CHARACTER SET utf8 COLLATE utf8_general_ci;

Make sure to change <store_database_name> to your database name.

Done. No effect.

Franc1sco · 04-12-2013 , 13:27 Re: Encoding error

Quote:

Originally Posted by rocknroll

Done. No effect.

Only happen with your language (russian)? you have tried with other language?

alongub · 04-12-2013 , 13:41 Re: Encoding error

Oops, the second line should be

Code:

ALTER TABLE store_items CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

rocknroll · 04-13-2013 , 08:17 Re: Encoding error

Quote:

Originally Posted by alongub

Oops, the second line should be

Code:

ALTER TABLE store_items CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

Executed. No help.

rocknroll · 04-13-2013 , 17:01 Re: Encoding error

Any ideas?