#203 Internal error - resolution is NULL or <= 0


Fresh install with sample data.

When trying to add an entry to a room, the following appears at the end of the Start Date box.

Internal error - resolution is NULL or <= 0

Here's the following information from the Help Menu.

Meeting Room Booking System: MRBS 1.4.5
Database: MySQL 5.1.49-1ubuntu8.1
System: Linux scruffy 2.6.35-25-generic-pae #44-Ubuntu SMP Fri Jan 21 19:01:46 UTC 2011 i686
Server time: Tue 08 Feb 2011 09:49:45 EST
PHP: 5.3.3-1ubuntu9.3

I thought it might be because we are using PHP 5.3, but any other ideas would be great.


  • Dennis Nguyen

    Dennis Nguyen - 2011-02-22

    I too have this problem ever since MRBS 1.4.5 and later on when doing a fresh install, but when I'm doing an upgrade from previous versions there seems to be no problem.

    Here is my Help Menu info

    Meeting Room Booking System: MRBS 1.4.6
    Database: MySQL 5.1.53-community-log
    System: Windows NT MGTECH-PC 6.1 build 7600 (Unknow Windows version Home Premium Edition) AMD64
    Server time: 2/22/2011 3:08:56 PM
    PHP: 5.3.4

  • Campbell Morrison

    I'm not sure why this is happening. It's one of those internal errors that should never happen ...! You should be able to get round it in the short term by going to edit the areas you get the problem in and saving the area, without necessarily making any changes. Once you've done that you shouldn't get it again.

    I've tried to reproduce it on both Windows and Unix but can't. Finchwizard: when you say "fresh install with sample data", where did the sample data come from? I suspect that may be the cause of the problem. Both: can you let me have your configs (with database details and any other sensitive information removed) so that I can see if I can reproduce it with your configs?


  • Dennis Nguyen

    Dennis Nguyen - 2011-03-03

    Hi, I believe the problem was that we used the included sample data that was in the zip. I used the tables.my.sql to create the tables within phpMyAdmin and then filled the tables with sample-data.sql which was included within mrbs-1.4.6.zip. This seemed to be the trigger for the null problem when trying to book an appointment.

  • Finchwizard

    Finchwizard - 2011-03-03

    I can confirm the Sample Data is the problem.

    I've dropped the database, inserted the tables as per instructions but didn't insert any sample data and everything appears to be working.

  • Dirk De Naegel

    Dirk De Naegel - 2011-05-15

    I had the same problem when installing version 1.4.6 localy and importing data from the operational server (version 1.4.1). The problem disapeared after manualy updating the existing AREAS (all of them). When uploading the old data in the new database not all the fields were filled correctly. By changing all the areas from within the program, I got the solution.

  • Jani Ollikainen

    Jani Ollikainen - 2011-11-01

    cimorrison: Sample data comes with the installation!

    Did a fresh install, did mysql db <sample-data.sql and="" then:="" mysql=""> select DISTINCT resolution from mrbs_area;
    | resolution |
    | NULL |
    1 row in set (0.00 sec)

    Which gives that error...



Cancel  Add attachments

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks