Page 1 of 1

Lead Loader SQL error

PostPosted: Wed Jan 08, 2014 11:01 pm
by mav2287
I was cleaning out logs today and doing some DB maintance when I found ALOT of the same error. I tried to reproduce it and found that every time I open the lead loader the log gets stuffed with errors exactly like this one. I repaired the DB thinking it might be corrupt and it turned out to be good. Anyone have any clue where to start on this one?

Code: Select all
[Wed Jan 08 21:57:06 2014] [error] [client 192.168.2.130] PHP Warning:  mysql_fetch_row() expects parameter 1 to be resource, object given in /usr/local/apache2/htdocs/vicidial/admin_listloader_fourth_gen.php on line 584, referer: http://192.168.1.69/vicidial/admin.php?ADD=100
 

Re: Lead Loader SQL error

PostPosted: Thu Jan 09, 2014 5:55 am
by DomeDan
You found a bug! :) or I would rather call it a small miss by the coder in the file admin_listloader_fourth_gen.php
mysql_fetch_row() on row 584 should have been changed to
mysqli_fetch_row() but was probably missed

I posted this to the issue tracker http://www.vicidial.org/VICIDIALmantis/view.php?id=732 for the developer to fix it
The list loader might still work because the log states it as a "PHP Warning"
So you can either add that missing i-letter yourself or just use the loader as usual and update your system when the bug is fixed to get rid of that error message

Re: Lead Loader SQL error

PostPosted: Thu Jan 09, 2014 12:03 pm
by mav2287
Implemented the fix and all is now right in the world, well at least in my apache2 logs. I will apply the fix to all my servers. Thanks for the heads up and posting it to the tracker DomeDan!

Re: Lead Loader SQL error

PostPosted: Thu Jan 09, 2014 4:34 pm
by williamconley
Excellent DomeDan and Excellent postback confirmation mav2287! 8-)