Coppermine forum plugin (cpgforum) for cpg1.5.x

[Αndré]

You need to create at least one forum category before you can start threads.

[ninouee]

Hello

Thank you for your answer.

But, how can i creat a category? I search on the first message of this topik and i dont understant how the can do that.

[ninouee]

Hello, i'm Sorry for the 2 posts but i find my problem: I find where was the forum administrator.

Thank You for your work and the reply! 

[computel]

I'm getting this error when I installed the login and looked at the forum or forum manager

Array (

• => Error Number: 1146 [1] => Table 'archives_arc1.cpg15x_fr_categories' doesn't exist [2] => SELECT * FROM cpg15x_fr_categories ORDER BY cat_order asc )
  
  Thanks
  

[Αndré]

It seems that you haven't properly installed the plugin. Please try to re-install again and make sure you hit the install button at the installer.

[computel]

it's not installing the database from what I can see, As I looked in the database and nothing is added. I downloaded the file again and uploaded still the same problem

Code Select Expand

Performing database updates
CREATE TABLE IF NOT EXISTS `cpg15x_fr_boards` ( `board_id` smallint(5) NOT NULL auto_increment, `cat_id` tinyint(4) NOT NULL default '0', `child_level` tinyint(4) NOT NULL default '0', `parent_id` smallint(5) NOT NULL default '0', `board_order` smallint(5) NOT NULL default '0', `last_msg_id` int(10) NOT NULL default '0', `updated_msg_id` int(10) NOT NULL default '0', `name` tinytext NOT NULL, `description` text NOT NULL, `topics` mediumint(8) NOT NULL default '0', `posts` mediumint(8) NOT NULL default '0', PRIMARY KEY (`board_id`) ) TYPE=MyISAM Already Done
CREATE TABLE IF NOT EXISTS `cpg15x_fr_categories` ( `cat_id` tinyint(4) NOT NULL auto_increment, `cat_order` tinyint(4) NOT NULL default '0', `name` tinytext NOT NULL, PRIMARY KEY (`cat_id`) ) TYPE=MyISAM Already Done
CREATE TABLE IF NOT EXISTS `cpg15x_fr_message_icons` ( `icon_id` smallint(5) NOT NULL auto_increment, `title` varchar(80) NOT NULL default '', `filename` varchar(80) NOT NULL default '', `icon_order` smallint(5) NOT NULL default '0', PRIMARY KEY (`icon_id`) ) TYPE=MyISAM AUTO_INCREMENT=14 Already Done
INSERT INTO `cpg15x_fr_message_icons` (`icon_id`, `title`, `filename`, `icon_order`) VALUES (1, 'Post', 'icon1', 0), (2, 'Smile', 'icon2', 1), (3, 'Big smile', 'icon3', 2), (4, 'Angry', 'icon4', 3), (5, 'Cool', 'icon5', 4), (6, 'Sad', 'icon6', 5), (7, 'Wink', 'icon7', 6), (8, 'Comment', 'icon8', 7), (9, 'Magnify', 'icon9', 8), (10, 'Icon', 'icon10', 9), (11, 'Lamp', 'icon11', 10), (12, 'Bug', 'icon12', 11), (13, 'Wheel', 'icon13', 12) Already Done
CREATE TABLE IF NOT EXISTS `cpg15x_fr_messages` ( `msg_id` int(10) NOT NULL auto_increment, `topic_id` mediumint(8) NOT NULL default '0', `board_id` smallint(5) NOT NULL default '0', `poster_time` int(10) NOT NULL default '0', `poster_id` mediumint(8) NOT NULL default '0', `modified_id` int(10) NOT NULL default '0', `subject` tinytext NOT NULL, `poster_name` tinytext NOT NULL, `poster_email` tinytext NOT NULL, `poster_ip` tinytext NOT NULL, `smileys_enabled` tinyint(4) NOT NULL default '1', `modified_time` int(10) NOT NULL default '0', `modified_name` tinytext NOT NULL, `body` text NOT NULL, `icon` varchar(16) NOT NULL default '1', PRIMARY KEY (`msg_id`) ) TYPE=MyISAM Already Done
CREATE TABLE IF NOT EXISTS `cpg15x_fr_topics` ( `topic_id` mediumint(8) NOT NULL auto_increment, `is_sticky` tinyint(4) NOT NULL default '0', `board_id` smallint(5) NOT NULL default '0', `first_msg_id` int(10) NOT NULL default '0', `last_msg_id` int(10) NOT NULL default '0', `started_member_id` int(8) NOT NULL default '0', `updated_member_id` int(8) NOT NULL default '0', `poll_id` mediumint(8) NOT NULL default '0', `replies` int(10) NOT NULL default '0', `views` int(10) NOT NULL default '0', `locked` tinyint(4) NOT NULL default '0', PRIMARY KEY (`topic_id`) ) TYPE=MyISAM Already Done
INSERT INTO `cpg15x_config` (name, value) VALUES ('fr_version', '2.0 Beta') OK
INSERT INTO `cpg15x_config` (name, value) VALUES ('fr_title', 'Coppermine Simple Forum') OK
INSERT INTO `cpg15x_config` (name, value) VALUES ('fr_guest_browse', 1) OK
INSERT INTO `cpg15x_config` (name, value) VALUES ('fr_guest_post', 1) OK
INSERT INTO `cpg15x_config` (name, value) VALUES ('fr_hot_topic_msg', 20) OK
INSERT INTO `cpg15x_config` (name, value) VALUES ('fr_topic_per_page', 20) OK
INSERT INTO `cpg15x_config` (name, value) VALUES ('fr_msg_max_size', 512) OK
INSERT INTO `cpg15x_config` (name, value) VALUES ('fr_msg_per_page', 15) OK
INSERT INTO `cpg15x_config` (name, value) VALUES ('fr_max_word_length', 30) OK
INSERT INTO `cpg15x_config` (name, value) VALUES ('fr_gap_time', 30) OK
INSERT INTO `cpg15x_config` (name, value) VALUES ('fr_avatar_size', 100) OK
INSERT INTO `cpg15x_config` (name, value) VALUES ('fr_signature_max_size', 512) OK
ALTER TABLE `cpg15x_users` ADD `fr_avatar` varchar(255) NOT NULL DEFAULT '' OK
ALTER TABLE `cpg15x_users` ADD `fr_signature` text NOT NULL DEFAULT '' OK
Performing database updates
UPDATE `cpg15x_config` SET value='2.1/Beta/9' where name='fr_version' OK
CREATE TABLE IF NOT EXISTS `cpg15x_fr_notify` ( `user_id` int(10) NOT NULL default '0', `topic_id` mediumint(8) NOT NULL default '0', `board_id` smallint(5) NOT NULL default '0', `send` tinyint(1) NOT NULL default '0' ) TYPE=MyISAM Already Done
INSERT INTO `cpg15x_config` (name, value) VALUES ('fr_time_online_checking', 5) OK
CREATE TABLE IF NOT EXISTS `cpg15x_fr_badwords` ( `word_id` int(10) NOT NULL auto_increment, `word` varchar(45) NOT NULL default '', `replace` varchar(45) NOT NULL default '', PRIMARY KEY (`word_id`) ) TYPE=MyISAM Already Done
INSERT INTO `cpg15x_config` (name, value) VALUES ('fr_msg_icons', 1) OK
ALTER TABLE `cpg15x_fr_messages` ALTER `icon` SET DEFAULT '1' Already Done

[gmc]

The message log indicates 'already done' for the create table statements... I would have expected 'OK' since the statement is coded 'IF NOT EXISTS'. If the tables don't exist, make sure the user specified in includes/config.inc.php has 'CREATE TABLE' privileges in MySQL..
It should if you used the same user when you installed CPG??
In shared hosting, it is typically specified in cPanel or equivalent.

If that is ok, try executing one of the CREATE statements from a tool like phpMyAdmin... And see if you get an error.

[Αndré]

I just tried to install the forum and it also doesn't create the tables. It works as expected if I remove

Code Select Expand

TYPE=MyISAM
from the files in the sql/ folder.

[Αndré]

cpg1.5.x_plugin_cpgforum_v2.1-beta10.zip attached to initial post. It fixes the latest issue and also contain some other improvements.

[computel]

Thanks it worked.

[sphoto]

I downloaded the forum from the top link on 2/12/14. According to the plugin manager it is version 2.1 Beta. My coppermine version is 1.5.24. PHP version is 5.3.24 and MYSQL version is 5.6.

When trying to make a post in a board on my site I am getting the following error. Wondering if anyone has any ideas.

Array (

• => Error Number: 1364 [1] => Field 'poster_email' doesn't have a default value [2] => INSERT INTO cpg15x_fr_messages (icon, subject, body, poster_time, poster_id, poster_name, poster_ip, smileys_enabled, topic_id, board_id)

[gmc]

Bridged with phpBB3 by chance?
Try this link if so:  https://www.phpbb.com/kb/article/doesnt-have-a-default-value-errors/.
I recently had to use this technique with a phpBB3 installation at 3.0.7. Worked very well.
Or is this a plugin table?
Problem seems same (and maybe same cause) - but may need a different solution...

[sphoto]

Bridged with phpBB3 by chance?

No bridge... completely standalone.

[Αndré]

Have you tried to post as guest or registered user?

[Αndré]

Have you tried to post as guest or registered user?

It seems that this doesn't matter. Please set a default value for the database field poster_email (with a tool like phpMyAdmin). If don't know how or haven't any posts in your forum yet, we also could re-install the forum plugin with an updated SQL file.

[sphoto]

Thanks André. I'll try that later today and get back to you. Could it be happening due to me not having email set up on my server in PHP? I tried posting as a registered user. Tried selecting notification on and off. This is a brand new install of Coppermine and the Forum.

If I can't get this to work, is there a private message plugin that works well? I don't need the functionallity of a forum, I just need a messenger.

[Αndré]

There's a private messaging plugin, but your forum issue is very easy to fix.

[406man]

Are there any plans to make this plugin available for CPG 1.6 ?

[ron4mac]

The 'plan' is to upgrade plugins by frequency of request for it. You can contact the plugin author to see if they will upgrade it by PM'ing them. If the author has abandoned the plugin, then, if there is still some demand, someone else may be willing to step in and upgrade it.