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

open
nobody
None
5
2012-07-20
2011-02-07
Finchwizard
No

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.

Discussion

  • 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

     
  • 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?

    Campbell

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

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

     


Anonymous


Cancel   Add attachments