CollectorToolz.co.uk
Fans of Collectorz.com software
It is currently Tue Sep 07, 2010 12:46 am




Post new topic Reply to topic  [ 6 posts ] 
GhostWritter not exporting (I think) 
Author Message

Joined: Fri Apr 03, 2009 3:48 am
Posts: 75
Post GhostWritter not exporting (I think)
I took the Ghost Writter field and renamed it to Narrator for the audio books I have, then went to export them today. It created the cross over table, but then the second half points to null.

Code:
DROP TABLE IF EXISTS `BookXNarrator`;

--
-- Table structure for table `BookXNarrator`
--

CREATE TABLE `BookXNarrator` (
  `BookID` int(11) NOT NULL,
  `NarratorID` int(11) default NULL,
  PRIMARY KEY  (`BookID`,`NarratorID`)
) ENGINE=MyISAM;


--
-- Dumping data for table BookXNarrator
--

INSERT INTO `BookXNarrator` VALUES (228,NULL);
INSERT INTO `BookXNarrator` VALUES (600,NULL);
INSERT INTO `BookXNarrator` VALUES (739,NULL);
INSERT INTO `BookXNarrator` VALUES (934,NULL);
INSERT INTO `BookXNarrator` VALUES (935,NULL);
INSERT INTO `BookXNarrator` VALUES (935,NULL);
INSERT INTO `BookXNarrator` VALUES (938,NULL);


And there is no Narrator/Ghostwritter table. I even renamed the settings.xml file so that k would create a new one, in case I deleted the table choice, but it still doesn't seem to work. Am I just missing it, or does it not exist?


Thu Mar 04, 2010 6:28 am
Profile
Site Admin
User avatar

Joined: Sun Jan 25, 2009 5:08 pm
Posts: 782
Location: Southampton, UK
Post Re: GhostWritter not exporting (I think)
darthyoda6 wrote:
I took the Ghost Writter field and renamed it to Narrator for the audio books I have, then went to export them today. It created the cross over table, but then the second half points to null.


Thanks for finding this Darthyoda, I will add to my TOFIX list. happy-159

Mark

_________________
Author of KollectiON :-: Written by a User for Users
Twitter me Here


Sun Mar 07, 2010 8:01 pm
Profile WWW

Joined: Fri Apr 03, 2009 3:48 am
Posts: 75
Post Re: GhostWritter not exporting (I think)
What I guess I should say is, because there was no ghostwritter/narrator table, the cross table couldn't point to anything.


Sun Mar 07, 2010 8:26 pm
Profile
Site Admin
User avatar

Joined: Sun Jan 25, 2009 5:08 pm
Posts: 782
Location: Southampton, UK
Post Re: GhostWritter not exporting (I think)
darthyoda6 wrote:
because there was no ghostwritter/narrator table, the cross table couldn't point to anything.


OK, thanks

_________________
Author of KollectiON :-: Written by a User for Users
Twitter me Here


Sun Mar 07, 2010 8:52 pm
Profile WWW

Joined: Fri Apr 03, 2009 3:48 am
Posts: 75
Post Re: GhostWritter not exporting (I think)
Just looking into it a bit further, it's putting the narrators/ghostwriters under the author table.


Thu Mar 11, 2010 4:17 pm
Profile
Site Admin
User avatar

Joined: Sun Jan 25, 2009 5:08 pm
Posts: 782
Location: Southampton, UK
Post Re: GhostWritter not exporting (I think)
darthyoda6 wrote:
it's putting the narrators/ghostwriters under the author table.

ok, thanks

_________________
Author of KollectiON :-: Written by a User for Users
Twitter me Here


Sat Mar 13, 2010 2:34 am
Profile WWW
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 


Who is online

Users browsing this forum: Google [Bot] and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by Vjacheslav Trushkin for Free Forum/DivisionCore.