Hey All,
I have a major problem. I have a 350b (Open Source) install and finally need to upgrade.
I am not a programmer.
What I have…
MySQL - 4.1.18-standard
phpMyAdmin - 2.8.0.4
Fedora Core 2 – with numerous updates and upgrades.
What I have done…
I tried the upgrade patch SugarSuite-Patch-3.5.0b.zip
And got this error…
The uploaded file is not compatible with the current version (3.5.0b) of Sugar.
I found the “Upgrading to Sugar Suite 3.5.1” and the files to upgrade the MySQL.
I have actually check marked the order as I went through it
When I attempt to update the MySQL (running the query from within PHPmyAdmin) I get errors. As the instructions say I run them in order.
When I run “2.0.x-2.5_open_db_upgrade.sql” file
Error
SQL query:
-- --------------------------------------------------------
--
-- Table structure for table `users_feeds`
--
CREATE TABLE `users_feeds` (
`user_id` char( 36 ) NOT NULL default '',
`feed_id` char( 36 ) NOT NULL default '',
`rank` int( 11 ) NOT NULL default '0',
`deleted` tinyint( 1 ) NOT NULL default '0',
KEY `idx_user_id` ( `user_id` , `feed_id` )
) TYPE = MYISAM ;
MySQL said:
#1050 - Table 'users_feeds' already exists
When I run “2.5-2.5.1_open_db_upgrade.sql”
Error
SQL query:
-- $Id: 2.5-2.5.1_open_db_upgrade.sql,v 1.3 2005/04/07 22:56:48 bob Exp $
ALTER TABLE bugs ADD `fixed_in_release` varchar( 255 ) DEFAULT NULL AFTER `type` ;
MySQL said:
#1060 - Duplicate column name 'fixed_in_release'
As I see it those are the two most important sql upgrades.
At this point I am not all that certain what I am doing wrong.
Thanks!


LinkBack URL
About LinkBacks



Reply With Quote
Bookmarks