Modify ↓
#6777 closed defect (wontfix)
Trac Updating error! (MySQL)
| Reported by: | anonymous | Owned by: | Jonas Borgström |
|---|---|---|---|
| Priority: | normal | Milestone: | |
| Component: | general | Version: | |
| Severity: | normal | Keywords: | plugin |
| Cc: | Branch: | ||
| Release Notes: | |||
| API Changes: | |||
| Internal Changes: | |||
Description (last modified by )
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 (0)
Change History (2)
follow-up: 2 comment:1 by , 18 years ago
| Description: | modified (diff) |
|---|---|
| Keywords: | plugin added |
| Priority: | highest → normal |
| Resolution: | → wontfix |
| Status: | new → closed |
comment:2 by , 18 years ago
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.