Coppermine Forum Plugin (cpgforum)

[foulu]

Hi everyone,

The coppermine simple forum plugin reach version 2.0/beta/0 and the old 1.x.x version is discontinue. From now, I will use

http://cpgsf.amfcvn.net/forum.php

as the support forum for the plugin. Only one topic is just not enough for me.

Please check my forum for release files.

Thanks !


Edit by André (2009-05-08): release of version 2.0/beta/2
Edit by André (2009-05-28): release of version 2.0/beta/2a
Edit by André (2009-06-25): release of version 2.0/beta/2b
Edit by André (2010-05-08): release of version 2.0/beta/5 (standalone version for cpg1.5.x)

[Hein Traag]

Good work foulo. Will test @home and let you know the outcome.

Cheers
Hein

[gavu]

thanks and good luck ... will install it now to test

[DaBe]

hello is there a demo?

[foulu]

http://kak.amfcvn.net/cpgforum/forum.php <-- this is a outdate demo version 

[DaBe]

looks nice..but dont worked for me..

I have installed and want go to the forum admin..there I have a critical database error.

Is there avaible with the modpack?=

[foulu]

I didn't try to install it with the modpack so I don't know. Could you post the error message here ?

[DaBe]

is on german:
Kritischer Fehler
Beim Ausführen einer Datenbank-Abfrage ist ein Fehler aufgetreten

Kritischer fehler = critical error
Datenbank = datebase

[foulu]

Sorry for didn't make it clear for you, I mean error message in debug mode.

[DaBe]

ah ok

Code Select Expand

While executing query "SELECT * FROM `cpg54x_fr_categories` ORDER BY cat_order ASC;" on 0

mySQL error: Table 'mygallery.cpg54x_fr_categories' doesn't exist


/home/www/web619/html/include/functions.inc.php - Zeile: 248

I have cpg 1.4.16 with the modpack 1.4.16

[Αndré]

good job foulu.. installation run without errors and it seems to work correctly..
i was looking for a forum plugin since a while waiting for a final release

-
muu

[foulu]

ah ok

Code Select Expand

While executing query "SELECT * FROM `cpg54x_fr_categories` ORDER BY cat_order ASC;" on 0

mySQL error: Table 'mygallery.cpg54x_fr_categories' doesn't exist


/home/www/web619/html/include/functions.inc.php - Zeile: 248

I have cpg 1.4.16 with the modpack 1.4.16

Did you install the plugin from plugin manager page ? I named it "adaptor".

[gavu]

it works great, only i found a bug... if you try to delete a post... it crashes mysql error

While executing query "SELECT COUNT(*) FROM `cpg14x_fr_topics` WHERE msg_id='2';" on 0

mySQL error: Unknown column 'msg_id' in 'where clause'

can't wait to see it final

[DaBe]

yes install and deinstall and install again...but the forum dont work!

can you send me the .sql file, than I can make the datebase manuelly?

[foulu]

it works great, only i found a bug... if you try to delete a post... it crashes mysql error

While executing query "SELECT COUNT(*) FROM `cpg14x_fr_topics` WHERE msg_id='2';" on 0

mySQL error: Unknown column 'msg_id' in 'where clause'

can't wait to see it final Wink

I fixed this bug, update your file with the lastest version (I update the archive).

yes install and deinstall and install again...but the forum dont work!

can you send me the .sql file, than I can make the datebase manuelly?

I attach it with this message.

[gavu]

it worked perferct

i will install it on my production server as soon as i have the ability to make read only topics so i can use it as announcements

[Hein Traag]

Foulu

On your own site it says "Forum Stasts" instead of "Forum Stats"

Cheers
Hein

p.s. On my testbed it installed and works perfectly 

[DaBe]

hello

I have put the code from the install.txt in the phpMyAdmin...

but I have following error:
CREATE TABLE IF NOT EXISTS `cpg54x_fr_boards` (
`board_id` smallint( 5 ) unsigned NOT NULL AUTO_INCREMENT ,
`cat_id` tinyint( 4 ) unsigned NOT NULL default '0',
`child_level` tinyint( 4 ) unsigned NOT NULL default '0',
`parent_id` smallint( 5 ) unsigned NOT NULL default '0',
`board_order` smallint( 5 ) unsigned NOT NULL default '0',
`last_msg_id` int( 10 ) unsigned NOT NULL default '0',
`updated_msg_id` int( 10 ) unsigned NOT NULL default '0',
`name` tinytext NOT NULL ,
`description` text NOT NULL ,
`topics` mediumint( 8 ) unsigned NOT NULL default '0',
`posts` mediumint( 8 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `board_id` )
) CREATE TABLE IF NOT EXISTS `cpg54x_fr_categories` (
`cat_id` tinyint( 4 ) unsigned NOT NULL AUTO_INCREMENT ,
`cat_order` tinyint( 4 ) unsigned NOT NULL default '0',
`name` tinytext NOT NULL ,
PRIMARY KEY ( `cat_id` )
) CREATE TABLE IF NOT EXISTS `cpg54x_fr_message_icons` (
`icon_id` smallint( 5 ) unsigned NOT NULL AUTO_INCREMENT ,
`title` varchar( 80 ) NOT NULL default '',
`filename` varchar( 80 ) NOT NULL default '',
`icon_order` smallint( 5 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `icon_id` )
) INSERT INTO `cpg54x_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 ) ;

MySQL meldet: Dokumentation
#1064 - 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 'CREATE TABLE IF NOT EXISTS `cpg54x_fr_categories` (
  `cat_id`
sry Im a noob in english and php

[foulu]

use this:

Code Select Expand

CREATE TABLE IF NOT EXISTS `cpg54x_fr_boards` (
`board_id` smallint( 5 ) unsigned NOT NULL AUTO_INCREMENT ,
`cat_id` tinyint( 4 ) unsigned NOT NULL default '0',
`child_level` tinyint( 4 ) unsigned NOT NULL default '0',
`parent_id` smallint( 5 ) unsigned NOT NULL default '0',
`board_order` smallint( 5 ) unsigned NOT NULL default '0',
`last_msg_id` int( 10 ) unsigned NOT NULL default '0',
`updated_msg_id` int( 10 ) unsigned NOT NULL default '0',
`name` tinytext NOT NULL ,
`description` text NOT NULL ,
`topics` mediumint( 8 ) unsigned NOT NULL default '0',
`posts` mediumint( 8 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `board_id` ));
CREATE TABLE IF NOT EXISTS `cpg54x_fr_categories` (
`cat_id` tinyint( 4 ) unsigned NOT NULL AUTO_INCREMENT ,
`cat_order` tinyint( 4 ) unsigned NOT NULL default '0',
`name` tinytext NOT NULL ,
PRIMARY KEY ( `cat_id` ));
CREATE TABLE IF NOT EXISTS `cpg54x_fr_message_icons` (
`icon_id` smallint( 5 ) unsigned NOT NULL AUTO_INCREMENT ,
`title` varchar( 80 ) NOT NULL default '',
`filename` varchar( 80 ) NOT NULL default '',
`icon_order` smallint( 5 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `icon_id` ));
INSERT INTO `cpg54x_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 ) ;

[foulu]

Foulu

On your own site it says "Forum Stasts" instead of "Forum Stats"

Cheers
Hein

p.s. On my testbed it installed and works perfectly 

Sorry, I didn't notice about it. Thanks !