Thread tagged as: Error, Configuration

Cannot log into perch on my site

I have just moved my site to a new host. I imported my sql database and got through the setup and login just fine but encountered these error messages: The following error occurred:

RENAME TABLE perch2_content_resources TO perch2_resource_log SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'perch2_resource_log' already exists The following error occurred: ALTER TABLE perch2_resource_log DROP PRIMARY KEY SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key

Stacey Plant

Stacey Plant 0 points

  • 7 years ago

Should I accept these errors and continue or alter the tables?

Rachel Andrew

Rachel Andrew 394 points
Perch Support

See the solution, how to move a Perch Site:

You should not be going through setup if you have moved the database.

I followed those instructions and still get the same error message. Should I accept these errors and continue?

Rachel Andrew

Rachel Andrew 394 points
Perch Support

When do you get this error? What steps are you following?

I followed the steps you linked to here: I accepted the errors and continued. Seems to be ok. I'll let you know if it trips up somewhere.

Found a glitch. The link to the webpage from perch's world icon is wrong. How do I fix it? It should go to but instead goes to leading to a 404 page

Drew McLellan

Drew McLellan 2638 points
Perch Support

That's on the Settings page - you should just be able to update it.

oops, sorry about that.



Not a big deal, just thought you would want to know.