1.9to1.10 sql from cvs (August 1st 2007) still produces "too long key/column length" errors
- Status
- Closed
- Subject
- 1.9to1.10 sql from cvs (August 1st 2007) still produces "too long key/column length" errors
- Version
- 2.x
- Category
- Usability
- Feature
- Installer (profiles, upgrades and server-related issues)
- Resolution status
- Fixed or Solved
- Submitted by
- Xavier de Pedro
- Lastmod by
- Xavier de Pedro
- Rating
- Description
Upgrading a previous 1.10 site with current cvs code (from August 1st, 2007) I get, while using
tiki_1.9to1.10.sql with -f param from command line:(...)
ERROR 1071 at line 561: Specified key was too long. Max key length is 500
ERROR 1071 at line 585: Specified key was too long. Max key length is 500
(...)
ERROR 1074 at line 620: Too big column length for column 'value' (max = 255). Use BLOB instead
ERROR 1074 at line 627: Too big column length for column 'fieldname' (max = 255). Use BLOB instead
(...)
Plus some:Copy to clipboard(...) ERROR 1064 at line 497: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'user(100),serverId,groupName(100))' at line 1 ERROR 1064 at line 500: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'user(150),pageName(100))' at line 1 ERROR 1064 at line 506: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'user(100),id(100))' at line 1 ERROR 1064 at line 509: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'user(100),event,object(50))' at line 1 ERROR 1064 at line 513: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'user(120),friend(120))' at line 1 (...) ERROR 1064 at line 597: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'user(120))' at line 1 (...) ERROR 1064 at line 638: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `fieldId` FROM `tiki_webmail_contacts_fields` WHERE `fie (...)
Sylvieg, if you review this, you can see it your own at ourproject.org server, uniwiki project, updating uniwiki2 database (the one for http://uniwiki.ourproject.org ).- Solution
Sylvieg: I suppose it is a mysql4?
Xavi: Yes, Mysql 4.0.24 (at http://ourproject.org )620,627 fixed
561,585 will dissapear when the script is run a second time
497 and folowing - I can not reproduce
sylvie- Importance
- 5
- Priority
- 25
- Demonstrate Bug (Tiki 19+)
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Version: Create show2.tiki.org instanceAbout show2.tiki.orgTo help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tiki.org.
- Ticket ID
- 1271
- Created
- Wednesday 01 August, 2007 09:58:59 GMT-0000
by Unknown - LastModif
- Wednesday 31 March, 2010 09:04:50 GMT-0000
Attachments
| filename | created | hits | comment | version | filetype | ||
|---|---|---|---|---|---|---|---|
| No attachments for this item | |||||||
;){kind=link}
;){kind=link}
- htaccess.sh is gone from Tiki26 and after the installation you may need to create the symlink manually
- Create new Group function does not work Tiki V26.0 Clean install brand new database
- Manticore install and configuration
- Wiki plugin User list show all the user, the parameter Max of rows is not applied
- Automatic Indexing of Mathematical Calculation Tracker Fields
;){kind=link}
;){kind=link}