search

google-code-export / glossword

Automatically exported from code.google.com/p/glossword
0 stars 0 forks source link

I can not upgrade from 1.8.9 #71

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
= What steps will reproduce the problem?
1. Find a working glossword 1.8.9
2. Replace all files with files from 1.8.10 excluding db_config.php
3. Go to http://localhost/gw_install/
4. Choose language (English) + click on Next
5. Choose upgrade from Update from 1.8.9 to 1.8.10
6. Click on "Continue to the next step"
7. Nothing happens (bank page is opened)

= What is the expected output? What do you see instead?
There are errors in /var/log/httpd/error_log:

[Sun Jul 13 21:35:51 2008] [notice] Apache/2.2.8 (Mandriva
Linux/PREFORK-6mdv2008.1) mod_python/3.3.1 Python/2.5.2 PHP/5.2.5 with
Suhosin-Patch mod_perl/2.0.4-dev Perl/v5.10.0 configured -- resuming normal
operations
[Sun Jul 13 21:36:11 2008] [error] [client 127.0.0.1] PHP Warning: 
Variable passed to each() is not an array or object in
/home/zdpo/myapp/glossword/inc/func.browse.inc.php on line 743
[Sun Jul 13 21:36:22 2008] [error] [client 127.0.0.1] PHP Warning: 
include(includes/mysql410/mysql410_driver.php) [<a
href='function.include'>function.include</a>]: failed to open stream: No
such file or directory in
/home/zdpo/myapp/glossword/gw_install/includes/DB.php on line 24, referer:
http://level2/~zdpo/slovniky/gw_install/index.php?arg[action]=1.8.9-1.8.10&arg[i
l]=english&arg[target]=update
[Sun Jul 13 21:36:22 2008] [error] [client 127.0.0.1] PHP Warning: 
include() [<a href='function.include'>function.include</a>]: Failed opening
'includes/mysql410/mysql410_driver.php' for inclusion
(include_path='.:/usr/lib/php/:/usr/share/pear/') in
/home/zdpo/myapp/glossword/gw_install/includes/DB.php on line 24, referer:
http://level2/~zdpo/slovniky/gw_install/index.php?arg[action]=1.8.9-1.8.10&arg[i
l]=english&arg[target]=update
[Sun Jul 13 21:36:22 2008] [error] [client 127.0.0.1] PHP Warning: 
include(includes/mysql410/mysql410_forge.php) [<a
href='function.include'>function.include</a>]: failed to open stream: No
such file or directory in
/home/zdpo/myapp/glossword/gw_install/includes/DB.php on line 25, referer:
http://level2/~zdpo/slovniky/gw_install/index.php?arg[action]=1.8.9-1.8.10&arg[i
l]=english&arg[target]=update
[Sun Jul 13 21:36:22 2008] [error] [client 127.0.0.1] PHP Warning: 
include() [<a href='function.include'>function.include</a>]: Failed opening
'includes/mysql410/mysql410_forge.php' for inclusion
(include_path='.:/usr/lib/php/:/usr/share/pear/') in
/home/zdpo/myapp/glossword/gw_install/includes/DB.php on line 25, referer:
http://level2/~zdpo/slovniky/gw_install/index.php?arg[action]=1.8.9-1.8.10&arg[i
l]=english&arg[target]=update
[Sun Jul 13 21:36:22 2008] [error] [client 127.0.0.1] PHP Fatal error: 
Class 'CI_DB_mysql410_driver' not found in
/home/zdpo/myapp/glossword/gw_install/includes/DB.php on line 26, referer:
http://level2/~zdpo/slovniky/gw_install/index.php?arg[action]=1.8.9-1.8.10&arg[i
l]=english&arg[target]=update

= What version of the product are you using? On what operating system?
Mandriva 2008.1
mysql-5.0.51a-7mdv2008.1
php 2.5.2

= Please provide any additional information below.

I tried installation (instead of upgrade) to see if there is not
requirement problem. There is problem reported: "Database setting
max_allowed_packet" where required value is "1 MB" and checker says my
setting is "0 MB ". So I log in to mysql console and run "show variables
like 'max_allowed%';" I got this result:
+--------------------+---------+
| Variable_name      | Value   |
+--------------------+---------+
| max_allowed_packet | 1047552 |
+--------------------+---------+

So it is not true my setting is "0 MB".

Original issue reported on code.google.com by zde...@gmail.com on 13 Jul 2008 at 8:20

GoogleCodeExporter commented 9 years ago 
>failed to open stream: No such file or directory in
/home/zdpo/myapp/glossword/gw_install/includes/DB.php 

Try new file update_1.8.9-1.8.10.php

> 1047552
> So it is not true my setting is "0 MB".

This is 0 MB because there are 1024 bytes in one megabyte.
1024*1024 is 1048576 and 1024 bytes are missed here (1048576-1047552).

I've changed the requirements (in attached file).

However max_allowed_packet should be 16 MB if we are planing to work with BLOB 
field
types.

Update files:

gw_install\views\install_.php
gw_install\views\update_1.8.9-1.8.10.php

Original comment by dmitry.s...@gmail.com on 14 Jul 2008 at 12:01

Attachments:

GoogleCodeExporter commented 9 years ago 
max_allowed_packet has initial value - I increased it.

Anyway upgrade still do not work for me /var/log/httpd/error_log:

[Mon Jul 14 12:07:28 2008] [error] [client 127.0.0.1] PHP Fatal error:  Call to 
a
member function num_rows() on a non-object in
/home/zdpo/myapp/glossword/gw_install/includes/DB_driver.php on line 774, 
referer:
http://level2/~zdpo/slovniky/gw_install/index.php?arg[action]=1.8.9-1.8.10&arg[i
l]=english&arg[target]=update
[Mon Jul 14 12:07:33 2008] [error] [client 127.0.0.1] PHP Fatal error:  Call to 
a
member function num_rows() on a non-object in
/home/zdpo/myapp/glossword/gw_install/includes/DB_driver.php on line 774, 
referer:
http://level2/~zdpo/slovniky/gw_install/index.php?arg[action]=1.8.9-1.8.10&arg[i
l]=english&arg[target]=update

Original comment by zde...@gmail.com on 14 Jul 2008 at 10:15

GoogleCodeExporter commented 9 years ago 
The script can't retrieve the list of database tables in case of unknown reason.

Add the code to file DB_driver.php, line 770:

print $sql;

Run update, SQL-request should appear on screen, like

SHOW TABLES FROM database.

Then, run these database requests manually with phpmyadmin.

Perhaps, the command "SHOW TABLES" is disabled for the current MySQL user.

Original comment by dmitry.s...@gmail.com on 14 Jul 2008 at 4:43

GoogleCodeExporter commented 9 years ago 
Output is this:

SHOW TABLES FROM ``database``

When I run in mysql console I got this error message:

ERROR 1102 (42000): Incorrect database name ''
(problem is with that double `` - before and after database name)

I look at db_config.php and really there this wrong definitions:
define('GW_DB_DATABASE', '`database`');

Strange that it works in 1.8.9 ;-)

After correction of db_config.php, I was able to get to Step 3 of upgrade.
Unfortunately when I tried to go on main page I got this (page) information:
--------------------------
The installer is locked.

Before to run this script, you need to remove or rename the
/home/zdpo/myapp/glossword/gw_temp/install_lock.txt file. It can be done with 
any
FTP-client software (Filezilla, FlashFXP, and others). 
------------------------

When I removed install_lock.txt I can run upgrade/installation once again (with 
the
same result).

/var/log/httpd/error_log:
[Mon Jul 14 21:03:03 2008] [error] [client 127.0.0.1] PHP Warning:  Variable 
passed
to each() is not an array or object in
/home/zdpo/myapp/glossword/inc/func.browse.inc.php on line 743
[Mon Jul 14 21:03:13 2008] [error] [client 127.0.0.1] PHP Warning:  Variable 
passed
to each() is not an array or object in
/home/zdpo/myapp/glossword/inc/func.browse.inc.php on line 743

Original comment by zde...@gmail.com on 14 Jul 2008 at 7:10

GoogleCodeExporter commented 9 years ago 
> I was able to get to Step 3 of upgrade
The update is complete then.

> Unfortunately when I tried to go on main page
You don't need to do a further actions, update is complete and you may open the 
main
page of Glossword (not the main page of the installer).

Add the code to file func.browse.inc.php:

line 743: prn_r( $arSql );
line 744: exit;

This is inside function getSettings();

Original comment by dmitry.s...@gmail.com on 14 Jul 2008 at 8:13

GoogleCodeExporter commented 9 years ago 
>> Unfortunately when I tried to go on main page
> You don't need to do a further actions, update is complete and you may open 
the main
> page of Glossword (not the main page of the installer).

I was automatically redirected to installer

> Add the code to file func.browse.inc.php:

> line 743: prn_r( $arSql );
> line 744: exit;

> This is inside function getSettings();

I put it there (see attachment) and I am not redirected to installer. 
Unfortunately
main page is blank...

Original comment by zde...@gmail.com on 15 Jul 2008 at 7:00

Attachments:

GoogleCodeExporter commented 9 years ago 
Try attached file.

Original comment by dmitry.s...@gmail.com on 19 Jul 2008 at 5:06

Attachments:

GoogleCodeExporter commented 9 years ago 
With this file (after upgrade to 1.8.10) when I go to main page, 
installation/upgrade
procedure is run (in circle)...

/var/log/httpd/error_log:

[Sun Jul 20 21:03:44 2008] [error] [client 127.0.0.1] PHP Warning:  Variable 
passed
to each() is not an array or object in
/home/zdpo/myapp/glossword/inc/func.browse.inc.php on line 744
[Sun Jul 20 21:03:56 2008] [error] [client 127.0.0.1] PHP Warning:  Variable 
passed
to each() is not an array or object in
/home/zdpo/myapp/glossword/inc/func.browse.inc.php on line 744

Original comment by zde...@gmail.com on 20 Jul 2008 at 7:08

GoogleCodeExporter commented 9 years ago

Original comment by dmitry.s...@gmail.com on 18 Feb 2010 at 9:22