List Info

Thread: Error on upgrade 2.1.x to 2.5




Error on upgrade 2.1.x to 2.5
user name
2006-03-22 16:12:39
I tryed to upgrade from 2.1 to 2.5 version and endet with
errors below.
Seems I have to delete this unsupported image first, but how
can I find it?



fluter2:/usr/local/campsite/bin# ./campsite-create-instance
--db_name
fluter_campsite
tables.sql (2.1.x): Templates transfered successfuly
convert: only level zero files Supported
`/usr/local/campsite/www/fluter_campsite/html/images/cms-ima
ge-000000963.wbm
p'.
convert: missing an image filename
`/usr/local/campsite/www/fluter_campsite/html/images/thumbna
ils/cms-thumb-00
0000963.wbmp'.

Warning: chown(): No such file or directory in
/usr/local/campsite/instance/database/upgrade/2.1.x/transfer
_images.php on
line 178

Warning: chgrp(): No such file or directory in
/usr/local/campsite/instance/database/upgrade/2.1.x/transfer
_images.php on
line 179
Images transfered successfuly
ERROR 1062 at line 244: Duplicate entry '1382-2' for key 2
There was an error when upgrading the database; the old
database was
restored.
A backup of the old database is in
/usr/local/campsite/backup/fluter_campsite directory.
Campsite parameters:
APACHE_USER = www-data
APACHE_GROUP = www-data
CAMPSITE_DIR = /usr/local/campsite
BIN_DIR = /usr/local/campsite/bin
SBIN_DIR = /usr/local/campsite/sbin
ETC_DIR = /usr/local/campsite/etc
WWW_DIR = /usr/local/campsite/www
WWW_COMMON_DIR = /usr/local/campsite/www-common
DEFAULT_SMTP_SERVER_ADDRESS = localhost
DEFAULT_SMTP_SERVER_PORT = 25
DEFAULT_DATABASE_SERVER_ADDRESS = localhost
PARSER_START_PORT = 2002
DATABASE_SERVER_ADDRESS = localhost
DATABASE_SERVER_PORT = 0
DATABASE_NAME = fluter_campsite
DATABASE_USER = root
DATABASE_PASSWORD =
PARSER_PORT = 0
PARSER_MAX_THREADS = 0
SMTP_SERVER_ADDRESS = localhost
SMTP_SERVER_PORT = 25

Error on upgrade 2.1.x to 2.5
user name
2006-03-23 13:30:36
I hacked to got out of the previous descriped error by
adding IGNORE to
query in tables.sql line 244:
INSERT IGNORE INTO ArticleImages (NrArticle, IdImage,
Number) SELECT
NrArticle, Id, Number FROM ImagesDup;


But now 2 other issues happend:

1. The campsite-create-instance script does not transfer
templates anymore:
fluter2:/usr/local/campsite/bin# ./campsite-create-instance
--db_name
fluter_campsite
The apache virtual host configuration file:
       
/usr/local/campsite/etc/fluter_campsite/fluter_campsite-vhos
t.conf
was created.

Previous run printed message that templates are transferred:
fluter2:/usr/local/campsite/bin# ./campsite-create-instance
--db_name
fluter_campsite
tables.sql (2.1.x): Templates transfered successfuly
(...)

Because the transfer_templates.php is called before line 244
I cannot
imagine that my change affects this behavior.


2. The browser show following error page:
There were errors!
Internal error: Invalid value "46" of
"issue number"


Note: Issue 46 does exists, it is the newest published
issue.


Error on upgrade 2.1.x to 2.5
user name
2006-03-23 14:51:34
It seems to me that you have some images which were not regonized by the ImageMagic utility and this caused the upgrade to fail. You could pass this by changing the code that converts the images, allowing it to fail and still continue upgrading the database. If you need help with this I need access to your system.

Mugur

Sebastian Goebel <develyellowsunshine.de> wrote:
I tryed to upgrade from 2.1 to 2.5 version and endet with errors below.
Seems I have to delete this unsupported image first, but how can I find it?

fluter2:/usr/local/campsite/bin# ./campsite-create-instance --db_name
fluter_campsite
tables.sql (2.1.x): Templates transfered successfuly
convert: only level zero files Supported
`/usr/local/campsite/www/fluter_campsite/html/images/cms-image-000000963.wbm
p'.
convert: missing an image filename
`/usr/local/campsite/www/fluter_campsite/html/images/thumbnails/cms-thumb-00
0000963.wbmp'.

Warning: chown(): No such file or directory in
/usr/local/campsite/instance/database/upgrade/2.1.x/transfer_images.php on
line 178

Warning: chgrp(): No such file or directory in
/usr/local/campsite/instance/database/upgrade/2.1.x/transfer_images.php on
line 179
Images transfered successfuly
ERROR 1062 at line 244: Duplicate entry '1382-2' for key 2
There was an error when upgrading the database; the old database was
restored.
A backup of the old database is in
/usr/local/campsite/backup/fluter_campsite directory.
Campsite parameters:
APACHE_USER = www-data
APACHE_GROUP = www-data
CAMPSITE_DIR = /usr/local/campsite
BIN_DIR = /usr/local/campsite/bin
SBIN_DIR = /usr/local/campsite/sbin
ETC_DIR = /usr/local/campsite/etc
WWW_DIR = /usr/local/campsite/www
WWW_COMMON_DIR = /usr/local/campsite/www-common
DEFAULT_SMTP_SERVER_ADDRESS = localhost
DEFAULT_SMTP_SERVER_PORT = 25
DEFAULT_DATABASE_SERVER_ADDRESS = localhost
PARSER_START_PORT = 2002
DATABASE_SERVER_ADDRESS = localhost
DATABASE_SERVER_PORT = 0
DATABASE_NAME = fluter_campsite
DATABASE_USER = root
DATABASE_PASSWORD =
PARSER_PORT = 0
PARSER_MAX_THREADS = 0
SMTP_SERVER_ADDRESS = localhost
SMTP_SERVER_PORT = 25



Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.
Error on upgrade 2.1.x to 2.5
user name
2006-03-23 14:47:52
Hi Sebastian,

1. If the message regarding the template transfer wasn't printed it doesn't mean they were not transfered. Just check the look directory in the new install.

2. Restart the template engine. If you still get the same error it means the database was not upgraded properly, in which case I need access to your system to debug.

Mugur

Sebastian Goebel <develyellowsunshine.de> wrote:
I hacked to got out of the previous descriped error by adding IGNORE to
query in tables.sql line 244:
INSERT IGNORE INTO ArticleImages (NrArticle, IdImage, Number) SELECT
NrArticle, Id, Number FROM ImagesDup;


But now 2 other issues happend:

1. The campsite-create-instance script does not transfer templates anymore:
fluter2:/usr/local/campsite/bin# ./campsite-create-instance --db_name
fluter_campsite!
The apache virtual host configuration file:
/usr/local/campsite/etc/fluter_campsite/fluter_campsite-vhost.conf
was created.

Previous run printed message that templates are transferred:
fluter2:/usr/local/campsite/bin# ./campsite-create-instance --db_name
fluter_campsite
tables.sql (2.1.x): Templates transfered successfuly
(...)

Because the transfer_templates.php is called before line 244 I cannot
imagine that my change affects this behavior.


2. The browser show following error page:
There were errors!
Internal error: Invalid value "46" of "issue number"


Note: Issue 46 does exists, it is the newest published issue.




New Yahoo! Messenger with Voice. Call regular phones from your PC and save big.
[1-4]

about | contact  Other archives ( Real Estate discussion Medical topics )