Table content dissapears when adding new Lookup field

Please report bugs and any annoyances here. Kindly include all possible details: steps to reproduce, expected result, actual result, screenshots, ... etc.
Post Reply
mdspine
Veteran Member
Posts: 34
Joined: 2020-06-06 12:38

Table content dissapears when adding new Lookup field

Post by mdspine » 2020-08-15 02:48

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

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: Table content dissapears when adding new Lookup field

Post by pbottcher » 2020-08-15 08:52

Hi,

can you try to recreate your fields through the admin area
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

mdspine
Veteran Member
Posts: 34
Joined: 2020-06-06 12:38

Re: Table content dissapears when adding new Lookup field

Post by mdspine » 2020-08-15 13:14

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!

mdspine
Veteran Member
Posts: 34
Joined: 2020-06-06 12:38

Re: Table content dissapears when adding new Lookup field

Post by mdspine » 2020-08-15 19:10

Found the answer
MySQL has a limit of 60 tables as a lookup
The moment it hits 61 lookuptables it shuts down
Thanks

mdspine
Veteran Member
Posts: 34
Joined: 2020-06-06 12:38

Re: Table content dissapears when adding new Lookup field

Post by mdspine » 2020-08-15 19:11

Found the answer
MySQL has a limit of 60 tables as a lookup
The moment it hits 61 lookupfields it shuts down
Thanks

Post Reply