Loading...
 
Skip to main content

1.9to1.10 sql from cvs (August 1st 2007) still produces "too long key/column length" errors

  • Tracker item actions
Trackers
Items
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
(0)
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 on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
1271
Created
Wednesday 01 August, 2007 09:58:59 UTC
by Unknown
LastModif
Wednesday 31 March, 2010 09:04:50 UTC


Show PHP error messages