Opened 6 years ago

Closed 5 years ago

#10618 closed defect (fixed)

Error with MySQL and TRAC 0.12.4

Reported by: martin.fernholz@… Owned by: branson
Priority: normal Component: DirectoryAuthPlugin
Severity: blocker Keywords:
Cc: Trac Release: 0.12


I installed TracDirectoryAuth 0.5 with TRAC 0.12.4, MySQL 5.1.63 and AccountManager 0.3.2. After I activate the TracDirectoryAuth Plugin

tracext.adauth.api.userextensiblepermissionstore = enabled
tracext.adauth.auth.adauthstore = enabled
tracext.adauth.db.activedirectoryauthpluginsetup = enabled

and edit the trac.ini as at the projectpage shown I try to upgrade my project environment. Here I get this error message:

ProgrammingError: (1064, "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 'varcahar(32),\n    `lut` int,\n    `data` binary,\n    PRIMARY KEY (`id`)\n)' at line 2")

Any idea what's wrong?

Attachments (0)

Change History (7)

comment:1 Changed 6 years ago by anonymous

I thinks it's invalid column type "varcahar". Fixed it and schema upgrade went smoothly.

comment:2 Changed 6 years ago by martin.fernholz@…

Resolution: fixed
Status: newclosed

Thx to "anonymous" for the silly hint. The error is in the file in line 23. I tryed to update the source but I haven't a login for svn.

@sandinak: Please fix it.

Problem is fixed for me.

comment:3 in reply to:  2 Changed 5 years ago by Ryan J Ollos

Replying to

@sandinak: Please fix it. Problem is fixed for me.

It is more likely to get fixed if you leave the ticket open until the issue is actually resolved in the codebase.

comment:4 Changed 5 years ago by Ryan J Ollos

(In [12776]) Refs #10618: Fixed typo in database schema.

comment:5 Changed 5 years ago by Ryan J Ollos

Resolution: fixed
Status: closedreopened

[12776] was reverted by the plugin author in [12971] and [12972], so the issue persists following r12972.

comment:6 Changed 5 years ago by anonymous

This issue also reported in postgresql DB back end(Testing on trac 1.0 )

Run "trac-admin /opt/trac upgrade"

trac@trac:/etc/apache2/sites-enabled$ trac-admin /opt/trac upgrade
Error: Error reading '/opt/trac/conf/trac.ini', make sure it is readable.
trac@trac:/etc/apache2/sites-enabled$ sudo trac-admin /opt/trac upgrade
The upgrade failed. Please fix the issue and try again.

ProgrammingError: type "varcahar" does not exist
LINE 2:     "id" varcahar(32) PRIMARY KEY,

comment:7 Changed 5 years ago by Ryan J Ollos

Resolution: fixed
Status: reopenedclosed

(In [13074]) Fixes #10618: Fixed typo into DB schema. This had previously been fixed in [12776], but the change was reverted by the plugin author for unknown reason.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain branson.
The resolution will be deleted.

Add Comment

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

Note: See TracTickets for help on using tickets.