Error Can not Get Row Count 
Author: Mark Fletcher
Visited 2399,
Followers 1,
Shared 0
Peter K suggested fix for this error, Error Can not Get Row Count
https://helpcenter.websitex5.com/en/post/192774
This was happenning to me, since names.co.uk ukservers recently.
This works, but, you do not then get the row count number at the bottom of the viewer.
You also need to change lines 70 and 71, (I believe), from
$count = $count->fetch_assoc();
$rows = $count['rows'];
TO
$rows = $count->fetch_row();
which seems to work, for me, when manually uploading to server.
Posted on the
Author
Oops, mean't to say took over ukservers.
Hello Mark
Be careful with this :-) If too many users tells INCOMEDIA how to fix bugs in the system, we will in the future have releases that has bugs from the start - and then INCOMEDIA will wait for us users to report the bugs, and now also tell how to fix it.
This bug should have been fixed as soon it was reported - I have not seen an update yet.
INCOMEDIA should support their customers. They have named one of the versions a PRO-version. They should think that for some users it is important to have a functioning version. We can all make bugs - but we should also be willing to fix it, when we are aware that they exist, and when we are able to fix it. This is an issue the developers at INCOMEDIA should be able to fix.
Kind regards
JohnS.
Author
Quite correct, but, if you were administering your membership database through dbviewer and it stops working, do we wait, like TSB customers. I say NO NO NO.
I will put up a simple website demonstrating errors I have pointed out, that have not been fixed for some 4 months.
My final sugestion is that the variables websiteX5 use, $count and $row are causing a conflict, because they are reserved words.
What are your suggestions to fix this? Wait?
Hello Mark
My suggestionm is to wait. I think the developers at INCOMEDIA is quite capable. But I don't understand their priorities.
I think their first priority should be to fix known problems.
Second priority should be to implement some of the suggestions we users has posted - some of the suggestions are suggested by many people but are still not implemented.
Third priority should be to develop functions that are useful, but that we users didn't knew we were missing.
I can guarantee that if INCOMEDIA doesn't do this, they will end up as NOKIA.
One day a very succesful firm - the next day a firm that could see the world move to another firm that better knew what people wanted.
Kind regards
John S.
Hello everyone.
Thank you for reporting this further detail on the problem.
I can confirm to you that the issue has been reported and is being analyzed, also thank to your effort into trying to individuate the problem and reporting it here.
I would like to get back to you here as soon as the developers get back to me on this matter.
Thank you
Stefano
Author
I have sent you a private posting about this:
Since moving to names.co.uk, I have been getting "Error cant get row count", when using the dbviewer.
The problem lies with these lines:
62 $count = $db->query("select count(*) as rows from table" . $where);
71 $rows = $count['rows'];
'rows' is a reserved word and is causing the problem on these servers.
When replacing rows with rowcount, therefore
62 $count = $db->query("select count(*) as rowcount from table" . $where);
71 $rows = $count['rowcount'];
the error disappears.
Please pass this information on to the developers and rectify asap.
I do not want to have to manually change several dbviewers manually everytime I update my sites.
Regards