Announcement

#31 2007-05-14 23:09:01

VDigital
Former Piwigo Team
Paris (FR)
2005-05-04
17680

Re: Upgrade 1.6.x to 1.7.x

krickett wrote:

I already had a table named "phpwebgallery_history_backup" with the same information as "phpwebgallery_history" so i renamed "phpwebgallery_history" to "phpwebgallery_history_backup7" incase i need it again later.  "phpwebgallery_history" was then created as you instructed.

Ryan,

Check phpwebgallery_history_backup would be empty. If it is drop it and rename "phpwebgallery_history_backup7" in "phpwebgallery_history_backup".

We are very close to the end, I think.
I didn't check indexes because I didn't get them. I didn't get them because you hadn't done an EXPORT structure as I requested.
We can hope Indexes are corrects.
You can check you're self, if you know SQL a bit.
All creative statements (DDL) are in ./install/phpwebgallery_structure.sql
or if your prefer available online SVN Repositories at Gna! - markup - phpwebgallery: branches/branch-1_7/install/phpwebgallery_structure.sql

PhpMyAdmin:
1 .  Could you display phpwebgallery_config table and tell me if "email_admin_on_picture_uploaded" is in param column?
2 . Tell me how many rows you have in phpwebgallery_comments table.
3 . Last and not least: Could you display phpwebgallery_config table and tell me if "auto_expand" is in param column?

8-)


Piwigo.com: Start and run your own photo gallery. Signup and get 30 days to try for free, no commitment.
8-)

Offline

 

#32 2007-05-15 00:03:43

krickett
Member
2007-02-07
26

Re: Upgrade 1.6.x to 1.7.x

phpwebgallery_history_backup is NOT empty.  phpwebgallery_history_backup has about 11,000 rows while phpwebgallery_history_backup7 has about 6,000 rows.  It looks like phpwebgallery_history_backup is a newer version of phpwebgallery_history_backup7 because it has the same information as phpwebgallery_history_backup7 along with more information.

Should i just drop phpwebgallery_history_backup7?

Sorry for not exporting the correct structure.  I was working on it late last night and for some reason it wasn't outputing the correct data and the format i sent you was the only format i could find that didn't have all the data in it.  I did some more searching today and i think i found the format you want.

The file is at http://www.4wdtoyota.com/fullstructure.doc

Again, sorry about the confusion.

To answer your questions:

1.) No, "email_admin_on_picture_uploaded" is not in the param column.
2.) There are 0 rows in the comments table
3.) Yes, "auto_expand" is in the param column

Offline

 

#33 2007-05-15 00:44:27

VDigital
Former Piwigo Team
Paris (FR)
2005-05-04
17680

Re: Upgrade 1.6.x to 1.7.x

krickett wrote:

phpwebgallery_history_backup is NOT empty.  phpwebgallery_history_backup has about 11,000 rows while phpwebgallery_history_backup7 has about 6,000 rows.  It looks like phpwebgallery_history_backup is a newer version of phpwebgallery_history_backup7 because it has the same information as phpwebgallery_history_backup7 along with more information.

Should i just drop phpwebgallery_history_backup7?

Sorry for not exporting the correct structure.  I was working on it late last night and for some reason it wasn't outputing the correct data and the format i sent you was the only format i could find that didn't have all the data in it.  I did some more searching today and i think i found the format you want.

The file is at http://www.4wdtoyota.com/fullstructure.doc

Again, sorry about the confusion.

To answer your questions:

1.) No, "email_admin_on_picture_uploaded" is not in the param column.
2.) There are 0 rows in the comments table
3.) Yes, "auto_expand" is in the param column

Keep both History backup tables. We will merge them on time. 8-)

My next task will be to have a look on your doc...
(Maybe you can check too with previous link to /branch-1_7/install/phpwebgallery_structure.sql).

Now, your 3 answers:

1. I was expecting Yes.
2. Lucky we are.
3. I was expecting... No.

So, we have a some work...
Just another request:
Could you list me your config table? If a line as param = 'secret_key' suppress that line from the list.

FYI: Official contents
SVN Repositories at Gna! - markup - phpwebgallery: branches/branch-1_7/install/config.sql : here !!!

Yeh, near to conclude.
8-)


Piwigo.com: Start and run your own photo gallery. Signup and get 30 days to try for free, no commitment.
8-)

Offline

 

#34 2007-05-15 00:58:01

krickett
Member
2007-02-07
26

Re: Upgrade 1.6.x to 1.7.x

Here is my config table:

http://www.4wdtoyota.com/config.jpg


There is no 'secret_key' line.

Judging by the link you posted, it definetely looks like we have some work to do.

Offline

 

#35 2007-05-16 17:17:16

VDigital
Former Piwigo Team
Paris (FR)
2005-05-04
17680

Re: Upgrade 1.6.x to 1.7.x

PhpMyAdmin, left side column, First SQL icon:

INSERT INTO phpwebgallery_config
(param,value,comment)
VALUES
('show_nb_hits', 'false', 'Show hits count under thumbnails');
INSERT INTO phpwebgallery_config
(param,value,comment)
VALUES
('history_admin','false','keep a history of administrator visits on your website');
INSERT INTO phpwebgallery_config
(param,value,comment)
VALUES
('history_guest','true','keep a history of guest visits on your website');
INSERT INTO phpwebgallery_config
(param,value,comment)
VALUES
('allow_user_registration','true','allow visitors to register?');
INSERT INTO phpwebgallery_config
(param,value,comment)
VALUES
('secret_key', MD5(RAND()), 'a secret key specific to the gallery for internal use');
INSERT INTO phpwebgallery_config
(param,value,comment)
VALUES
('nbm_send_html_mail','true','Send mail on HTML format for notification by mail');
INSERT INTO phpwebgallery_config
(param,value,comment)
VALUES
('nbm_send_recent_post_dates','true','Send recent post by dates for notification by mail');
INSERT INTO phpwebgallery_config
(param,value,comment)
VALUES
('email_admin_on_new_user','false','Send an email to theadministrators when a user registers');
INSERT INTO phpwebgallery_config
(param,value,comment)
VALUES
('email_admin_on_comment','false','Send an email to the administrators when a valid comment is entered');
INSERT INTO phpwebgallery_config
(param,value,comment)
VALUES
('email_admin_on_comment_validation','false','Send an email to the administrators when a comment requires validation');
INSERT INTO phpwebgallery_config
(param,value,comment)
VALUES
('email_admin_on_picture_uploaded','false','Send an email to the administrators when a picture is uploaded');
UPDATE phpwebgallery_user_cache
SET need_update = 'true';

UPDATE phpwebgallery_user_infos
SET
template = 'yoga/clear',
nb_image_line = 3,
nb_line_page = 3,
language = 'en_UK.iso-8859-1',
maxwidth = NULL,
maxheight = NULL,
recent_period = 7,
expand = 'false',
show_nb_comments = 'false',
show_nb_hits = 'false',
enabled_high = 'true'
WHERE
user_id = 2;

DELETE FROM phpwebgallery_config
WHERE
param IN
(
'default_template',
'nb_image_line',
'nb_line_page',
'default_language',
'default_maxwidth',
'default_maxheight',
'recent_period',
'auto_expand',
'show_nb_comments',
'show_nb_hits'
);

Your gallery will be correct except a history backup we have to solve.
8-)


Piwigo.com: Start and run your own photo gallery. Signup and get 30 days to try for free, no commitment.
8-)

Offline

 

#36 2007-05-19 09:01:42

krickett
Member
2007-02-07
26

Re: Upgrade 1.6.x to 1.7.x

I will make those changes and let you know how it goes w/in the next couple days.  Thanks again for the help.

Offline

 

#37 2007-05-22 03:09:00

krickett
Member
2007-02-07
26

Re: Upgrade 1.6.x to 1.7.x

OK, i copied that above code you posted into the SQL queries, as you descibed (the first sql icon in the top left) and it executed successfully.  I double checked your questions that you asked previously:

1 .  Could you display phpwebgallery_config table and tell me if "email_admin_on_picture_uploaded" is in param column?
2 . Tell me how many rows you have in phpwebgallery_comments table.
3 . Last and not least: Could you display phpwebgallery_config table and tell me if "auto_expand" is in param column?

The answers are now:
1. Yes
2. 0
3. No

All as you expected so looks like that works.  The only other issues it seems like we have to deal with is combining the histories and solving that backup issue along with fixing the quick search problem.  Is the quick search issue because of me or is that something you guys are trying to fix?

Could you provide me with the detailed instructions on how to upgrade and prevent this issue from happening.  I REALLY don't want to have to go through this with the next update.

Thanks

Offline

 

#38 2007-05-22 07:46:06

VDigital
Former Piwigo Team
Paris (FR)
2005-05-04
17680

Re: Upgrade 1.6.x to 1.7.x

I would like to have the content of PhpWebGallery upgrade table...

phpMyAdmin

SQL

SELECT *
FROM `phpwebgallery_upgrade`
WHERE id >55

Have to display something like this:

56     2007-05-05 08:02:50     upgrade included in migration
57     2007-05-05 08:02:50     upgrade included in migration
58     2007-05-05 08:02:50     upgrade included in migration
59     2007-05-05 08:02:50     upgrade included in migration
60     2007-05-05 08:02:50     upgrade included in migration

I don't forget history_backup problem.

Use your gallery as other users, now.
Make your backups as usualy (phpMyAdmin exports data, FTP backup).

8-)


Piwigo.com: Start and run your own photo gallery. Signup and get 30 days to try for free, no commitment.
8-)

Offline

 

#39 2007-05-24 08:05:33

krickett
Member
2007-02-07
26

Re: Upgrade 1.6.x to 1.7.x

I did what you said it it looks just like what you posted:

http://www.4wdtoyota.com/upgrade.jpg

Offline

 

#40 2007-05-24 12:44:46

VDigital
Former Piwigo Team
Paris (FR)
2005-05-04
17680

Re: Upgrade 1.6.x to 1.7.x

Perfect, we'll manage history tables next week-end.
I have no time today because I'm working in London the whole day.
8-)


Piwigo.com: Start and run your own photo gallery. Signup and get 30 days to try for free, no commitment.
8-)

Offline

 

#41 2007-05-24 18:00:19

krickett
Member
2007-02-07
26

Re: Upgrade 1.6.x to 1.7.x

No worries!  Thanks again for the help VDigital.  You're a lifesaver!!!!

Offline

 

#42 2007-10-12 02:36:03

oleDB
Guest

Re: Upgrade 1.6.x to 1.7.x

What am I doing wrong here?



define('PHPWG_IN_UPGRADE', true); define('PHPWG_INSTALLED', true);PhpWebGallery is not in upgrade mode. In include/mysql.inc.php, insert line

define('PHPWG_IN_UPGRADE', true);

if you want to upgrade

 

#43 2007-10-12 08:32:06

VDigital
Former Piwigo Team
Paris (FR)
2005-05-04
17680

Re: Upgrade 1.6.x to 1.7.x

It looks like you had inserted
define('PHPWG_IN_UPGRADE', true); define('PHPWG_INSTALLED', true);

outside of the php tags
which are <?php and ?>

Please insert line

define('PHPWG_IN_UPGRADE', true);

just before line
?>

And then it will upgrade normally.

8-)


Piwigo.com: Start and run your own photo gallery. Signup and get 30 days to try for free, no commitment.
8-)

Offline

 

Board footer

Powered by FluxBB

github twitter facebook google+ newsletter Donate Piwigo.org © 2002-2019 · Contact