Lead Loader SQL error

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Lead Loader SQL error

Postby mav2287 » Wed Jan 08, 2014 11:01 pm

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
 
ViciBox5.x86_64-5.0.3.preload from .iso upgraded to 13.1 | VERSION: 2.10-444c BUILD: 150129-0828 | 1.8.32.2-vici | Dual Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel twin quad core 3Ghz Xeon chips | 32gb of RAM
mav2287
 
Posts: 256
Joined: Thu Oct 03, 2013 6:47 pm

Re: Lead Loader SQL error

Postby DomeDan » Thu Jan 09, 2014 5:55 am

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
Vicidial Partner. Region: Sweden/Norway.
Does Vicidial installation, configuration, customization, add-ons, CRM implementation, support, upgrading, network-related, pentesting etc. Remote and onsite assistance.
Email: domedan (at) gmail.com
DomeDan
 
Posts: 1226
Joined: Tue Jan 04, 2011 9:17 am
Location: Sweden

Re: Lead Loader SQL error

Postby mav2287 » Thu Jan 09, 2014 12:03 pm

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!
ViciBox5.x86_64-5.0.3.preload from .iso upgraded to 13.1 | VERSION: 2.10-444c BUILD: 150129-0828 | 1.8.32.2-vici | Dual Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel twin quad core 3Ghz Xeon chips | 32gb of RAM
mav2287
 
Posts: 256
Joined: Thu Oct 03, 2013 6:47 pm

Re: Lead Loader SQL error

Postby williamconley » Thu Jan 09, 2014 4:34 pm

Excellent DomeDan and Excellent postback confirmation mav2287! 8-)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Support

Who is online

Users browsing this forum: Google [Bot], Majestic-12 [Bot] and 89 guests