MiniCMS for CPG 1.6.x

[gmc]

This is a port of the cpg1.5.x plugin MiniCMS.

Quote from: Joachim Müller on November 04, 2009, 01: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

Primary update to eliminate direct calls to MySQL functions and convert to CPG wrapper functions that use the CPG database abstraction layer.
MySQL functions are removed in PHP 7.

See thread http://forum.coppermine-gallery.net/index.php/topic,68455.0.html for the history under 1.5.

Update 2.5 - only insert CMS Test message on initial install (tables being created).  Avoids having to manually delete message in an already established installation - and addresses sharpo's issue of mysteriusly appearing quantities of the test message.
(Have to delete 2.4 due to single post size restriction.  This plugin is large with fckeditor included.)

[Αndré]

The plugin has been added to our GitHub repository: https://github.com/coppermine-gallery/cpg1.6.x-plugins

[sharpo]

Thanks Greg.

Have downloaded and installed in my 1.6 test site. Only added one set of text so far, on home page, to thank you for releasing the update!!

I'm now one step further to upgrading my 1.5 galleries now.

http://sharpo.co.uk/cpg16test/index.php

[gmc]

Thanks Greg.

Have downloaded and installed in my 1.6 test site. Only added one set of text so far, on home page, to thank you for releasing the update!!

I'm now one step further to upgrading my 1.5 galleries now.

http://sharpo.co.uk/cpg16test/index.php

lol... thanks... should have been released earlier - just not enough hours in day these days...
An important one for me to get several of my galleries upgraded too.

[sharpo]

Oops, something has gone wrong!!! I've spent so much time trying to solve the mobile view problem on my 2 test sites that I hadn't bothered to look at my proper site that I upgraded to 1.6.

If you look at the screen print below you will see the example MinCMS message line keeps repeating itself. I upgraded the site a week or so ago with this plugin, probably with just the one MiniCMS entry showing on the home page. I have since added one new entry since noticing the problem, wonder if any more will suddenly appear??

Getting back to the problem, using my desktop, the message appears about 15 times on the screen and I scrolled down about 25 times before reaching the end, that makes about 375 enties if my maths is right?? Any idea what is wrong???

[sharpo]

I always forget something, the problem site is:-

http://www.sharpos-world.co.uk/kc/

[gmc]

...If you look at the screen print below you will see the example MinCMS message line keeps repeating itself. I upgraded the site a week or so ago with this plugin, probably with just the one MiniCMS entry showing on the home page. I have since added one new entry since noticing the problem, wonder if any more will suddenly appear??

Getting back to the problem, using my desktop, the message appears about 15 times on the screen and I scrolled down about 25 times before reaching the end, that makes about 375 enties if my maths is right?? Any idea what is wrong???

Looks like you have 3 messages in there (at least for the home page) and only one is repeating...
Would like to take a look at the data behind it (and try to recreate in my sandbox).  Can you attach an SQL dump (export from phpMyAdmin including structure and data) of the two CMS tables?  Going to be very small - one row per message in cpgxxx_cms and 8 rows in cpgxxx_cms_config. 
Not saying it is data related (and that would be a problem too assuming you used the plugin only to update the data) - but just want to see if I can recreate...

Thanks!
Greg

[sharpo]

Just noticed your reply Greg, will try and get what you ask for.

[sharpo]

Have to say you were very quick in responding to the problem!!

Hope I've done this right...... They are .sql files but if they don't work then pm me with an email address and I'll send that way

Aah, sql wouldn't send so trying text files

[sharpo]

I logged into mysql and deleted all the ones that shouldn't have been there, just 3 MiniCMS entries remaining now. Hope it stays like that unless I add any more. Very strange how they appeared???

[Chuckster]

Worked like a champ on my site.

I was just wondering about this a couple weeks ago when I did my upgrade to CPG v1.6.

Thanks for such a great mod.

[gmc]

I logged into mysql and deleted all the ones that shouldn't have been there, just 3 MiniCMS entries remaining now. Hope it stays like that unless I add any more. Very strange how they appeared???

I have no guesses at this point as to how they all got in there... but at least we know why so many were displaying!
Let me know if you see that again.

[sharpo]

I have no guesses at this point as to how they all got in there... but at least we know why so many were displaying!
Let me know if you see that again.

Will do. Strange that it happened on one of my proper galleries and not any of the three test sites. I must check it more often in case it happens again, not many updates of our dog photos these days!!

[sharpo]

It happened again Greg. Just had a look to make sure all was working and 6 new entries had appeared. Done a little print from mysql.

[gmc]

It happened again Greg. Just had a look to make sure all was working and 6 new entries had appeared. Done a little print from mysql.

Any idea what you were doing in the gallery around those time stamps??  All happened within an hour.
Only the install dialog should add a message like that.

I'll do some testing and see if I can recreate that here.

[sharpo]

It's not a gallery I look at on a regular basis, only looked this afternoon as I was about to back it up for the first time since the 1.6 upgrade. Previous visit was days ago.

I know what you mean about that message appearing, as I always remember to delete it when the plugin is re-installed - such as after the recent 1.6 upgrade.

[sharpo]

Another site had about 70 blank messages appear early this morning, while I was asleep. I have since removed them from the database, easier than doing it one by one using the gallery. Any ideas?

[sharpo]

It has just screwed up again, looks like hundreds of entries. I will delete from database again, but watch to see if they come back again. If it continues like this l will have to uninstall, pity really, as it is so useful.

http://www.sharpos-world.co.uk/cpg/

[sharpo]

Just for the record, it was 130 entries timed between 10.14 and 10.24 this morning.

I am the only administrator. Is there anything else I can check? I did look in logs after the earlier incident but nothing obvious.

[gmc]

Just for the record, it was 130 entries timed between 10.14 and 10.24 this morning.

I am the only administrator. Is there anything else I can check? I did look in logs after the earlier incident but nothing obvious.

Only way I can get multiple messages to happen for me is if I repeatedly uninstall/reinstall the plugin...
As a quick workaround - edit file 'minicms/sql/basic.sql' and remove line:

Code Select Expand

INSERT INTO `CPG_cms` (conid,title,content,type) VALUES ('0','Welcome to Coppermine', 'Simple test of CPG MiniCMS','0');
Without this line - no way the message can be inserted again.

Adding version 2.5 to first post that checks if tables already existed at install time and only inserts the test message if they are being created new...  Probably the behavior it should have anyway - as don't want to add test message on a reinstall.
I expect this will also eliminate the symptom you are seeing.

Still a mystery to me why it seems install is getting driven... Not doable from the menus (have to uninstall first).