Hi Folks:
I am trying to use the web report functionality in PHPRunner 7.1. There is some kind of bug though that is causing PHPRunner to give long aliases to my field/table names which results in an Oracle error.
The error occurs regardless of which tables I chose for the left/right side. The screen I am talking about is this one:

I found someone with what seemed like the same issue from 2012 (2012 Post). I tried unchecking the count box in the tables relations section of PHPRunner but that didn't fix anything.
Any other ideas?
Matthew
Below is the error message:
php error happened

Technical information

Error type 2

Error description ociexecute(): ORA-00972: identifier is too long

URL testing/dreport.php?rname=FARMING_FARM_BALES_HARVESTED_5&param=preview&ie=UTF-8&iframe

Error file D:\Web\include\dbconnection.php

Error line 28

SQL query SELECT "FARMING"."FARM_BALERS_BALES"."BALER" as "FARMING_FARM_BALERS_BALES_BALER", "FARMING"."FARM_BALERS_BALES"."NUMBER_BALES" as "FARMING_FARM_BALERS_BALES_NUMBER_BALES", "FARMING"."FARM_BALERS_BALES"."BALE_RCD" as "FARMING_FARM_BALERS_BALES_BALE_RCD", "FARMING"."FARM_BALERS_BALES"."BALES_ID" as "FARMING_FARM_BALERS_BALES_BALES_ID", "FARMING"."FARM_LK_BALERS"."BALER" as "FARMING_FARM_LK_BALERS_BALER", "FARMING"."FARM_LK_BALERS"."MAKE" as "FARMING_FARM_LK_BALERS_MAKE", "FARMING"."FARM_LK_BALERS"."YEAR_PURCHASED" as "FARMING_FARM_LK_BALERS_YEAR_PURCHASED", "FARMING"."FARM_LK_BALERS"."SERIAL_NUMBER" as "FARMING_FARM_LK_BALERS_SERIAL_NUMBER" FROM "FARMING"."FARM_BALERS_BALES" INNER JOIN "FARMING"."FARM_LK_BALERS" ON "FARMING"."FARM_BALERS_BALES"."BALER"="FARMING"."FARM_LK_BALERS"."BALER" ORDER BY "FARMING"."FARM_BALERS_BALES"."BALER" ASC
More info
Call stack

File: line Function Arguments

0. include\dbconnection.php:28 runner_error_handler 1. 2;

2. ociexecute(): ORA-00972: identifier is too long;
   
3. D:\Web\include\dbconnection.php;
   
4. 28;
   
5. Array ( [qstring] => SELECT "FARMING"."FARM_BALERS_BALES"."BALER" as "FARMING_FARM_BALERS_BALES_BALER", "FARMING"."FARM_BALERS_BALES"."NUMBER_BALES" as "FARMING_FARM_BALERS_BALES_NUMBER_BALES", ...;
   

   1. (null):0 ociexecute 1. Resource id #50;
   

   2. include\dbconnection.php:28 db_query 1. SELECT "FARMING"."FARM_BALERS_BALES"."BALER" as "FARMING_FARM_BALERS_BALES_BALER", "FARMING"."FARM_BALERS_BALES"."NUMBER_BALES" as "FARMING_FARM_BALERS_BALES_NUMBER_BALES", "FARMING"."FARM_BALERS_BA...;
   

   
   
6. Resource id #13;
   

   3. dreport.php:702 Global scope N/A