Cannot login to admin area after 4.8.5 upgrade

[MonchaVX]

I had the same problem of not being able to get into admin also. I could log in to the VB admin and the VBP navbar login would show that I was logged in but, PP would show 1 unregistered user. I check my settings for cookie prefix and cookie domain through phpMyAdmin and they were correct. I just happened to notice in the table "settings" the user registration was still showing vB2. I changed it to vB3 and all is ok.. So this maybe another slight problem that some are coming across.

Scott

[Denz]

I did have this problem. I solved it by changing my cookie option in my old config file to 'BB' then re-running upgrade282.php

[criscokid]

Originally Posted by grandma

kaiwang

The 'settings' table. Record #172 and 173.

Grandma

I copied my live gallery site and database over to a test domain and then ran the upgrade scripts.

If I remember correctly my site was at 4.6.6 so ran the upgrade script...
"Upgrade complete! You should continue to upgrade47.php"... ran the next script which created records 144 to 164 into the settings table.

"You should continue to upgrade482.php"
I tried running this file but it kept telling me that it couldn't connect to the database - I even tried replacing the cvariables in the .php script with the real database name, server IP address, etc and still received the error message saying the script couldn't connect to the database.

I got frustrated at that point and the nly way I managed to get it all working was to install PhotoPost 4.8.5 as a fresh install (now can I restore my database files so that all of my photos, comments, etc are returned?)

I copy & pasted the output in my browser when I was doing the upgrade... now that I've gone back to that log things are looking clearer to me and I have worked out that upgrade482.php is probably the script (which I didn't manage to get to work) that created various records including the cokkie records which are now causing so many people problems. A note to myself when upgrading PhotoPost in the future... always copy & paste the output because it'll help me work out what may be broken if I have a problematic upgrade.

[Chuck S]

Yes upgrade482.php is a very important update if one expects Photopost to run correctly.

[criscokid]

Decided I wasn't happy with a working gallery and no photos & comments on my test domain so started all over again...

I copied my live gallery site and database over to a test domain and then ran the upgrade scripts.

I've run /gallery/upgrades/upgrade482.php and the following is output...

Preparing to update 4.8.2 database...
Performing MySQL command: REPLACE INTO settings VALUES (165,'Your SMF Cookie Name', 'smfcookie', 'Only needed for users of SMF forums', '', 5, 12) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (183,'Show Peronsal Albums Index link under Members Gallery?', 'showalbum', 'Adds a text link to the Albums index into the Members Gallery description', 'yes', 10, 3) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (184,'Allow users to move their own images?','usermove', '', 'no', 16, 2) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (84,'PhotoPost Version','pversion','','4.8.5',53,0) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (37,'cright','cright','','Powered by: PhotoPost --replaceme--
Copyright 2004 All Enthusiast, Inc.',300,'0') ... Successful!
Performing MySQL command: REPLACE INTO admingroups VALUES (12,'Cookie Settings') ... Successful!
Performing MySQL command: REPLACE INTO admingroups VALUES (13,'Forum Settings') ... Successful!
Performing MySQL command: ALTER TABLE usergroups ADD uplimit INT(5) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'uplimit'
Performing MySQL command: ALTER TABLE categories ADD ugnovote VARCHAR(255) NULL AFTER ugnopost ... Error: Duplicate column name 'ugnovote'
Performing MySQL command: UPDATE settings SET title='Allow users to delete their own images?',optionorder=17 WHERE id=91 ... Successful!
Performing MySQL command: ALTER TABLE categories CHANGE catorder catorder MEDIUMINT(4) DEFAULT '9999' NOT NULL ... Successful!
Performing MySQL command: UPDATE categories SET catorder=9999 WHERE catorder=0 AND cattype='a' ... Successful!
Performing MySQL command: UPDATE settings SET section=13,optionorder=1 WHERE id=7 ... Successful!
Performing MySQL command: UPDATE settings SET section=13,optionorder=2 WHERE id=41 ... Successful!
Performing MySQL command: UPDATE settings SET section=13,optionorder=3 WHERE id=83 ... Successful!
Performing MySQL command: UPDATE settings SET section=13,optionorder=4 WHERE id=163 ... Successful!
Performing MySQL command: UPDATE settings SET section=13,optionorder=5 WHERE id=153 ... Successful!

Upgrade complete! You may now remove this file.

I'm concerned about the two lines that showed an error above:
Performing MySQL command: ALTER TABLE usergroups ADD uplimit INT(5) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'uplimit'
Performing MySQL command: ALTER TABLE categories ADD ugnovote VARCHAR(255) NULL AFTER ugnopost ... Error: Duplicate column name 'ugnovote'

WHen I check my mySQL database none of the aforementioned records (that the script was supposed to have written) have been written. Tried the script over and over and nothing's being written to the database. Checked all my settings... What gives?

[Chuck S]

duplicate records are not a problem as it means you ran that before

[criscokid]

Originally Posted by criscokid

When I check my mySQL database none of the aforementioned records (that the script was supposed to have written) have been written. Tried the script over and over and nothing's being written to the database. Checked all my settings... What gives?

The settings table has entries up to 165 and then 183 & 184 - records 166 to 182 are missing - those are the ones that aren't being written.

[Chuck S]

You note you have multiple installs or test install. Make sure you have it updating the proper database. running upgrade482.php will enter the records needed.

[criscokid]

I've checked it's writing to the correct database (even tempoarily renamed the settings table, ran the upgrade script and received error messages like this telling me that the file doesn't exist:
Performing MySQL command: REPLACE INTO settings VALUES (165,'Your SMF Cookie Name', 'smfcookie', 'Only needed for users of SMF forums', '', 5, 12) ... Error: Table 'scene-outscenegallery.settings' doesn't exist

Looking at the upgrade482.php file it seems to be skipping the following lines:
$query[] = "REPLACE INTO {$pp_db_prefix}settings VALUES (166,'BotBuster Integration', 'botbuster', 'Set to yes if you have BotBuster on your system (this includes the necessary tag)', '$botbuster', 22, 1)";
$query[] = "REPLACE INTO {$pp_db_prefix}settings VALUES (167,'Enable ZLIB page compression', 'compression', 'Set to on if you want to enable Zlib page compression (and it is supported)', '$compression', 23, 1)";
$query[] = "REPLACE INTO {$pp_db_prefix}settings VALUES (168,'Date format', 'ppdateformat', 'Keywords: dow, month, mm, dd, yyyy', '$ppdateformat', 24, 1)";
$query[] = "REPLACE INTO {$pp_db_prefix}settings VALUES (169,'GMT Offset', 'gmtoffset', 'If you are running VB and want the server to display the time as an offset of GMT (for example, to the timezone where your server is located), enter the offset here.', '$gmtoffset', 25, 1)";
$query[] = "REPLACE INTO {$pp_db_prefix}settings VALUES (170,'Enable IP Cache Timeout', 'ipcache', 'This variable is used to track IP addresses and userids for voting and viewing purposes. This is set in HOURS. 0 disables this setting', '$ipcache', 26, 1)";
$query[] = "REPLACE INTO {$pp_db_prefix}settings VALUES (171,'PhotoPost Cookie Path', 'cookie_path', 'This should be set to match the path/domain for your cookies. Setting to / enables entire site.', '$cookie_path', 1, 12)";
$query[] = "REPLACE INTO {$pp_db_prefix}settings VALUES (172,'Forum Cookie Prefix', 'cookieprefix', 'Some Default values vB3: bb, phpBB2: phpbb2mysql, Threads: w3t_', '$cookieprefix', 2, 12)";
$query[] = "REPLACE INTO {$pp_db_prefix}settings VALUES (173,'PhotoPost Cookie Domain', 'domain_path', '.yourdomain.com; sets the cookie to be usable across the domain', '$cookie_domain', 3, 12)";
$query[] = "REPLACE INTO {$pp_db_prefix}settings VALUES (174,'Debug Setting', 'debug', 'How do you want PhotoPost to handle errors?', '$debug', 27, 1)";
$query[] = "REPLACE INTO {$pp_db_prefix}settings VALUES (175,'Enable On-The-Fly Watermarks', 'onthefly', 'Requires GD2 and you must edit the file watermark.php', '$onthefly', 29, 5)";
$query[] = "REPLACE INTO {$pp_db_prefix}settings VALUES (176,'Imaging Integration (IM or GD)', 'usegd', 'Select ImageMagick or GD1/GD2 for image processing', '$usegd', 28, 1)";
$query[] = "REPLACE INTO {$pp_db_prefix}settings VALUES (177,'Directory for backups?', 'backupdir', 'The full path to the directory to store backups', '$backupdir', 29, 1)";
$query[] = "REPLACE INTO {$pp_db_prefix}settings VALUES (178,'Path to mysqldump', 'mysqldumppath', 'The full path to your mysqldump executable', '$mysqldumppath', 30, 1)";
$query[] = "REPLACE INTO {$pp_db_prefix}settings VALUES (179,'Path to jpegtran (if used)', 'jpegtran', 'If you would like to clean any JPG image uploaded before being processed; enter the path to your jpegtran executable.', '$jpegtran', 18, 1)";
$query[] = "REPLACE INTO {$pp_db_prefix}settings VALUES (180,'Path to jhead (if used)', 'jhead_command', 'This only needs to be set if you are extracting EXIF information from images. Full server path.', '$jhead_command', 19, 1)";
$query[] = "REPLACE INTO {$pp_db_prefix}settings VALUES (181,'Gallery Open?', 'ppboards', 'Yes for Open, No for Closed', '$ppboards', 20, 1)";
$query[] = "REPLACE INTO {$pp_db_prefix}settings VALUES (182,'Message displayed when closed', 'closedmsg', '', '$closedmsg', 21, 1)";
}

My logic tells me that I need to force this section of code to run to create the entries in the mySQL table. A quick way to do this? Will that solve my problem?

[Chuck S]

well the only way to do it is to manually add them via phpmyadmin then

[criscokid]

Originally Posted by omegatron

well the only way to do it is to manually add them via phpmyadmin then

Just finished doing that... deleted all the cookies and tried accessing the gallery and admin pages... blank page.... AAARRRGGGHHH
Tried Firefox - same blank page!

Checked 'User Registration System' and that's set to vb3

[criscokid]

Spotted a tiny typo in $PP_PATH in config.inc - I've been staring at thois screen all day so I'm not suprised - my poor eyes.

Now that it's working I went into /gallery/adm-index.php to start making some changes... typed in the changes but when I look at the mySQL tables the changes haven't been made... this isn't the first time today that changes haven't been made to mySQL tables.

What's changed then? I installed PHP Version 4.3.10 on Windows 2003... do I need to make any changes to the PHP config? Seems to me like something's lost it's write permission - not sure what it is at the moment though.

[Chuck S]

well check your PP_Path and make sure its is right with the opening " and closing "; as it sounds like you have a parse error in the config file now

[troubadour]

I have a similar problem described in this thread. I upgraded from 4.7 to 4.86. Everything seemed to update fine, at least the upgrade process stated it was successful.

However, I cannot access the admin area. Following the discussion here, I attempted to manually set the cookie setting via sql, but my database does not have IDs that high. Although the upgrade process reported:

Performing MySQL command: REPLACE INTO settings VALUES (172,'Forum Cookie Prefix', 'cookieprefix', 'Some Default values vB3: bb, phpBB2: phpbb2mysql, Threads: w3t_', '', 2, 12) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (173,'PhotoPost Cookie Domain', 'domain_path', '.yourdomain.com; sets the cookie to be usable across the domain', '.thruhikers.com', 3, 12) ... Successful!


What should I attempt now?

Web site: thruhikers.com

Thanks!

[Chuck S]

The upgrade documentation specifically states to NOT replace the config file ever.

The reason you do not have id's that high is because you replaced the config file with a new version that does not have certain variables. On of those variables is needed to trigger a set of queries that get inserted.

As it is stated in this thread I believe edit your config-inc.php file and place in it at the bottom before the closing ?> this $onthefly="0";

Then rerun the upgrade.php script and select upgrade 482

The queries will be inserted and then you can manually change the variables.

Basically in an upgrade the program assumes you have the proper cookie variables inserted into the config file and transfers those to the database settings table so you can login to admin or in a new install you enter the correct cookie settings.

[troubadour]

Thanks for the help Chuck. I did as you instructed, added $onthefly="0"; prior to the closing ?> at the bottom of my config-inc.php and all the settings the file are correct.

I reran the 482 upgrade script.

However, looking at the database, there have been no changes. It still lacks the relevant rows in the settings table.

I assumed that I should use the config-inc.php file that came with the 486 download. I edited that file instead of my backup from 47. Was that correct?

Thanks,

[Chuck S]

I fail to see why you would not have the queries entered. In fact I just checked and Michael upgraded the 482 upgrade to not check for $onthefly which means they get entered regardless

Here are the inserts

Content visible to verified customers only.

In your settings table you should have entries up to numeric value 182

Your cookie settings are 171-173

[troubadour]

I've checked with Phpadmin and also through the command line, I have entries up to 142.

I may not have fully understood your last note, should I manually enter the inserts into the database?

Thanks

[Chuck S]

If thats the case you have not ran your upgrade script.

What I said before was not that you should manually enter anything. It was a statement that I can not understand if you ran the queries why you say there are not there.

There is a whole bunch of queries after that like the entire upgrade 47 database structure and then 482

You can PM my a site link and PHPMyAdmin link so I can see first hand what your issue is.