MySQL Error 4.9.1

[Guenter]

Hello Flynax team,

I created some items in Data Entries, then I wanted to add a new Profile Field and tried to connect it to the Data Entries as a dropdown. After them I got MYSQL ERROR.

In the second attempt I tried not to connect the dropdown field with Data Entries and used 'Add an Option' but again I got a MYSQL ERROR!

In the third attempt I go to includes > classes > admin > rlFields.class.php

and ghanges:



VARCHAR({$info['Values']}) to TEXT({$info['Values']})
VARCHAR({$new_length}) to TEXT({$new_length})
VARCHAR( 100 ) to TEXT( 100 )


and and got again an ERROR with NO CONNECTION to database!

What else can I do to eliminate the error?

[Viktor]

How many fields did you add earlier? In mysql database there is a limit on the number of text fields in 1 table. Or maybe it is another error :)
I suggest you create a new ticket with the problem.

[Guenter]

At the moment I have in 'Profile fields' 20 of type TEXT fields, and 5 TEXTAREA.

Is it possible to increase the limit in MySQL table?
Or was the changed PHP code wrong?

[Guenter]

Hello Viktor,

what can I do? I need these fields but nothing works!!! :(