Forums

Join
bbPress Support Forums › Installation › bbPress database error - can't setup table

Info

bbPress database error - can't setup table

    • Posted 4 years ago #

    I've gone over the configuration file, and it all looks correct. I am installing in forums.nerdgrind.com, which I gave it's own directory, so there is no wordpress installation sharing the forums directory. I'm not sure why I keep getting this error:

    bbPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' '', , '', '2008-01-16 00:57:55'' at line 4]
    INSERT INTO bb_topics (topic_title, topic_slug, topic_poster, topic_poster_name, topic_last_poster, topic_last_poster_name, topic_start_time, topic_time, forum_id) VALUES ('Your first topic', 'your-first-topic', , '', , '', '2008-01-16 00:57:55', '2008-01-16 00:57:55', 1)

    The database is setup, and all other tables are created except this one. I am using the latest bbPress.

    • Posted 4 years ago #

    Not sure why, but you're missing all the topic poster name stuff:

    topic_poster
topic_poster_name
topic_last_poster
topic_last_poster_name

     
    Maybe there was an error with the name you selected when you setup the forum? Maybe it didn't like a special character or something?

    It's not a problem with the database but a problem with the data that's being sent to create that first topic. I suspect there is a problem with the name that was entered. Do you know what that was?

    • Posted 4 years ago #

    I found the problem. In the install form I set the Site Name and Forum Name the same, which caused a conflict. Perhaps the install.php script could be updated to catch this error, and prompt to use different names.

    • Posted 4 years ago #

    Glad you found it.

    • Posted 4 years ago #

    Which version of bbPress was this? 0.8.3.1 or latest trunk?

    • Posted 4 years ago #

    It was 0.8.3.1

  7. You must log in to post.