Error upgrade 1.6.2 -- 1.7.0

[SUTANEJO]

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

[alvarotm01]

Hi,

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

Code: [Select]

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:

Code: [Select]

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.

[cabeza]

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.

[damendieta]

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?

[cabeza]

What version did you previously have?

[damendieta]

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.

[damendieta]

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

Daniel.

[cabeza]

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.

[damendieta]

Ok, I did it.

Now, What do I do?

Thanks for your help.

[cabeza]

Retry installation going to public/upgrade

[damendieta]

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

[cabeza]

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

post the relevant contents

[damendieta]

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

[damendieta]

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.

[cabeza]

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 ...