Hi,

When I "Take a tour of the online programming tutorials. Having the
demo database running, point the browser to
http://localhost:8890/tutorial ." I get a 404.


I'm using the Windows binaries.

My server port is set to 1112


So exactly what do I have to do to get the demo database running. I
looked around for a bit and realized that the demo db is in the src,
so I got the src, went to samples/demo and took the mkdemo.bat

I put it in the bin directory and made the following changes to it
based on where I had the demo folder:

@echo off

del 
C:\projects\tests\proto-community\testsite\virtuoso-opensource\virtuoso-opensource-5.0.9-rc6\binsrc\samples\demo\demo.db
del 
C:\projects\tests\proto-community\testsite\virtuoso-opensource\virtuoso-opensource-5.0.9-rc6\binsrc\samples\demo\demo.trx
del 
C:\projects\tests\proto-community\testsite\virtuoso-opensource\virtuoso-opensource-5.0.9-rc6\binsrc\samples\demo\demo.log

virtuoso-t -I demo -S create -c
C:\projects\tests\proto-community\testsite\virtuoso-opensource\virtuoso-opensource-5.0.9-rc6\binsrc\samples\demo\mkdemo
virtuoso-t -I demo -S start
isql localhost:1112 PROMPT=OFF VERBOSE=OFF
<C:\projects\tests\proto-community\testsite\virtuoso-opensource\virtuoso-opensource-5.0.9-rc6\binsrc\samples\demo\mkdemo.sql
>NUL
isql localhost:1112 PROMPT=OFF VERBOSE=OFF EXEC=checkpoint >NUL
isql localhost:1112 PROMPT=OFF VERBOSE=OFF EXEC=shutdown >NUL
virtuoso-t -I demo -S delete

del 
C:\projects\tests\proto-community\testsite\virtuoso-opensource\virtuoso-opensource-5.0.9-rc6\binsrc\samples\demo\demo.trx
del 
C:\projects\tests\proto-community\testsite\virtuoso-opensource\virtuoso-opensource-5.0.9-rc6\binsrc\samples\demo\demo.log


Probably that is totally wrong.
But anyway when I ran it, it came with a number of errors - for example

INSERT INTO Order_Details(OrderID,ProductID,UnitPrice,Quantity,Discount) VALUES(
11070,2,19.000000,20,0.150000)

*** Error S1000: [OpenLink][Virtuoso ODBC Driver][Virtuoso Server]SR306: INSERT
statement conflicted with FOREIGN KEY constraint referencing table "Demo.demo.Or
ders"
at line 3451 of Top-Level:
INSERT INTO Order_Details(OrderID,ProductID,UnitPrice,Quantity,Discount) VALUES(
11070,16,17.450000,30,0.150000)

which anyway the end result is that I am still getting  a 404 on the
database. What is the best way to load the demos database?
Note I have also tried the same loaded on port 1111.

Best Regards,
Bryan Rasmussen

Reply via email to