Several Issues After 4.2->4.5.0h upgrade

[ggolin]

Went through an upgrade - it was a bumpy ride to say the least.

1.This is what I get in the logs when I try the 'repair database ' option.
PHP Fatal error: require_once() [<a href='function.require'>function.require</a>]: Failed opening required '' (include_path='.:/usr/share/pear') in /var/www/html/sugar/modules/Administration/repairDatabase.php on line 75, referer: http://sugar.ourserver.com/sugar/ind...repairDatabase
2. The logs are littered with php notices about undefined indexes:
PHP Notice: Undefined index: default_currency_significant_digits in /var/www/html/sugar/include/Localization/Localization.php on line 132, referer: http://sugar.ourserver.com/sugar/ind...n&module=Users
3. When sending email from the 'Compose Email' screen it indeed sends, but when it shows you the sent email right after seding, there is an error displayed at the bottom of the page:
Error running count query for Email List: Query Failed SELECT count( DISTINCT ) FROM notes where notes.deleted=0 )::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') FROM notes where notes.deleted=0 )' at line 1

Has anyone seen these issues?

sugarpro-4.5.0h
centos-4
php-5.1
mysql-4.1
apache-2

Thanks,
Greg

[kpit]

Went through an upgrade - it was a bumpy ride to say the least.

1.This is what I get in the logs when I try the 'repair database ' option.
PHP Fatal error: require_once() [<a href='function.require'>function.require</a>]: Failed opening required '' (include_path='.:/usr/share/pear') in /var/www/html/sugar/modules/Administration/repairDatabase.php on line 75, referer: http://sugar.ourserver.com/sugar/ind...repairDatabase
2. The logs are littered with php notices about undefined indexes:
PHP Notice: Undefined index: default_currency_significant_digits in /var/www/html/sugar/include/Localization/Localization.php on line 132, referer: http://sugar.ourserver.com/sugar/ind...n&module=Users
3. When sending email from the 'Compose Email' screen it indeed sends, but when it shows you the sent email right after seding, there is an error displayed at the bottom of the page:
Error running count query for Email List: Query Failed SELECT count( DISTINCT ) FROM notes where notes.deleted=0 )::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') FROM notes where notes.deleted=0 )' at line 1

Has anyone seen these issues?

sugarpro-4.5.0h
centos-4
php-5.1
mysql-4.1
apache-2

Thanks,
Greg

I have seen some issues like this you should file a case in the sugar support portal as you have a pro license.

One of the things I did was download the full installer version of Sugar for the current version and overwrite all files except the config.php. Then login and run all the repair tools in the admin pannel for the database. This method will loose any customizations you may have done with the studio or layouts. The data will remain intact including custom fields.