|
Database error / Please Help me
|
| benvather |
Posted on 20-11-2011 00:46
|
Amateur
Posts: 5
Joined: 19-11-2011
PCM$: 200.00
|
Hi,
I cannot use lachi's planning manager or PCM editor because of an error (french message : An error occured - L'index0 est négatif ou superieur au nombre de lignes).
I think that something is wrong in my DB in attachment but I cannot find what.
For info, with the PCM editor, there is an error when I select the Teams tab...
Could you please check my DB in attachment?
Thanks in advance !!!!
|
| |
|
|
| Lachi |
Posted on 20-11-2011 15:10
|
Grand Tour Champion
Posts: 8360
Joined: 29-06-2007
PCM$: 200.00
|
Are you talking about my PCM season planner? If yes, are you sure that the error comes from the DB you have attached because I can load it without problems? If yes, are you sure that you are using the latest version of my planner?
Latest beta version could be found here: https://pcmdaily.c...d_id=19400 |
| |
|
|
| benvather |
Posted on 20-11-2011 15:44
|
Amateur
Posts: 5
Joined: 19-11-2011
PCM$: 200.00
|
Yes you can load it...but can you change something and export the result into cdb file ?
Thx for your help |
| |
|
|
| Lachi |
Posted on 20-11-2011 16:35
|
Grand Tour Champion
Posts: 8360
Joined: 29-06-2007
PCM$: 200.00
|
What did you change?
Did it work before, or is this the first time you are using my tool? |
| |
|
|
| benvather |
Posted on 20-11-2011 16:53
|
Amateur
Posts: 5
Joined: 19-11-2011
PCM$: 200.00
|
If I change nothing I can't export in cdb
If I change anything I can't export in cdb
-> The result is the same...
It was OK during my first season...and now I'm at the begining of the second (january)...and it does not function.
Did you try to modify something in my db and export the result? |
| |
|
|
| Ad Bot |
Posted on 13-12-2025 11:01
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| benvather |
Posted on 20-11-2011 17:25
|
Amateur
Posts: 5
Joined: 19-11-2011
PCM$: 200.00
|
I start a new planner selecting Europcar.cdb. Without any change I try to export in cdb and I have this error message :
I use the last version as you can see
Edited by benvather on 20-11-2011 17:27
|
| |
|
|
| Lachi |
Posted on 20-11-2011 21:53
|
Grand Tour Champion
Posts: 8360
Joined: 29-06-2007
PCM$: 200.00
|
I found the error but I really cannot help you because there is wrong data in your file.
The problem is the table DYN_team_race, in that table there are references to races which do not exist in the table STA_race. For example there is no race with the ID 295 but in DYN_team_race there are 12 lines with have that number in the column fkIDrace.
If you did something strange to your save, then undo it. Else you could delete the wrong links manually. But I will not do it. |
| |
|
|
| benvather |
Posted on 22-11-2011 00:11
|
Amateur
Posts: 5
Joined: 19-11-2011
PCM$: 200.00
|
Thanks a lot Lachi !!!!
I removed all wrong races from DYN_Team_Race.....and it works ! |
| |
|
