Restoring with Akeeba

Resolve database errors after restoring a CF backup with special characters.

Overview

The issue occurs when a form name contains apostrophes or spaces, which creates invalid table names during backup restoration.
Rename the problematic form and its associated database table to remove special characters, then verify all CF database tables exist and have the correct prefix.

Answered
js jscottcarson 22 Jul, 2014
restoring from akeeba back up I get the following..error - Women's Event being the name of a form I created. It errors out and won't resort. Site is off-line. Any ideas?

SQL=SHOW FULL COLUMNS FROM `chronoengine_chronoforms_datatable_Women\'s Event`
Gr GreyHead 22 Jul, 2014
1 Likes
HI jscottcarson,

Looks like the problem is the apostrophe and the space in the table name; please try renaming it to, say, chronoengine_chronoforms_datatable_womens_event

Presumably this came from the form name where apostrophes and spaces are also not allowed so best to rename that too.

Bob
js jscottcarson 24 Jul, 2014
Answer
Thank you very much. Spot on. I got it all back up and running. However, when I go components>chronoforms5 I get the following error and the component does not open.

An error has occurred.
0 SQL=DESCRIBE `chronoengine_extensions`

Have tried phpmyadmin table repair as well as extension manager > database > fix. This does produce the following.. Database schema version (3.2.3-2014-02-20) does not match CMS version (3.2.3).

Any thoughts? Forms seem to be live on the front end, but I can't access the component in the admin area.
Gr GreyHead 25 Jul, 2014
Hi jscottcarson,

I don't recognise the message at all :-(

One oddity is that the table name has no prefix . . . does the chronoengine_extensions table exist?

Bob
This topic is locked and no more replies can be posted.