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 4   Go Down

Author Topic: News Bulletin - RSS feed generator, News Bulletin, News Manager...  (Read 96934 times)

0 Members and 1 Guest are viewing this topic.

just_some_guy

  • Supporter
  • Coppermine addict
  • ****
  • Offline Offline
  • Posts: 539
  • I am currently on holiday, back in a few weeks. :D

News Bulletin
CPG 1.4x
DEMO


This plugin will create an interface for you to write news bulletins for your gallery which can be viewed in a neat expandable/collapsable section. These notices can also be added to an RSS feed for your gallery. The plugin uses coppermine's built in JavaScript (same as in the config page) to operate the expandable/collapsable section.

Manual -

Installing the plugin -

•    Upload and install via the Plugin Manager .
•    Specify where to show the news block in the Album List View section of the config section nu adding "/news". 
•            Add this below <head> in themes/"theme"/template.html
Code: [Select]
<link rel="alternate" type="application/rss+xml" title="News Bulletins" href="index.php?file=News_Bulletin/news_rss" />
Bulletins -

•   Click “News Manager” on the admin menu.
•   Click “Create new bulletin.”
•   Enter the bulletins title in the first box.
•   Enter the bulletin into the larger box, by default the bulletin can be viewed in the RSS feed and the News section.
•   You can specify where to show the bulletin by clicking edit and choosing from the drop down list.
•   You can delete bulletins at any time.

Viewing Bulletins –

•   The bulletins can be viewed in the RSS feed and the News section. (By default settings) .


Languages -
  • English.
  • Translations welcome.

New Version - V2
  • This version address a minor bug fix which fixes the problem cause when expanding the news block when placed at the top of the gallery (found by will)
  • Also i have attached a "low" version whic is suitable for mysql servers that dont support the number of chars in colomns that is supported in the normal version. This version also does not expand automatically hide the block on page load. (Lite Version)
  • Upgraded manually by overwriting all the files except those in the include directory, lang directory,codebase.php and configuration.php
just_some_guy,

mysimtractor.com

Could a Dev Team Member please move this to the plugins section, thanks.
« Last Edit: November 16, 2007, 08:02:24 am by GauGau »
Logged
Tambien, Hablo Español      PHP - Achieve Anything
"The Internet is becoming the town square for the global village of tomorrow. " - Bill Gates
Windows 7 Forums

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: News Bulletin - RSS feed generator, News Bulletin, News Manager...
« Reply #1 on: November 12, 2007, 03:13:47 pm »

Could a Dev Team Member please move this to the plugins section, thanks.
We always do this for valid contributions - no need to explicitely ask for your thread to be moved, nor do you have to edit out this request once the thread has been moved.
Did as you suggested and moved your thread accordingly.
Logged

just_some_guy

  • Supporter
  • Coppermine addict
  • ****
  • Offline Offline
  • Posts: 539
  • I am currently on holiday, back in a few weeks. :D
Re: News Bulletin - RSS feed generator, News Bulletin, News Manager...
« Reply #2 on: November 12, 2007, 06:10:34 pm »

Ok, i will know that for the future. Thanks GauGau.
« Last Edit: November 12, 2007, 06:55:59 pm by just_some_guy »
Logged
Tambien, Hablo Español      PHP - Achieve Anything
"The Internet is becoming the town square for the global village of tomorrow. " - Bill Gates
Windows 7 Forums

will

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 263
Re: News Bulletin - RSS feed generator, News Bulletin, News Manager...
« Reply #3 on: November 13, 2007, 12:42:06 pm »

Great plugin but I got this error when installing:

mySQL error: Table 'newgallery2007.cpg1411_plugin_news' doesn't exist

It says in the plugin manager when uploaded the plugin that:

This plugin will create a table called cpg1411_plugin_news. Make sure this table does not already exist. ;)
Logged

just_some_guy

  • Supporter
  • Coppermine addict
  • ****
  • Offline Offline
  • Posts: 539
  • I am currently on holiday, back in a few weeks. :D
Re: News Bulletin - RSS feed generator, News Bulletin, News Manager...
« Reply #4 on: November 13, 2007, 05:43:06 pm »

I just deleted it all of my gallery and installed it again and it all works perfectly fine; the table is created. Im not sure what the problem is... can you be more specific.

The "This plugin will create a table called cpg1411_plugin_news. Make sure this table does not already exist." is normal.
Logged
Tambien, Hablo Español      PHP - Achieve Anything
"The Internet is becoming the town square for the global village of tomorrow. " - Bill Gates
Windows 7 Forums

will

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 263
Re: News Bulletin - RSS feed generator, News Bulletin, News Manager...
« Reply #5 on: November 13, 2007, 05:59:46 pm »

I'll try that and see what happens, basically when I go to install is gives me:

There was an error while processing a database query

And in the debug it give me the error I posted in the last post.

It looks to me that its not creating the table in the database. ;)
Logged

just_some_guy

  • Supporter
  • Coppermine addict
  • ****
  • Offline Offline
  • Posts: 539
  • I am currently on holiday, back in a few weeks. :D
Re: News Bulletin - RSS feed generator, News Bulletin, News Manager...
« Reply #6 on: November 13, 2007, 06:05:06 pm »

I have attached another version to my first post, try this one as it might fix your problem.
Logged
Tambien, Hablo Español      PHP - Achieve Anything
"The Internet is becoming the town square for the global village of tomorrow. " - Bill Gates
Windows 7 Forums

will

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 263
Re: News Bulletin - RSS feed generator, News Bulletin, News Manager...
« Reply #7 on: November 13, 2007, 08:03:26 pm »

Still get the same database error.

But now I get a different MySQL error:

mySQL error: Too big column length for column 'name' (max = 255). Use BLOB instead ???
Logged

just_some_guy

  • Supporter
  • Coppermine addict
  • ****
  • Offline Offline
  • Posts: 539
  • I am currently on holiday, back in a few weeks. :D
Re: News Bulletin - RSS feed generator, News Bulletin, News Manager...
« Reply #8 on: November 14, 2007, 08:23:27 am »

Well how big a title are you entering? it is limited to 255 chars, if you want i bigger you will need to edit the table.
Logged
Tambien, Hablo Español      PHP - Achieve Anything
"The Internet is becoming the town square for the global village of tomorrow. " - Bill Gates
Windows 7 Forums

will

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 263
Re: News Bulletin - RSS feed generator, News Bulletin, News Manager...
« Reply #9 on: November 14, 2007, 09:55:44 am »

I'm not entering any title in, the plugin is supposed to add the table for me so it should enter the title as well surely ;D
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: News Bulletin - RSS feed generator, News Bulletin, News Manager...
« Reply #10 on: November 14, 2007, 11:56:50 am »

@Will: you don't qualify as tester for a plugin in an early development stage. In other words: the plugin is not meant for you unless you post valid reports. If you have no idea to do this, then wait for others to test and evaluate this plugin first.
Logged

will

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 263
Re: News Bulletin - RSS feed generator, News Bulletin, News Manager...
« Reply #11 on: November 14, 2007, 02:29:09 pm »

I'm not testing it, I want it installed on my gallery but having trouble installing, I use anycontent.php to show news about my site and just_some_guy shows it working on his gallery. Look at some early posts to see my point ;D

Anyway back to the subject: just_some_guy does it matter if my tables are named cpg1410 in the database as the error shows cpg1411_plugin_news, should it be cpg1410_plugin_news ???
« Last Edit: November 14, 2007, 02:44:47 pm by will »
Logged

just_some_guy

  • Supporter
  • Coppermine addict
  • ****
  • Offline Offline
  • Posts: 539
  • I am currently on holiday, back in a few weeks. :D
Re: News Bulletin - RSS feed generator, News Bulletin, News Manager...
« Reply #12 on: November 14, 2007, 05:25:23 pm »

During the install all the plugin does is create. You need to enter your news articles into the table using the form in your CPG, click "News Manager" and the click "Create new bulletin." then type away. The plugin does not enter in any info during install. The table will be called cpg1411_plugin_news.

There is no need to use the anycontent. The plugin behaves the same way as an anycontent.

Trust me, the plugin works fine.
Logged
Tambien, Hablo Español      PHP - Achieve Anything
"The Internet is becoming the town square for the global village of tomorrow. " - Bill Gates
Windows 7 Forums

will

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 263
Re: News Bulletin - RSS feed generator, News Bulletin, News Manager...
« Reply #13 on: November 14, 2007, 05:29:59 pm »

You may be confused, GauGau was saying I was testing your plugin when actually I'm trying to install. Basically it won't install period. I've been using anycontent for a while and I'm glad you've made this plugin as I won't need to use anycontent anymore. So amid the confusion can it be possible if I give you u/p with admin rights to take a look for me so you can see the problem I'm getting. ;)
Logged

just_some_guy

  • Supporter
  • Coppermine addict
  • ****
  • Offline Offline
  • Posts: 539
  • I am currently on holiday, back in a few weeks. :D
Re: News Bulletin - RSS feed generator, News Bulletin, News Manager...
« Reply #14 on: November 14, 2007, 05:33:34 pm »

First, can we try and solve this problem without that option. Do you have a tool like PhPMyadmin? if so see if the table is created. Post the answer.

Thanks,
Logged
Tambien, Hablo Español      PHP - Achieve Anything
"The Internet is becoming the town square for the global village of tomorrow. " - Bill Gates
Windows 7 Forums

will

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 263
Re: News Bulletin - RSS feed generator, News Bulletin, News Manager...
« Reply #15 on: November 14, 2007, 05:44:31 pm »

I do and that's my point it hasn't created the table. That's why I got this error first time round:

Code: [Select]
mySQL error: Table 'newgallery2007.cpg1411_plugin_news' doesn't exist
Logged

just_some_guy

  • Supporter
  • Coppermine addict
  • ****
  • Offline Offline
  • Posts: 539
  • I am currently on holiday, back in a few weeks. :D
Re: News Bulletin - RSS feed generator, News Bulletin, News Manager...
« Reply #16 on: November 14, 2007, 05:46:45 pm »

So is this error when you install or when you create a new bulletin?
Logged
Tambien, Hablo Español      PHP - Achieve Anything
"The Internet is becoming the town square for the global village of tomorrow. " - Bill Gates
Windows 7 Forums

will

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 263
Re: News Bulletin - RSS feed generator, News Bulletin, News Manager...
« Reply #17 on: November 14, 2007, 05:49:04 pm »

When I install hence:

Code: [Select]
Great plugin but I got this error when installing:

mySQL error: Table 'newgallery2007.cpg1411_plugin_news' doesn't exist

It says in the plugin manager when uploaded the plugin that:

This plugin will create a table called cpg1411_plugin_news. Make sure this table does not already exist.
Logged

just_some_guy

  • Supporter
  • Coppermine addict
  • ****
  • Offline Offline
  • Posts: 539
  • I am currently on holiday, back in a few weeks. :D
Re: News Bulletin - RSS feed generator, News Bulletin, News Manager...
« Reply #18 on: November 14, 2007, 05:52:33 pm »

I have no idea why it is saying that, are you using the attached News_Bulletin_bugfix.zip? and can you attach the codebase.php file so i can see if there is an error.

Thanks,
Logged
Tambien, Hablo Español      PHP - Achieve Anything
"The Internet is becoming the town square for the global village of tomorrow. " - Bill Gates
Windows 7 Forums

will

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 263
Re: News Bulletin - RSS feed generator, News Bulletin, News Manager...
« Reply #19 on: November 14, 2007, 06:34:30 pm »

When I used the first attached file it gave me:

Code: [Select]
There was an error while processing a database query

mySQL error: Table 'newgallery2007.cpg1411_plugin_news' doesn't exist

So I reported this and you attached the 2nd file, when I uploaded that and tried to install it, it gave me:

Code: [Select]
There was an error while processing a database query

mySQL error: Too big column length for column 'name' (max = 255). Use BLOB instead

Its given me the same database error but a different mySQL error for each.

I've attached the codebase file so you can take a look.
Logged
Pages: [1] 2 3 4   Go Up
 

Page created in 0.027 seconds with 19 queries.