Advanced search  

News:

cpg1.5.46 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter recently discovered vulnerabilities. It is important that all users who run version cpg1.5.44 or older update to this latest version as soon as possible.
[more]

Pages: 1 2 3 [4] 5   Go Down

Author Topic: MiniCMS plugin for cpg1.5.x  (Read 49191 times)

0 Members and 1 Guest are viewing this topic.

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 723
    • GMC Design Photo Gallery
Re: MiniCMS plugin for cpg1.5.x
« Reply #60 on: December 28, 2013, 02:13:24 am »

Reviewing the code - and examining the source of pages for editing both on the displayed pages, and via MiniCMS admin - conid and type are both passed and populated in all cases I can find.

From MiniCMS Admin and editing on displayed page - as well as inserting new content - all post directly to cms_edit.php with conid passed in form data:
Code: [Select]
<form name="post" method="post" action="index.php?file=minicms/cms_edit&amp;referer=index.php%3Ffile%3Dminicms%2Fcms_admin">
...
<td class="row2">
    <input type="text" value="0" class="post" tabindex="3" style="width: 50px;" maxlength="5" name="conid" />
</td>

and in cms_edit.php issuing the updates:
Code: [Select]
if(isset($request['submit']) && $request['submit']==$lang_minicms['submit'] && $request['id'] > -1){
    $MINICMS['conid']=(int)$request['conid'];
    $MINICMS['type']=(int)$request['type'];

Insert code for new items is handled just below the updates - driven when $request['id']=='-1' - and properly inserts the conid value passed in the form.

I believe this is a safe change to commit.
An excellent question to verify... :)
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15396
Re: MiniCMS plugin for cpg1.5.x
« Reply #61 on: January 02, 2014, 01:52:32 pm »

Suggested fix committed in SVN revision 8633. Version 2.3 attached to initial post. Thanks for your report.
Logged

netb

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 81
Re: MiniCMS plugin for cpg1.5.x
« Reply #62 on: August 14, 2014, 03:23:28 pm »

Hello, I have some weird problem when tried to work with MiniCMS.
I can't type anything in the text field when I create a new Content Title, also many of the editor buttons aren't working or when they open a popup and you close it, the whole area of the editor stays with different color as out of focus.

I have a test gallery setup here http://www.greatmusclebodies.com/gallery/ and test account is admin psw qwerty123
Logged

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 723
    • GMC Design Photo Gallery
Re: MiniCMS plugin for cpg1.5.x
« Reply #63 on: August 14, 2014, 03:29:37 pm »

Please don't post admin credentials... even for a test gallery..  We'll send you a message wit contact info if admin credentials are needed.
I logged in and changed the password - looking at your issue.
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 723
    • GMC Design Photo Gallery
Re: MiniCMS plugin for cpg1.5.x
« Reply #64 on: August 14, 2014, 03:35:19 pm »

Using your test gallery, I have edited existing, and created new items - including using editor buttons driving popups (find).
Can you try from a different computer or browser?  You might have an issue with a browser plugin?

Sending PM with changed admin password.
Greg
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

netb

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 81
Re: MiniCMS plugin for cpg1.5.x
« Reply #65 on: August 14, 2014, 04:09:18 pm »

Using your test gallery, I have edited existing, and created new items - including using editor buttons driving popups (find).
Can you try from a different computer or browser?  You might have an issue with a browser plugin?

Sending PM with changed admin password.
Greg

Hey, thanks! I tried with Opera and Chrome and it wasn't working. On IE I was able to type text but there weren't any of the edit buttons. Seems to work okay in Firefox though. Is this your browser? Now I'll have a different browser for every site, lol. ;D
Logged

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 723
    • GMC Design Photo Gallery
Re: MiniCMS plugin for cpg1.5.x
« Reply #66 on: August 14, 2014, 04:30:46 pm »

I was using Firefox...
I can recreate your problem using Chrome...

MiniCMS is packaged with a version of fckeditor that provides the wysiwyg editor. Guessing this is where the issue is...
There is a replacement - ckeditor ckeditor.com.
Perhaps this can be a simple drop in replacement?

I'll see if I can test this - I have already downloaded/used the new ckeditor elsewhere.
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

flamendeShana

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Re: MiniCMS plugin for cpg1.5.x
« Reply #67 on: October 08, 2014, 08:16:36 pm »

hello,
i have tryed this plugin on an older version, on this all was fine.

so i tryed to re test and install hole copermine,
so i have creata a new database, and installed copermine, all fine, all function workes, after create a dsign based on curve, i wanted to install the MiniCMS.
so i have download this version from start post (v2.3)
i have put all data in plugin folder,
i tryed to install it, press the GO! button.
and then i click at my main page.
there comes the following message:
Quote
Kritischer Fehler
Beim Ausführen einer Datenbank-Abfrage ist ein Fehler aufgetreten 
i'm sorry that the error message it's in german.
the tranalstion into english means
Quote
Critical error
on running one data base request a mistake occurred

i can't post a url, to my copermien instalaltion because it's run on a virtual machine at my home. on a Ubuntu-server with apache 2.4.7
and
php version 5.5.9

Server-Typ: MySQL
Server Version: 5.5.38-0ubuntu0.14.04.1 - (Ubuntu)
Protokoll-Version: 10

if you need more infomrations please ask
Logged

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 723
    • GMC Design Photo Gallery
Re: MiniCMS plugin for cpg1.5.x
« Reply #68 on: October 08, 2014, 09:06:35 pm »

Please enable debug mode so we can see a better error message.
http://documentation.coppermine-gallery.net/en/errors.htm#errors_debug_mode_manual
Instructions above for the case where you cannot access the config menu - since you are getting an error accessing the main page.

Greg
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

flamendeShana

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Re: MiniCMS plugin for cpg1.5.x
« Reply #69 on: October 08, 2014, 09:17:30 pm »

i have now enable the debug mode
this happens:
Code: [Select]
While executing query 'SELECT * FROM cpg15x_cms WHERE conid='0' AND type='0' ORDER BY cpos' in plugins/minicms/codebase.php on line 92

mySQL error: Table 'test.cpg15x_cms' doesn't exist

File: /var/www/html/foto/include/functions.inc.php - Zeile: 272

Logged

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 723
    • GMC Design Photo Gallery
Re: MiniCMS plugin for cpg1.5.x
« Reply #70 on: October 09, 2014, 04:02:53 am »

OK... looks like the install didn't create the 'cms' table.
I will guess that the id used for Coppermine to access the database doesn't have the authority to CREATE a table?

Easiest way to get out of this: in a tool like phpMyAdmin - edit the 'plugins' table and delete the row that contains 'minicms'...
That will let you back into the gallery.
Correct the error that caused the CREATE TABLE to fail - and reinstall the plugin.
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15396
Re: MiniCMS plugin for cpg1.5.x
« Reply #71 on: October 09, 2014, 09:19:41 am »

During the Coppermine installation the MySQL already needed CREATE permissions. So I guess it still has, unless you revoked it.

But I agree with Greg, that re-installing the plugin might solve the issue.
Logged

flamendeShana

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Re: MiniCMS plugin for cpg1.5.x
« Reply #72 on: October 14, 2014, 07:08:52 pm »

i ahve reinstalled the plugin
i stil get
Code: [Select]
While executing query 'SELECT * FROM cpg15x_cms WHERE conid='0' AND type='0' ORDER BY cpos' in plugins/minicms/codebase.php on line 92

mySQL error: Table 'test.cpg15x_cms' doesn't exist

(http://www11.pic-upload.de/thumb/14.10.14/thk136mihyye.jpg)
Logged

flamendeShana

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Re: MiniCMS plugin for cpg1.5.x
« Reply #73 on: October 14, 2014, 07:20:27 pm »

uh i cant edit my post, ok, i hope double post is ok in this case...

the rror message says
Code: [Select]
mySQL error: Table 'test.cpg15x_cms' doesn't exist
i cant find this table... on phpmyadmin
(http://www11.pic-upload.de/thumb/14.10.14/jenlhvdy6ab.jpg)

Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15396
Re: MiniCMS plugin for cpg1.5.x
« Reply #74 on: October 14, 2014, 08:52:51 pm »

Then you either need to fix the MySQL user's permissions (it needs CREATE, ALTER, INSERT, UPDATE permission) or run the queries in plugins/minicms/sql/basic.sql manually in e.g. phpMyAdmin. Don't forget to replace "CPG_" with your actual database prefix "cpg15x_".
Logged

flamendeShana

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Re: MiniCMS plugin for cpg1.5.x
« Reply #75 on: October 14, 2014, 09:35:40 pm »

i have change the user now from coppermine to root,
nothg has changed.
but the databse user "copermine" had all privileges too, (look at first shrenshot)

i'm not realy good in sql, how it works to create it manually?
Logged

flamendeShana

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Re: MiniCMS plugin for cpg1.5.x
« Reply #76 on: October 14, 2014, 09:47:27 pm »

ok... i found where to create it manualy...
i get a error
Code: [Select]
SQL-Befehl:

# Table structure for table `cpg15x__cms`
#
CREATE TABLE  `cpg15x_cms` (

 `ID` INT( 11 ) NOT NULL AUTO_INCREMENT ,
 `catid` INT( 11 ) NOT NULL DEFAULT  '0',
 `title` VARCHAR( 255 ) NOT NULL DEFAULT  '',
 `content` TEXT NOT NULL DEFAULT  '',
PRIMARY KEY (  `ID` ,  `catid` ) ,
FULLTEXT KEY  `title` (  `title` ,  `content` )
) AUTO_INCREMENT =1;

MySQL meldet: Dokumentation

#1214 - The used table type doesn't support FULLTEXT indexes
Logged

ron4mac

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Posts: 686
Re: MiniCMS plugin for cpg1.5.x
« Reply #77 on: October 14, 2014, 10:15:20 pm »

Default table creation for your MySQL must not be MyISAM.
Add ENGINE=MyISAM to the end of the CREATE TABLE statement.
Logged

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 723
    • GMC Design Photo Gallery
Re: MiniCMS plugin for cpg1.5.x
« Reply #78 on: October 14, 2014, 10:16:20 pm »

What version of MySQL are you using?
(go to the information tab - phpinfo as admin in Coppermine if you don't know...)

Appears your installation may be trying to create the table as InnoDB... rather than MyISAM..
http://stackoverflow.com/questions/20964269/1214-the-used-table-type-doesnt-support-fulltext-indexes
Before MySQL 5.6 Full-Text Search is supported only with MyISAM Engine.

Not sure where the default type is specified... You can add ENGINE=MyISAM to the CREATE (see examples at the link provided).

For Devs - Should the engine be specified in plugins creating tables? or what assumptions are made about the users setup?
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

flamendeShana

  • Coppermine newbie
  • Offline Offline
  • Posts: 11
Re: MiniCMS plugin for cpg1.5.x
« Reply #79 on: October 14, 2014, 10:24:15 pm »

Quote

Server: Localhost via UNIX socket
Server-Typ: MySQL
Server Version: 5.5.38-0ubuntu0.14.04.1 - (Ubuntu)
Protokoll-Version: 10
Benutzer: root@localhost
Server Zeichensatz: UTF-8 Unicode (utf8)

output of phpinfo:
mysql
MySQL Support   enabled
Active Persistent Links   0
Active Links   1
Client API version   5.5.38
MYSQL_MODULE_TYPE   external
MYSQL_SOCKET   /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE   -I/usr/include/mysql
MYSQL_LIBS   -L/usr/lib/x86_64-linux-gnu -lmysqlclient_r


Quote
Not sure where the default type is specified... You can add ENGINE=MyISAM to the CREATE (see examples at the link provided).
can you please say me where to ad this exactyl?
Code: [Select]
# Table structure for table `cpg15x__cms`
#

CREATE TABLE `cpg15x_cms` (
  `ID` int(11) NOT NULL auto_increment,
  `catid` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `content` text NOT NULL default '',
  PRIMARY KEY  (`ID`, `catid`),
  FULLTEXT KEY `title` (`title`,`content`)
) AUTO_INCREMENT=1 ;

#
# Table structure for table `cpg15x_cms_config`
#
cpg15x_cms_config (
  name varchar(40) NOT NULL default '',
  value varchar(255) NOT NULL default '',
  PRIMARY KEY  (name)
);

ALTER TABLE `cpg15x_cms` ADD `pos` int(11) NOT NULL default '0';
ALTER TABLE `cpg15x_cms` ADD `type` int(11) NOT NULL default '0';
ALTER TABLE `cpg15x_cms` CHANGE `catid` `conid` int(11) NOT NULL default '0';
ALTER TABLE `cpg15x_cms` CHANGE `pos` `cpos` int(11) NOT NULL default '0';

ALTER TABLE `cpg15x_cms` ADD `modified` TIMESTAMP NOT NULL;
ALTER TABLE `cpg15x_cms` ADD `start` DATETIME;
ALTER TABLE `cpg15x_cms` ADD `end` DATETIME;

INSERT INTO `cpg15x_cms` (conid,title,content,type) VALUES ('0','Welcome to Coppermine', 'Simple test of CPG MiniCMS','0');
INSERT INTO `cpg15x_cms_config` VALUES ('dbver', '0.0');
INSERT INTO `cpg15x_cms_config` VALUES ('redirect_index_php', '');
INSERT INTO `cpg15x_cms_config` VALUES ('related_size', 'thumb');
INSERT INTO `cpg15x_cms_config` VALUES ('editor', 'fckeditor');
INSERT INTO `cpg15x_cms_config` VALUES ('rss_enabled', '0');
INSERT INTO `cpg15x_cms_config` VALUES ('rss_description_length', '50');
INSERT INTO `cpg15x_cms_config` VALUES ('rss_include_image', '0');
INSERT INTO `cpg15x_cms_config` VALUES ('rss_image_size', 'thumb');


UPDATE `cpg15x_cms` SET `modified`=NOW() WHERE `modified`='0000-00-00 00:00:00';

# Cleanup - Values that shouldn't exist anymore:
ALTER TABLE `cpg15x_cms` DROP `pos`;

# Write this dbver to the config table
# This should match the DBVER constant in init.inc.php
UPDATE cpg15x_cms_config SET value='1.5.20' WHERE name='dbver';
Logged
Pages: 1 2 3 [4] 5   Go Up
 

Page created in 0.022 seconds with 20 queries.