Thread: Database access error after database upload

Hi all,

i have just upload my database. the upload runs without problems.

In the admin-area i can see the member on the admin panel, but when i try to click on the activ, unconfirmed, approval or suspended link or if i try to open the main page i got a database access error.

I my error-email i got this mail:

Error in /index.php: Unknown column 'Profiles.ProfileType' in 'field list'Query: 'SELECT Profiles.ID, Profiles.Headline, Profiles.Country, Profiles.Occupation, Profiles.City, Profiles.Sex, Profiles.NickName, Profiles.Children, Profiles.MerchantPrice, LEFT( Profiles.DescriptionMe, 180 ) AS DescriptionMe, LEFT( Profiles.DescriptionYou, 100 ) AS DescriptionYou, Profiles.DateOfBirth, Profiles.Pic_0_addon, Profiles.Sound, Profiles.ProfileType, Profiles.Sex2, Profiles.DateOfBirth2 FROM `Profiles` WHERE `Status` = 'Active' ORDER BY RAND() LIMIT 4'

Can someone help me with this problem?


best regards Sanne

Are you running on a Windows or Linux server now?

You imported data? Did it some from a Linux or Windows server?

Did you check the tables and field names using something like phpMyAdmin?

In the Profiles table (is it "Profiles" or "profiles" in your database), is their a field ProfileType? (and is it "ProfileType" or "profiletype")

Smoge

Originally Posted by sanne

Error in /index.php: Unknown column 'Profiles.ProfileType' in 'field list'Query: 'SELECT Profiles.ID, Profiles.Headline, Profiles.Country, Profiles.Occupation, Profiles.City, Profiles.Sex, Profiles.NickName, Profiles.Children, Profiles.MerchantPrice, LEFT( Profiles.DescriptionMe, 180 ) AS DescriptionMe, LEFT( Profiles.DescriptionYou, 100 ) AS DescriptionYou, Profiles.DateOfBirth, Profiles.Pic_0_addon, Profiles.Sound, Profiles.ProfileType, Profiles.Sex2, Profiles.DateOfBirth2 FROM `Profiles` WHERE `Status` = 'Active' ORDER BY RAND() LIMIT 4'