NextPVR Forums
  • ______
  • Home
  • New Posts
  • Wiki
  • Members
  • Help
  • Search
  • Register
  • Login
  • Home
  • Wiki
  • Members
  • Help
  • Search
NextPVR Forums Public Add-ons (3rd party plugins, utilities and skins) Old Stuff (Legacy) GB-PVR Support (legacy) v
« Previous 1 … 417 418 419 420 421 … 1231 Next »
Database migration - tip

 
  • 0 Vote(s) - 0 Average
Database migration - tip
wannabepvr
Offline

Senior Member

Posts: 635
Threads: 131
Joined: Sep 2005
#1
2007-11-25, 04:06 AM
A few releases back I tried to migrate from MS Access to SQLIte, without success - so I just carried on with MS Access - until now.

With 1.15 I found I has this problem with "search guide" under MS Access.
http://forums.nextpvr.com/showthread.php...post242588

So I tried again to use the change database utility and got errors where tables like "custom task", and others, didn't exist in the SQLite DB.

I tried to make the change in config.xml and config.exe to reconfigure the SQLIte DB but this didn't work.

However when I took a new (1.15) 'seed' SQLIte DB from a fresh install and ran the change database utility it went perfectly smoothly.

The problem that was due to the old original install the SQLIte DB was just too far out of date and subsequent GBPVR upgrades hadn't also updated the SQLite DB - presumably because it had not been the selected DB?
Core2-E2180, 1G RAM, 1Gb-5450 Silent, 2Tb +300g HDDs.
Three tuners: [SIZE=2][SIZE=1]Twinhan DVB-T x 1, Hauppauge Nova 500T (dual)
[/SIZE][/SIZE]
DTB Digital SD + HD content (PAL-MPEG2-AC3).
Custom case made very quiet. Zalman CPU cooler.
Sits in rack with other HiFi.

ParaLED to show tuner activity.

Display: 42" 1920x1080p Panasonic Plasma

1x wired MVP
1x PC client
[URL="http://web.aanet.com.au/media/"]
[/URL]
sub
Offline

Administrator

NextPVR HQ, New Zealand
Posts: 106,677
Threads: 767
Joined: Nov 2003
#2
2007-11-25, 04:50 AM
Try copying empty.db3 over gbpvr.db3.
« Next Oldest | Next Newest »

Users browsing this thread: 1 Guest(s)



Possibly Related Threads…
Thread Author Replies Views Last Post
  Staged upgrade/migration from gb to next koornneef 5 3,368 2011-11-27, 05:44 AM
Last Post: sub
  Huge database (+27GB) - is it a problem? pme 7 2,956 2011-01-24, 12:37 AM
Last Post: gEd
  "database disk image is malformed" during attemped EPG update! (GBPVR v.1.4.7) DaveA 4 3,312 2011-01-23, 06:35 PM
Last Post: DaveA
  GBPVR Database question - Recording Schedule David B 1 1,613 2010-11-08, 09:21 PM
Last Post: sub
  Lost recordings database keith_leitch 9 3,680 2010-09-22, 09:20 PM
Last Post: keith_leitch
  Postprocessing and the recordings database shsw 1 1,481 2010-08-29, 04:46 PM
Last Post: sub
  Lost recordings database dongna 25 7,749 2010-08-26, 10:00 AM
Last Post: martint123
  Strange database problem -- pvrx2 not seeing updates, EWA and Config.exe are. 86atc250r 5 2,387 2010-07-26, 10:09 AM
Last Post: martint123
  Cleaning up the database? Spark 3 1,786 2010-03-28, 07:20 PM
Last Post: sub
  database locked error speising 1 1,173 2010-03-17, 12:45 AM
Last Post: sub

  • View a Printable Version
  • Subscribe to this thread
Forum Jump:

© Designed by D&D, modified by NextPVR - Powered by MyBB

Linear Mode
Threaded Mode