Edgewall Software
Modify

Ticket #6554 (closed defect: worksforme)

Opened 4 years ago

Last modified 13 months ago

trac-admin allows to init environment with mysql errors

Reported by: techtonik@… Owned by: cmlenz
Priority: normal Milestone:
Component: admin/console Version: 0.11b1
Severity: major Keywords: mysql
Cc: thijstriemstra
Release Notes:
API Changes:

Description

When using MySQL backend with the wrong collation the following warning are produced and it's likely that DB is created wrong. But Trac doesn't stop or bring attention to the warning. It should fail with a hint to convert MySQL table to UTF-8 collation as described in MySqlDb.

Creating and Initializing Project
 Installing default wiki pages
 /home/t/lib/python2.3/site-packages/Trac-0.11b1-py2.3.egg/trac/wiki/default-pages/TracBackup imported from TracBackup
/home/t/lib/python2.3/site-packages/Trac-0.11b1-py2.3.egg/trac/db/util.py:50: Warning: Data truncated for column 'text' at row 1
  return self.cursor.execute(sql_escape_percent(sql), args)
 /home/t/lib/python2.3/site-packages/Trac-0.11b1-py2.3.egg/trac/wiki/default-pages/TracInstall imported from TracInstall
...
 /home/t/lib/python2.3/site-packages/Trac-0.11b1-py2.3.egg/trac/wiki/default-pages/TracIni imported from TracIni
/home/t/lib/python2.3/site-packages/Trac-0.11b1-py2.3.egg/trac/db/util.py:50: Warning: Data truncated for column 'text' at row 0
  return self.cursor.execute(sql_escape_percent(sql), args)
 /home/t/lib/python2.3/site-packages/Trac-0.11b1-py2.3.egg/trac/wiki/default-pages/TracFastCgi imported from TracFastCgi
...
 Indexing repository
/home/t/lib/python2.3/site-packages/Trac-0.11b1-py2.3.egg/trac/db/util.py:50: Warning: Data truncated for column 'message' at row 1
  return self.cursor.execute(sql_escape_percent(sql), args)
 [1406]

Attachments

Change History

comment:1 Changed 4 years ago by eblot

  • Keywords mysql added

comment:2 Changed 3 years ago by rblank

  • Milestone set to 1.0

comment:3 Changed 22 months ago by cboos

  • Milestone changed from 1.0 to unscheduled

Milestone 1.0 deleted

comment:4 Changed 13 months ago by thijstriemstra

  • Cc thijstriemstra added
  • Severity changed from normal to major
  • Summary changed from trac-admin allows to init environment with errors to trac-admin allows to init environment with mysql errors

comment:5 Changed 13 months ago by thijstriemstra

Also see #8089

comment:6 Changed 13 months ago by thijstriemstra

  • Milestone unscheduled deleted
  • Resolution set to worksforme
  • Status changed from new to closed

Not able to reproduce this with 0.13 trunk, marking it as worksforme.

View

Add a comment

Modify Ticket

Change Properties
<Author field>
Action
as closed
The resolution will be deleted. Next status will be 'reopened'
to The owner will be changed from cmlenz. Next status will be 'closed'
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.