Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Doku_LexerParallelRegex has a deprecated constructor in /var/www/vhosts/conlite.org/httpdocs/dev/tickets/plugins/dokuwiki/inc/parser/lexer.php on line 35 Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Doku_LexerStateStack has a deprecated constructor in /var/www/vhosts/conlite.org/httpdocs/dev/tickets/plugins/dokuwiki/inc/parser/lexer.php on line 229 Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Doku_Lexer has a deprecated constructor in /var/www/vhosts/conlite.org/httpdocs/dev/tickets/plugins/dokuwiki/inc/parser/lexer.php on line 285 Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Doku_Handler has a deprecated constructor in /var/www/vhosts/conlite.org/httpdocs/dev/tickets/plugins/dokuwiki/inc/parser/handler.php on line 4 Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Doku_Handler_CallWriter has a deprecated constructor in /var/www/vhosts/conlite.org/httpdocs/dev/tickets/plugins/dokuwiki/inc/parser/handler.php on line 699 Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Doku_Handler_Nest has a deprecated constructor in /var/www/vhosts/conlite.org/httpdocs/dev/tickets/plugins/dokuwiki/inc/parser/handler.php on line 728 Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Doku_Handler_List has a deprecated constructor in /var/www/vhosts/conlite.org/httpdocs/dev/tickets/plugins/dokuwiki/inc/parser/handler.php on line 770 Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Doku_Handler_Preformatted has a deprecated constructor in /var/www/vhosts/conlite.org/httpdocs/dev/tickets/plugins/dokuwiki/inc/parser/handler.php on line 963 Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Doku_Handler_Quote has a deprecated constructor in /var/www/vhosts/conlite.org/httpdocs/dev/tickets/plugins/dokuwiki/inc/parser/handler.php on line 1017 Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Doku_Handler_Table has a deprecated constructor in /var/www/vhosts/conlite.org/httpdocs/dev/tickets/plugins/dokuwiki/inc/parser/handler.php on line 1109 Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Doku_Handler_Block has a deprecated constructor in /var/www/vhosts/conlite.org/httpdocs/dev/tickets/plugins/dokuwiki/inc/parser/handler.php on line 1386 FS#141 : SQL-Error: Data truncated for column 'visited'

ConLite

  • Status Assigned
  • Percent Complete
    0%
  • Task Type Bug Report
  • Category Core
  • Assigned To
    Ortwin Pinke
  • Operating System All
  • Severity Medium
  • Priority High
  • Reported Version ConLite 2.0 RC
  • Due in Version ConLite 2.0.0
  • Due Date Undecided
  • Votes 1
  • Private
Attached to Project: ConLite
Opened by Ortwin Pinke - 05.05.2015

FS#141 - SQL-Error: Data truncated for column 'visited'

Got the following error while testing ConLite with PHP 5.6 and MySQL 5.5.5 

[05-May-2015 11:58:20 UTC]  error: 1265 (Data truncated for column 'visited' at row 1) - info: /ConLite/conlite/main.php?area=client&frame=1&contenido=cef3c97414c53bf7fe3f292d2cdac331 INSERT INTO
                          cl_stat
                          ( idstat, idcatart, idlang, idclient, visited )
                      VALUES (
                          24,
                          23,
                          1,
                          1,
                          '0000-00-00 00:00:00')

Error based on wrong field value in cl db for field visited (varchar(14)).
Change field type to datetime, write api class for db-table and change all calls to use the api class.

Deprecated: Function create_function() is deprecated in /var/www/vhosts/conlite.org/httpdocs/dev/tickets/includes/class.user.php on line 115
Frank commented on 19.09.2015 17:31

Das scheint an einer strikten Einstellung in MySQL 5 zu liegen.
http://www.elitepvpers.com/forum/metin2-pserver-guides-strategies/3497779-how-fix-error-1265-data-truncated-column-row.html Passiert zum Beispiel, wenn '' und Null verwechselt werden.
http://stackoverflow.com/questions/1704304/what-is-this-error-database-query-failed-data-truncated-for-column-column-na

Es wird hier so sein, dass die Spalte ´visited´ gar nicht für '0000-00-00 00:00:00' ausgelegt ist.
varchar(14) hat eine Länge von 14 Zeichen aber '0000-00-00 00:00:00' hat 19 Zeichen.
Hier wäre statt einer Charakter Spaltendefinition ein Timestamp oder Datetime besser.
Dadurch kann MySQL auch richtig mit Datum rechnen (das geht besser als in PHP).

Deprecated: Function create_function() is deprecated in /var/www/vhosts/conlite.org/httpdocs/dev/tickets/includes/class.user.php on line 115 Project Manager
Ortwin Pinke commented on 20.09.2015 09:03

Servus Frank,

generell muss da noch viel Optimierung an der DB-Struktur betrieben werden. Grundsätzlich müssen all diese Felder, in denen ein Datum mit dieser Formatierung steht, in DateTime gewandelt werden. Nichts anderes steht aber auch bereits im 1. Posting dieses Eintrages.

"Error based on wrong field value in cl db for field visited (varchar(14)).
Change field type to datetime, write api class for db-table and change all calls to use the api class."

Loading...

Available keyboard shortcuts

Tasklist

Task Details

Task Editing