In our support boards we aim to provide support for the B3 core in its current state. Older releases of B3 are NOT supported. Check our front page for the latest version. You may post feature requests in our General Discussion board. Modifications and Hacks of the core B3 code are NOT supported.
Before you ask for support: [ Read the Support Instructions ] - More info: [ Full Support Disclaimer ]

You are here: Big Brother Bot ForumSupport ForumsInstallation Support (Moderator: MordyT)MySQL Record Limit
Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: MySQL Record Limit  (Read 937 times) Bookmark and Share
LuxXx
Jr. Member
**
OS: Linux
Type: Owner dedicated server(s)
Gameservers: UrT
Posts: 23
Offline Offline
« on: March 02, 2011, 07:17:05 AM »
Hi All,
I have a Problem
My MySQL database Record limit is set to 30


How I can raise this?
Im Using PHPMyAdmin

1:





2:
« Last Edit: March 02, 2011, 07:21:24 AM by LuxXx » Logged
82ndAB.Bravo17
Dev. Team
*
OS: Windows
Type: Gameserver Rental Co.
Gameservers: COD2,COD4,COD5
Posts: 1098
Offline Offline
« Reply #1 on: March 02, 2011, 08:36:30 AM »
If you have more results than 30 it should show navigational arrows for you to see to the other pages, at the moment you only have 23 records so they don't show up.
Logged
LuxXx
Jr. Member
**
OS: Linux
Type: Owner dedicated server(s)
Gameservers: UrT
Posts: 23
Offline Offline
« Reply #2 on: March 02, 2011, 08:46:36 AM »
LoL. Dude. Im not n00bsy. I've got more ppl on my Server than 23.
The tables are limited to 30 records.
That's not what i've posted. Please read again. Look at the attachments!





It's limited"
« Last Edit: March 02, 2011, 08:49:34 AM by LuxXx » Logged
Jackster
Full Member
***
OS: Linux
Type: Gameserver Rental Co.
Gameservers: COD
Posts: 53
Offline Offline
WWW
« Reply #3 on: March 02, 2011, 09:36:26 AM »
Use a better host.
Logged
WarServers.NET

The BEST Game Server provider!
82ndAB.Bravo17
Dev. Team
*
OS: Windows
Type: Gameserver Rental Co.
Gameservers: COD2,COD4,COD5
Posts: 1098
Offline Offline
« Reply #4 on: March 02, 2011, 10:25:52 AM »
I suggest that you read how the sql select statements work, I very much doubt that you are limited to 30 records and nothing in your post shows that you have more than 30 records in the clients table, in fact if you look at the attachments it shows that you have only 23.

http://www.plus2net.com/sql_tutorial/sql_limit.php
Logged
LuxXx
Jr. Member
**
OS: Linux
Type: Owner dedicated server(s)
Gameservers: UrT
Posts: 23
Offline Offline
« Reply #5 on: March 02, 2011, 12:36:33 PM »

Quote from: Jackster on March 02, 2011, 09:36:26 AM
Use a better host.

Its not the fault of teh host.


7 Records in penalties
23 Records in clients

=

30 Records at all. The Limit.
« Last Edit: March 02, 2011, 12:38:34 PM by LuxXx » Logged
MordyT
Moderator
*
OS: Windows
Type: Gameserver Rental Co.
Gameservers: 2x CoD4, 1x BF3
Posts: 2627
Offline Offline
Owner of Host4B3.com - Over 70 bots hosted!
WWW
« Reply #6 on: March 02, 2011, 02:58:08 PM »
Hey,
First, you are not limited.
But since you don't seem to care for our answers, I will go down this road.

This is not a B3 issue, rather a mysql issue.
Please ask for help in a mysql forum. We support B3 here.
Thanks.
Logged
Need B3 Bot hosting? Check out Host4B3.com
Check Twitter.com/Host4B3 for updates if the site it down.

Help will be given to those with a b3.log

System: Python 2.7.1 - B3 Source Code - Locally hosted MySQL & Apache - Win 2k3
Spruehwurstheinz
Beta Testers
*
OS: Linux
Type: Owner dedicated server(s)
Posts: 234
Offline Offline
« Reply #7 on: March 02, 2011, 03:56:07 PM »
lol, there isn't any issue.

The Limit 0, 30 in phpMyAdmin simple means you start collecting at entry 0 and up to entry 30. But you have definitly 23 records only in your database. The entrys in penalties are not added to them.

Maybe your server is just empty or the bot is down so that you don't get new entrys. MySQL is in fact not the problem.

Check out the b3.log if there is everything okay.
Logged
Tags:
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to:  


Rate this page +1 at Google Search


SimplePortal 2.3.1 © 2008-2009, SimplePortal