This topic has 12 replies, 3 voices, and was last updated 10 years, 3 months ago by Fem.
Tagged: error
Viewing 13 posts - 1 through 13 (of 13 total)
HI,
When I log into the Advanced Testimonials Manager, I get Warning: mysqli_num_rows() errors. Please see image here: http://pasteboard.co/1x3OdQeO.png or attached.
I’m running a WAMP server off Windows 2012.
I also noticed an UPDATE MESSAGE:
“Update Plugin to Version 4.1.1
You are using an outdated version of Advanced Testimonial Manager Script.
You can upgrade it to latest version by clicking on Update Script button. If you have any questions regarding the updates you can feel free to create a ticket in our dedicated support forum where our support staff will help you with the upgrades.”
The thing is …. I did use version 4.1.1 in the install…so I cannot understand why it’s prompting me to update? And when I click Update… it “updates successfully” but the UPDATE MESSAGE above doesn’t go away.
There are no testimonials in your database. So add some testimonials in the database and see. If the bug still arises then let us know so that we can make a fix for that asap.
For your other question which is Update Plugin to Version 4.1.1,
Open testimonials/admin/index.php on line around #61,
replace
<?php if( $version <= $new_version || $version == NULL ) { ?>
with
<?php if( $version < $new_version || $version == NULL ) { ?>
Sorry, that message isn’t for you. I have deleted that.
“There are no testimonials in your database. So add some testimonials in the database and see. If the bug still arises then let us know so that we can make a fix for that asap.”
It shouldn’t be a case where “if there’s no testimonials then you will have error messages”…
Someone else had the same problem on codecanyon comment section. You guys apparently fixed it… so what did you do with his/hers script?
I knew it’s a bug. We’ll fix this and we’ll release a new version with in a day soon.
But if you want it to resolve asap, then replace these 2 files in admin folder and see but before replacing take a backup of these 2 files.
Thanks …
The files replacements sorted out some warnings, however I am getting ONE warning for the following pages:
ACCEPTED:
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\……..\guest-reviews\admin\accepted.php on line 48
PENDING:
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\……..\guest-reviews\admin\pending.php on line 47
DENIED:
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\……..\guest-reviews\admin\denied.php on line 45
ACCEPTED:
Replace this on line no#46 in admin/accepted.php file
//Accepted testimonials
$acceptsql = mysqli_query($link, "SELECT * from review where status='1'");
$accepttotal = mysqli_num_rows( $acceptsql );
with
//Accepted testimonials
$accepttotal = '0';
if ( $acceptsql = mysqli_query($link, "SELECT * from review where status='1'") ) {
$accepttotal = mysqli_num_rows( $acceptsql );
}
PENDING:
Replace this on line no#45 in admin/pending.php file
//pending testimonials
$pendingsql = mysqli_query($link, "SELECT * from review where status='0'");
$pendingtotal = mysqli_num_rows( $pendingsql );
with
//pending testimonials
$pendingtotal = '0';
if ( $pendingsql = mysqli_query($link, "SELECT * from review where status='0'") ) {
$pendingtotal = mysqli_num_rows( $pendingsql );
}
DENIED:
Replace this on line no#43 in admin/denied.php file
//Denied testimonials
$deniedsql = mysqli_query($link,"SELECT * from review where status='-1'");
$deniedtotal = mysqli_num_rows( $deniedsql );
with
//Denied testimonials
$deniedtotal = '0';
if ( $deniedsql = mysqli_query($link,"SELECT * from review where status='-1'") ) {
$deniedtotal = mysqli_num_rows( $deniedsql );
}
Hi,
Thanks … Your replacements have gotten rid of the error messages however:
1) Have we just gotten rid of the error messages but the problems remain that we can’t see or 2) Have we sorted out the issues altogether?
Why did this happen to me and not others?
Did you deleted the testimonials in database which comes by default with the script. By default we have added 1 testimonial with installation, if you remove that one then you’ll see that error. We have not tested with an empty database so far but we’ll consider updating it soon.
This has been resolved it for you but not for others. We’ll update the script very soon.
If you have anymore questions please feel free to contact us. We’ll be there to assist you.
Viewing 13 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic.