Feng Forum

Support => Installation problems => : SUTANEJO June 29, 2010, 05:21:37 PM

: Error upgrade 1.6.2 -- 1.7.0
: SUTANEJO June 29, 2010, 05:21:37 PM

Error upgrade ??

Config file found and loaded.

File '/config/config.php' exists and is writable
Folder '/config' exists and is writable
Folder '/cache' exists and is writable
Folder '/tmp' exists and is writable
Folder '/upload' exists and is writable
Extension 'mysql' is loaded
Extension 'gd' is loaded
Extension 'simplexml' is loaded
Upgrade script has connected to the database.
Test query has been executed. Its safe to proceed with database migration.
Failed to execute DB schema transformations. MySQL said: Duplicate entry 'slim' for key 'extension'
Error upgrading to version 1.7

error in updating,

I can do?

the server was ubuntu 9.10

: Re: Error upgrade 1.6.2 -- 1.7.0
: alvarotm01 June 30, 2010, 12:35:35 PM

Hi,

Try replacing lines 6 - 9 of "public/upgrade/templates/db_migration/1_7_pastafrola.php"

:

INSERT INTO `<?php echo $table_prefix ?>file_types` (`extension`, `icon`, `is_searchable`, `is_image`) VALUES
('slim', 'ppt.png', 1, 0),
('html', 'html.png', 1, 0),
('webfile', 'webfile.png', 0, 0);

with these ones:

:

INSERT INTO `<?php echo $table_prefix ?>file_types` (`extension`, `icon`, `is_searchable`, `is_image`) VALUES
('slim', 'ppt.png', 1, 0),
('html', 'html.png', 1, 0),
('webfile', 'webfile.png', 0, 0)
ON DUPLICATE KEY UPDATE id=id;

this will prevent that failure when insterting a row that already exists.

: Re: Error upgrade 1.6.2 -- 1.7.0
: cabeza June 30, 2010, 01:04:07 PM

It looks like upgrade failed somewhere with a different error and left the base inconsistent.

After that you retried the upgrade and it failed in the first query. That is the error you are sharing with us.

: Re: Error upgrade 1.6.2 -- 1.7.0
: damendieta July 01, 2010, 10:48:44 AM

Hi, I have a similar problem.

    * Config file found and loaded.
    * File '/config/config.php' exists and is writable
    * File '/config/installed_version.php' exists and is writable
    * Folder '/config' exists and is writable
    * Folder '/cache' exists and is writable
    * Folder '/tmp' exists and is writable
    * Folder '/upload' exists and is writable
    * Extension 'mysql' is loaded
    * Extension 'gd' is loaded
    * Extension 'simplexml' is loaded
    * Upgrade script has connected to the database.
    * Test query has been executed. Its safe to proceed with database migration.
    * Failed to execute DB schema transformations. MySQL said: Duplicate key name 'in_reply_to_id'
   * Error upgrading to version 1.6.2

How can I fix it?

: Re: Error upgrade 1.6.2 -- 1.7.0
: cabeza July 01, 2010, 10:56:55 AM

What version did you previously have?

: Re: Error upgrade 1.6.2 -- 1.7.0
: damendieta July 01, 2010, 10:59:42 AM

One more thing, In the from box it says upgrade from 1.6-beta but I'm using 1.6.2

Because of the error I didn't upgrade and click in "back to feng office" insted but when the sistem tried to get back it give me a message

Error
We are sorry, but a fatal error prevented Feng Office from executing your request. An Error Report has been sent to the administrator.

Please, I really need your help. All my information is in there.

Daniel.

: Re: Error upgrade 1.6.2 -- 1.7.0
: damendieta July 01, 2010, 11:01:33 AM

The first install was 1.6-beta, then I upgrade to 1.6.2 via automatic upgrade.

Daniel.

: Re: Error upgrade 1.6.2 -- 1.7.0
: cabeza July 01, 2010, 11:05:53 AM

I assume you have backup up your DB and file system.
If not, do it now.

Then change config/installed_version.php so that it says 1.6.2 intead on 1.6beta and retry.

: Re: Error upgrade 1.6.2 -- 1.7.0
: damendieta July 01, 2010, 11:20:18 AM

Ok, I did it.

Now, What do I do?

Thanks for your help.

: Re: Error upgrade 1.6.2 -- 1.7.0
: cabeza July 01, 2010, 11:43:53 AM

Retry installation going to public/upgrade

: Re: Error upgrade 1.6.2 -- 1.7.0
: damendieta July 01, 2010, 11:58:32 AM

Hi, I tried, but give me this error.


Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@xxxx.net and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache Server at www.hdtb.net Port 80

: Re: Error upgrade 1.6.2 -- 1.7.0
: cabeza July 01, 2010, 12:26:28 PM

set debug to true in config/config.php
retry
and take a look at the log in cache/log.php

post the relevant contents

: Re: Error upgrade 1.6.2 -- 1.7.0
: damendieta July 01, 2010, 01:10:54 PM

Hi, this is what I did.

Back up the files and database
Change debug=true in /config/config.php
Change version to 1.6.2 in /config/installed_version.php
go to /public/upgrade

Then I got this message:

Warning: require_once(/home/hdtbnet1/public_html/iee/environment/functions/general.php) [function.require-once]: failed to open stream: No such file or directory in /home/hdtbnet1/public_html/iee/public/upgrade/include.php  on line 30

Fatal error: require_once() [function.require]: Failed opening required '/home/hdtbnet1/public_html/iee/environment/functions/general.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/hdtbnet1/public_html/iee/public/upgrade/include.php on line 30


My log.php information is too large to public here, but you can check it going to:

www.hdtb.net/log.txt

Thanks a lot, you are a live saver.

Daniel

: Re: Error upgrade 1.6.2 -- 1.7.0
: damendieta July 01, 2010, 01:12:59 PM

I tried to go to my login page and this is the information it gives me:

Warning: include_once(environment/environment.php) [function.include-once]: failed to open stream: No such file or directory in /home/hdtbnet1/public_html/iee/init.php  on line 84

Warning: include_once() [function.include]: Failed opening 'environment/environment.php' for inclusion (include_path='/home/hdtbnet1/public_html/iee/library/pdf:/home/hdtbnet1/public_html/iee/library/PEAR:/home/hdtbnet1/public_html/iee/library/zend:/home/hdtbnet1/public_html/iee:/home/hdtbnet1/public_html/iee/application') in /home/hdtbnet1/public_html/iee/init.php on line 84

Fatal error: Class 'Env' not found in /home/hdtbnet1/public_html/iee/init.php on line 86

Daniel.

: Re: Error upgrade 1.6.2 -- 1.7.0
: cabeza July 01, 2010, 02:22:39 PM

It looks like your filesystem permissions are not right.
The easiest is try 777 to the whole folder to discard permissions issues :).
You can always go back afterwards ...

: Re: Error upgrade 1.6.2 -- 1.7.0
: damendieta July 01, 2010, 02:53:22 PM

Thanks a lot Cabeza, you are a hero.

You save my live.

Well, it is fixed.

I have to change the permissions from 775 to 755 to the next files and folders:

/fengoffice/
/fengoffice/index.php
/fengoffice/public/
/fengoffice/public/install/
/fengoffice/public/install/index.php
fengoffice/public/upgrade/
/fengoffice/public/upgrade/index.php

Ones I made those changes, I went to:

/fengoffice/public/upgrade

Follow the upgrade script and that's it, working again.

I hope it is useful for someone else.

Daniel.

: Re: Error upgrade 1.6.2 -- 1.7.0
: cabeza July 01, 2010, 03:07:39 PM

Glad to hear it's solved.

: Re: Error upgrade 1.6.2 -- 1.7.0
: SUTANEJO July 01, 2010, 08:42:28 PM

thanks for your guidance

but now I get this error

Config file found and loaded.
File '/config/config.php' exists and is writable
Folder '/config' exists and is writable
Folder '/cache' exists and is writable
Folder '/tmp' exists and is writable
Folder '/upload' exists and is writable
Extension 'mysql' is loaded
Extension 'gd' is loaded
Extension 'simplexml' is loaded
Upgrade script has connected to the database.
Test query has been executed. Its safe to proceed with database migration.

Failed to execute DB schema transformations. MySQL said: Duplicate column name 'visible'

[/color]
Error upgrading to version 1.7

can you help me please

: Re: Error upgrade 1.6.2 -- 1.7.0
: cabeza July 02, 2010, 10:16:32 AM

http://forums.fengoffice.com/index.php?topic=4378.msg16302#msg16302

Restore the backup and retry the upgrade with debug=true. Copy the errors you get while trying to upgrade from a working 162 copy.

The errors you get when retrying after a failed install are not useful.

Best

: Re: Error upgrade 1.6.2 -- 1.7.0
: mcedwards54 July 02, 2010, 12:29:15 PM

Running 1.6.2. This is related to installed_version.php.

When I go to /public/upgrade it tells me "You already have upgraded to the latest possible version."

I checked config/installed_version and see "return '1.6.2'; "

Anyone know what could be causing this problem?

: Re: Error upgrade 1.6.2 -- 1.7.0
: linuxman July 03, 2010, 10:14:07 PM

: cabeza  July 02, 2010, 10:16:32 AM

http://forums.fengoffice.com/index.php?topic=4378.msg16302#msg16302

Restore the backup and retry the upgrade with debug=true. Copy the errors you get while trying to upgrade from a working 162 copy.

The errors you get when retrying after a failed install are not useful.

Best

Hi , i try with this method but is not working . I get the
Failed to execute DB schema transformations. MySQL said: Duplicate column name 'visible'
I try upgraded from 1.7-rc2 .

Is working after I remove some line from  1_7_pastafrola.php and from  PastafrolaUpgradeScript.class.php   
And the line I remove is

ALTER TABLE `<?php echo $table_prefix ?>administration_tools` ADD COLUMN `visible` BOOLEAN NOT NULL DEFAULT 1; 

from  1_7_pastafrola.php

and

ALTER TABLE `" . TABLE_PREFIX . "administration_tools` ADD COLUMN `visible` BOOLEAN NOT NULL DEFAULT 1;
from PastafrolaUpgradeScript.class.php

After this I upgrade is perfect .

: Re: Error upgrade 1.6.2 -- 1.7.0
: cabeza July 05, 2010, 09:53:22 AM

: mcedwards54  July 02, 2010, 12:29:15 PM

Running 1.6.2. This is related to installed_version.php.

When I go to /public/upgrade it tells me "You already have upgraded to the latest possible version."

I checked config/installed_version and see "return '1.6.2'; "

Anyone know what could be causing this problem?

This should happen when you have not upgraded the code.

: Re: Error upgrade 1.6.2 -- 1.7.0
: wantman July 07, 2010, 08:31:54 AM

Hi! I'm upgrade fengoffice 1.6.2 to 1.7.0 and have this error:

Failed to execute DB schema transformations. MySQL said: Duplicate entry 'slim' for key 2

How fix it?

: Re: Error upgrade 1.6.2 -- 1.7.0
: cabeza July 07, 2010, 10:19:45 AM

This error usually happens when  you try to upgrade after a failed upgrade.

Please revert to your backup, and retry  the upgrade. If it does not work, copy the error you get the first time.

Best

: Re: Error upgrade 1.6.2 -- 1.7.0
: wantman July 07, 2010, 01:00:56 PM

Yes, i'm try 5 july upgrade but is failed and i'm restore from backup filesystem and BD fengoffice 1.6.2 .
Now i'm backup mysql BD from 4 july and try upgrade 1.6.2 to 1.7.0, and see this error:

Failed to execute DB schema transformations. MySQL said: Table 'og_application_read_logs' already exists

P.S. 5 july, theni first try to upgrade, i do this, but i see bug with lang.js with russian language, and try again, after second attempt upgrade i see errors.

: Re: Error upgrade 1.6.2 -- 1.7.0
: cabeza July 07, 2010, 04:04:00 PM

Does the table og_administration_logs exist in your DB?
What about table og_mail_datas? Is og_mail_datas empty?

: Re: Error upgrade 1.6.2 -- 1.7.0
: SUTANEJO July 07, 2010, 09:00:34 PM

I did the update for aa 1.7 and 1.6.2 gives me this error

nothing appears!

I need help please

Fatal error: Call to undefined method User::isGuest() in /var/www/py/coficina/application/helpers/permissions.php on line 193

Fatal error: Undefined class constant 'ACTION_LOGOUT' in /var/www/py/coficina/application/controllers/AccessController.class.php on line 412

Fatal error: Call to undefined method User::isGuest() in /var/www/py/coficina/application/helpers/permissions.php on line 40

: Re: Error upgrade 1.6.2 -- 1.7.0
: wantman July 08, 2010, 03:19:21 AM

: cabeza  July 07, 2010, 04:04:00 PM

Does the table og_administration_logs exist in your DB?
What about table og_mail_datas? Is og_mail_datas empty?

og_administration_logs, yes exist.
og_mail_datas, not empty .

: Re: Error upgrade 1.6.2 -- 1.7.0
: SUTANEJO July 08, 2010, 08:31:01 AM

in my case are also tables

og_administration_logs, sí existe.
og_mail_datas, no está vacío.

: Re: Error upgrade 1.6.2 -- 1.7.0
: cabeza July 08, 2010, 10:15:38 AM

Have you checked code permissions (try 777 or 755)?
Are you sure you replaced all files?
Was the upgrade interrupted by a power failure or a process killed while upgrading?

If you are Feng Onsite user please enter a ticket and the team will solve it immediately.

: Re: Error upgrade 1.6.2 -- 1.7.0
: wantman July 09, 2010, 10:08:14 AM

: cabeza  July 08, 2010, 10:15:38 AM

Have you checked code permissions (try 777 or 755)?

Yes, i'm try 777 and 755 permissions, but have error:
# Failed to execute DB schema transformations. MySQL said: Duplicate entry 'slim' for key 2

: cabeza  July 08, 2010, 10:15:38 AM

Are you sure you replaced all files?

Yes, i'm replace all files, because i'm create archive.

: cabeza  July 08, 2010, 10:15:38 AM

Was the upgrade interrupted by a power failure or a process killed while upgrading?

No, i'm don't have power failure or a process killed while upgrading

So thanks for help, i'm try write ticket.

: Re: Error upgrade 1.6.2 -- 1.7.0
: cabeza July 09, 2010, 11:30:34 AM

FYI: If those tables exist, the migration process must have been ran before.