Problems after upgrade from Dolphin 7.0.0 to 7.0.6

Hi,

I need help with my Dolphin Website

I made an upgrade from Dolphin 7.0.0 to Dolphin 7.0.6 on steps: 7.0.0-7.0.1, 7.0.1-7.0.2, 7.0.2-7.0.3, 7.0.3-7.0.4, 7.0.4-7.0.5, 7.0.5-7.0.6.
Right now I have some big problems with my site:
1. I can't log in as admin on the administration panel. I always get the message "Your username or password was incorrect. Please try again"
2. I can't access the website frontpage. I receive an error message: "Database query error".

I've done the typical....clean the cache, cache_public, and tmp files MANUALLY via FTP, but not working.
All these errors appear when I put the website online.
I suppose that isn't big deal, because when I made the test on my localhost server, everything worked very well. After upgrade, I can create new users on my website, I can navigate on every page, but only on localhost.

The error that I received when I try to access the administration is:

Database error in KOLEGAYS
Query:

SELECT `ID` FROM `Profiles` WHERE `NickName` = 'admin'

Mysql error: Table 'anddr3ss_red.Profiles' doesn't exist

Found error in the file '/home/anddr3ss/public_html/inc/admin.inc.php' at line 229.
Called 'db_value' function with erroneous argument #0.


The error that I received when I try to access the website frontpage is:

Database error in KOLEGAYS
Query:

SELECT COUNT(`Profiles`.`ID`) FROM `Profiles`  WHERE `Profiles`.`Status` = 'Active' and (`Profiles`.`Couple` = 0 or `Profiles`.`Couple` > `Profiles`.`ID`)

Mysql error: Table 'kolecom_dolphin.Profiles' doesn't exist

Found error in the file '/home/anddr3ss/public_html/templates/base/scripts/BxBaseIndexPageView.php' at line 363.
Called 'db_value' function with erroneous argument #0.


I made a verification on the database and tha table "Profile" exist.
I need a solution urgently.

So does anyone have any ideas about what causes, or how to fix this, other than clean the cache, cache_public, and tmp files?

Thanks

I can take a  look if you like

farily evident what the problem is there:

Mysql error: Table 'anddr3ss_red.Profiles' doesn't exist

you are missing a table

Check whether you have correct tables. You can look the structure in the installation SQL file.

If you read my message with attention, you can view that I verified the existence of the table "Profiles"

Did you ever send me the details ?

Here is what has me baffeled.

Your first error is this.

Mysql error: Table 'anddr3ss_red.Profiles' doesn't exist

This indicates a database name of anddr3ss_red and the table Profiles.

This is the second error.

Mysql error: Table 'kolecom_dolphin.Profiles' doesn't exist

This one indicates a database name of kolecom_dolphin and the table Profiles

So i wonder if these two errors are from the same website as two different database names does not make any sense.

Check inc/header.inc.php and make sure the database information listed is accurate.

What happend was he downloaded the database to a windows machine  then ran the upgrade and windows makes all the table names lower case then uploaded it back to a new empty database and thus it was looking for "Profiles" and it was now listed as "profiles" after the import.

Yes, thats what exactly happened.

 were you able to get it fixed praveen? 

Yes, He just need to update the name of the tables by looking at the original database.

example

profiles => Profiles

praveenkv1988    Man your funny..  you didnt even fix anything.  If you really must know it was profiles table and 24 others that needed to be renamed.

What happend was he downloaded the database to a windows machine  then ran the upgrade and windows makes all the table names lower case then uploaded it back to a new empty database and thus it was looking for "Profiles" and it was now listed as "profiles" after the import.

To resolve the above issue, that is the solution.

@billybrasov

In both times your getting errors regarding different tables. (anddr3ss_red.Profiles and kolecom_dolphin.Profiles). Check what exactly your database name. Also, let us know the contents of your inc/header.inc.php