foulu 
Contributor
  
Gender: 
Posts: 225
uhm
|
 |
« on: April 01, 2008, 06:46:11 am » |
|
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.phpas 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 eenemeenemuu (2009-05-08): release of version 2.0/beta/2Edit by eenemeenemuu (2009-05-28): release of version 2.0/beta/2aEdit by eenemeenemuu (2009-06-25): release of version 2.0/beta/2b
|
|
|
« Last Edit: June 25, 2009, 02:45:55 pm by eenemeenemuu »
|
Logged
|
|
|
|
Hein Traag
Dev Team member
   
Gender:
 Netherlands
Posts: 2153
A, B, Cpg
|
 |
« Reply #1 on: April 01, 2008, 03:08:12 pm » |
|
Good work foulo. Will test @home and let you know the outcome.
Cheers Hein
|
|
|
|
|
Logged
|
|
|
|
gavu
Coppermine newbie
Posts: 12
|
 |
« Reply #2 on: April 05, 2008, 11:42:05 am » |
|
thanks and good luck ... will install it now to test
|
|
|
|
|
Logged
|
it's not a bug, it's a feature
|
|
|
DaBe
Coppermine frequent poster
  
Posts: 109
|
 |
« Reply #3 on: April 05, 2008, 06:16:39 pm » |
|
hello is there a demo?
|
|
|
|
|
Logged
|
|
|
|
foulu 
Contributor
  
Gender: 
Posts: 225
uhm
|
 |
« Reply #4 on: April 05, 2008, 06:43:38 pm » |
|
|
|
|
|
|
Logged
|
|
|
|
DaBe
Coppermine frequent poster
  
Posts: 109
|
 |
« Reply #5 on: April 05, 2008, 07:28:51 pm » |
|
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?=
|
|
|
|
|
Logged
|
|
|
|
foulu 
Contributor
  
Gender: 
Posts: 225
uhm
|
 |
« Reply #6 on: April 05, 2008, 07:42:12 pm » |
|
I didn't try to install it with the modpack so I don't know. Could you post the error message here ?
|
|
|
|
|
Logged
|
|
|
|
DaBe
Coppermine frequent poster
  
Posts: 109
|
 |
« Reply #7 on: April 05, 2008, 08:12:43 pm » |
|
is on german: Kritischer Fehler Beim Ausführen einer Datenbank-Abfrage ist ein Fehler aufgetreten
Kritischer fehler = critical error Datenbank = datebase
|
|
|
|
|
Logged
|
|
|
|
foulu 
Contributor
  
Gender: 
Posts: 225
uhm
|
 |
« Reply #8 on: April 05, 2008, 08:27:44 pm » |
|
Sorry for didn't make it clear for you, I mean error message in debug mode.
|
|
|
|
|
Logged
|
|
|
|
DaBe
Coppermine frequent poster
  
Posts: 109
|
 |
« Reply #9 on: April 05, 2008, 08:42:01 pm » |
|
ah ok 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
|
|
|
|
|
Logged
|
|
|
|
Αndré
Dev Team member
   
Gender:
 Germany
Posts: 1947
|
 |
« Reply #10 on: April 06, 2008, 07:36:16 pm » |
|
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
|
|
|
|
|
Logged
|
|
|
|
foulu 
Contributor
  
Gender: 
Posts: 225
uhm
|
 |
« Reply #11 on: April 07, 2008, 04:17:45 am » |
|
ah ok 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".
|
|
|
|
|
Logged
|
|
|
|
gavu
Coppermine newbie
Posts: 12
|
 |
« Reply #12 on: April 07, 2008, 12:27:41 pm » |
|
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 
|
|
|
|
|
Logged
|
it's not a bug, it's a feature
|
|
|
DaBe
Coppermine frequent poster
  
Posts: 109
|
 |
« Reply #13 on: April 07, 2008, 06:18:29 pm » |
|
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?
|
|
|
|
|
Logged
|
|
|
|
foulu 
Contributor
  
Gender: 
Posts: 225
uhm
|
 |
« Reply #14 on: April 08, 2008, 04:09:37 am » |
|
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.
|
|
|
|
Logged
|
|
|
|
gavu
Coppermine newbie
Posts: 12
|
 |
« Reply #15 on: April 08, 2008, 07:41:46 am » |
|
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
|
|
|
|
|
Logged
|
it's not a bug, it's a feature
|
|
|
Hein Traag
Dev Team member
   
Gender:
 Netherlands
Posts: 2153
A, B, Cpg
|
 |
« Reply #16 on: April 08, 2008, 08:11:00 am » |
|
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 
|
|
|
|
|
Logged
|
|
|
|
DaBe
Coppermine frequent poster
  
Posts: 109
|
 |
« Reply #17 on: April 08, 2008, 06:25:24 pm » |
|
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
|
|
|
|
|
Logged
|
|
|
|
foulu 
Contributor
  
Gender: 
Posts: 225
uhm
|
 |
« Reply #18 on: April 08, 2008, 06:44:21 pm » |
|
use this: 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 ) ;
|
|
|
|
|
Logged
|
|
|
|
foulu 
Contributor
  
Gender: 
Posts: 225
uhm
|
 |
« Reply #19 on: April 08, 2008, 06:48:55 pm » |
|
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 !
|
|
|
|
|
Logged
|
|
|
|
|