PDA

View Full Version : Installation errors?


witek
05-23-2008, 02:45 AM
I've moved my site and transferred my whole sql database with it.
I had to reinstall pixelpost which ran smoothly, the site loads fine except when I try to go to my admin page. It says it needs to update the tables, when I click continue it spits out an error:
Upgrade
MySQL Error: Table 'pixelpost_tags' already exists

I delete that table and it spits out:

MySQL Error: Duplicate column name 'altlangfile'



any solutions?

witek
05-25-2008, 01:36 AM
Anyone?
Anyone?


Bueller?
Bueller?

Dkozikowski
05-25-2008, 04:07 AM
Mr. Rooney says you're screwed!

There is no easy way to fix what has happened.

Either the installation was interrupted during the current or previous attempt or your version table was incorrect prior to the upgrade and the wrong procedures were run.

There are a few options.

Option A) Painstakingly go through each table and make sure all procedures found in includes/create_tables.php was performed
Option B) Create a new pixelpost database and transfer over all records 1 by 1 by hand.
Option C) Screw it, start over.
Option D) Contact me via PM and maybe we can work something out where I can do all the dirty work for you.