Fatal error: unfortunately the database is not available at the moment.

[antham1616]

when trying to edit or add entry i get the following message

Fatal error: unfortunately the database is not available at the moment.

when debugging it states

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '80902' for key 'PRIMARY' SQL: INSERT INTO mrbs_entry (`

[campbell-m]

Which version of MRBS are you running? And have you made any changes to it? Can you please post the full stack trace from the debug output, having first removed any confidential data.

[antham1616]

MRBS version | MRBS 1.9.2 -- | -- Database schema version | 77 Database local schema version | 1 $auth['type'] | db $auth['session'] | php

[campbell-m]

Is there any reason why you can't upgrade to the latest version of MRBS (1.11.5)?

[antham1616]

Legacy with many modifications

[antham1616]

#0 MRBS\generate_backtrace() called at [/homepages/15/d858295215/htdocs/NDCT-V1.0/web/functions_error.inc:152]
#1 MRBS\output_error() called at [/homepages/15/d858295215/htdocs/NDCT-V1.0/web/functions_error.inc:182]
#2 MRBS\error_handler(2, Cannot modify header information - headers already sent by (output started at /homepages/15/d858295215/htdocs/NDCT-V1.0/web/functions_error.inc:157), /homepages/15/d858295215/htdocs/NDCT-V1.0/web/functions.inc, 694, array)
#3 header(Expires: Mon, 26 Jul 1997 05:00:00 GMT) called at [/homepages/15/d858295215/htdocs/NDCT-V1.0/web/functions.inc:694]
#4 MRBS\expires_header(0) called at [/homepages/15/d858295215/htdocs/NDCT-V1.0/web/functions.inc:709]
#5 MRBS\http_headers(array) called at [/homepages/15/d858295215/htdocs/NDCT-V1.0/web/Themes/default/header.inc:547]
#6 MRBS\print_theme_header(array, true, false) called at [/homepages/15/d858295215/htdocs/NDCT-V1.0/web/functions.inc:749]
#7 MRBS\print_header(NULL, true) called at [/homepages/15/d858295215/htdocs/NDCT-V1.0/web/functions.inc:718]
#8 MRBS\print_simple_header() called at [/homepages/15/d858295215/htdocs/NDCT-V1.0/web/functions_error.inc:220]
#9 MRBS\fatal_error(Fatal error: unfortunately the database is not available at the moment.) called at [/homepages/15/d858295215/htdocs/NDCT-V1.0/web/functions_error.inc:210]
#10 MRBS\exception_handler(object)

[antham1616]

Uncaught exception 'MRBS\DBException' in /homepages/15/d858295215/htdocs/NDCT-V1.0/web/lib/MRBS/DB.php at line 109
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '80911' for key 'PRIMARY'
SQL: INSERT INTO mrbs_entry (`start_time`, `end_time`, `entry_type`, `repeat_id`, `room_id`, `create_by`, `modified_by`, `name`, `trip_ref`, `type`, `customer_name`, `customer_number`, `wheelchair_required`, `description`, `status`, `ical_uid`, `ical_sequence`, `ical_recur_id`, `pickup_address`, `pickup_town`, `pickup_postcode`, `pickup_time`, `appointment_time`, `destination_address`, `destination_town`, `destination_postcode`, `return_time`, `driver`, `driver_assistant`, `payment_type`, `fee`, `paid_driver`, `start_mileage`, `end_mileage`, `fuel_litres_purchased`, `shoppers`, `other_area_shoppers`, `no_shows`, `allow_registration`, `enable_registrant_limit`, `registrant_limit`, `CANCELLATIONS`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: Array
(

[campbell-m]

Thanks. Was there any more of the stack trace? I'd expect to see some more lines below the last one.

[antham1616]

there is but its all the post values with alot of confidential data

[campbell-m]

Can you post a screenshot from phpMyAdmin of the structure of your mrbs_entry table?

[antham1616]

[campbell-m]

I don't know why this is happening? Can you reproduced the problem at will? If so, does it still hapen if you run vanilla MRBS 1.9.2?

[antham1616]

only happens when adding new entry or editing existing, able to open add participants without issue setup upgraded vanilla database, connected existing site to it no issues so far

[antham1616]

will try copying existing database and running upgrade to see if resolves

[campbell-m]

setup upgraded vanilla database, connected existing site to it no issues so far

What happens if you run vanilla MRBS 1.9.2 against your database?