Bug #1484
Namespace columns are used to store URIs now but are only VARCHAR(255)
| Status: | Resolved | Start date: | 2008-09-09 | |
|---|---|---|---|---|
| Priority: | Should have | Due date: | ||
| Assigned To: | Matthias Hörmann | % Done: | 100% |
|
| Category: | - | |||
| Target version: | - |
Description
...but URIs can be up to 2048 characters according to most sources
Associated revisions
TYPO3CR: Implemented MySQL testing, vastly improved PostgreSQL testing and wrote install shell script.
- the SQL code contains key lengths for MySQL which are removed by all code that uses the SQL automatically if the database type is not mysql, fixes #1486
- namespace URIs are now stored in TEXT columns, fixes #1484
- MySQL gets it's ANSI_QUOTES option after connection setup in all places where connections are made
- install.sh allows fully automated setup of both production and test databases: MySQL, PostgreSQL, SQLite; calls fixpermissions.sh
- install.sh automatically calls web based database setup via lynx (could be wget if there are problems with the availability of lynx but lynx -dump gives more meaningful output)
- testdb.sh replaces the various db specific tools and is used by install.sh for testdb setup, also allows dumping and cleanup of test databases
- PHP code uses testdb.conf to read test database settings (all except sqlite currently)
- production and testing now use the same database schema file, multi-line statements are now supported by the storage helper too
Patch (mostly) by Matthias Hörmann.
History
#1 Updated by Matthias Hörmann almost 7 years ago
- Assigned To set to Matthias Hörmann
Resolved in patch sent to Karsten today
#2 Updated by Karsten Dambekalns almost 7 years ago
- Status changed from New to Resolved
- % Done changed from 0 to 100
Applied in changeset r1261.