SQL syntax error in listloader_super.pl

[farish]

Hi,

i am getting this error in my web server log file..

Code: Select all

DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'yer','','**** ***** Ferry Rd','','','Baltimore','MD','','21230','','','','',''' at line 1 at /var/www/vicidial/listloader_super.pl line 446.


after look at the leads file found that the name yer actually O'yer and the error cause by the single quote ( ' ) and listloader_super.pl is not going to escape it.....

thanks
farish

[mflorell]

Moved from General to Support.

astGUIclient version?

What kind of file were you loading?

[farish]

astGUIclient 2.0.3

With perl modeules install as descrived in ( SUBPHASE 3.2: Installing Perl Modules )

i used to load excel file in vicidial load leads and always use super lead loader .

Thanks

[farish]

in addition leads are success fully enter in database except these leads which has a single quote in name or address ( last try out of 10,000 only 8,441 leads enter in database ....)

[mflorell]

Have you tried this with a CSV or TXT file?

Can you post this in the issue tracker with a sample file?

[farish]

Have you tried this with a CSV or TXT file?

i just tried csv also but it doesn't give any error but silently ignore the single quoted name ....