Sql error in Services screen

Management and Administration
1

cadprofessor wrote on Monday, May 17, 2010:

Using openemr 3.2.0  Just download and installed the ICD9 database (all 14,000 plus of them).  When I go to the services screen under administrator and enter a code to search for there is no problem.  If I use the arrow top right to move to the next screen more than 4 times I receive this error when I search for a code…

ERROR: query failed: SELECT * FROM codes WHERE 1 = 1 AND code LIKE ‘295.35%’ ORDER BY code_type, code, code_text LIMIT 400, -399

Error: 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 ‘-399’ at line 1

This only happens if you advance the display screen more than a couple of times.  I have tried this on two systems with the same result.  I don’t know if something is not set right in database tables.

Thanks….

2

visolveemr wrote on Thursday, May 20, 2010:

Hi Michael,

We’d tested this and we are confirming this bug. This is also placed in the bug tracker.
Bug Tacker Link: https://sourceforge.net/tracker/?func=detail&aid=3004505&group_id=60081&atid=493001

In superbill_custom_full.php, $fstart variable is not reseted properly.

Thanks,
Vicareplus Team,
www.vicareplus.com