Modify ↓
Ticket #6777 (closed defect: wontfix)
Opened 4 years ago
Last modified 4 years ago
Trac Updating error! (MySQL)
| Reported by: | anonymous | Owned by: | jonas |
|---|---|---|---|
| Priority: | normal | Milestone: | |
| Component: | general | Version: | |
| Severity: | normal | Keywords: | plugin |
| Cc: | |||
| Release Notes: | |||
| API Changes: | |||
Description (last modified by eblot) (diff)
Error creating function ISNUMERIC: (1064, "You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right sy
ntax to use near ') RETURNS boolean AS '\nSELECT $1 ~ ''^[0-9]+$''\n' LANGUAGE '
sql'' at line 1"). Continue
Traceback (most recent call last):
File "C:\Programme\Python24\Scripts\trac-admin.py", line 22, in ?
sys.exit(run(sys.argv[1:]))
File "C:\Programme\Python24\Lib\site-packages\trac\scripts\admin.py", line 122
9, in run
return admin.onecmd(command)
File "C:\Programme\Python24\Lib\site-packages\trac\scripts\admin.py", line 96,
in onecmd
rv = cmd.Cmd.onecmd(self, line) or 0
File "C:\Programme\Python24\lib\cmd.py", line 219, in onecmd
return func(arg)
File "C:\Programme\Python24\Lib\site-packages\trac\scripts\admin.py", line 114
2, in do_upgrade
self.__env.upgrade(backup=do_backup)
File "C:\Programme\Python24\Lib\site-packages\trac\env.py", line 371, in upgra
de
participant.upgrade_environment(db)
File "build/bdist.linux-x86_64/egg/backlog/init.py", line 47, in upgrade_envir
onment
File "build/bdist.linux-x86_64/egg/backlog/db/db1.py", line 51, in do_upgrade
File "build/bdist.linux-x86_64/egg/backlog/db/db1.py", line 212, in _create_vi
ew
Error creating view story_rd: (1064, "You have an error in your SQL syntax; chec
k the manual that corresponds to your MySQL server version for the right syntax
to use near 'ISNULL OR NOT ISNUMERIC(rd.value)) THEN 0 ELSE CAST (rd.value as in
teger) END) a' at line 2")
I always get this error! I Dont know whats wrong. I was trying to install agilo for scrum.
Attachments
Change History
comment:1 follow-up: ↓ 2 Changed 4 years ago by eblot
- Description modified (diff)
- Keywords plugin added
- Priority changed from highest to normal
- Resolution set to wontfix
- Status changed from new to closed
comment:2 in reply to: ↑ 1 Changed 4 years ago by anonymous
Replying to eblot:
The error seems to come from a plugin ("backlog").
Please contact the plugin maintainer. Maybe the plugin does not work properly with MySQL.
Please always report the version of Trac you're using when you submit a bug report.
The problem has been solved :-) You can download Agilo for Scrum 0.6 from agile42 website.
Note: See
TracTickets for help on using
tickets.



The error seems to come from a plugin ("backlog").
Please contact the plugin maintainer. Maybe the plugin does not work properly with MySQL.
Please always report the version of Trac you're using when you submit a bug report.