xoops forums

cgunther

Just popping in
Posted on: 2006/1/23 18:37
cgunther
cgunther (Show more)
Just popping in
Posts: 59
Since: 2005/3/27
#1

CBB 2.32a Could not insert forum post

I have recently upgraded a site to XOOPS 2.2.3a. This update also included update of CBB to version 2.32a. I have not had any problems with other modules or site functions with the 2.2.3a version of xoops, however CBB is not letting any user post to the forum. I ran the update script and reset all of the forum permissions, I also checked in the XOOPS admin groups to make sure permissions were correct. No posts, topics or categories are missing. The error I get on submitting a post says, "Could not insert forum post." Any ideas?
"Your motherboard wears Army chips"

cgunther

Just popping in
Posted on: 2006/1/25 23:25
cgunther
cgunther (Show more)
Just popping in
Posts: 59
Since: 2005/3/27
#2

Re: CBB 2.32a Could not insert forum post

Bumpity - bump - bump - bump!

Still can't post to forum under any profile...brain reeeealy hurts now!
"Your motherboard wears Army chips"

draj

Quite a regular
Posted on: 2006/1/29 7:33
draj
draj (Show more)
Quite a regular
Posts: 271
Since: 2005/6/23
#3

Re: Re: CBB 2.32a Could not insert forum post

Hi!

I am using 2.31 with 2.2.4 (now with the upgrade)

I have seen this and could only say that you need to correct the permissions like I did.

I checked the module permissions. Thereafter, I launched a default permission template and then applied to it.

It then got solved.

cgunther

Just popping in
Posted on: 2006/1/31 19:34
cgunther
cgunther (Show more)
Just popping in
Posts: 59
Since: 2005/3/27
#4

Re: Re: CBB 2.32a Could not insert forum post

Thanks for trying. I have cleared the cache and templates_c, updated the module, verified the correct version (2.32a), reset and applied the default permission template and still no ability to post new topics or reply from ANY login. All of the forum information is displaying as it did previous to the update, I just can't add anything new.

Stumped and switching to a different forum in a week. The member board that I report to is demanding this.
"Your motherboard wears Army chips"

draj

Quite a regular
Posted on: 2006/1/31 19:43
draj
draj (Show more)
Quite a regular
Posts: 271
Since: 2005/6/23
#5

Re: Re: CBB 2.32a Could not insert forum post

Hey, I do not beleive this!

Still for the community it would be in the interest of others to publish debug info...

cgunther

Just popping in
Posted on: 2006/1/31 21:50
cgunther
cgunther (Show more)
Just popping in
Posts: 59
Since: 2005/3/27
#6

Re: Re: CBB 2.32a Could not insert forum post

CBB Version before upgrade was 1.13

sql error:
INSERT INTO mydatabasename_bb_posts ( post_id, pid, topic_id, forum_id, post_time, uid, poster_ip, poster_name, subject, dohtml, dosmiley, doxcode, doimage, dobr, icon, attachsig, attachment, approved, post_karma, require_reply) VALUES (0, 91, 45, 15, 1138741614, 1, 414230653, '', 'Re: Solar for Computers', 0, 1, 1, 1, 1, '', 1, '', 1, 0, 0)
Error number: 2013
Error message: Lost connection to MySQL server during query
( 0.010761)

I did a check/repair on the MySQL tables and found no errors.
"Your motherboard wears Army chips"

draj

Quite a regular
Posted on: 2006/2/1 10:33
draj
draj (Show more)
Quite a regular
Posts: 271
Since: 2005/6/23
#7

Re: Re: CBB 2.32a Could not insert forum post

Hi!

Are the table fields in mydatabasename_bb_posts the same as it should be in the new format of 2.32 mentioned in sql file? Here is what I have:

Quote:

CREATE TABLE mydatabasename_bb_posts (
post_id int(8) unsigned NOT NULL auto_increment,
pid int(8) NOT NULL default '0',
topic_id int(8) NOT NULL default '0',
forum_id int(4) NOT NULL default '0',
post_time int(10) NOT NULL default '0',
uid int(10) unsigned NOT NULL default '0',
poster_name varchar(255) NOT NULL default '',
poster_ip int(11) NOT NULL default '0',
subject varchar(255) NOT NULL default '',
dohtml tinyint(1) NOT NULL default '0',
dosmiley tinyint(1) NOT NULL default '1',
doxcode tinyint(1) NOT NULL default '1',
dobr tinyint(1) NOT NULL default '1',
doimage tinyint(1) NOT NULL default '1',
icon varchar(25) NOT NULL default '',
attachsig tinyint(1) NOT NULL default '0',
approved int(1) NOT NULL default '1',
post_karma int(10) NOT NULL default '0',
attachment text,
require_reply int(1) NOT NULL default '0',
PRIMARY KEY (post_id),
KEY uid (uid),
KEY pid (pid),
KEY subject (subject(40)),
KEY forumid_uid (forum_id,uid),
KEY topicid_uid (topic_id,uid),
KEY topicid_postid_pid (topic_id,post_id,pid),
FULLTEXT KEY search (subject)
) TYPE=MyISAM;


I am using 2.31! The moment I did an upgrade, it made some nightmare Problems and the entire XOOPS installation did not work. I was not able to figureout where was the problem as I made many modules active and installed.

So the above is a 2.31 format and have no knowledge, if there is a change in 2.32a!

cgunther

Just popping in
Posted on: 2006/2/3 21:20
cgunther
cgunther (Show more)
Just popping in
Posts: 59
Since: 2005/3/27
#8

Re: Re: CBB 2.32a Could not insert forum post

Had to work on another project for a bit but I'm back to this one.

My sql table is identical to the sample posted by deepy.
"Your motherboard wears Army chips"