blogger api - Invalid Section Selection
Posted: 27 May 2005 11:28 PM   [ Ignore ]  
Summer Student
Total Posts:  15
Joined  07-19-2003

Hello,
I’m using the blogger api and getting the error message “Invalid Section Selection”, code 802.  Can you tell me what that means?
John

Profile
 
 
Posted: 28 May 2005 07:06 AM   [ Ignore ]   [ # 1 ]  
Research Scientist
Avatar
RankRankRankRankRankRank
Total Posts:  9868
Joined  06-19-2002

Did you create a new “configuration” to use and make sure you selected a valid weblog/weblog field when you did so?  If you’re simply trying to use the “default” configuration then you would have problems if you’ve altered the default installation by either deleting the default weblog or changing the weblog fields it uses.

(In your case, of course, it appear you’ve changed the term “weblog” to be “section”.)

 Signature 

Chris Curtis
chriscurtis.org

Profile
 
 
Posted: 28 May 2005 09:08 PM   [ Ignore ]   [ # 2 ]  
Summer Student
Total Posts:  15
Joined  07-19-2003

Hi Chris,
Thanks for the reply.  I discovered yes, the term weblog has been changed to section, and there is no weblog 1.  So now I specify a weblog_id and I get a little further.

Now I am getting this error message:

MySQL ERROR:<br /><br />Error Number: 1054<br /><br />Description: Unknown column ‘field_id_’ in ‘field list’<br /><br />Query: INSERT INTO exp_weblog_data (weblog_id, field_id_, field_ft_, entry_id) VALUES (‘2’, ‘test from jh’, ‘’, ‘8727’)

Can you tell me what would cause this?

John

Profile
 
 
Posted: 28 May 2005 10:10 PM   [ Ignore ]   [ # 3 ]  
Research Scientist
Avatar
RankRankRankRankRankRank
Total Posts:  9868
Joined  06-19-2002

When you set up the “configuration” in the Blogger API module section, are you specifying valid information?  You have to select a weblog as well as a field for the weblog.  Based on the error you’re receiving, your Configuration isn’t set up right and it isn’t assigning a field.

 Signature 

Chris Curtis
chriscurtis.org

Profile
 
 
Posted: 15 June 2005 09:03 PM   [ Ignore ]   [ # 4 ]  
Summer Student
Total Posts:  15
Joined  07-19-2003

Hello Chris,

Thanks for the help.  Here is some more information for you.

In Modules - Blogger API, I created a configuration named jh, with these values.

  Default field for Entry Data:  WestportNow : body
  Send Entries as Block:  No
  Text Formatting Preference:  Yes
  Send Pre-formatted Text to Desktop Client:  No
  HTML Formatting:  Allow only safe HTML

In Admin - Section Management, there are three sections, as follows.
  3 Info Info
  2 Sections   Sections
  5 WestportNow wn

Here is the string I’m sending through the Blogger API.

<title>Test from JH</title><body>This is a test story sent by JH.</body><weblog_id>5</weblog_id>

The error message returned is this.

MySQL ERROR:<br /><br />Error Number: 1054<br /><br />Description: Unknown column ‘field_id_’ in ‘field list’<br /><br />Query: INSERT INTO exp_weblog_data (weblog_id, field_id_, field_ft_, entry_id) VALUES (‘5’, ‘<body>This is a test story sent by JH.</body>’, ‘’, ‘8729’)

Can you decipher what is wrong?

John

Profile
 
 
Posted: 15 June 2005 10:31 PM   [ Ignore ]   [ # 5 ]  
Research Scientist
Avatar
RankRankRankRankRankRank
Total Posts:  7534
Joined  08-05-2002

Questions:

1.  Is WestportNow your weblog with id of 5 as specified in the data you are sending?

2.  If not, does there exist a weblog with id of 5 and does it have any textareas in its custom fields group?

 Signature 
Profile
 
 
Posted: 16 June 2005 09:46 AM   [ Ignore ]   [ # 6 ]  
Summer Student
Total Posts:  15
Joined  07-19-2003

Hello Paul,

Thanks for the reply.

Yes.  WestportNow is the weblog with id 5.  It uses the Default Field Group.  There are no other field groups.

Here is some more information.

They have changed the word “Weblog” to “Section”.  So every place a normal EE installation shows the word “weblog”, this one shows the work “section”.  (Except I still use the <weblog_id> tag in my Blogger API call.)

There are three sections.  The section we’re using is id=5, longname=WestportNow, shortname=wn.

I have discovered that my test entries are getting into the system partially.  I can see the titles in the menu on the Edit tab in the console.  I have entered items both on the Publish tab of the console, and via Blogger API.  All the items look the same in the Edit menu;  all of them show “wn” as the section (weblog).  But if I click on the title of a Blogger API item to go to the Edit page, I get an error message that says “You have tried to access a section that does not exist.”

Does this give you some more clues?

John

Profile
 
 
Posted: 16 June 2005 11:32 AM   [ Ignore ]   [ # 7 ]  
Research Scientist
Avatar
RankRankRankRankRankRank
Total Posts:  7534
Joined  08-05-2002

That error is because EE is unable to find the exp_weblog_data for an entry.

Could you send me an email and I can try to dig deeper on your site and find where this is going wrong?

 Signature 
Profile
 
 
   
 
 
‹‹ tag question.      Tag Limiting ››
Post Marker Legend
New Topic New posts Hot Topic Hot Topic with new posts New Poll New Poll Moved Topic Moved Topic Sticky Topic Sticky topic
Old Topic No new posts Hot Old Topic Hot Topic with no new posts Old Poll Old Poll Closed Topic Closed Topic Announcement Announcements
Theme
Change Theme
Visitor Statistics
The most visitors ever was 1149, on July 16, 2007 09:33 AM
Total Registered Members: 64912 Total Logged-in Users: 24
Total Topics: 81864 Total Anonymous Users: 13
Total Replies: 440103 Total Guests: 181
Total Posts: 521967    
Members ( View Memberlist )
Newest Members:  bjmohrAqua193Bios Elementmjpoteetguimogranwelshmrcfthenetmonkeybenekwhobutsb