Project

General

Profile

Bug #1347

Migration to PostgreSQL fails because of too long channel messages inside buffer table

Added by michiwend over 4 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Quassel Core
Target version:
Start date:
04/28/2015
Due date:
% Done:

0%

Estimated time:
Version:
0.10.0
OS:
Linux

Description

buffername and buffercname are of type varying(128). I suggest using varying(512)

WriterError:                                                                                                                                                                                                                     
  executed Query:                                                                                                                                                                                                                
INSERT INTO buffer (bufferid, userid, groupid, networkid, buffername, buffercname, buffertype, lastseenmsgid, markerlinemsgid, key, joined)                                                                                      
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)                                                                                                                                                                                         
  bound Values:                                                                                                                                                                                                                  
0 :  275                                                                                                                                                                                                                         
1 :  1                                                                                                                                                                                                                           
2 :  0                                                                                                                                                                                                                           
3 :  1                                                                                                                                                                                                                           
4 :  Willkommen in #augsburg | EH15: https://eh15.easterhegg.eu/site/2015/01/aufruf-zur-mitgestaltung | https://openlab-augsburg.de/veranstaltungen/ | https://www.c3a.de/ | http://augsburg.freifunk.net/ | helden:[xxxxxx,xxxxx];
5 :  willkommen in #augsburg | eh15: https://eh15.easterhegg.eu/site/2015/01/aufruf-zur-mitgestaltung | https://openlab-augsburg.de/veranstaltungen/ | https://www.c3a.de/ | http://augsburg.freifunk.net/ | helden:[xxxxxx,xxxxx];
6 :  4                                                                                                                                                                                                                           
7 :  3794584                                                                                                                                                                                                                     
8 :  3794584                                                                                                                                                                                                                     
9 :                                                                                                                                                                                                                              
10 :  false                                                                                                                                                                                                                      
  Error Number: -1                                                                                                                                                                                                               
  Error Message: "ERROR:  value too long for type character varying(128)                                                                                                                                                         
(22001) QPSQL: Unable to create query"                                            

Also available in: Atom PDF