MantisBT - ATutor
View Issue Details
0005193ATutor- no cat -public2013-02-12 11:152013-02-20 11:14
anovak 
anovak 
highmajoralways
closedfixed 
2.1 
2.1.12.1.1 
SVN
https://github.com/atutor/ATutor/pull/43 [^]
0005193: SQL language_pages table inconsistencies
term column is VARCHAR(30) in language_pages
term column is VARCHAR(50) in language_text

This difference breaks page caching as well as generates lots of faulty INSERT statements for language_pages table in _AT() function.
Also this should create lots of troubles for translators who want to translate existing terms.

page column is VARCHAR(50) in language_pages
Since some of the ATutor page addresses are longer than 50 characters it breaks page caching. Also this should create lots of troubles for translators who want to translate existing terms.

SOLUTION:
Both term columns should have the same length in both tables.
page column should be big enough to accomodate different variation of ATutor page addresses.
No tags attached.
Issue History
2013-02-12 11:15anovakNew Issue
2013-02-12 11:16anovakSummarySQL table inconsistencies => SQL language_pages table inconsistencies
2013-02-12 14:04anovakSVN Revision# => https://github.com/atutor/ATutor/pull/43 [^]
2013-02-12 14:04anovakAssigned To => anovak
2013-02-12 14:04anovakStatusnew => assigned
2013-02-12 14:04anovakFixed in Version => 2.1.1
2013-02-12 14:04anovakStatusassigned => resolved
2013-02-12 14:04anovakResolutionopen => fixed
2013-02-20 11:14gregNote Added: 0006083
2013-02-20 11:14gregStatusresolved => closed

Notes
(0006083)
greg   
2013-02-20 11:14   
resolved in 2.1.1