I am having some problems with the new version of PHPRunner ver 6.1
1. Using lookup field
I've been trying to use a Custom Display field for lookup as per post http://www.asprunner.com/forums/topic/19106-custom-display-field/pagep64594fromsearch1&#entry64594
After trying the view a a lookup field I got errors and at first thought it was the setup of the view and that I had done something wrong. After trying a number of times I then tried to just use a simple lookup field to a table but still get the same error. I'm not sure if Im doing something really stupid but I can't get the lookup table to work.
The 2 tables involved are;
leadcontacts
SELECT
ID,
HContactID
FROM leadcontacts
hotel contacts
SELECT ID,
Company_ID,
Last Name,
First Name,
E-mail Address,
Job Title,
Business Phone,
Home Phone,
Mobile Phone,
Fax Number,
Notes,
Attachments,
Category
FROM hotel contacts
I am trying to lookup the [leadcontacts.HContactID]form the [hotel contacts.ID]
I keep getting the following error;
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 'Name' at line 3
URL 127.0.0.1/TimeoutBookings/output/leadcontacts_list.php?
Error file C:\USB-Server\root\TimeoutBookings\output\include\dbconnection.my.mysqli.php
Error line 42
SQL query SELECT ID, Company_ID, Last Name, First Name, E-mail Address, Job Title, Business Phone, Home Phone, Mobile Phone, Fax Number, Notes, 1 as runnerdummy12, Category FROM hotel contacts ORDER BY First Name
2. The second problem I'm having is I get the message Unable to process file:plugins/ckeditor
I have the ckeditor plugin loaded in the plugins directory and it was working fine with the previous version 6.0