Forum

Results 1 to 4 of 4
  1. #1
    Join Date
    January 2009
    Location
    Moscow
    Posts
    29

    Data too long for column 'ban_name' at row 1

    I have tried to ban Russian letters and tried to insert the code (Russian alphabet)

    Code:
    .*[АаБбВвГгДдЕеЕеЖжЗзИиЙйКкЛлМмНнОоПпРрСсТтУуФфХхЦцЧчШшЩщЪъЫыЬьЭэЮюЯя].*
    The client gave an error
    Code:
    <19:59:49> database error
    In logs
    Code:
    2011-04-01 16:00:07.512606 | ERROR | DatabaseQuery | | db_exec () INSERT INTO bans (server_id, ban_ip, ban_name, ban_uid, ban_timestamp, error: Data too long for column 'ban_name' at row 1
    Solution: Change varchar (255) to varchar (8192)
    Maybe in the future you will fix that in the new release.

  2. #2
    Join Date
    June 2002
    Location
    Krün / Germany
    Posts
    1,638
    you are using mysql ?

    changed it to 2048... should be enough. if not you need to split it up into two bans.

  3. #3
    Join Date
    January 2009
    Location
    Moscow
    Posts
    29
    Quote Originally Posted by R. Ludwig View Post
    you are using mysql ?

    changed it to 2048... should be enough. if not you need to split it up into two bans.
    Yes, I use mysql.

    I've changed it to varchar (8192) and it worked.

  4. #4
    Join Date
    March 2014
    Posts
    2

    Still Having the Same problem

    Quote Originally Posted by KrabKley View Post
    Yes, I use mysql.

    I've changed it to varchar (8192) and it worked.
    I followed your messages to fix it, but istill with the problem, I change with text type, does not work, change with long text , the system is running... does not stop. I check that my code is working on windows correctly , but have changed with a mac book pro pc, does not get the solution of this. pl

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [Not possible] Banlist MYSQL does not work "ban_name"
    By szpakuziom in forum General Questions
    Replies: 1
    Last Post: September 21st, 2014, 12:34 PM
  2. Replies: 1
    Last Post: April 14th, 2013, 06:51 PM
  3. [Resolved] Data too long for column value at row
    By KrabKley in forum Bug Reports [EN/DE]
    Replies: 10
    Last Post: April 28th, 2011, 10:12 PM
  4. Bookmarks Column size
    By florian_fr40 in forum Suggestions and Feedback
    Replies: 2
    Last Post: March 4th, 2011, 02:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •