http://bbpress.org/forums/ bbPress support forums Topic: bbPress database error - can't setup table en Sun, 07 Sep 2008 20:45:07 +0000 http://bbpress.org/forums/topic/bbpress-database-error-cant-setup-table#post-13235 Sat, 19 Jan 2008 05:06:39 +0000 hollywoodgrind 13235@http://bbpress.org/forums/ <p>It was 0.8.3.1 </p> http://bbpress.org/forums/topic/bbpress-database-error-cant-setup-table#post-13214 Fri, 18 Jan 2008 10:13:12 +0000 sambauers 13214@http://bbpress.org/forums/ <p>Which version of bbPress was this? 0.8.3.1 or latest trunk? </p> http://bbpress.org/forums/topic/bbpress-database-error-cant-setup-table#post-13194 Thu, 17 Jan 2008 06:39:05 +0000 chrishajer 13194@http://bbpress.org/forums/ <p>Glad you found it. </p> http://bbpress.org/forums/topic/bbpress-database-error-cant-setup-table#post-13193 Thu, 17 Jan 2008 02:12:51 +0000 hollywoodgrind 13193@http://bbpress.org/forums/ <p>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. </p> http://bbpress.org/forums/topic/bbpress-database-error-cant-setup-table#post-13190 Wed, 16 Jan 2008 22:23:27 +0000 chrishajer 13190@http://bbpress.org/forums/ <p>Not sure why, but you're missing all the topic poster name stuff:</p> <pre><code>topic_poster topic_poster_name topic_last_poster topic_last_poster_name</code></pre> <br />&nbsp;<br /> 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?</p> <p>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? </p> http://bbpress.org/forums/topic/bbpress-database-error-cant-setup-table#post-13179 Wed, 16 Jan 2008 01:08:24 +0000 hollywoodgrind 13179@http://bbpress.org/forums/ <p>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:</p> <p>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]<br /> 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)</p> <p>The database is setup, and all other tables are created except this one. I am using the latest bbPress. </p>