What is the database structure required by ndcms? When I try to run it for the first time it dies with an exception saying that it can't find the tblPAGES table. Is there an sql script that will generate the required NDCMS database and tables or is there documentation listing the table structure. I should mention that I'm using an SQL database and I'm running v0.4rc1 or ndcms.
Thanks
By the way, ndcms looks like an amazing project, hope I can get it up and running.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Wrecker33, I am having the same problem...it seems that we are missing the SQL scripts...if you try to run it using the MSSAccess version everything works fine of course you don't want to do this in production.
Try exporting the *.mdb in common/db to SQL Server that should work
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Wrecke33, I just did. I use SQL Server Import from access to my SQL Server database and boom I was able to run the site using SQL Server...One minor issue...you need to Allow Nulls in the indx coulmn of table tblLOG.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I figured this out a while ago as well :) After importing all the data into SQL2000 I had to manually convert each index column into an identity column. Once I'd done this it worked great. Other than that, I haven't had any problems.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
What is the database structure required by ndcms? When I try to run it for the first time it dies with an exception saying that it can't find the tblPAGES table. Is there an sql script that will generate the required NDCMS database and tables or is there documentation listing the table structure. I should mention that I'm using an SQL database and I'm running v0.4rc1 or ndcms.
Thanks
By the way, ndcms looks like an amazing project, hope I can get it up and running.
Wrecker33, I am having the same problem...it seems that we are missing the SQL scripts...if you try to run it using the MSSAccess version everything works fine of course you don't want to do this in production.
Try exporting the *.mdb in common/db to SQL Server that should work
Wrecke33, I just did. I use SQL Server Import from access to my SQL Server database and boom I was able to run the site using SQL Server...One minor issue...you need to Allow Nulls in the indx coulmn of table tblLOG.
Now we need to know if this is the correct way of doing this...because indx seems to be an ID. Can someone help us?
I figured this out a while ago as well :) After importing all the data into SQL2000 I had to manually convert each index column into an identity column. Once I'd done this it worked great. Other than that, I haven't had any problems.
Great that is what I did....
Here was my comment:
I was able to get it to work. I changed the indx column to Identity = yes, Identity Seed = 1 and Identity Increment=1 in tblLOG