Personal Video Database
English => Support => Topic started by: IBICO on February 04, 2010, 12:48:12 pm
-
First time downloading this software and got these error messages.
First I noticed was that the ip address was not the one on my laptop.. So might it be that I have to edit something or change ip address to match the program?
(http://img709.imageshack.us/img709/8868/databaseerror.jpg)
-
Have you tried to select the database using File -> Open menu?
-
Have you tried to select the database using File -> Open menu?
But what database?.. I have not got to the part where the program is installs properly yet.
-
Yep, I too have this issue.
Latest downloads, Vista SP2, Latest firebird, MC14.0.137
Where is the DB supposed to be?
-
Latest download here also.. I run Norwegian XP, FF 3.5.7.
I also e-mailed the error report that the software generated for me
-
Just looking at the Media Centre Plug in and there are some log in there saying that the "PVDImportFieldConfig.XML" file cannot be found ans that I need to build the config from scratch, and that the "movies.pvd" database cannot be opened from the standard locations. However, I hav searched for these and cannot find them. Can these be downloaded from somewhere?
-
This is very strange.
1. Does File -> New work?
2. Do you already have firebird installed? (which version?)
-
This is very strange.
1. Does File -> New work?
No - same error.
2. Do you already have firebird installed? (which version?)
For me yes - 2.1
-
OK, the most should firebird that is already installed on your machine.
1. It is a newer version which is not compatible with PVD (it can be made compatible if you change fbembed.dll and fbclient.dll in PVD directory with newer ones)
2. Your firebird could have some special configuration preventing PVD from creating the database
Could you please try my suggestion in this topic: http://www.videodb.info/forum_en/index.php?topic=1644.msg7632#msg7632
-
OK, the most should firebird that is already installed on your machine.
1. It is a newer version which is not compatible with PVD (it can be made compatible if you change fbembed.dll and fbclient.dll in PVD directory with newer ones)
2. Your firebird could have some special configuration preventing PVD from creating the database
Could you please try my suggestion in this topic: http://www.videodb.info/forum_en/index.php?topic=1644.msg7632#msg7632
Hmm, tried 1. Didn't work. Copied all the files from the zip to the PVD directory but still the same error. However, there was no fbclient.dll file in the zip.
2. This is a fresh install. not config has been changed. Defaults were selected (apart from disabling control panel as from the firebird site it indicated that this would corrupt the control applet in Vista.
-
fbclient.dll is needed to use PVD with a remote server and it should be obtained from the normal firebird installation (you probably have this some somewhere on your system as you have firebird installed).
Are you getting exactly the same error as in the first post or smth else?
-
fbclient.dll is needed to use PVD with a remote server and it should be obtained from the normal firebird installation (you probably have this some somewhere on your system as you have firebird installed).
Found and copied - made no difference
Are you getting exactly the same error as in the first post or smth else?
Exactly the same.
-
1. Is it a normal PVD installation or you are using PVD from usb stick?
2. Does PVD and Firebird have access to "My Documents" folder?
3. Would it help if you fully uninstall PVD and Firebird and then install PVD again?
-
1. Is it a normal PVD installation or you are using PVD from usb stick?
Normal
2. Does PVD and Firebird have access to "My Documents" folder?
I don't see why not - how can i tell?
3. Would it help if you fully install PVD and Firebird and then install PVD again?
Do you mean uninstall, then re-install?
-
Quote from: nostra on February 05, 2010, 12:50:37 am
2. Does PVD and Firebird have access to "My Documents" folder?
I don't see why not - how can i tell?
OK, if you did not change anything then it can most probably be accessed by PVD
Quote from: nostra on February 05, 2010, 12:50:37 am
3. Would it help if you fully install PVD and Firebird and then install PVD again?
Do you mean uninstall, then re-install?
Yep
-
OK, uninstalled PVD then firebird, rebooted. Installed firebird in default and PVD as full install.
Tried to start PVD and got a new error about Visual C libraries. I remembered that it looked like there was something to do with these in the updated embedded client zip you posted earlier, so I re-copied the contents of the zip to the PVD directory.
Although this got rid of the Visual C error , unfortunately, non of this worked fully and we are now back at the beginning with the same error!
-
Ah ha. With some pointer form here and the MC forum , I believe we have got somewhere.
Is is possible that PVD doesn't like UDF file names? My "My Docs" folder is re-directed to a server share and referenced via a UDF path name. If I actually try to create a new DB on a local HDD, then finally I can get PDV to work.
I don't believe its a permissions thing. The PVD data folder in "My Docs" was created by the PVD installation, and permissions are inherited, so full access is granted.
-
Reply here (http://yabb.jriver.com/interact/index.php?topic=54918.msg380388#msg380388).
-
When using PVD locally the database must be on the same PC, if it is not you need to have a firebird server on the remote PC.
-
Ah...that makes sense. ;)
-
fantastic. Iwill install firbird on the server and see how this goes. Shame about the error messages, but i hope this solves the problem for IBICO as well.
-
installed Firefird 2.5 and inside PVD I took Connect to server and wrote 127.0.0.1 and started saving new database.. Now everything works.
Only thing bugging me now is can`t seems to categories main list after Action, Comedy, Horror.. and then have movies listed under those.
Also when I write The Golden Child and The Witches of Eastwick it changes it to Golden Child, The and Witches of Eastwick, The.
-
Also when I write The Golden Child and The Witches of Eastwick it changes it to Golden Child, The and Witches of Eastwick, The.
Tools->Preferences->Movies->Title Formatting->Prefixes->Leave as they are radio button checked?
-
Well, I tried install Firebird 2.1.3 on the server but cannot connect to it from PVD. The port is open, FB is listening on the sever and can be probed (3050 I believe). So I still can't open a file stored in my re-directed "My Docs" folder.
I will try FB 2.5 and see what happens.
-
Only thing bugging me now is can`t seems to categories main list after Action, Comedy, Horror.. and then have movies listed under those.
The meaning of this is unclear. Please edit your post to restate.
-
Only thing bugging me now is can`t seems to categories main list after Action, Comedy, Horror.. and then have movies listed under those.
The meaning of this is unclear. Please edit your post to restate.
That instead of having the movies listed like it is now.. Where the movies are listed on the left side with the name of your movies.
Let me explain it like if you had all your movies on an harddrive on your computer
instead I could have the possibility to put the movies under categories like a folder and subfolder.
The folder could be called ACTION - under you have folder Bad boys, then Bad boys II, Running man etc etc..
Now you have one folder called Your movies, and under it lot`s of folders with your movies.
It is good if you got a smaller collection of movies.. but I got hundreds of DVD`s in my closet and need to check my list to see what movies I have. So therefore it would be also easier if I could categories them under different lists.. Children movies, Scifi, Horror, Comedy etc.
Hope it is more clear now.
Sorry for the off topic..
-
It seems what you want is View - Group by... genre—or whatever. You can also do nested grouping by specifying what you want at Preferences - Movies - Tree View Nodes. For example, for a large collection, you might prefer a Decade\Genre grouping. Note that if a movie is in more than one genre (most are), then it will appear in both categories.
-
Hmm, not sure what is going on with me. I still cannot get the "movies.pvd" file to open from the redirected "my docs" folder.
I have tried FB 2.5 on both the client and the server, however I am not getting a new error message:
1: Your user name and password are not defined. Ask your database administrator so set up a Firebird login.
Unsuccessful execution cause by a system error that precludes successful execution of subsequent statement.
Error code: 152
Whether is matters or not, I cann't Connect to any server in PVD. I have tried typing the IP address, machines name or local machine ip address. If I try doing this I get this error massage:
1:I/O error during "CreateFile (open) operation for "machine name"
Error when trying to open file. The system cannot find the file specified.
Unsuccessful execution cause by a system error that precludes successful execution of subsequent statement.
Error code: 24
-
Does this (http://www.firebirdfaq.org/faq135/) help? You shouldn't need to login to Firebird.
How, exactly, are you specifying the connection? "[server name]:[database path]" should work.
-
Does this (http://www.firebirdfaq.org/faq135/) help? You shouldn't need to login to Firebird.
Unfortunately not. As you say, I shouldn't need a username and password and there isn't the moption to insert them anywhere.
How, exactly, are you specifying the connection? "[server name]:[database path]" should work.
I have tried a simple ip address or machine name, UDF convention and not your suggested method (with the braces). So I have:
server:Users\me\My Documents\Personal Video Database\movies.pvd
With this I get the error message:
2:I/O error during "@1" operation for file "@2".
Error while tring to open file.
The system cannot find the path specified.
Unsuccessfully...
Error code:24
Not sure what else to try.
-
apologies - didn't see the -user and -pass parameters that can be passed - will try that
Now tried
server:Users\me\My Documents\Personal Video Database\movies.pvd -user SYSDBA -pass masterke
same error as:
2:I/O error during "@1" operation for file "@2".
Error while tring to open file.
The system cannot find the path specified.
Unsuccessfully...
Error code:24
I only get the the user name/password error when I try to OPEN (not Connect) the movies.pvd file, but only then once I close down PVD and re-open
-
Did you try full syntax, for instance 127.0.0.1:C:\Documents and settings\All Users\....\Data\MOVIES.PVD?
It works for me fine.
-
Did you try full syntax, for instance 127.0.0.1:C:\Documents and settings\All Users\....\Data\MOVIES.PVD?
It works for me fine.
although 127.0.0.1 refers to you local machine, I have tried
server:\\server\Users\me\My Documents\Personal Video Database\movies.pvd
and I now get the error:
1:unavailable database
Unsuccessful execution caused by an unavailable resource
Error Code:55
As said, all permissions seem fine.
-
Yes, but I meant instead "server" to enter it's address. I would also check sharing and security permissions. If that wouldn't work, I would map network drive so I could try 127.0.0.1 syntax... Although, if you could map it, it would meant that sharing and security permissions were ok.
-
Yes, but I meant instead "server" to enter it's address. I would also check sharing and security permissions. If that wouldn't work, I would map network drive so I could try 127.0.0.1 syntax... Although, if you could map it, it would meant that sharing and security permissions were ok.
I have tried connecting to the local machine and server (using both IP or machine name), using both UDF and mapped network drive, but still no joy. Tried connections such as:
127.0.0.1:Z:\My Documents\Personal Video Database\movies.pvd
server:Z:\My Documents\Personal Video Database\movies.pvd
etc
Any further ideas?
-
Can you open movies.pvd from mapped drive without connecting to server?
-
Can you open movies.pvd from mapped drive without connecting to server?
No
I get the error:
2:I/O error during "@1" operation for file "@2".
Error while tring to open file.
The system cannot find the path specified.
Unsuccessfully...
Error code:24
-
Just to let you know, both my user account and the System account have full permissions on both the folder and file. The firebird service is started used the Local System account.
-
1. Did you try to copy movies.pvd to a local disc and to open it without connecting to a server?
2. Did you try with stopping firebird services first, then to open it from a local disc?
3. Did you install Kroozbox, maybe? If so, try to uninstall it, then open database from local disc?
-
I really appreciate all this, but I had a thought and have finally resolved the issue.
You can specify the remote server as indicated in the posts above, but you need to pass the physical location of the database file on the SERVER, rather then with refernce to the local machine. So, we end up with a connection string that's:
server:E:\Users Shared Folders\me\My Documents\Personal Video Database\movies.pvd
Still, I'm a little confused as to why UDF notation didn't work, as this is still accessible from the server (i,e, \\server\users\me....).
This might be useful to stick in you solved problem in case anyone else wishes to run the database from a remote location.
Many thanks all. Now I just need to figure out how it all works.
-
This is exactly what I meant by "[server name]:[database path]", but I obviously didn't have the words to convey this effectively. Maybe someone familiar with a network/server environment (i.e., not me) can improve the existing wiki entry (http://www.nimidia.com/pvd_wiki/tiki-index.php?page=Connect-to-server), but it seems to cover it as is.
-
This is exactly what I meant by "[server name]:[database path]", but I obviously didn't have the words to convey this effectively. Maybe someone familiar with a network/server environment (i.e., not me) can improve the existing wiki entry (http://www.nimidia.com/pvd_wiki/tiki-index.php?page=Connect-to-server), but it seems to cover it as is.
Actually, the WIKI entry seems to be quite good. I think the problem was that UDF share names do not seem to be liked by Firebird in the Connection string, and the error messages provided by Firebird where a little obscure. Not to mention lavish amounts of stupidity on my part - I really should know the difference between absolute and relative path names (Rick - I think your sig is quite apt in this case!)
-
I really appreciate all this, but I had a thought and have finally resolved the issue.
server:E:\Users Shared Folders\me\My Documents\Personal Video Database\movies.pvd
Did you try full syntax, for instance 127.0.0.1:C:\Documents and settings\All Users\....\Data\MOVIES.PVD?
Yes, but I meant instead "server" to enter it's address.
With those two comments above, that's exactly what I suggested, too. I never suggested to use remote path.
I think the problem was that UDF share names do not seem to be liked by Firebird in the Connection string.
It's not that Firebird doesn't like UDF. It's how it was designed to be, I think?
Existing Wiki entry was totally ok saying:
Remote server path configuration
The database path for the Firebird server can be entered using one the following formats:
1. local path (if both client and server are on the same computer)
2. computer name:local path
3. ip:local path
You always have to specify database's local path.
The following paragraph "Movie path configuration" explains how to handle remote paths. And that's another little gem of PVD.
-
I really appreciate all this, but I had a thought and have finally resolved the issue.
server:E:\Users Shared Folders\me\My Documents\Personal Video Database\movies.pvd
Did you try full syntax, for instance 127.0.0.1:C:\Documents and settings\All Users\....\Data\MOVIES.PVD?
Yes, but I meant instead "server" to enter it's address.
With those two comments above, that's exactly what I suggested, too. I never suggested to use remote path.
Again apologies. However, as it was shown earlier (and above), if the path is actually a route to server share (either UDF or a mapped drive) it won't work. The database HAS to physically be located on the machine with the instance of FB is running AND the path MUST be local to that machine. I must admit, I didn't see the WIKI entry until after the fact.
For instance, all of these refer to exactly the same location, and would be acceptable references to access the resource from each machine, but only the first one works:
server:E:\Users Shared Folders\me\My Documents\Personal Video Database\movies.pvd - FB on a remote server, local path on server - WORKS!
server:\\server\Users\me\My Documents\Personal Video Database\movies.pvd - FB on a remote server, share on the same server - DOESN'T Work
127.0.0.1:\\server\Users\me\My Documents\Personal Video Database\movies.pvd - FB on local machine, share on remote server - DOESN'T Work
127.0.0.1:Z:\My Documents\Personal Video Database\movies.pvd - FB on local machine, mapped drive to remote server - DOESN'T Work
The biggest issue for me was that as I run a server and have all the users files redirected to shares on a server, and even though these shares use off-line files (so essentially I am using a local copy), the default install of PVD creates the DB in the "My Docs" folder - which is actually a server share.
Maybe examples of what WON'T work would be as useful as what will.
-
Maybe examples of what WON'T work would be as useful as what will.
Absolutely. And that's how existing wiki entry could be updated? Unfortunately, my English is not so good :(
Cheers
-
I found this line (#128) in firebird.conf:"UdfAccess = None". That could explain a lot...
-
I've been saying UDF, I really meant UNC relating to remote path names :-[. However, as was show, even mapped drives don't work, although I'm guessing they will resolve to a UNC path.
-
Of course! Firebird QuickStart Guide:
You cannot locate components of the server, or any database, on a mapped drive, a filesystem share or a network filesystem.
To add one more issue, which I recently resolved. In case of such an error messages 2:Unable to complete network request to host "@1".
Failed to establish a connection.
A connection attempt failed because the connected party did not properly respond afer period of time, or established connection failed because connected host has failed to respond.
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
Error Code: 401
4:unavailable database
Unsuccessful execution caused by an unavailable resource.
Error Code: 55
ERROR
Failed to open database
most likely you'll have to open 3050 TCP port on your firewall, or any other TCP port defined in firebird.conf, line:
#RemoteServiceName = gds_db
#RemoteServicePort = 3050
Another solution is to add fbserver.exe and/or fbguard.exe services to an exception list in firewall.
I haven't checked if this issue was treated earlier in forum, so I apologize if it was.