title: python json database corrupted
body: <p>I got a bug in a huge database with thousand of lines, so i tried to remove thousands of them (obviously got a backup file) to lock out the problem and i end up with a problem. I'll provide a working without problem list in the database in case you want to compare:</p>
  
  <pre><code>#Working
  ["#saelyth", 8, 40, 4, "000", "000", "0", 11, "!Bot, me lees?", "legionanimenet", 0, "primermensajitodeesapersona"]
  
  #Not working
  ["!anon7002", 545, 3166, 7, "000", "000", "0", 13, "\u2014\u00a1 Hijo! Estas calificaciones merecen una golpiza. \u2014\u00bf Verdad que si mam ...Vamos que yo se donde vive la maestra.", "legionanimenet", 0, "primermensajitodeesapersona"]
  </code></pre>
  
  <p>Causing this error:</p>
  
  <pre><code>ValueError: Extra data: line 1 column 240 - line 2 column 1 (char 239 - 366)
  </code></pre>
  
  <p>My question is: what is wrong there? i have no idea and all efforts to find what is the problem for json to give me such error are unsuccessful.</p>
  
  <p>So i completely deleted that line and try to load the full database without that line but i also get now a new error:</p>
  
  <pre><code>ValueError: Expecting ',' delimiter: line 1 column 62 (char 61)
  </code></pre>
  
  <p>With so maaany and maaany and maaany records like:</p>
  
  <pre><code>["tyjyu", 59, 302, 19, "000", "000", "0", 13, "holas", "legionanimenet", 0, "primermensajitodeesapersona"]
  ["inuyacha64", 15944, 79401, 3496, "000", "F00", "0", 16, "cuidence chau", "legionanimenet", 2, "primermensajitodeesapersona"]
  ["!anon3573", 24, 140, "1", "nada", "nada", "nada", "nada", "nada", "legionanimenet", 0, "primermensajitodeesapersona"]
  ["eldiaoscuro", 74, 446, 16, "603", "369", "4", 13, "nada", "legionanimenet", 0, "primermensajitodeesapersona"]
  </code></pre>
  
  <p>What would be an efficient way to FIND the missing , giving me that error? And if possible i'd like to know also if json got a maximum number of items to load or something like that.</p>
  
  <p><strong>EDIT</strong>
  The code to load info is:</p>
  
  <pre><code>  data = []
    with open('listas\Estadisticas.txt', 'r+') as f:
      for line in f:
        data_line = json.loads(line)
        if data_line[0] == user.name and data_line[9] == "legionanimenet": 
          data_line[1] = int(data_line[1])+int(palabrasdelafrase)
          data_line[2] = int(data_line[2])+int(letrasdelafrase)
          data_line[3] = int(data_line[3])+1
          data_line[4] = user.nameColor
          data_line[5] = user.fontColor
          data_line[6] = user.fontFace
          data_line[7] = user.fontSize
          data_line[11] = data_line[8]
          data_line[8] = message.body
          data_line[9] = "legionanimenet"
        data.append(data_line)
      f.seek(0)
      f.writelines(["%s\n" % json.dumps(i) for i in data])
      f.truncate()
  </code></pre>
  
  <p>I hope anyone can help me on that.</p>
  
  <p><strong>EDIT2:</strong> Python version is 3.3.2 IDLE</p>