| Project: | ProjectPier |
| Version: | 0.8.6-stable |
| Component: | Miscellaneous |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | new |
Jump to:
Description
Here's the error that I get:
Config file found and loaded.
Upgrade script has connected to database projectsdb3
Upgrade selected database projectsdb3
Test query has been executed. It is safe to proceed with database migration.
Configuration file is writable.
Migrating to new permissions system.
Failed to retrieve current (project,user) permissions. Error 1146: Table 'projectsdb3.project_users' doesn't exist
Upgrade process failed!
==========================
Here's my config file:
<?php
define('DB_ADAPTER', 'mysql');
define('DB_HOST', 'localhost');
define('DB_USER', 'username');
define('DB_PASS', 'password');
define('DB_NAME', 'projectsdb3');
define('DB_PERSIST', true);
define('TABLE_PREFIX', 'pp_');
define('ROOT_URL', 'example.com/projects');
define('DEFAULT_LOCALIZATION', 'en_us');
define('DEBUG', false);
define('PRODUCT_VERSION', '0.8.0.3');
define('SHOW_MESSAGE_BODY', true);
define('SHOW_COMMENT_BODY', true);
define('SHOW_MILESTONE_BODY', true);
define('TOKEN_COOKIE_NAME', 'somerandomcookie');
define('DB_CHARSET', 'utf8');
return true;
?>
Hi,
I got the same error and I resolved it this way:
On public\upgrade\scripts\PearUpgradeScript.class.php I had changed line 210
$pup_query = "select project_id, user_id, project_users.* FROM project_users";
to this one
$pup_query = "select project_id, user_id FROM `$project_users_table`";
The problem was that the query was looking for table "project_users" which doesn't exist exactly with this name since it haves a prefix so I put instead the variable that contains the wright table name. The second problem on this query is that "project_users.*" doesn't exist as a field and also it was writen with a syntax mistake. Hope it will work for you!
I am not sure why you would use the 0.8.0.3 to 0.8.5 upgrade script for 0.8.6.
Just follow the instructions here:
http://www.projectpier.org/node/2132
0.8.5?? We were talking about upgrading to 0.8.6, I found this 210 line wich wasn't correct on file PearUpgradeScript.class.php and you are talking about the permissions problem on 0803-086.php.
Clearly, you did not read UPGRADE.txt and you did not spend time trying to read the link I gave you. Please do that before trying all kinds of stuff. I have pasted UPGRADE.txt here for your convenience. Read that, than read the link again.
Good luck...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Upgrading to ProjectPier 0.8.6
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ProjectPier 0.8.6 is NOT database compatible with previous versions.
Upgrade instructions
1) Make a copy of your 0.8.0.3 database
2) Make a new database from your copy (this ensures the copy is okay)
3) Archive your 0.8.0.3 copy in a safe place
4) Run the script 0803-086.php in public/upgrade/templates/db_migration against the copy of step 1.
5) If step 4 completes without errors, run the same script against your production database else stop and report.
6) Install 0.8.6 on a fresh database.
After the complete installation:
7) Edit 0.8.6 /config/config.php and set the values equal to the values of your 0.8.0.3 production database
8) Open the browser on your 0.8.6 site and login with your 0.8.0.3 user id and password
9) Drop the 0.8.6 database
10) Enjoy 0.8.6
Yes I did read it and when I got to step 4 is when I got the error that rushal posted. I downloaded today 0.8.6 version, wouldn't be much easy to check the file were I found that error?? Maybe you should read more carefully what I said. I just wanted to collaborate helping on this issue I could resolve, if you feel I'm doing wrong posting a solution that was good for me, let me know and I will not bother again. Otherwise, in case you need help on spanish translation I may offer my collaboration.