2. PHPRunner General questions
  3. Error Adding new, or inline adding new record (7.1)
This topic is locked

Error Adding new, or inline adding new record (7.1)

 		10/3/2014 11:11:14 AM
PHPRunner General questions
C
 cyberslugg author

I have a database that has a table for Company names and contact info. Unfortunately, I am not able to add records now, I get this error message
php error happened

Technical information

Error type 256

Error description 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 '' at line 8

URL wwwww.ww/wwwww/www/wwwwwwwwww/Employer_add.php?ferror=1&fly=1&;

Error file /home/wwwwww/public_html/wwwww/wwwww/wwwwwwwwww/include/dbconnection.my.mysqli.php

Error line 63

SQL query SELECT Member.MemberID, Employment.MemberID, Employment.EmployerID, Employer.EmployerID, Member.FirstName, Member.LastName FROM Member, Employment, Employer WHERE Member.MemberID = Employment.MemberID AND Employment.EmployerID = Employer.EmployerID AND Employer.EmployerID =

More info
I have several sections with member names, and details... all are able to add new records with out problems. I have even made a second simple site that can look at and add new Company records and it works fine.
I just can not find the place that this sql error is happening.
Any thoughts were I can look would be a great help
Thanks
C
 		cyberslugg author 10/3/2014

Small added note, this is only happening on the add (inline or normal) process for this page... edit, both types, work fine.
Sergey Kornilov admin 10/4/2014

Looks like incorrect project configuration, something is missing at the end of that select statement:

AND Employer.EmployerID =


Check code in your events like BeforeAdd or AfterAdd that might produce this sort of error.
If you have a valid support contract post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.