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

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

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

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

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

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

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