This topic is locked

Northwind SQL

2/22/2010 8:17:05 AM
PHPRunner General questions
N
ninemins author

Is this table included in the demo.
I see this message when running demo 2 locally
Table 'northwind.security_ugrights' doesn't exist
I dont see it in the SQL
Cheers Chris

Sergey Kornilov admin 2/22/2010

This table will be created once you turn on User Group Permissions options.

N
ninemins author 2/22/2010

Thanks for the quick reply but I am confused
in the demo 2 I cannot create a user login as there are no users and until there

are users the table is not created
On the online demo I can export this data but I dont see this is the Northwind SQL

supplied with the offline demos - what am I missing here?
Chris
userID username password email group active

1 admin admin admin@test.com admin Yes

2 test test test@test.com manager Yes

3 demo demo demo@test.com user Yes

4 new new user1@test.com user No

5 jane jane jane@test.com manager Yes

Sergey Kornilov admin 2/22/2010

It's quite possible that sample database misses some tables.
I would suggest to connect to your own database and to build your own app. This way you can quickly build something useful and learn on the way.

N
ninemins author 2/22/2010

Thanks Sergey,

I never understood why the email didnt work so I thought if I set up the sample databases on

a local box then I could see if it was a server issue.
I would however have thought that if you have the sample databases working on your server

you would include that same database in the sample download. Can you dump the sql from

the working live demo so I can be sure I have the correct tables.
PHP version changes and features being deprecated make it a challenge just to stay still.

I dont have the time to learn PHP from scratch so hence my desire to use your software

to do the repetetive heavy lifting.
Cheers Chris



It's quite possible that sample database misses some tables.
I would suggest to connect to your own database and to build your own app. This way you can quickly build something useful and learn on the way.

Sergey Kornilov admin 2/23/2010

Chris,
providing sample projects for download was actually a wrong idea and we have removed that download. It's just yet another way to get confused.
You can get much better results and better understanding of how PHPRunner works creating a project from the template or using your own database. If there are any issues - post your app to demo account account and contact support team directly. Issues like this quite easy to resolve once you have access to the whole application.