I get the following error when trying to create a new thread appended to a new page node:

user warning: Unknown column 'forum_id' in 'field list' query: SELECT forum_id FROM vb_thread WHERE dr_nid = 1 in /home/myaccount/public_html/dev/modules/com2vb/com2vb.module on line 684.

Any ideas?

Comments

elia’s picture

elia commented

Hello.
You must run http://example.com/update.php for executing full installation process of COM2VB module - 2nd update function will create this field for you.

jasonbrice’s picture

jasonbrice commented

Hi,

Good advice!

I have run update.php, and had the following errors:

user warning: Can't DROP 'score'; check that column/key exists query: ALTER TABLE comments DROP score in /home/sbc/public_html/dev/modules/com2vb/com2vb.install on line 35.
user warning: Can't DROP 'users'; check that column/key exists query: ALTER TABLE comments DROP users in /home/sbc/public_html/dev/modules/com2vb/com2vb.install on line 36.
user warning: Duplicate key name 'pid' query: ALTER TABLE comments ADD INDEX pid (pid) in /home/sbc/public_html/dev/includes/database.mysql-common.inc on line 434.

Additionally, I cannot see the comments under the nodes. When the core module COMMENTS is installed and switched on, I can see them.

The Com2vb Settings page says:

Comments can be attached to any node, and their settings are below. The display comes in two types: a 'flat list' where everything is flush to the left side, and comments come in chronological order, and a 'threaded list' where replies to other comments are placed immediately below and slightly indented, forming an outline. They also come in two styles: 'expanded', where you see both the title and the contents, and 'collapsed' where you only see the title. Preview comment forces a user to look at their comment by clicking on a 'Preview' button before they can actually add the comment.

But I cannot see where to define the style of the Comments.

Thanks for your help!

Jason Brice

elia’s picture

elia commented
Category: support » bug

Hello!

This warnings are unimportant - I clone some update code from original COMMENT module for compatibility with all 6.x versions of Drupal. You can ignore it.

Check display mode of comments - it seems to me that you have mode "expanded threaded". This display mode not supported by COM2VB module. You must check it in workflow section in settings for all node's types.

jasonbrice’s picture

jasonbrice commented

Hi Elia,

Yes, I assumed the mysql warnings were not that important - deleting fields not there, and creating fields that already exist.

Sorry for being stupid, but I'm not sure where to find the display mode for comments. Where do I find it?

Thanks,
Jason

elia’s picture

elia commented

http://example.com/admin/content/node-type/blog
http://example.com/admin/content/node-type/page
http://example.com/admin/content/node-type/story
and so on

jasonbrice’s picture

jasonbrice commented

Got it. Thanks!

jasonbrice’s picture

jasonbrice commented
Category: bug » support
jasonbrice’s picture

jasonbrice commented
Category: bug » support

Hi Elia,

Here is an error I got when trying to unpublish a comment:
user warning: 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 'WHERE postid = 97617' at line 1 query: UPDATE vb3post SET visible = WHERE postid = 97617 in /home/myaccount/public_html/dev/modules/com2vb/com2vb.admin.inc on line 110.

Thanks,
Jason

jasonbrice’s picture

jasonbrice commented

Hi Elia,

And here is an error I got when I just tried to add a new user with "Create the same user in forum" unchecked.

Fatal error: Call to undefined function db_num_rows() in /home/sbc/public_html/dev/modules/com2vb/vbuser.inc on line 61

Thanks,
Jason

elia’s picture

elia commented

Here is an error I got when trying to unpublish a comment:
user warning: 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 'WHERE postid = 97617' at line 1 query: UPDATE vb3post SET visible = WHERE postid = 97617 in /home/myaccount/public_html/dev/modules/com2vb/com2vb.admin.inc on line 110.

Fixed. I hope :)
See development snapshot tonight.

elia’s picture

elia commented

And here is an error I got when I just tried to add a new user with "Create the same user in forum" unchecked.
Fatal error: Call to undefined function db_num_rows() in /home/sbc/public_html/dev/modules/com2vb/vbuser.inc on line 61

Function db_num_rows() not used in D6. I forgot this during creating unified module vbuser.inc. This function replaced with PHP native function msql_num_rows().

See development snapshot tonight.

elia’s picture

elia commented
Status: Active » Closed (fixed)
jasonbrice’s picture

jasonbrice commented

Hi Elia,

Here is an error I got when trying to unpublish a comment:
user warning: 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 'WHERE postid = 97617' at line 1 query: UPDATE vb3post SET visible = WHERE postid = 97617 in /home/myaccount/public_html/dev/modules/com2vb/com2vb.admin.inc on line 110.

Fixed. I hope :)
See development snapshot tonight.

Sorry it took so long to get back to you - there was an earthquake here!

No code errors.

And here is an error I got when I just tried to add a new user with "Create the same user in forum" unchecked.
Fatal error: Call to undefined function db_num_rows() in /home/sbc/public_html/dev/modules/com2vb/vbuser.inc on line 61

Function db_num_rows() not used in D6. I forgot this during creating unified module vbuser.inc. This function replaced with PHP native function msql_num_rows().

See development snapshot tonight.

Yes, fixed, thanks!