Closed (fixed)
Project:
phpBB Forum Integration
Version:
6.x-2.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
9 Apr 2009 at 02:46 UTC
Updated:
9 Jan 2012 at 07:11 UTC
I have a content type set up to allow posting to phpBB.
After selecting which forum to post to and clicking save I get the following error:
# user warning: Table 'mydatabase.phpbbforum_drupal2phpbb' doesn't exist query: SELECT topic_id FROM phpbbforum_drupal2phpbb WHERE node_id = 3 in /home/admin/mywebsite.com/modules/phpbbforum/phpbbforum.module on line 658.
# user error: in /home/admin/mywebsite.com/phpBB3/includes/db/dbal.php on line 654.
# user error: SQL ERROR [ mysqli ]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 '' at line 3 [1064]
Im using MySQLi if that means anything.
Comments
Comment #1
problue solutionsany thoughts on this? Its a feature I'd find incredibly useful and I really really want to get it working!
Comment #2
problue solutionsFYI - this error still appears when posting a 'story' node even when Drupal to phpBB submission is disabled
The error message is permanently on display above the story teaser after the node has been posted.
Comment #3
problue solutionsIs there any more info I can provide to diagnose this bug?
Comment #4
Treidge commentedThere is drupal_sandbox.drupal2phpbb Table, not drupal_sandbox.phpbbforum_drupal2phpbb, as required. So, you can go to drupal_sandbox database and rename table drupal_sandbox.drupal2phpbb to drupal_sandbox.phpbbforum_drupal2phpbb
Be careful, i can't guarantee anything, because i'm using drupal for the first day.
Comment #5
problue solutionsThanks, but why would phpbbforum have named the table wrong, or why is it trying to use the wrong name?
Comment #6
problue solutionsI implemented phpbbforum on my main site (new installation, different databases etc) and I am no longer getting this error message, but nothing is being posted to the phpBB forum, all settings ARE correct, content type story has the feature enabled, when posting a story node, I select which forum to post it to etc. Nodes posts ok, no error message, but nothing is posted in the forum.
any ideas?
Comment #7
problue solutionsis this feature compatible with CCK fileds?
Comment #8
Treidge commentedWhy it's using wrong table name? Maybe it's just a bug. For CCK fields better ask developers of phpbb integraton module.
Do you try to rename table, as i mentioned before? As far as i know, errors displayed only first time - if there is no error message, this is not 100 % proof that all is fine. Maybe first time that error is displayed you just didn't notice it. On my site i'm able to get working phpbb submission only after i renamed table drupal2phpbb to phpbbforum_drupal2phpbb. After that, all works perfect.
Sorry for my ugly english :)
Comment #9
problue solutionsThanks for the info Treidge, I will try this on my test site.
Any input from the developer on this?
Comment #10
problue solutionsThanks Treidge, your suggestion worked.
Why has there been no reply from the developer on this? I'm assuming it's a bug in the code yes?
Also I'm assuming the drupal to phpbb posting does not work with CCK fields like I asked before?
This is an excellent module despite any problems :)
Comment #11
vb commentedI have fixed table prefix in beta2. The name should be drupal2phpbb. Read release notes to beta2.
Please tell me if beta2 still have CCK issue, i will fix.
Comment #12
fizk commented