Page 1 of 1

Table content dissapears when adding new Lookup field

Posted: 2020-08-15 02:48
by mdspine
Hi
I have a table called Billing which works fine
I add a new look-up field on the desktop by modifying the .axp file, make a new folder and upload the folder to the server
I notice that the Billing table on the server goes blank. I cannot see any fields,
I have looked in PHP my admin and I can see the intact table and fields
Any advise would help
Thanks
Sam

Re: Table content dissapears when adding new Lookup field

Posted: 2020-08-15 08:52
by pbottcher
Hi,

can you try to recreate your fields through the admin area

Re: Table content dissapears when adding new Lookup field

Posted: 2020-08-15 13:14
by mdspine
First of all thank you for even replyinig
I am struggling with this for past few days
I went to admin in rebuild fields

No deviations found. All fields OK!

Re: Table content dissapears when adding new Lookup field

Posted: 2020-08-15 19:10
by mdspine
Found the answer
MySQL has a limit of 60 tables as a lookup
The moment it hits 61 lookuptables it shuts down
Thanks

Re: Table content dissapears when adding new Lookup field

Posted: 2020-08-15 19:11
by mdspine
Found the answer
MySQL has a limit of 60 tables as a lookup
The moment it hits 61 lookupfields it shuts down
Thanks