nuBuilder Forum

Posted: **Wed Jun 01, 2022 4:49 pm**

Just a heads up I tried to create a fast report from a table with a little bit longer name "Current_Days_Recurring_Billing". The sre_zzzzsys_php_id column in the zzzzsys_report table is varchar(25) and will not fit TABLE:Current_Days_Recurring_Billing but it states that it created the fast report in the standard big yellow box. The report is of course nowhere to be found. Looking at the Debug log error it shows the column was too long and the insert query failed. I managed to get around it by renaming my table to "CurDaysRecBilling".

Posted: **Thu Jun 02, 2022 3:54 am**

Hi,

Thank you for pointing this out. You may want to change the column length to varchar(200).

Code: Select all

ALTER TABLE `zzzzsys_report` CHANGE `sre_zzzzsys_php_id` `sre_zzzzsys_php_id` VARCHAR(200) NULL DEFAULT NULL;

(This will also be changed in a future Github commit)

Posted: **Mon Jul 18, 2022 8:54 pm**

I hope that helps.

Posted: **Mon Jul 18, 2022 8:58 pm**

Sorry I thought I had marked that as solved previously

nuBuilder Forum

sre_zzzzsys_php_id column length

sre_zzzzsys_php_id column length

Re: sre_zzzzsys_php_id column length

Re: sre_zzzzsys_php_id column length

Re: sre_zzzzsys_php_id column length