Advanced search  

News:

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

Pages: [1] 2 3   Go Down

Author Topic: MiniCMS for CPG 1.6.x  (Read 5013 times)

0 Members and 1 Guest are viewing this topic.

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 784
    • GMC Design Photo Gallery
MiniCMS for CPG 1.6.x
« on: November 02, 2018, 03:20:44 am »

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

Quote from: Joachim Müller on November 04, 2009, 01:55:01 am
Quote
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.)
« Last Edit: November 22, 2018, 03:46:19 pm by gmc »
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: 15759
Re: MiniCMS for CPG 1.6.x
« Reply #1 on: November 02, 2018, 11:54:08 am »

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

sharpo

  • Coppermine frequent poster
  • ***
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 313
Re: MiniCMS for CPG 1.6.x
« Reply #2 on: November 02, 2018, 12:46:03 pm »

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
Logged
Sharpo (not an expert, just a Coppermine user)
3 live galleries, first started in 2006, all now 1.6.04.
http://www.sharpos-world.co.uk/BB3cpg/ with over 8,000 images.
http://www.sharpos-world.co.uk/cpg/ with over 25,000 images
http://www.sharpos-world.co.uk/kc/ with over 300 images
Also 4 for tests

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 784
    • GMC Design Photo Gallery
Re: MiniCMS for CPG 1.6.x
« Reply #3 on: November 02, 2018, 12:53:47 pm »

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.
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

sharpo

  • Coppermine frequent poster
  • ***
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 313
Re: MiniCMS for CPG 1.6.x
« Reply #4 on: November 10, 2018, 12:05:03 pm »

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???
Logged
Sharpo (not an expert, just a Coppermine user)
3 live galleries, first started in 2006, all now 1.6.04.
http://www.sharpos-world.co.uk/BB3cpg/ with over 8,000 images.
http://www.sharpos-world.co.uk/cpg/ with over 25,000 images
http://www.sharpos-world.co.uk/kc/ with over 300 images
Also 4 for tests

sharpo

  • Coppermine frequent poster
  • ***
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 313
Re: MiniCMS for CPG 1.6.x
« Reply #5 on: November 10, 2018, 12:06:56 pm »

I always forget something, the problem site is:-

http://www.sharpos-world.co.uk/kc/
Logged
Sharpo (not an expert, just a Coppermine user)
3 live galleries, first started in 2006, all now 1.6.04.
http://www.sharpos-world.co.uk/BB3cpg/ with over 8,000 images.
http://www.sharpos-world.co.uk/cpg/ with over 25,000 images
http://www.sharpos-world.co.uk/kc/ with over 300 images
Also 4 for tests

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 784
    • GMC Design Photo Gallery
Re: MiniCMS for CPG 1.6.x
« Reply #6 on: November 10, 2018, 01:48:10 pm »

...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
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

sharpo

  • Coppermine frequent poster
  • ***
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 313
Re: MiniCMS for CPG 1.6.x
« Reply #7 on: November 10, 2018, 02:15:44 pm »

Just noticed your reply Greg, will try and get what you ask for.
Logged
Sharpo (not an expert, just a Coppermine user)
3 live galleries, first started in 2006, all now 1.6.04.
http://www.sharpos-world.co.uk/BB3cpg/ with over 8,000 images.
http://www.sharpos-world.co.uk/cpg/ with over 25,000 images
http://www.sharpos-world.co.uk/kc/ with over 300 images
Also 4 for tests

sharpo

  • Coppermine frequent poster
  • ***
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 313
Re: MiniCMS for CPG 1.6.x
« Reply #8 on: November 10, 2018, 02:27:49 pm »

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
Logged
Sharpo (not an expert, just a Coppermine user)
3 live galleries, first started in 2006, all now 1.6.04.
http://www.sharpos-world.co.uk/BB3cpg/ with over 8,000 images.
http://www.sharpos-world.co.uk/cpg/ with over 25,000 images
http://www.sharpos-world.co.uk/kc/ with over 300 images
Also 4 for tests

sharpo

  • Coppermine frequent poster
  • ***
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 313
Re: MiniCMS for CPG 1.6.x
« Reply #9 on: November 11, 2018, 01:21:53 am »

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???
Logged
Sharpo (not an expert, just a Coppermine user)
3 live galleries, first started in 2006, all now 1.6.04.
http://www.sharpos-world.co.uk/BB3cpg/ with over 8,000 images.
http://www.sharpos-world.co.uk/cpg/ with over 25,000 images
http://www.sharpos-world.co.uk/kc/ with over 300 images
Also 4 for tests

Chuckster

  • Coppermine newbie
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 16
    • Mopars Unlimited of Tacoma
Re: MiniCMS for CPG 1.6.x
« Reply #10 on: November 11, 2018, 04:24:12 am »

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.
Logged

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 784
    • GMC Design Photo Gallery
Re: MiniCMS for CPG 1.6.x
« Reply #11 on: November 12, 2018, 12:08:20 am »

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.
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

sharpo

  • Coppermine frequent poster
  • ***
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 313
Re: Re: MiniCMS for CPG 1.6.x
« Reply #12 on: November 12, 2018, 12:59:03 am »

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!!
Logged
Sharpo (not an expert, just a Coppermine user)
3 live galleries, first started in 2006, all now 1.6.04.
http://www.sharpos-world.co.uk/BB3cpg/ with over 8,000 images.
http://www.sharpos-world.co.uk/cpg/ with over 25,000 images
http://www.sharpos-world.co.uk/kc/ with over 300 images
Also 4 for tests

sharpo

  • Coppermine frequent poster
  • ***
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 313
Re: MiniCMS for CPG 1.6.x
« Reply #13 on: November 19, 2018, 05:25:27 pm »

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.

Logged
Sharpo (not an expert, just a Coppermine user)
3 live galleries, first started in 2006, all now 1.6.04.
http://www.sharpos-world.co.uk/BB3cpg/ with over 8,000 images.
http://www.sharpos-world.co.uk/cpg/ with over 25,000 images
http://www.sharpos-world.co.uk/kc/ with over 300 images
Also 4 for tests

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 784
    • GMC Design Photo Gallery
Re: MiniCMS for CPG 1.6.x
« Reply #14 on: November 19, 2018, 07:03:38 pm »

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.
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

sharpo

  • Coppermine frequent poster
  • ***
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 313
Re: MiniCMS for CPG 1.6.x
« Reply #15 on: November 19, 2018, 07:10:37 pm »

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.
Logged
Sharpo (not an expert, just a Coppermine user)
3 live galleries, first started in 2006, all now 1.6.04.
http://www.sharpos-world.co.uk/BB3cpg/ with over 8,000 images.
http://www.sharpos-world.co.uk/cpg/ with over 25,000 images
http://www.sharpos-world.co.uk/kc/ with over 300 images
Also 4 for tests

sharpo

  • Coppermine frequent poster
  • ***
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 313
Re: MiniCMS for CPG 1.6.x
« Reply #16 on: November 22, 2018, 10:45:47 am »

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?

Logged
Sharpo (not an expert, just a Coppermine user)
3 live galleries, first started in 2006, all now 1.6.04.
http://www.sharpos-world.co.uk/BB3cpg/ with over 8,000 images.
http://www.sharpos-world.co.uk/cpg/ with over 25,000 images
http://www.sharpos-world.co.uk/kc/ with over 300 images
Also 4 for tests

sharpo

  • Coppermine frequent poster
  • ***
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 313
Re: MiniCMS for CPG 1.6.x
« Reply #17 on: November 22, 2018, 11:41:04 am »

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/
Logged
Sharpo (not an expert, just a Coppermine user)
3 live galleries, first started in 2006, all now 1.6.04.
http://www.sharpos-world.co.uk/BB3cpg/ with over 8,000 images.
http://www.sharpos-world.co.uk/cpg/ with over 25,000 images
http://www.sharpos-world.co.uk/kc/ with over 300 images
Also 4 for tests

sharpo

  • Coppermine frequent poster
  • ***
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 313
Re: MiniCMS for CPG 1.6.x
« Reply #18 on: November 22, 2018, 11:52:50 am »

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.
Logged
Sharpo (not an expert, just a Coppermine user)
3 live galleries, first started in 2006, all now 1.6.04.
http://www.sharpos-world.co.uk/BB3cpg/ with over 8,000 images.
http://www.sharpos-world.co.uk/cpg/ with over 25,000 images
http://www.sharpos-world.co.uk/kc/ with over 300 images
Also 4 for tests

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 784
    • GMC Design Photo Gallery
Re: MiniCMS for CPG 1.6.x
« Reply #19 on: November 22, 2018, 03:35:51 pm »

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]
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).
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money
Pages: [1] 2 3   Go Up
 

Page created in 0.047 seconds with 20 queries.