PCM.daily banner
02-01-2025 15:16
PCM.daily
Users Online
· Guests Online: 51

· Members Online: 0

· Total Members: 162,354
· Newest Member: TW12
View Thread
PCM.daily » Pro Cycling Manager 2006-2020 » Pro Cycling Manager 2018
 Print Thread
Problem building my DB (Lachi's Excel Editor)
timpiej
Hi guys

I can extract .CDB files, I can open tables from them. But when I try to build and after I give it a name, it starts running over all tables and then the screen stopt (can't read what's at the finish, it goes quite fast). After that there is no DB anywhere to be found + I can no longer open the tables with the editor. This is twice now.

When I try to open a table from the failed DB I get the following error:
Error-2147217376 (80041020) during execution:
The object was not found.

With MS Excel I can still open them, but I can't build a DB with Excel so… Can somebody help me?
 
Lachi
It is important to give a simple file name, like "test.cdb" because the database builder tool from Cyanide does not like special characters or spaces.

When it starts running, this is the database builder tool from Cyanide, so I cannot give much support. But I know that it will crash when you alter the tables, like adding, deleting or moving columns. The tool also does not like rows with duplicated keys. Or missing keys in the fk columns. Wrong data types also make it crash, like if you enter a text where a number should be.

If you want to find the table which causes the problem, then try to build the database with only one table at a time. In my editor you can select the tables by putting an X in the first column. So remove the X from all tables but one and build it. If the DB can be built, add another X and build again until you find the culprit. But I cannot help you find the errors which could be in that table.
 
Ad Bot
Posted on 02-01-2025 15:16
Bot Agent

Posts: Countless
Joined: 23.11.09

IP: None  
timpiej
Wow, I had been looking so many times wether you had answered or not. and I never noticed you did. :lol:

I'll try it just now and let you know what I find
 
Jump to Forum:
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Latest content
Screenshots
Behind the Peloton
Behind the Peloton
PCM10: General Screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet fighti... 18,976 PCM$
bullet df_Trek 17,874 PCM$
bullet Marcovdw 15,945 PCM$
bullet jseadog1 14,052 PCM$
bullet baseba... 10,539 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet Ollfardh 22,090 PCM$
bullet df_Trek 16,020 PCM$
bullet Marcovdw 15,400 PCM$
bullet jseadog1 14,000 PCM$
bullet baseball... 7,432 PCM$

bullet Main MG Betting page
bullet Get weekly MG PCM$
bullet Rankings: Top 100
Render time: 2.37 seconds