next »

[gwynevere]

Hrm.. I'm on box15, I can't seem to view any rows  in any of my tables past the first 30 it displays for you when you browse the rows for that table in the 110dbmanager. I've tried changing the limit in the process box too, and it just times out. Is it just me? I've restarted my internet and all that, it's just not working. I'm trying to edit some rows manually, but I can't get to them.


Edit: and now I've logged out of my database and can't get back in

[jamesbrauman]

I'm not sure if that is a problem with teh box or a just with 110dbmanager.. try this simple php code to see (place it somewhere on your site and run it. You'll have to edit some data to get it to connect)

Code:

<?php
  mysql_connect("localhost", "USERNAME", "PASSWORD");
  mysql_select_db("YOURDATABASE");
  $result = mysql_query("select * from YOURTABLE");
  $row_count = 0;  
  while ($row = mysql_fetch_array($result)) {
    echo "<XMP>ROW $row_count: ";    
    for ($i = 0; $i <= count($row); $i++) {
      echo $row[$i]." ";
    }
    $row_count++;
  }
?>

That should get all the info out of your database..

[gwynevere]

I did what you said... and it wouldn't show anything past row 60, and I can tell you there are a lot more than that

I'm getting frustrated... I'm trying to release something new for my users and I can't get anything to load using 110dbmanager. I've deleted it, redownloaded it... I've removed the last script I put up to see if it was the problem and still nothing. I've tried restarting my internet AND my computer to see if it was just me.. and still nothing. I can't login into other databases I have, so I'm stuck in just one. It's been like this for two days now. It will only let me see the first 30 rows in each table and nothing more. I've tried emptying the tables and it won't go through.

[gwynevere]

Still haven't found a solution to my problem....

[gwynevere]

Okay... I've submitted a ticket on the 110mb support. Is there anywhere else I can go to get faster help, please? I don't mean to be impatient, but I have a ton of people using my site that have been waiting nicely. I just can't get any rows to show up.. I can only see the first thirty in each table but nothing further than that when I try to change the page or increase my limit. I did, however, manage to log into a different database of mine.. but it took 5 minutes for it to go through, then I had to wait another just to get it to load after clicking 'Force Reload'. It wasn't just 110dbmanager.. I tried to use Phpminiadmin too... and it's doing the same thing. I tried switching from internet explorer to firefox.. and still nothing.

[Myles Grey]

Are there buttons to click to more pages. 110dbmanager automatically paginates, however for me it's 50 per page. You can always use phpMyAdmin instead.

Also don't triple post, edit your posts to put them together.

[gwynevere]

Yeah the pages are there.. but I'm stuck on page 1. When I try to click.. say.. page 2, it just times out and doesn't get there. Then, I've tried changing the limit and clicking 'Show'. That doesn't work either. I've tried changing the limit in the "Process This" box above.. and it just all does the same thing. In the past I could easily bring up 1000 rows at once... and now it's just not working at all. It all started when I attempted to use this script:

Code:

<?php
$host = "localhost";
$user = "gwynevere_clan";
$pass = "blahblah";
$db = "gwynevere_clan";
$tbl = "members";

mysql_connect($host, $user, $pass)or die("cannot connect");
mysql_select_db($db)or die("cannot select DB");

$sql = "SELECT * FROM $tbl WHERE clan='{$_SESSION[SESS_CLAN_ID]}'";
$result = mysql_query($sql);
$entries = mysql_num_rows($result);


if(isset($_POST['submit'])){
$login = $_POST['login'];
$title = $_POST['title'];  

for($i=0;$i<$entries;$i++){
mysql_query("UPDATE $tbl SET title='$title[$i]' WHERE login='$login[$i]'") or die(mysql_error());;
}
}
?>

<form method="post" action="" name="form1">
<table width="100%" cellspacing="1" cellpadding="0">
<tr>
<td align="center">Name</td>
<td align="center">Title</td>
</tr>

<?php
while($info = mysql_fetch_assoc($result)){
?>
 
<input type="hidden" name="login[]" value="<? echo $info[login];?>" />
<tr>
<td align="center"><? echo $info[login];?></td>
<td align="center"><input type="text" name="title[]" value="<? echo $info[title];?>" /></td>
</tr>

<?php
}
?>

<tr>
<td align="center" colspan="100%"><input type="submit" name="submit" value="Submit" /></td>
</tr>
</table>

<?php
mysql_close();
?>

Did the script mess it up somehow? Cause the script worked ONCE to update my table.. then after that it just didn't work at all. And now I can't even get 110dbmanager to work for ANY database. It only seems to be this form/script that is incredibly slow... it works.. it just takes forever to process, if it manages not to time out. Other forms on my site work just fine. But I don't know... I re-downloaded 110dbmanager and it still doesn't work. I'm at a loss on what to do and feeling rather desperate for a solution.

Sorry for the multiple posts, but I usually wait many hours before posting again. Getting a response here seems to take a while and I feel like my post will get lost and forgotten.

[Myles Grey]

Are you sure there isn't some record on the second page that has some corrupt data or something else that is incompatible with 110dbmanager. Try installing phpMyAdmin.

[gwynevere]

Why would that affect other databases though? Just curious...

I tried downloading phpmyadmin and I just can't get it to upload through FTP. I'm giving up for the day.. I'm tired and irritated. Thanks for trying to help though.


EDIT: I don't know what fixed it.. but it's working now!

[gwynevere]

Just kidding.. it worked for several hours then just quit again. It's been another day or so and it's still not working. I'm tired of this.