Comments (2)
how to fix this ?
from big-brother-bot.
how to fix this ?
Обратите внимание на слово 'None' в запросе. Это слово необходимо обернуть в одинарные кавычки(''). Таким образом полный запрос будет выглядеть так:(Место, которое требовало редактирования выделено жирным шрифтом)
SELECT MAX(xlr_playerstats.skill) AS max_skill, MIN(xlr_playerstats.skill) AS min_skill, SUM(xlr_playerstats.skill) AS sum_skill,\n AVG(xlr_playerstats.skill) AS avg_skill , COUNT(xlr_playerstats.id) AS cnt\n FROM xlr_playerstats, clients\n WHERE clients.id = xlr_playerstats.client_id\n AND xlr_playerstats.client_id <> 'None'\n AND (xlr_playerstats.kills + xlr_playerstats.deaths) > 50\n AND 1573829422 - clients.time_edit <= 5184000
from big-brother-bot.
Related Issues (20)
- B3 Source Mod Plugin is back HOT 3
- redirect stdout crash with KeyError: \'admin\'\\n"' HOT 1
- DB conntion ERROR HOT 10
- Error: Could not parse line no such group HOT 13
- Changing colors HOT 4
- XLRStats Webfront V3 tab-content not loading HOT 1
- Not parsing dark blue (the ";" color code) in MW3
- DB connecting failed HOT 19
- ERROR 'Query failed [SELECT clients.time_edit, MAX(xlr_playerstats.skill) HOT 2
- No error but not working HOT 2
- XLRStats Webfront v3 issue HOT 2
- banlist_v2.dat HOT 1
- B3 on rented gameserver HOT 4
- b3.distribution.ini is the name of config file but b3 expects b3.ini by default HOT 3
- [WOP] Could not parse line no such group
- plugins not working for cod4x HOT 1
- b3 not working
- 'STDERR "ValueError: invalid literal for int() with base 10: \'senioradmin\'\\n"' HOT 1
- B3 Sending multiple messages HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from big-brother-bot.