Menu

#79 PHP Script error and/or sql error

all
open
nobody
None
3
2021-02-03
2020-12-22
No

[22-Dec-2020 01:36:23 UTC] PHP Warning: A non-numeric value encountered in /var/www/html/daloradius/include/management/userReports.php on line 386

Having issues with database updates and noticing the php error above regarding what appears to be the time fields "$timeDiff = ($planTimeBank - $totalTimeUsed);"

Also getting sql error when updating user plans (below). Could be related.
Running fc31.x86_64, FreeRADIUS Version 3.0.21, Mysql 8.0.22.

Let me know if you want more details!

Error Message: DB Error: syntax error
Debug info: UPDATE userbillinfo SET contactperson='', planname='Daily-Plan', company='', email='', phone='', paymentmethod='', cash='', creditcardname='', creditcardnumber='', creditcardverification='', creditcardtype='', creditcardexp='', address='', city='', state='', country='', zip='', notes='', changeuserbillinfo='0', lead='', coupon='', ordertaker='', billstatus='', nextinvoicedue='0', billdue='0', postalinvoice='', faxinvoice='', emailinvoice='', updatedate='2020-12-22 01:47:46', updateby='administrator' WHERE username='kevint' [nativecode=1064 ** 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 'lead='', coupon='', ordertaker='', billstatus='', nextinvoicedue='0', billdue='0' at line 1]

Discussion

  • kevin teahan

    kevin teahan - 2020-12-22

    running DaloRADIUS version 1.1-3 BETA / 06 Dec 2019

     
  • Anonymous

    Anonymous - 2021-02-03
    Post awaiting moderation.

Anonymous
Anonymous

Add attachments
Cancel





MongoDB Logo MongoDB