I use the Joyent Cloud's VirtualMin system and asked their support team this question. However, they referred me to VirtualMin, so I appreciate any support you can provide.
In my database, “gac_prod”, I have a table called “staticpages”. Recently, I added three rows to “staticpages” and gave them the ids of 35, 36, and 37. These rows exist and have content.
However, I am unable to view these rows on-screen in VirtualMin. VirtualMin will only show me rows 1-34, and it won't give me the option for pagination. In order to view rows 35-36, I have to sort by ID, backwards to forwards.
I don't have this problem with any of my other tables. They always show rows 1-50 and then give me the option to page forward to view the next 50.
How can I resolve this glitch?
Thanks in advance for your help.
- Kevin
Comments
Submitted by JamieCameron on Tue, 10/09/2012 - 13:06 Comment #1
Could you attach a screenshot of the page showing the contents of the table?
Normally I would expect to see a line near the top like "Rows 1 to 34 of 36" , with arrows next to it for moving between pages.
Submitted by Kevin P on Tue, 10/09/2012 - 14:08 Comment #2
Here are links to two screenshots. The upload feature on VirtualMin is giving me an "HTTP Error 0" message.
https://www.dropbox.com/s/g03rdaa3axu4mnt/image1.jpg https://www.dropbox.com/s/8uobaacexia242b/image2.jpg
The first image shows the default view of my table (I've cut the content out from the database for security.) The second image shows the view I get when I sort by reverse ID order. I kept one of my rows in place as an example. Note that neither screen offers the Rows 1 to X.
Thanks for your speedy response and any help you can provide!
Submitted by JamieCameron on Tue, 10/09/2012 - 17:28 Comment #3
Are you sure there are no numbers missing in your row IDs? By default, Virtualmin will display only 25 rows of a table at a time.
You can increase this limit by going to Webmin -> Servers -> MySQL Database, clicking on the Module Config link and changing the "Number of rows to display per page" field.
Submitted by Kevin P on Tue, 10/09/2012 - 19:17 Comment #4
Oh, man, this is user error on my part... very embarassing.
So, it turns out that the missing rows (35-37) are not actually missing. They just appear out of ID sequence. You can see them in Image 1 just after row 19. Then, numbering continues as normal.
The rows have always sorted by ID automatically in my view of the data. This is the first time I have created rows and they have not appeared in order. Now, I just have to figure how to default sort by ID again, and I'll be in business. Thanks for your help, JamieCameron!
Submitted by JamieCameron on Tue, 10/09/2012 - 19:30 Comment #5
Ok, I figured it might be something like that..
Submitted by Issues on Tue, 10/23/2012 - 19:46 Comment #6
Automatically closed -- issue fixed for 2 weeks with no activity.