From:
Phillip Pearson
Date:
2007 May 30 04:15 UTC
Short link
Aslan, hi,
(CC pa-users mailing list - go to
http://lists.peopleaggregator.org/groups/pa-users to join.)
We've got someone else with exactly the same problem... it's possible
there's a problem with the MySQL version on GoDaddy. I'll take a look.
(I've been putting this off as it takes forever to upload all the files
:-) )
I'm uploading a copy of PA to GoDaddy right now. I'll try it with MySQL
4.0 (which should definitely fail), and 4.1 and 5.0. With any luck 4.1
or 5.0 will work - as both are usually fine on our installs.
Cheers,
Phil
Aslan wrote:
> k I've gone through this a few times.. deleting everything and re uploading
and creating a new DB just to be sure... I'm getting stuck in the same spot
during the install process on my server... I'm on GOdaddy the Economy hosting
plan Using Linux... I keep getting the same error heres the output from the
install:
>
> Checking config details
>
> * Able to connect to the MySQL server at h50mysql15.secureserver.net with
supplied login details.
> * SHOW TABLES
> * Initializing database ...
> * Ran 181 database queries from file
/home/content/d/r/e/dreamscience/html/pa/web/config/../../db/PeepAgg.mysql
> * Running database upgrade script and installing default module settings
...
> Running database upgrade script ...
>
> Adding mother network
>
> Changing the extra field of existing networks
>
> Creating tables for existing networks
>
> Changing the extra field of existing networks
>
> Adding extra notification options to all networks.
>
> Adding extra notification options for owner to all networks.
>
> Networks updated successfully
>
> * WARNING: Installation failed (Error updating database or installing
default module settings: DB Error: unknown error; query=ALTER TABLE
user_profile_data DROP KEY user_id, ADD KEY profile_fields (user_id,
field_type, field_name)) - undoing operations
>
> what can I do?
>