upgrade error

[tmjcbs]

Hello,

My upgrade from 2.0.5. to 2.1.8 stops at the following error when I try to load the login page:

Uh-oh.
Form Tools couldn't find all the database tables. Please check your /global/config.php file to confirm the $g_table_prefix setting. The following tables are missing:
ft_email_template_when_sent_views
ft_field_type_validation_rules
ft_field_validation

I can add the following information:

the config file has this line: $g_table_prefix = "ft_";

ft_email_template_when_sent_views is indeed missing, but my database (ft 2.0.5) works fine and had no integrity error,

ft_field_type_validation_rules exists,

ft_field_validation exists, but gives the following error when I try to open it: `vavorijnmond`.`ft_field_validation`: table data is not editable because there is no primary key defined for the table

Luckily I have been able to revert to 2.0.5 and a database backup.

I have no clue how to solve this, any help is appreciated,

Thanks, Theo

[Ben]

Hi Theo,

Sorry you're having trouble - and for not getting back to you earlier; I've been away the last week.

So...! Something must have gone wrong with the upgrade script, preventing those tables from being created. When you initially upgraded, did you see any other errors outputted to the screen, or were you just automatically redirected to the Uh-oh page?

Speaking frankly, this just plain shouldn't happen. Either there's a problem in the upgrade code for your particular environment, or when you upgraded, all the files weren't properly uploaded to your web server causing the upgrade to fail.

I'd suggest this:
1. Edit your config.php file and add the following line:

PHP Code:

$g_default_error_reporting = 2047; 


This outputs all minor warnings and errors. It may provide a few more clues.

2. Try the upgrade again. Wait until all files have been uploaded via FTP, then go to your login screen.

If you still have problems, do you see any additional errors outputted at the very top of the page, prior to (or at the top of) the uh-oh page?

- Ben

[tmjcbs]

Hello Ben,

First off I'd like to thank you very much for this great piece of software! I was asked back in april by my school to develop a database for the submission period for the new schoolyear ('11-'12) and your software was just about perfect for this. I get quite a few compliments from the employees working with formtools about its ease of use while you of course are the one deserving these compliments.

Back to the problem however:
I was automatically redirected to the uh-oh page so I didn't see other errors.
If I do another upgrade attempt I'll follow your suggestions.

I want to use the new version for the new submission period which starts in april '12, so I'm not in any hurry and will probably not do it soon.

I've learnt quite a bit more about all techniques involved (mysql/php etc.) and I'm considering making quite a few changes to the setup of the database. Therefore I wonder if it might be a good idea to do a seperate install of the new version and build the new database from scratch.

Anyway, thanks for your extensive answer, I'll let you know how it goes,

Theo