bbPress

Info

• 10 posts
• 4 voices
• Started 3 years ago by ikailo
• Latest reply from mvds
• This topic is not resolved

Tags

• IIS
• new post
• new topic
• query

• Posts in this topic

INSERT queries for new Topic and new Post

1. • 
   • ikailo
   • Member

   • Posted 3 years ago #

   This was originally going to be an "It's not working!" post, but I made some progress. Now it's "Is what I did ok?" post.

   I kept getting a"This Topic is Closed" error every time I tried to create a new topic. Traced it back to the insert statement in 'bb_insert_topic' in functions.php. The database was responding with the error of "The value ' ' is not a valid integer for column 'topic_id'. (I am paraphrasing, I don't have the exact response in front of me)

   I suspected it had something to do with the fact that the topic_id value is being supplied to MySql, but it is set to be an auto-increment / not null field.

   So, I commented out in the $default array definition in 'bb_insert_topic':
   // 'topic_id' => false, // accepts ids or slugs

   and I changed this line:
   unset( $default['topic_id'], $defaults['tags'] );
   to this:
   unset( $args['topic_id'], $defaults['tags'] );

   Did the same thing under the 'bb_insert_post' function in the same file, but for the 'post_id' variables.

   Presto. Everything seems to work OK now.

   Could this issue be specific to my version of MySql? Although it is strange, because the original query works just fine using a third party tool (SQLyog).

   Has anyone encountered this issue before? Or - can anyone comment on the validity of my changes, and if they might cause issues going forward?

   Finally - should this be logged as a bug?

   Thanks!

   WP 2.6, BB 1.0, IIS 6.
2. • 
   • chrishajer
   • Moderator

   • Posted 3 years ago #

   What is your MySQL version?
3. • 
   • ikailo
   • Member

   • Posted 3 years ago #

   Ver 14.12 Distrib 5.0.45, for Win32 (ia32)
   5.0.45-community-nt MySQL Community Edition (GPL)
4. • 
   • Micheal Benedict Arul
   • Member

   • Posted 3 years ago #

   I too am facing the same problem.

   I am trying on a local server (apache) wp2.6.2+bbpress alpha releases and also the latest version from the trunk

   I have tried on ,
   mysql version 5.0.16-nt
   mysql version is 5.0.67-community nt

   I think it is a bug.
5. • 
   • chrishajer
   • Moderator

   • Posted 3 years ago #

   Sounds like both of you are on IIS web servers?
6. • 
   • Micheal Benedict Arul
   • Member

   • Posted 3 years ago #

   i am using apache 2.2.9. php 5.2.6
7. • 
   • chrishajer
   • Moderator

   • Posted 3 years ago #

   So much for my IIS guess. I am not having this trouble on a Linux server, MySQL 4.0.28-log, Apache 1.3.x, PHP 5.2.6 with Alpha 2.
8. • 
   • mvds
   • Member

   • Posted 3 years ago #

   Same problem here, with an Apache server on Windows. Latest versions of all applications. I will try your solutions and see what happens.
9. • 
   • mvds
   • Member

   • Posted 3 years ago #

   Just a question:

   do you include your wp functions in bbpress? I see calls to wp functions in several bb functions (also in bb_insert_topic and bb_insert_post) and I can imagine that if you dont include wp functions in bbpress, that these statements fail.

   I cannot include wp functions with the

   $bb->WP_BB = true;
   if (file_exists('../wp-blog-header.php'))
   	require_once('../wp-blog-header.php');
   else
   if (file_exists('../../wp-blog-header.php'))
   	require_once('../../wp-blog-header.php');

   part because then my forums don't work. I can't access my bb-admin pages and bbpress doesn't recognize my users.
10. • 
    • mvds
    • Member

    • Posted 3 years ago #

    It also seems to be working if you initialize the value of 'topic_id' as 0 (zero) instead of false. I found no problems with it so far.

11. You must log in to post.