News Bulletin - RSS feed generator, News Bulletin, News Manager...

just_some_guy · November 11, 2007, 06:08:27 PM

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.

Joachim Müller · November 12, 2007, 03:13:47 PM

Quote from: just_some_guy on November 11, 2007, 06:08:27 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.

just_some_guy · November 12, 2007, 06:10:34 PM

Ok, i will know that for the future. Thanks GauGau.

will · 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.

just_some_guy · 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.

will · 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.

just_some_guy · 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.

will · 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

just_some_guy · 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.

will · 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

Joachim Müller · 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.

will · 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

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

just_some_guy · 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.

will · 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.

just_some_guy · 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,

will · 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

just_some_guy · November 14, 2007, 05:46:45 PM

So is this error when you install or when you create a new bulletin?

will · 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.

just_some_guy · 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,

will · 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.

coppermine-gallery.com/forum

News:

News Bulletin - RSS feed generator, News Bulletin, News Manager...

just_some_guy

Joachim Müller

just_some_guy

will

just_some_guy

will

just_some_guy

will

just_some_guy

will

Joachim Müller

will

just_some_guy

will

just_some_guy

will

just_some_guy

will

just_some_guy

will