sre_zzzzsys_php_id column length Topic is solved

[chpwebmaster]

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".

[kev1n]

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)

[kev1n]

I hope that helps.

[chpwebmaster]

Sorry I thought I had marked that as solved previously