[bramruiter]

The problem got a bit bigger. When someone tries to find something through the search they get:

bbPress database error: [You have an error in your SQL syntax near ‘ON ( t.topic_id = p.topic_id ) WHERE p.post_text LIKE ‘%ja%’ AND p.post_status =’ at line 1]

SELECT p.*, 0 AS search_score, MAX(post_time) AS post_time FROM bb_posts AS p JOIN bb_topics as t ON ( t.topic_id = p.topic_id ) WHERE p.post_text LIKE ‘%ja%’ AND p.post_status = ‘0’ AND t.topic_status = ‘0’ GROUP BY t.topic_id ORDER BY p.post_time DESC LIMIT 5

bbPress database error: [You have an error in your SQL syntax near ‘ON ( t.topic_id = p.topic_id ) WHERE t.topic_status = ‘0’ AND p.post_status = ‘0’ at line 1]

SELECT t.*, MIN(p.post_id) as post_id, p.post_text, 0 AS search_score FROM bb_topics AS t JOIN bb_posts as p ON ( t.topic_id = p.topic_id ) WHERE t.topic_status = ‘0’ AND p.post_status = ‘0’ AND ( (t.topic_title LIKE ‘%ja%’) OR p.post_text LIKE ‘%ja%’ ) GROUP BY t.topic_id ORDER BY t.topic_time DESC LIMIT 20

[bubblebla]

hi, i’m a newbie here..

i need some help here. can anyone advise me on how to add a main page in my forum? i want the page to show only the login form, active and newest threads and i need to main page to show some information. my question here, can i really add the page in kakumei? or do i need to use the wordpress to make such page?

i really want to avoid using wordpress bcoz currently i’m trying to integrate the bbpress forum to 3 websites using the wordpress.

i hope someone can help me here.. thank you

[chrishajer]

Does this problem happen with the stock theme? Maybe it’s a problem with the customization?

Where do you log in? Normally at http://lifelightcam.com/bbpress/ there is a spot to login or register, then logging in as keymaster allows access to the admin panel.

If you log in as keymaster, do you have a link to Admin your forum or can you access http://lifelightcam.com/bbpress/bb-admin/ ?

It doesn’t look like you are using permalinks at all for bbPress, which is fine.

BTW, I don’t think this has anything to do with WordPress.

[chrishajer]

What do you have to do to get that error to show up? Installation, view profile, post a new topic, post a reply, add a tag, etc…

[bramruiter]

bbPress database error: [You have an error in your SQL syntax near ‘ON ( t.topic_id = p.topic_id ) WHERE p.post_status != ‘0’ AND t.topic_status = ” at line 1]

SELECT p.* FROM bb_posts AS p JOIN bb_topics as t ON ( t.topic_id = p.topic_id ) WHERE p.post_status != ‘0’ AND t.topic_status = ‘0’ ORDER BY p.post_time DESC LIMIT 5

What does it mean?

[Detective]

I’m sorry, did you try with Genealogías theme or another? Currently i’m hooking on a custom action (my bad, i know :p).

In your profile-edit.php template put the following code:

<?php

userphoto_display_selector_fieldset($user->ID);

?>

[benbeltran]

I hope it helps somehow. In my opinion, this is the best forum software if you’re a developer that wants custom forums and doesn’t mind getting dirty with code. At least that’s why I love it (I know, people will disagree with me).

I’ve never felt so in control of my forums before . Everything is just … clean, from the default UI to the insides.

[reclaimyourskin]

Thanks a lot Detective.

But I can’t get the plugin to work. I have followed your instructions by uploading the user-photo foler into “my-plugins” directory and I made sure the paths are correct.

The plugin activated without any errors but i’m not sure how I upload a photo. There is no form to upload photos in user profiles, do I need to add some code manually to the template files?

Sorry to be a pain & thanks for your time

Will

[davidbaldwin]

here is the URL to bbpress:

http://lifelightcam.com/bbpress/

and the admin:

http://lifelightcam.com/bbpress/bb-admin

i’m using this permalink structure:

http://lifelightcam.com/2008/06/07/sample-post/

thanks for your help!

david

[chrishajer]

If you are installing fresh, sure, just delete those. If you want, you can change the table prefix in your new bbpress installation. I forget where it is in the installation procedure, but maybe it’s under an option called “advanced database settings” or something? I think it was hidden unless you reveal it by clicking.

If bbPress finds the bb_ tables there already, I suspect it might just try to upgrade the database. That’s probably OK, but if you don’t need the old bbPress installation, I would just start from scratch with new tables.

[chrishajer]

[edited out a stupid idea]

WAIT: update 26 minutes later. If you’re not logged in, trying to access /bbpress/bb-admin/ is SUPPOSED to redirect you to the home page of the forum. When you log in there as keymaster or administrator, you then have a link to View your profile (Admin | Log out) – and in my installation, clicking Admin takes you to /bbpress/bb-admin/. You can also access the /bbpress/bb-admin/ URL directly, but only after logging in as keymaster. If that’s what’s happening, then that is correct.

Is it possible you can’t log in on the home page of the forum as administrator or keymaster? Did that account lose privileges or something? Maybe you have a different problem. But direct access to /bbpress/bb-admin is prevented by design until you are logged in.

[chrishajer]

You did not set up permalinks on your server, or the server does not support them. Turning them back to none makes the links work again, but you don’t have any sort of permalinks.

https://bbpress.org/documentation/faq/#pretty-permalinks

[Detective]

You can download it here: User Photo for bbPress.

The readme.txt has installation instructions.

User Photo for bbPress is a modified/simplified/ported version of the original User Photo plugin by Weston Ruster.

[sachrilege]

Hey everyone,

I’m trying to do 3 things.

1. I want posts inactive longer then a set time to not be propagated to the Latest Discussions on the forum Index.

2. I want hidden private forums to not show up on the Latest Discussion list unless they would normally be allowed to see it.

3. I want the forum name to show up in another column in the Latest Discussion list.

I’m using the Private Forums plug-in, and Latest Discussion is only visible on my site from bbpress/index.

For 1. I found a plug-in but it’s no longer supported and I couldn’t clean up the Syntax error myself.

For 2 I can find nothing.

For 3 using another forum post I’ve already edited my templates to include the extra column and I almost see how to do it myself, but I can’t see where to get the name of the forum from the topic.

As always, thank you for whatever help you can offer.

[davidbaldwin]

I used this code from the documentation:

Code:

require_once(‘path/to/wp-blog-header.php’);

to intigrate bbpress with wordpress, so I could use my current wordpress themes.

the only problem I have now, is that when I try to access /bbpress/bb-admin I am automatically forwarded to /bbpress and I have no access of the admin screen.

any ideas?

thanks!

david

[reclaimyourskin]

Hi Detective, I really like this theme – like I said before definitely one of the best WordPress/BBpress installs I’ve seen.

Does this theme have the User Photo plugin intergrated into it? I would love to be able to use User Photo within BBpres like you have done at http://www.ryuuko.cl/bbpress

[Detective]

I’m hosting this plugin here: http://alumnos.dcc.uchile.cl/~egraells/proyectos/plugins-para-bbpress/

[cordoval]

I have found the trac website with the ticket for your records:

https://trac.bbpress.org/ticket/779

Now I am thinking that we can achieve this easily:

0. create custom field for password (at first do not validate with an extra field)

1. get the registration function to create the account with the given username

2. get the password be follow through the function and pass it to a second call

3. the second call will really call the change-password function and will get the passed user defined password to the change-password.

4. the end.

Sounds simple but let’s see where our code is.

[Detective]

URL: http://alumnos.dcc.uchile.cl/~egraells/proyectos/plugins-para-bbpress/

Test Installation: http://www.ryuuko.cl/bbpress

Includes readme.txt with examples. It supports english and spanish (es_ES).

Hope you like it

Suggestions, bug reports, comments and feedback in general are welcomed

[Detective]

I’ll release this plugin tomorrow. Check this profile to see how it looks.

[Detective]

I made a few changes in the layout. I’ll release the theme tomorrow

Remember it needs some knowledge, because without customization (through plugins) it’s kind of ugly …

[alexleonard]

Ah brilliant,

Thanks so much for the clarification. I was getting the feeling that quite a few things had changed all right. The main development site has had quite a lot of work done so far, but on bbpress all I had really done was set it to use the header and footer from the WP theme.

It’ll be easy to dump it and start again.

Actually on that point. In installing the old version I stored the bb_press database tables in this site’s WordPress database, eg:

| bb_forums              |

| bb_posts               |

| bb_tagged              |

| bb_tags                |

| bb_topicmeta           |

| bb_topics              |

| wp_comments            |

| wp_ig_caticons         |

| wp_links               |

| wp_options             |

| wp_postmeta            |

| wp_posts               |

| wp_term_relationships  |

| wp_term_taxonomy       |

| wp_terms               |

| wp_usermeta            |

| wp_users               |

Should I delete each of the tables prefixed “bb_” before continuing?

Cheers,

Alex

[rogermbyrne]

hi chrishajer

after your suggestion i tried to think of a diff way so i installed phpbb via fantastico on a different domain iimported the odl database and then looked through phpmyadmin to see if i could find the posts, success! exported as .csv file and now i have all the data and email addresses

thanks for your help!

[bobbyh]

Thanks, benbeltran, for the heads up! I just nominated it for the same categories…

[benbeltran]

Hello, as some of you might know already, Sourceforge.net hands out awards annually to the best open source projects. I’m inviting the community to nominate one of my favorite forums system (and possibly yours too). Of course, bbpress.

Just Click Here to Nominate BBPress

I Nominated it for best project and best new project.