I am adding more languages to my #!Language database. However, when I reach 65th entry and click Save - I get a Database Query Error.
In MySQL I have changed ENUM to VARCHAR but that did not resolve the problem. #!Country,for example has a lot more entries and has VARCHAR set in MySQL and it works fine, so I do not understand why the error gives me: Too many strings for column Languages and SET. This is whatI get in me email:
Query:
ALTER TABLE `Profiles` CHANGE `Languages` `Languages` set('10', '20', '30', '40', '50', '60', '70', '80', '90', '100', '110', '120', '130', '140', '150', '160', '170', '180', '190', '200', '210', '220', '230', '240', '250', '260', '270', '280', '290', '300', '310', '320', '330', '340', '350', '360', '370', '380', '390', '400', '410', '420', '430', '440', '450', '460', '470', '480', '490', '500', '510', '520', '530', '540', '550', '560', '570', '580', '590', '600', '610', '620', '630', '640', '650') NOT NULL default ''
Mysql error: Too many strings for column Languages and SET
Found error in the file '/home/www/s2723/public_html/xxxxxxx.com/administration/preValues.php' at line 364.
Called 'db_res' function with erroneous argument #0.
Please help me to resolve the issue. I need to add at least another 20 languages.