This is a port of the cpg1.4.x plugin MiniCMS (http://forum.coppermine-gallery.net/index.php/topic,62339.0.html).
Quote from: Joachim Müller on November 04, 2009, 07:55:01 AM
What it does
The MiniCMS plugin is a minimalistic Content Mangement System which allows the gallery admin to add / edit / delete pages. Typically this will be used by people who just want to add a few pages like About, Contact etc to their installs of coppermine but do not want full fledged CMS like Joomla.
It currently includes the ability to create stand-alone pages and add content to any category, album, or intermediate image page.
It has a WYSIWYG editor which works in IE and Mozilla, and respects the admin rights from Coppermine
Very good job.
Why this plugin does not appears in the list http://coppermine-gallery.net/plugins.php?cpg_version=5&sort=category&submit=#start (http://coppermine-gallery.net/plugins.php?cpg_version=5&sort=category&submit=#start)
That list hasn't been updated since a while.
Hi!
Got a little problem with this plugin. Upload via ftp was no problem, the plugin is detected in the plugin manager, but I don´t accomplish the minimum requirements and I don´t find any informations about them.
My system:
CPG 1.5.8 (stable)
PHP 5.2.6
MySQL 5.0.51a
MiniCMS (minicms): v2.1
Link: www.edition-steinbach.de
Actually, this should work, or not? Got anyone an idea?
So long...
Pat
Thanx André.
It was sooooo easy, but I don´t see the wood for the trees. Now it works great!
So long...
Pat
Have never used minicms before, but decided to give it a try. Seems to be working without problems but I did get one message line that didn't quite look right when I installed it, this was the message:-
1091: Can't DROP 'pos'; check that column/key exists
Should I be doing anything about it?
http://www.sharpos-world.co.uk/BB3cpg/
Only 1 minicms page entered at present and links from it do work.
I assume it's that line in
sql/basic.sql:
QuoteALTER TABLE `CPG_cms` DROP `pos`;
The column
pos should exist, as it has been added some lines before
QuoteALTER TABLE `CPG_cms` ADD `pos` int(11) NOT NULL default '0';
If everything works fine you can just ignore that message.
through mini cms I inserted a table and where there are empty cells are automatically filled with symbols of small squares. I thank those who can explain what may be the cause.
Quote from: VEGA on December 07, 2010, 09:03:50 AM
through mini cms I inserted a table and where there are empty cells are automatically filled with symbols of small squares. I thank those who can explain what may be the cause.
Post a link to your gallery, especially to the section where the issue occurs.
ops..in home page http://www.maranimage.it/index.php (http://www.maranimage.it/index.php)
(i disabled the plugin)
thanks
Hi all,
first the link to my Gallery : http://flyaway-photopassion.zxq.net/Gallery/
I've uploaded the plugin MiniCMS and I've installed it.
Now, it seems to have a problem ... I mean, I can create a new article, but when I want to edit it, I think that edit commands are missing.
See images on attachment.
And thanks for help.
Regards.
Bigfart10
Quote from: VEGA on December 07, 2010, 09:03:50 AM
through mini cms I inserted a table and where there are empty cells are automatically filled with symbols of small squares
Doesn't happen in my local testbed. Please post the source code of your table.
Quote from: bigfart10 on December 07, 2010, 11:52:39 AM
when I want to edit it, I think that edit commands are missing.
Works as expected in my local testbed. You have to enable JavaScript to use the FCKeditor. Also make sure you've uploaded all plugin files.
Quote from: Αndré on December 07, 2010, 12:06:48 PM
Doesn't happen in my local testbed. Please post the source code of your table.
<p>
<table border="1" cellspacing="1" cellpadding="2" width="371" align="left" style="width: 371px; height: 24px">
<tbody>
<tr>
<td bgcolor="#cc3300" style="text-align: center"><span style="color: #ffffff"><span style="font-size: larger"><strong>Reportage Inseriti</strong></span></span></td>
</tr>
</tbody>
</table>
</p>
<p style="text-align: left">�</p>
<p style="text-align: left">�</p>
<p style="text-align: left">
<table border="0" cellspacing="1" cellpadding="2" width="376" align="left" height="129" style="width: 376px; height: 129px">
<tbody>
<tr>
<td bgcolor="#ffffff" style="text-align: left">
<p>�</p>
</td>
<td bgcolor="#ffffff" style="text-align: left">
<p style="text-align: left"><span style="font-family: Verdana"><strong><span style="font-size: smaller"><span style="color: #000000"><span style="font-family: Verdana"><strong><span style="font-size: smaller"><span style="color: #000000"><a target="_blank" href="http://www.maranimage.it/thumbnails.php?album=88"><img border="0" alt="" width="195" height="50" src="/userfiles/camucia(1).jpg" /></a></span></span></strong></span></span><span style="color: #ff0000">(</span></span></strong></span><span style="font-family: Verdana"><strong><span style="font-size: larger"><a target="_blank" href="http://www.gareclassiche.it/camucia.htm"><span style="font-size: smaller"><span style="color: #ff0000">info sull'evento</span></span></a></span><span style="font-size: smaller"><span style="color: #ff0000">)</span></span></strong></span></p>
</td>
<td bgcolor="#ffffff" style="text-align: left">�</td>
</tr>
<tr>
<td bgcolor="#ffffff" valign="middle" style="text-align: left">�</td>
<td bgcolor="#ffffff" valign="middle" style="text-align: left">
<p><span style="font-family: Verdana"><strong><span style="font-size: smaller"><font color="#000000"><span style="font-family: Verdana"><strong><span style="font-size: smaller"><span style="color: #000000"><a target="_blank" href="http://www.maranimage.it/thumbnails.php?album=87"><img border="0" alt="" width="195" height="50" src="/userfiles/sanfelice.jpg" /></a></span></span></strong></span></font></span></strong></span><font color="#000000" size="2"><span style="color: #ff0000"><span style="font-size: smaller"><strong><span style="font-family: Verdana">�<a href="http://www.fotoincontri.net/"><span style="color: #ff0000">(info sull'evento)</span></a></span></strong></span></span></font></p>
</td>
<td bgcolor="#ffffff" valign="middle" style="text-align: left">�</td>
</tr>
<tr>
<td bgcolor="#ffffff" valign="middle" style="text-align: left">�</td>
<td bgcolor="#ffffff" valign="middle" style="text-align: left">
<p><a target="_blank" href="http://www.maranimage.it/thumbnails.php?album=47"><img border="0" alt="" src="/userfiles/polo.jpg" /></a><span style="color: #ff0000"><span style="font-size: smaller"><strong><span style="font-family: Verdana"><a target="_blank" href="http://www.argentariopoloclub.com/"><span style="color: #ff0000"><u>(info sull'evento)</u></span></a></span></strong></span></span></p>
</td>
<td bgcolor="#ffffff" valign="middle" style="text-align: left">�</td>
</tr>
</tbody>
</table>
</p>
<p style="text-align: left">
<table border="1" cellspacing="1" cellpadding="2" width="371" align="center" style="width: 371px; height: 24px">
<tbody>
<tr>
<td bgcolor="#cc3300" style="text-align: center"><span style="color: #ffffff"><span style="font-size: larger"><strong>Eventi Fotografici in Italia</strong></span></span></td>
</tr>
<tr>
<td bgcolor="#ffffff" style="text-align: center">
<p><strong><span style="font-family: Comic Sans MS"><span style="background-color: #ffffff"><span style="background-color: #ffffff"><span style="font-size: smaller">di varie tematiche utili per spunti di reportage fotografico.Per alcuni eventi inserita una recensione con suggerimenti e impressioni.</span></span></span></span></strong></p>
<p><span style="background-color: #ffff00"><strong><span style="font-family: Comic Sans MS"><span style="font-size: smaller">Sono gradite <a target="_blank" href="http://fotorisorse.altervista.org/">a questo link </a>vostre segnalazioni e recensioni</span></span></strong></span></p>
</td>
</tr>
</tbody>
</table>
</p>
<p style="text-align: left">�</p>
<p style="text-align: left">
<table border="0" cellspacing="1" cellpadding="2" width="460" align="center" height="58" style="width: 460px; height: 58px">
<tbody>
<tr>
<td bgcolor="#ffffff" style="text-align: center">�</td>
<td bgcolor="#ffffff" style="text-align: center">
<p><span style="color: #ff0000"><span style="font-family: Verdana"><span style="font-size: smaller"><strong>Dove</strong></span></span></span></p>
</td>
<td bgcolor="#ffffff" style="text-align: center">
<p><span style="color: #ff0000"><span style="font-family: Verdana"><span style="font-size: smaller"><strong>Quando</strong></span></span></span></p>
</td>
<td bgcolor="#ffffff" style="text-align: center">
<p><span style="color: #ff0000"><span style="font-family: Verdana"><span style="font-size: smaller"><strong>Evento</strong></span></span></span></p>
</td>
<td bgcolor="#ffffff" style="text-align: center">
<p><span style="color: #ff0000"><span style="font-family: Verdana"><span style="font-size: smaller"><strong>Info</strong></span></span></span></p>
</td>
<td bgcolor="#ffffff" style="text-align: center">
<p><strong><span style="color: #ff0000"><span style="font-family: Verdana"><span style="font-size: smaller">Recensioni</span></span></span></strong></p>
</td>
</tr>
<tr>
<td bgcolor="#ffffff" valign="middle" style="text-align: center">�</td>
<td bgcolor="#ffffff" valign="middle" style="text-align: center">
<p><span style="font-family: Verdana"><strong><span style="font-size: smaller">Ferrara</span></strong></span></p>
</td>
<td bgcolor="#ffffff" valign="middle" style="text-align: center">
<p><strong><span style="font-size: smaller"><span style="font-family: Verdana">da 17 al 26 settembre</span></span></strong></p>
</td>
<td bgcolor="#ffffff">
<p style="text-align: center"><span style="font-size: smaller"><span style="font-family: Verdana"><strong>Balloon Festival</strong></span></span></p>
</td>
<td bgcolor="#ffffff" valign="middle" style="text-align: center"><strong><span style="font-family: Verdana"><span style="font-size: larger"><span style="font-size: smaller"><span style="color: #ff0000"><a target="_blank" href="http://www.ferrarafestival.it/"><span style="color: #0000ff">link</span></a></span></span></span></span></strong></td>
<td bgcolor="#ffffff" valign="middle" style="text-align: left">
<p style="text-align: center"><span style="font-family: Verdana"><span style="font-size: smaller"><a target="_blank" href="http://fotorisorse.altervista.org/index.php?option=com_content&view=section&id=14&Itemid=72"><strong>link</strong></a></span></span></p>
</td>
</tr>
</tbody>
</table>
</p>
<p style="text-align: left">�</p>
<p style="text-align: left">�</p>
<p style="text-align: center">�</p>
<p>
<table border="1" cellspacing="1" cellpadding="1" width="398" align="center" height="23">
<tbody>
<tr>
<td bgcolor="#ffcc00" style="text-align: center"><<->><strong><a target="_blank" href="http://www.maranimage.altervista.org/new">ISCRIVITI ALLA NEWSLETTER</a></strong><<->></td>
</tr>
</tbody>
</table>
</p>
(if i remove manual the symbol � and copy and paste code, appears again)
VEGA, please try what happens if you set
FCKConfig.HtmlEncodeOutput = true ;
to
FCKConfig.HtmlEncodeOutput = false ;
in plugins > minicms > fckeditor > fckconfig.js
Clear your browser cache to ensure that the changes will be taken into account.
Αndré,
i set FALSE to FCKConfig.HtmlEncodeOutput ,but i don't look any change.
Please try to delete the � symbols and save your table again.
Quote from: Αndré on December 07, 2010, 06:48:45 PM
Please try to delete the � symbols and save your table again.
I already tried to do this
I'm not good with html. Maybe I mistyped the code to the schedules and the provision of content is not correct :-[ :-\
You can also try the following. Disable temporary JavaScript in your browser. That way you won't use FCKeditor to edit your section, but a 'regular' HTML form. Try again if the issue still happens without FCKeditor (which made some trouble for me in cpg1.5.x).
Thanks for this plug-in, it seems a truly excellent tool.
I managed to install it with no problems, created a table and saved it.
I tried to find information on how to show the table I created under MiniCMS in an Album Description, to no avail. Every search, I end up being asked to go to cpg-contrib.org, which seems to be gone. Anyone can point me to the right way please ?
Thanks.
Quote from: hanzon2010 on December 07, 2010, 08:40:36 PM
I tried to find information on how to show the table I created under MiniCMS in an Album Description
Just use the edit button on the appropriate page. They'll be displayed on every page you can MiniCMS for the admin. Another option would be to insert the correct id, but that's not the recommend way.
Excellent ! Thanks, Coppermine just keeps getting better :)
Sorry for incovenience.
There was files missing. Re-uploaded and now it's working.
Bye Bye.
Bigfart10
Hi Guys,
I have add an "Introduction" using this plugin, I want it be only on the index.php not on all pages. How to fix that? I do see that sharpo has done the same thing on his site.
My Site http://igallery.khanz.net
Quote from: fmk on January 02, 2011, 07:57:27 PM
I have add an "Introduction" using this plugin, I want it be only on the index.php not on all pages.
That's how it should work. Please post a screen-shot of the MiniCMS admin page (http://igallery.khanz.net/index.php?file=minicms/cms_admin).
Screen shot of MiniCMS admin page.
If you want to display it on the index.php page, add an article with type 'cat' and content '0'.
It goes off from everywhere when I put it under Cat, Section or Thumb Type with Content 0, and when I put it under Img Type it shows on all the pages. I tried changing value of Content but it loops back to 0. I did delete all the text contents I had before and created new one, but didn't help. ???
Please try to create new content with the MiniCMS rows displayed on every page instead of creating them with the MiniCMS admin page. You don't need to set type/content in that case. If you want I'll send you a PM with my email address where you can send your admin login data, so I can have a look at your issue on your gallery.
Tried that way too. Somethings wrong. Lets do it your way, PM me I trust Dev TM. :D
PM sent.
Here's what I found out.
When you add a new MiniCMS entry, it always uses 'type=2', which is the 'img' type. The pre-population of that value is determined in include/init.inc.php:
if (defined('DISPLAYIMAGE_PHP')) {
$MINICMS['type']=$MINICMS['conTypebyName']['img'];
} elseif (defined('THUMBNAILS_PHP')) {
$MINICMS['conid']=isset($request['album']) ? (int)$request['album'] : -1;
$MINICMS['type']=$MINICMS['conTypebyName']['thumb'];
} elseif (isset($request['file']) && $request['file'] =='minicms/cms') {
if (isset($request['id'])) {
$MINICMS['ID']=(int)$request['id'];
$MINICMS['conid']='';
$MINICMS['type']='';
} else {
$MINICMS['conid']=(int)$request['conid'];
$MINICMS['type']=(int)$request['type'];
}
} else {
$MINICMS['conid']=isset($request['cat']) ? (int)$request['cat'] : 0;
$MINICMS['type']=$MINICMS['conTypebyName']['cat'];
}
I wasn't able to reproduce that behavior in my testbed, even when I installed the same plugins like you. Do you use some modifications? Was your gallery an upgrade from cpg1.4.x? What happens if you uninstall all plugins but MiniCMS?
I had installed 1.5.10 and upgraded to 1.5.12 yesterday. I am not using any modifications. I will try uninstalling all Plugins and Reinstall MiniCMS as soon as I get home. Will give you an update soon.
Update:
I un-installed the MiniCMS and installed it back with new files, but same result. I didn't uninstall my other plugins on my site yet, but I installed a Test Bed, and MiniCMS is the only plugin and it seems to be working fine right now. I will try to install more plugins and list then here later with final result/findings. Thanks a lot for your help Andre.
Test Bed http://democpg.khanz.net
Andre, I installed all plugins (MiniCMS, EnlargeIT, Who is Online, Link Target, Keyboard Navigation, NewsLetter, etc) in my Test Bed that I was using in my Main CPG along with the same Timoswelt theme, and found the reason for MiniCMS' type changing to 'IMG' by default instead of 'CAT'.
It is because of EnlargeIT PlugIn's Buttons Section's Show button Info's "Yes: Open as AJAX snippet". This option allows the viewer to see file info within the same AJAX Box of Enlarged pic using EnlargeIT Plugin.
Hope to see a fix about this soon.
"EnlargeIt! AJAX GUI for CPG 1.5.x" is another must have PlugIn guys, but its a very small conflict so you can use it :). Announcement Thread: http://forum.coppermine-gallery.net/index.php/topic,57424.0.html
Thanks André, great Plugin.
When I edit/make a new entry, I always get an error message "Unbekanntes Menüleisten-Objekt "UniversalKey"" (eng: Unknown menu item "UniversalKey"). I can simply confirm this message and continue as normal. The behaviour occurs in Opera 11 as well as in FF 3.6.
Cheers,
André
Quote from: André Müller on January 22, 2011, 01:07:59 PM
Thanks André, great Plugin.
When I edit/make a new entry, I always get an error message "Unbekanntes Menüleisten-Objekt "UniversalKey"" (eng: Unknown menu item "UniversalKey"). I can simply confirm this message and continue as normal. The behaviour occurs in Opera 11 as well as in FF 3.6.
Cheers,
André
Sorry!
My galeries are www.fotowald.de and www.above-horizon.de, both CPG 1.5.12, error occurs on both.
Regarding the UniversalKey issue:
complete removing and new installation of the plugin solved the problem.
André
Hello everyone I have the verson 1.5.8 of coppermine I loaded the plungins the list, but it shows me with a symbol that indicates to me that did not meet the minimum requirements what can I do? thanks
I would start with upgrading to 1.5.12. Maybe that will help you.
ok thanks
Hello,
I'm also being told that my installation doesn't meet the minimum requirements. I've spent hours going round and round in circles trying to fix it, but feel that I've actually made the situation worse.
I installed minicms this morning and discovered I had not removed the database tables from a previous installation and the plugin didn't appear to like this. When I tried to edit cms I got the following error Fatal error: Cannot redeclare cpggetmicrotime
I deleted the database tables, reinstalled the plugin and got a list of actions that suggested the site was struggling to set up the database (possibly because it wasn't compatible with my coppemine installation). I discovered there was a newer version of the plugin 2.1 and hoped this would fix the error, but after installing I started getting the minimum requirement message.
The only suggestion I've found is too install the latest version of coppermine. I was already running that, but reinstalled it anyway just to make sure nothing was wrong, but no change.
I'm sure I'm missing something very simple, but I've run out of my own suggestions, so would appreciate any help available.
My site is www.darktea.co.uk and the debug mode is currently on in case it is useful.
Thank you for your help.
Works as expected in my testbed. Please check configuration.php, the line
$plugin_cpg_version = array('min' => '1.5.10');
defines the minimum version requirement.
Thank you Αndré, I finally got there.
The code in configuration.php was wrong (see below) so I updated it with your code.
$plugin_cpg_version = array('min' => '1.4', 'max' => '1.4.99');
However, I still had a problem when I tried to install the plugin and got messages such as "Can't DROP 'pos'; check that column/key exists". After spending time going round and round again, I finally solved it by deleting the minicms files and the database tables and then reinstalling the minicms files.
Thank you again for your help, it was certainly the key in solving my problem.
Installed, works perfectly.
I upload the file to the Spanish language. Thank you very much!
Quote from: Αndré on December 07, 2010, 01:31:27 PM
VEGA, please try what happens if you set
FCKConfig.HtmlEncodeOutput = true ;
to
FCKConfig.HtmlEncodeOutput = false ;
in plugins > minicms > fckeditor > fckconfig.js
Clear your browser cache to ensure that the changes will be taken into account.
I had the same problem.
The two opened galleries in the same browser, firefox 6
The installation in the gallery without the problem was a new installation.
The gallery that had the problem was an upgrade from CPG 1.4.27
In the gallery that had the problem I followed your recommendation and the problem was solved.
thanks
KchoPrro
Does MiniCMS work in latest coppermine (1.5.20)?
Thanks
Okay, I figured it out. In the sql file "TYPE" MUST be changed to "ENGINE" and then it will install correctly. Maybe this will help someone else out.
Quote from: peterb on May 05, 2012, 10:24:10 PM
In the sql file "TYPE" MUST be changed to "ENGINE"
Version 2.2 (attached to initial post) fixes that issue.
Hello,
how it can be set up that works well in MiniCMS PW protected folders?
VG TT
I assume your gallery has a password protection on web server level? What exactly doesn't work?
I noticed yesterday that the text box for MiniCMS was not displaying correctly when adding or editing text. It only happened with Firefox, not with Internet Explorer. I was gathering "evidence" as an example, and when I checked to see the version of Firefox I was using, it said a new version was available - which I downloaded, and the problem has now gone.
Seems problem was with Firefox 17.0 as the version I now have is 17.0.1
This what it looked like:-
<p>All recent updates are listed in my <a href="http://www.sharpos-world.co.uk/blog/">blog</a>. Since 2011, <a href="http://my.vidahost.com/aff.php?aff=744"><input type="image" align="absBottom" longdesc="undefined" alt="Vidahost.com image" src="http://www.vidahost.com/images/ab/80by15a.jpg" /></a> has been my host and the images are loading much faster. For 10% discount on hosting, use code:- <span style="font-size: larger;"><strong>vh-10</strong></span></p>
and now showing correctly:-
"All recent updates are listed in my blog. Since 2011, has been my host and the images are loading much faster. For 10% discount on hosting, use code:- vh-10"
http://www.sharpos-world.co.uk/cpg/
So if anybody else has a similar problem, check your Firefox version. Hope this may help somebody, as I was searching for answers yesterday but found nothing.
After uploading my plugin displays this message:
"Fatal Error
An error occurred while processing database ..
While executing query "SELECT * FROM WHERE conid cms = '0 'AND type = '0' ORDER BY cpos' in plugins / minicms / codebase.php on line 92
mySQL error: Table 'natorze1.cms' does not exist
File: / autoinstalator / coppermine / include / functions.inc.php - Line: 272"
Where there may be a problem, cpg version 1.5.22 ??
Problem solved.
Plugin in my database "sql" failed to create table "cms". So for this purpose I used cpg new installation on a test server, there minicms plugin installed and exported tables "cms", which is then imported the old database to the "sql".
There remains another problem, the plugin does not work in the search menu and I would write instructions for searching.
I get the same error as pasenger above after installation (CPG1.5.20):
QuoteCritical error
There was an error while processing a database query.
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 'coppermine_a.cpg15x_cms' doesn't exist
File: C:\Inetpub\vhosts\chainsawphotos.co.nz\httpdocs\gallery\include\functions.inc.php - Line: 270
Unfortunately I do not know enough to follow his method for solving this.
Quote from: pasenger on April 04, 2013, 08:53:07 AM
the plugin does not work in the search menu and I would write instructions for searching.
As a quick fix I suggest to edit the file
search.php. I don't know when I can have a closer look at that issue.
Certainly the easiest way to use MiniCMS is to create/edit content on the desired dispaly page, but in re-organizing a gallery, I had the need to 'move' MiniCMS content from the home/index page to a newly created category...
Editing the content on the index page - changing the content number to match the new category number - and submitting the update resulted in the content number being reset to 0 (display on index page...) I found this post previously in this thread that appeared to be same issue:
Quote from: fmk on January 04, 2011, 12:47:18 AM
It goes off from everywhere when I put it under Cat, Section or Thumb Type with Content 0, and when I put it under Img Type it shows on all the pages. I tried changing value of Content but it loops back to 0. I did delete all the text contents I had before and created new one, but didn't help. ???
In reviewing minicms/cms_edit.php, the code retrieves both type and conid (content number) from the input variables, but never passed the conid in the UPDATE statement.
Changing (line 63 of version 2.2 in my case):
$query = "UPDATE {$CONFIG['TABLE_CMS']} SET title = '$title', content = '$content', type = '{$MINICMS['type']}' WHERE ID = '$id'";to:
$query = "UPDATE {$CONFIG['TABLE_CMS']} SET title = '$title', content = '$content', type = '{$MINICMS['type']}', conid = '{$MINICMS['conid']}' WHERE ID = '$id'";resolved the issue.
Hopefully will help someone else with same issue... (or can be included as an update...)
Thanks!
Greg
Before I commit this change, is conid always submitted by the form (i.e. is $MINICMS['conid'] always populated)?
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:
<form name="post" method="post" action="index.php?file=minicms/cms_edit&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:
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... :)
Suggested fix committed in SVN revision 8633. Version 2.3 attached to initial post. Thanks for your report.
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
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.
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
Quote from: gmc 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
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
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 (http://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.
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:
QuoteKritischer 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
QuoteCritical 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
Please enable debug mode so we can see a better error message.
http://documentation.coppermine-gallery.net/en/errors.htm#errors_debug_mode_manual (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
i have now enable the debug mode
this happens:
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
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.
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.
i ahve reinstalled the plugin
i stil get
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
(https://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Fwww11.pic-upload.de%2Fthumb%2F14.10.14%2Fthk136mihyye.jpg&hash=90f10a06ff97c46d2ea1578328749b90d1a155e8) (http://www.pic-upload.de/view-24925727/Unbenannt.jpg.html)
uh i cant edit my post, ok, i hope double post is ok in this case...
the rror message says
mySQL error: Table 'test.cpg15x_cms' doesn't exist
i cant find this table... on phpmyadmin
(https://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Fwww11.pic-upload.de%2Fthumb%2F14.10.14%2Fjenlhvdy6ab.jpg&hash=4943abcf9f9a24725ec0805a2e44b7f302aef503) (http://www.pic-upload.de/view-24925870/Unbenannt.jpg.html)
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_".
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?
ok... i found where to create it manualy...
i get a error
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
Default table creation for your MySQL must not be MyISAM.
Add ENGINE=MyISAM to the end of the CREATE TABLE statement.
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 (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?
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
QuoteNot 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?
# 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';
Quote from: flamendeShana on October 14, 2014, 10:24:15 PM
can you please say me where to ad this exactyl?
At the end of the CREATE TABLE query:
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`)
) ENGINE=MyISAM AUTO_INCREMENT=1;
ok now i have this table, but i get a new error now...
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: Unknown column 'conid' in 'where clause'
data: /var/www/html/foto/include/functions.inc.php - Zeile: 272
oh ok, i have post to eraly, i'm soory, i have reinstalled the plugin now, it seems it work now,
thanks for the support
is there any problem that the rest of copermine is in innodb?
Quote from: flamendeShana on October 17, 2014, 03:37:11 PM
is there any problem that the rest of copermine is in innodb?
Should be fine... You might encounter another plugin that uses 'FULLTEXT' - but you know what to do now...
Once your ISP upgrades MySQL to 5.6 (currently 5.5.38) - then you can use innodb for that too...
thanks for suppoert,
i running and admin my own server at home,
but the Ubuntu 12.04 LTS version dont got the upgrade to mysql 5.6 yet... (i am waiting for it ;) so that there is no trouble if i will run the hole server on a puplic server with the same system without root [i cant manage a real server self])
it is possible to integrate the CKEditor (http://ckeditor.com/download)?, or where what needs to be adjusted
VG TT
Quote from: Tankertom on June 20, 2015, 08:49:55 AM
it is possible to integrate the CKEditor (http://ckeditor.com/download)?, or where what needs to be adjusted
VG TT
CKEditor is of course the replacement for FCKeditor that is included in the MiniCMS plugin.
A simple google search on converting finds:
http://docs.cksource.com/CKEditor_3.x/Howto/Upgrade_from_FCKeditor (http://docs.cksource.com/CKEditor_3.x/Howto/Upgrade_from_FCKeditor):
Quote
How do I Upgrade My FCKeditor to the Latest CKEditor Release?
...
However, since CKEditor was a complete rewrite of FCKeditor, with lots of changes in how the internal stuff works, no automatic upgrade path is available.
http://docs.cksource.com/CKEditor_3.x/Developers_Guide/FCKeditor_CKEditor_Configuration_Mapping (http://docs.cksource.com/CKEditor_3.x/Developers_Guide/FCKeditor_CKEditor_Configuration_Mapping)
Quote
Configuration Settings Mapping Between FCKeditor and CKEditor
and one possible band-aid:
http://david.dw-perspective.org.uk/da/index.php/computer-resources/migrating-from-fckeditor-to-ckeditor-without-changing-any-code/ (http://david.dw-perspective.org.uk/da/index.php/computer-resources/migrating-from-fckeditor-to-ckeditor-without-changing-any-code/)
Quote
Migrating from FCKeditor to CKeditor without changing any code
Here's a shim to allow you to swap FCKeditor for CKeditor without changing any application code.
(This may be a short term workaround - but the plugin should really be reworked to invoke CKEditor directly in my opinion...)
I've had this on my list to look at - but I haven't had the time to do so yet...
I do realize that it is implemented in version 3. It's about the next version of me. There were made some adjustments that I do not know where they were made. A simple upgrade enough I do not think so. :o
TT
Will there be a version for cpg1.6 ???
I use it in cpg1.5 and have set up cpg1.6.04 to see if the plugins I use will work, but MiniCMS v2.3 fails with.....
Critical error
There was an error while processing a database query
Quite a few calls to the database in this one. It will take time to adjust.
Quote from: Phill Luckhurst on August 18, 2018, 11:46:22 PM
Quite a few calls to the database in this one. It will take time to adjust.
Thanks Phill, thought I would mention it as I find it very useful. Will await developments, no rush as not intending to upgrade 1.5.46 galleries yet.
Sharpo.
Would be good if you start a thread with reasons why you cannot upgrade to 1.6 yet. Lists of what extensions people a in need of upgrade helps prioritise things.
I've got a version together for CPG 1.6...
Let me finish up my testing and I'll make it available this week. :)
Greg
Quote from: gmc on August 20, 2018, 12:24:40 AM
I've got a version together for CPG 1.6...
Let me finish up my testing and I'll make it available this week. :)
Greg
Thanks Greg, I'm impressed!! Look forward to trying it soon......
Sharpo.
Quote from: sharpo on August 20, 2018, 12:48:54 AM
Thanks Greg, I'm impressed!! Look forward to trying it soon......
Sharpo.
Any news on the update for this please?
Actually was just looking at this today... What I have seems to be working fine - so I'll get it packaged up and posted...
Greg
Quote from: gmc on October 31, 2018, 01:37:19 AM
Actually was just looking at this today... What I have seems to be working fine - so I'll get it packaged up and posted...
Greg
Package for MiniCMS for CPG 1.6 is available in the cpg1.6 plugin contributions board located here: http://forum.coppermine-gallery.net/index.php/topic,79514.0.html (http://forum.coppermine-gallery.net/index.php/topic,79514.0.html)
Enjoy!
Greg