Student Messages / Bulletin System

[Bev]

Hi, I am currently trying the system as it was recommended, but when I try to add a new message, Ill select the day I want to add it to e.g. Wed when I click Send I get the following error:

Error: Incorrect integer value: '' for column 'mon' at row 1

 

I have to 'Select all' to get it to send.

 

Any help would be appreciated.

Thanks

 

Have a look in the add.php module, there is a line in there which needs removing.

 

 

include 'includes/connect.php';

 

$name = mysqli_real_escape_string($con, $_POST['name']);

$title = mysqli_real_escape_string($con, $_POST['title']);

$content = mysqli_real_escape_string($con, $_POST['content']);

 

$mon = $_POST['mon'];

$mon = 0 -> I removed this line

$tue = $_POST['tue'];

$wed = $_POST['wed'];

$thu = $_POST['thu'];

$fri = $_POST['fri'];

[spadam]

Ah Ha! Thanks Bev.. I have it now.. I tried the changes you suggested but still wasn't working how I needed, url was losing a directory when navigating between feeds due to the ../ but I then found the solution. My problem was that the way I had specified the base url meant it was relative to the current url which was causing my navigation problems. I have now changed this to 'http://ipaddress/messages/' and the links all work as intended without any further changes.

 

Looking at your other post I don't have this line

$mon = 0 -> I removed this line

 

so I guess I am using a more recent version.

[Bev]

It did take me a bit of tweaking to get it all set up, but we've had it running since January and for the most part it works very well.

 

I use Rollgator to display the RSS feed on the front screen and I would like to get away from Rollgator and write my own screen for displaying the feed but that's currently beyond my technical know how.

[Theldron]

Hi Bev,

 

Thanks for the help so far but I am still getting the error:

Error: Incorrect integer value: '' for column 'mon' at row 1

 

When I try to select a day rather than select all.

 

Sean

[spadam]

Hi Sean,

 

I have tested this on my install (downloaded today) and am not getting any error when trying to add a message for a particular day. Firstly I would check that your add.php file has the correct value attribute for the input fields relating to the days of the week. On my version they are as follows:

 

       	Which day(s) should the message appear on (until expiry date below)?

             
       Mon  
       Tue  
       Wed 
       Thu 
       Fri 

           / Select all 
	
       

 

and then check your includes/connect.php as @Bev said.

Edited March 18, 2015 by spadam

[Theldron]

Hi mate,

 

I have the same settings as you mate, but I was wondering what versions of MYSQL or PHP are you using?

 

Cheers

[Theldron]

Hi,

 

I have found the solution to the day problem i had to alter the add.php to look like this:

 

$mon = (int)$_POST['mon'];

$tue = (int)$_POST['tue'];

$wed = (int)$_POST['wed'];

$thu = (int)$_POST['thu'];

$fri = (int)$_POST['fri'];

 

I am using the latest verions of MYSQL and PHP so maybe that is why?

 

I still have a couple of issues so I might be back!!

[Theldron]

Right nearly sorted the last thing I am having trouble with is when I try to delete some of the messages it goes to a 'This page can't be displayed' error message.

 

This is the address it gets the error:

http://IPADDRESS/messages/admin/all.php?del=24

 

Any help would be appreciated.

Sean

[Bev]

Does this page exist if you try and vide it directly?

 

http://IPADDRESS/messages/admin/all.php

[Theldron]

Hi Bev,

 

Yeah I can go directly to the page. I have found the issue, when I press delete, it asks me to confirm, but then it tries to take me to the message I just deleted (which of course I just deleted) instead of redirecting me back to the ....admin/all.php page. Not sure how to sort this?

 

Cheers

[spadam]

I was having the same problem. I changed line 6 of all.php to the following and think that it should work for all messages now:

 

header('Location:'.'all.php'.'');

[Theldron]

Brilliant all sorted thanks for your help both.

[TechMonkey]

Thanks Mr Dolan. This is helping staff add notices to our Xibo install now. One change I have made is in the RSS files change the description line to read

 

$rssfeed .= '';

 

This helps if there are any line break as RSS don't like

tags.

[Bev]

What are you using to display the RSS feed?

 

I was using Rollgator, which is great when it works but i find it doesn't always work.

[mrdolan]

Thanks Tech monkey. The RSS aspect is something that I haven't fully developed yet as we don't have any use for it at the moment. I will take note of this when I do.

[Bev]

Just thought I would add to this,

 

I was using Rollgator to display our messages on the reception screen notice board but it kept crashing on a regular basis, so I've found an alternative.

 

 

RSS feed widget free from FeedWind, the best RSS widget available

 

It's designed to create a small widget, but if you set the width to 800 and increase the font size, it looks good on a full screen.

 

 

I use the code this generates to create an HTML page and then I display that on my front screen. So far, it is much more robust, and it can cope with HTML in the descriptions, so if messages have bold, or carriage returns they don't need to be stripped out.

[Theldron]

Hi all,

 

Had to put this on the back burner, but trying to get it working again. I can create posts but they are not showing up on the relevant page. When I go to view all messages in database in shows the expires after date as:

 

0000-00-15 it shows the day I choose but everything is zeros I think this is why I am having issues, but cant figure out how to fix it.

 

Any help would be appreciated.

 

Sean

[Chuckster]

@mrdolan, I am having some problems with this.

 

I get a few lines of error messages which I have attached to this post. The first image shows the error message and the second image shows the snippet of code. It's this code that's being problematic in all of the year**messages.php and allmessages.php pages.

 

 

Any ideas on how to resolve it?

[TechMonkey]

Bug note - Ampersands (&) in titles causes an RSS invalidation which stops Xibo updating. I think using the fix I posted above for the title as well will solve it, but not tried yet.

 

Fault finding generally is helped by validating your RSS feed. I do this by going to https://validator.w3.org/feed/ and using the Validate Direct Input tab. This allows me to paste the RSS output and get a result. Only serious errors need to be solved.

[TechMonkey]

@sadams1980 I think this means the date wasn't selected or hasn't been saved correctly. You should be able to go in and edit the message, set a date and it will work. If editing the date doesn't work then there is an issue with writing the date from the PHP page to your database.

[TechMonkey]

@mrdolan, I am having some problems with this.

 

I get a few lines of error messages which I have attached to this post. The first image shows the error message and the second image shows the snippet of code. It's this code that's being problematic in all of the year**messages.php and allmessages.php pages.

 

[ATTACH=CONFIG]30828[/ATTACH] [ATTACH=CONFIG]30827[/ATTACH]

 

Any ideas on how to resolve it?

@Chuckster - You need quotes (') around the variables title, author and content. PHP will be ok but get a bit confused without them. Alternatively you could turn off error reporting using the line error_reporting(0); at the top of the page but that is sticking your head in the sand a bit.

[linkazoid]

Is there a way that this can be expanded upon, our staff are looking for something that can be used like this but they want to be able to add a comment to a notice that has been posted.

[mrdolan]

Can you explain more about what you mean by adding a comment please?

[linkazoid]

Pretty much like how this forum works, Staff would click on a posting and could then comment on the post to add further information.

 

Perhaps we're better off looking for an internal forum though... although this looks much simpler to use functionality wise

[mrdolan]

Yes I think if you want to effectively create threads of comments then forum software would probably be the best option.