1
cgunther
CBB 2.32a Could not insert forum post
  • 2006/1/23 18:37

  • cgunther

  • Just popping in

  • Posts: 59

  • Since: 2005/3/27


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"

2
cgunther
Re: CBB 2.32a Could not insert forum post
  • 2006/1/25 23:25

  • cgunther

  • Just popping in

  • Posts: 59

  • Since: 2005/3/27


Bumpity - bump - bump - bump!

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

3
draj
Re: Re: CBB 2.32a Could not insert forum post
  • 2006/1/29 7:33

  • draj

  • Quite a regular

  • Posts: 271

  • Since: 2005/6/23


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.

4
cgunther
Re: Re: CBB 2.32a Could not insert forum post
  • 2006/1/31 19:34

  • cgunther

  • Just popping in

  • Posts: 59

  • Since: 2005/3/27


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"

5
draj
Re: Re: CBB 2.32a Could not insert forum post
  • 2006/1/31 19:43

  • draj

  • Quite a regular

  • Posts: 271

  • Since: 2005/6/23


Hey, I do not beleive this!

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

6
cgunther
Re: Re: CBB 2.32a Could not insert forum post
  • 2006/1/31 21:50

  • cgunther

  • Just popping in

  • Posts: 59

  • Since: 2005/3/27


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"

7
draj
Re: Re: CBB 2.32a Could not insert forum post
  • 2006/2/1 10:33

  • draj

  • Quite a regular

  • Posts: 271

  • Since: 2005/6/23


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!

8
cgunther
Re: Re: CBB 2.32a Could not insert forum post
  • 2006/2/3 21:20

  • cgunther

  • Just popping in

  • Posts: 59

  • Since: 2005/3/27


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"

Login

Who's Online

206 user(s) are online (116 user(s) are browsing Support Forums)


Members: 0


Guests: 206


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits