New Upgrade

[travel124]

This is my first upgrage. I have 5.62. I have installed but I have huge errors
Thanks!
Lori

dian fax or mail back a signed permission form before we grant membership.

You can begin the registration process even before we receive a permission form by pressing the Agree button. Or you can cancel registration by pressing the Cancel button.

You can download the permission form here:"; $Globals['pp_lang']['reginstruct'] = "Registration to this forum is free! We do insist that you abide by the rules and policies detailed below. If you agree to the terms, please press the Agree button at the end of the page. Although the administrators and moderators of {$Globals['galleryname']} will attempt to keep all objectionable messages and images out of our gallery, it is impossible for us to review all messages. All messages express the views of the author, and neither the owners of {$Globals['galleryname']} or All Enthusiast, Inc. (developers of PhotoPost) will be held responsible for the content of any message or any image in our gallery.



By clicking the Agree button, you warrant that you will not post any messages or upload any images that are obscene, vulgar, sexually-orientated, hateful, threatening, or otherwise violative of any laws.



The owners of {$Globals['galleryname']} have the right to remove, edit, or move any image or post for any reason.

"; // EMAILS // register.php $Globals['pp_lang']['emailreg'] = "Thanks for registering at {$Globals['webname']}. In order to activate your account, which will enable you to upload photos and post comments (if the site allows comments), you must click on the link below or copy and paste it into your browser: {$Globals['maindir']}/register.php?ppaction=vfy&uid={$theuid}&knum={$joindate} Thanks! The {$Globals['webname']} Team ".$Globals['domain']; $Globals['pp_lang']['emailrsub'] = "Confirm {$Globals['webname']} Registration (action needed)"; // comments.php $Globals['pp_lang']['emailreply'] = "{$User['username']} has posted a reply about the following photo: \"{$gettitle}\" {$Globals['maindir']}/showphoto.php?photo={$photo} \"{$message}\" If you no longer wish to be notified of replies about the above photo, you can disable notification for it here: {$Globals['maindir']}/comments.php?notify=off&notifyid={$getuserid}&photo={$photo} Thanks! The {$Globals['webname']} Team {$Globals['domain']}"; $Globals['pp_lang']['ereplysub'] = "New Reply to {$gettitle} at {$Globals['webname']}"; $Globals['pp_lang']['eadmreply'] = "{$User['username']} has posted a reply about the following photo: \"{$gettitle}\" - {$Globals['maindir']}/showphoto.php?photo={$photo} {$message}"; $Globals['pp_lang']['eadmrsub'] = "New Reply to {$gettitle} at {$Globals['webname']}"; // pp-inc.php $Globals['pp_lang']['emailapp'] = "{$usernm}, We wanted to let you know that your photo, titled \"{$phototitle}\", has been approved and is now visible. Here is the link to the photo: {$Globals['maindir']}/showphoto.php?photo={$photonum} And if you would like to view your personal photo album, containing all of the images that you have uploaded to {$Globals['webname']}, you can do so here: {$Globals['maindir']}/showgallery.php?ppuser={$getuserid}&cat=500 Thanks! The {$Globals['webname']} Team {$Globals['domain']}"; $Globals['pp_lang']['emailasub'] = "{$Globals['webname']} photo upload approved"; $Globals['pp_lang']['emailmove'] = "{$usernm}, We felt that your photo, titled \"{$phototitle}\", was more appropriate in a different category. To view it, and to find out where we moved it (look in the upper left for the category name), visit this link: {$Globals['maindir']}/showphoto.php?photo={$photonum} Thanks! The {$Globals['webname']} Team {$Globals['domain']}"; $Globals['pp_lang']['emailmsub'] = "{$Globals['webname']} photo category change"; $Globals['pp_lang']['emaildel'] = "{$usernm}, I'm sorry, but the photo you submitted to {$Globals['webname']}, titled \"{$phototitle}\", has been deleted. Some reasons for photo deletions include: -Images that were partially uploaded/incomplete -Broken images -Extremely poor quality/images (impossible to make out the image itself) -Images that did not conform to our published site contribution and usage guidelines such as offensive images If you would like to submit another photo, please return to our photo upload form: {$Globals['maindir']}/uploadphoto.php Thanks, The {$Globals['webname']} Team {$Globals['domain']}"; $Globals['pp_lang']['emaildsub'] = "Regarding your {$Globals['webname']} photo upload"; // reportphoto.php $Globals['pp_lang']['reportemail'] = "{$User['username']} has complained ($reason) about one of the photos in the database:\n\n"; $Globals['pp_lang']['reportemail'] .= "{$Globals['maindir']}/showphoto.php?photo={$report}\n\n"; $Globals['pp_lang']['reportemail'] .= "with the following comments: \n\n{$desc}"; $Globals['pp_lang']['repsubject'] = "{$Globals['webname']} User Reported Photo Complaint"; // reportpost.php $Globals['pp_lang']['reportpost'] = "{$User['username']} has complained ($reason) about one of the posts:\n\n"; $Globals['pp_lang']['reportpost'] .= "{$Globals['maindir']}/showphoto.php?photo={$photo}\n\n"; $Globals['pp_lang']['reportpost'] .= "with the following comments: \n\n{$desc}\n\nPosted Comment:\n\n$postcom\n\nPosted By: $postname"; $Globals['pp_lang']['reppostsub'] = "{$Globals['webname']} User Reported Post Complaint"; // showgallery.php $Globals['pp_lang']['emailsug'] = "${rname} has suggested you look at a Photo Gallery on {$Globals['webname']}. The link to the gallery is: {$Globals['maindir']}/showgallery.php?cat={$cat}&ppuser={$ppuser}&catp={$catp} Enjoy! The {$Globals['webname']} Team {$Globals['domain']}"; $Globals['pp_lang']['esugsub'] = "{$rname} suggests you view this Image Gallery"; // member.php $Globals['pp_lang']['epassnew'] = "You just requested that your password be reset at {$Globals['webname']}. We have issued a you a new password. Your username is: {$dbuser} Your new password is: {$newpass} If you would like to change that password, you may do so here: {$Globals['maindir']}/member.php?ppaction=chgpass Or to edit your profle: {$Globals['maindir']}/member.php?ppaction=edit Thanks! The {$Globals['webname']} Team {$Globals['domain']}"; $Globals['pp_lang']['epassrsub'] = "New temporary {$Globals['webname']} password"; $Globals['pp_lang']['epassres'] = "You just requested that your password be reset at {$Globals['webname']}. In order to do so, you must click on the link below or copy it into your web browser: {$Globals['maindir']}/member.php?ppaction=rpwd&uid={$dbuid}&verifykey={$joindate} Thanks! The {$Globals['webname']} Team {$Globals['domain']}"; $Globals['pp_lang']['epasssub2'] = "How to reset your {$Globals['webname']} password"; $Globals['pp_lang']['enewemail'] = "You just changed your email address at {$Globals['webname']}. We have issued a you a new temporary password in order to confirm your new email address. Your New Temporary Password is: {$genpass} If you would like to change that password, you may do so here: {$Globals['maindir']}/member.php?ppaction=chgpass Thanks! The {$Globals['webname']} Team {$Globals['domain']}"; $Globals['pp_lang']['enewesub'] = "New temporary {$Globals['webname']} password"; // image-inc.php $Globals['pp_lang']['euplimg'] = "{$User['username']} has uploaded one or more photos to your gallery. If approval is required, visit the admin panel: Image name: {$realname} Title: {$title} Size: {$imagesize} Keywords: {$keywords} Description: {$desc} Link to image: {$Globals['maindir']}/showphoto.php?photo={$lastphotoid} {$Globals['maindir']}/adm-index.php"; $Globals['pp_lang']['euplsub'] = "{$Globals['webname']} photo upload(s)"; $Globals['pp_lang']['subnotify'] = "{$User['username']} has uploaded one or more photos to a category you subscribe to. Image name: {$realname} Title: {$title} Description: {$desc} Link to image: {$Globals['maindir']}/showphoto.php?photo={$lastphotoid} To turn off subscriptions for this category, click on the following link: {$Globals['maindir']}/misc.php?action=subscribe⊂={$thecat} The {$Globals['webname']} Team {$Globals['domain']}"; $Globals['pp_lang']['emsubscr'] = "{$Globals['webname']} photo upload notification"; // ecard.php $Globals['pp_lang']['ecardsent'] = "{$rname}, {$yname} has sent you an e-Card from {$Globals['webname']}. You can view your card here: {$Globals['maindir']}/ecard.php?view={$cardid} And you can email {$yname} directly at {$yemail}. Thanks! {$Globals['domain']}"; $Globals['pp_lang']['ecardsub'] = "{$yname} sent you an e-Card"; $Globals['pp_lang']['returnrec'] = "{$fromname}, {$toname} has read the eCard you sent. You can view your card here: {$Globals['maindir']}/ecard.php?view={$thiscard} The {$Globals['webname']} Team {$Globals['domain']}"; $Globals['pp_lang']['returnsub'] = "{$toname} has read your eCard"; ?> while( $row = mysql_fetch_array($result) ) { $date = getdate($row['date']); $mday = $date['mday']; if ( empty($photos_for_month[$mday]) ) { $photos_for_month[$mday] = array(); } array_push($photos_for_month[$mday], $row); } @mysql_free_result($result); if ( $Globals['cachetimeout'] > 0 && !$nocache) { // Let's update the cache $cacheq = addslashes(serialize($photos_for_month)); ppmysql_query("UPDATE {$Globals['pp_db_prefix']}cache SET calcache='$cacheq' WHERE id=1", $link); } return $photos_for_month; } else { $calcache = unserialize( $cacheq['calcache'] ); return $calcache; } } // Format the calender function gen_cal( $month, $year ) { global $Globals, $Style, $cacheq, $updatecache; // --------------------------------- // Get some info on the current date $today = getdate(); $thismonth = $today['mon']; $thisyear = $today['year']; $thisday = $today['mday']; if ( $thismonth != $month || $thisyear != $year ) { // Don't use cache for this kind $photos_for_month = get_photos_for_month($month, $year, true); } else { $photos_for_month = get_photos_for_month($month, $year); } // -------------------------------- // get what weekday the first is on $temp = getdate(mktime(0,0,0,$month,1,$year)); $firstweekday = $temp['wday']; $mname = "month". $temp['mon']; $monthname = $Globals['pp_lang'][$mname]; // ----------------------------- // get the last day of the month $nextmonth = $month + 1; $tempyear = $year; if ( $nextmonth == 13 ) { $nextmonth = 1; $tempyear = $tempyear + 1; } $temp = getdate(mktime(0,0,0,$nextmonth,0,$tempyear)); $lastday = $temp['mday']; $currentdate = 1; $firstweek = true; $weekday = 1; $currentweek = 1; // -------------------------------------- // Loop through all the days of the month while ( $currentdate <= $lastday ) { $days[$currentdate] = null; $printdate = $currentdate; if ( ($firstweek) && ($firstweekday) ) { $days[$currentdate] .= ""; for ($i=1; $i<=$firstweekday; $i++) { $days[$currentdate] .= " "; $weekday++; } $firstweek = false; } else { $firstweek = false; } if ( $weekday == 1 ) { $days[$currentdate] .= ""; } $class = $Style['alternatetable']; $alt = null; if (($currentdate == $thisday) && ($year == $thisyear) && ($month == $thismonth)) { $class = $Style['tddetails']; $printdate = "$printdate"; } $datelink = $printdate; if ( isset($photos_for_month[$currentdate]) ) { $class = $Style['tddetails']; $printdate = "$printdate"; $alt = "$marray[$currentdate]"; $htitle = count($photos_for_month[$currentdate]) ." ". $Globals['pp_lang']['photosadded']; $datelink = "$printdate"; } $days[$currentdate] .= "$datelink"; if ( $weekday == 7 ) { $days[$currentdate] .= ""; $lastsat = $currentdate; $currentweek++; } $weekday++; if ( $weekday > 7 ) { $weekday = 1; } $currentdate++; } // Fill out the rest of the table if ( $weekday > 1 ) { for ( $i = $weekday; $i <= 7; $i++ ) { $days[$currentdate] = " "; $currentdate = $currentdate + 1; } $currentdate = $currentdate - 1; $days[$currentdate] .= ""; } if ( $month == 1 ) { $prevmonth = 12; $prevyear = $year - 1; } else { $prevmonth = $month - 1; $prevyear = $year; } $backicon = "«"; // Don't offer forward if we're in the current month if ($year == $thisyear && $month == $thismonth) { $foricon = null; } else { if ( $month == 12 ) { $nextmonth = 1; $nextyear = $year + 1; } else { $nextmonth = $month + 1; $nextyear = $year; } $foricon = "»"; } $template = << $backicon $monthname $year$foricon {$Globals['pp_lang']['day1']}{$Globals['pp_lang']['day2']} {$Globals['pp_lang']['day3']}{$Globals['pp_lang']['day4']} {$Globals['pp_lang']['day5']}{$Globals['pp_lang']['day6']} {$Globals['pp_lang']['day7']} PPPRINT; for( $i = 1; $i <= sizeof($days); $i++ ) { $template .= $days[$i]; } return $template; } function inc_photoviews( $photo ) { global $Globals, $link; if ( $Globals['viewcache'] == "yes" ) { ppmysql_query("INSERT INTO {$Globals['pp_db_prefix']}photoviews SET photoid=$photo", $link); if ( mt_rand(1,200) < 10 ) { $result = ppmysql_query("SELECT photoid, COUNT(*) as views FROM {$Globals['pp_db_prefix']}photoviews GROUP BY photoid", $link); while ($newviews = mysql_fetch_array($result)) { ppmysql_query("UPDATE LOW_PRIORITY {$Globals['pp_db_prefix']}photos SET views = views+$newviews[views] WHERE id='$newviews[photoid]'", $link); } ppmysql_query("DELETE LOW_PRIORITY FROM {$Globals['pp_db_prefix']}photoviews", $link); } } else { ppmysql_query("UPDATE {$Globals['pp_db_prefix']}photos SET views=views+1 WHERE id=$photo", $link); } } function get_ratingcache() { global $Globals, $link, $cache; // Lets get the Most Popular Photos $queryz = ppmysql_query("SELECT count(*) AS vcount,avg(c.rating) AS avgr,p.cat,p.id,p.title,p.rating AS avgr FROM {$Globals['pp_db_prefix']}comments c LEFT JOIN {$Globals['pp_db_prefix']}photos p ON p.id=c.photo WHERE p.numcom > 1 GROUP BY c.photo ORDER BY avgr desc,vcount desc LIMIT {$Globals['mostpoppal']}", $link); $tpfound = 1; while ( list(,, $popcat, $popid, $poptitle, $popviews ) = mysql_fetch_row($queryz) ) { $cache['popular']['title'][$tpfound] = ( strlen($poptitle) > 20 ? substr($poptitle,0,20)."..." : $poptitle ); $cache['popular']['views'][$tpfound] = number_format($popviews,1); if ( $Globals['spider'] == "yes" ) { $cache['popular']['link'][$tpfound] = "{$Globals['maindir']}/showphoto.php/photo/$popid/cat/$popcat"; } else { $cache['popular']['link'][$tpfound] = "{$Globals['maindir']}/showphoto.php?photo=$popid&cat=$popcat"; } $tpfound++; } return; } function get_statscache() { global $Globals, $link, $db_link, $cache; $cache['stats']['usertotal'] = get_totalusers(); $totalv = ppmysql_query("SELECT SUM(views) as totalviews, SUM(filesize) as diskuse, count(*) as totalphotos FROM {$Globals['pp_db_prefix']}photos", $link); list( $cache['stats']['totalviews'], $cache['stats']['diskuse'], $cache['stats']['totalphotos'] ) = mysql_fetch_row($totalv); $totalv = ppmysql_query("SELECT count(*) FROM {$Globals['pp_db_prefix']}comments", $link); list( $cache['stats']['posttotal'] ) = mysql_fetch_row($totalv); $cache['stats']['totalviews'] = number_format( $cache['stats']['totalviews'] ); $cache['stats']['totalphotos'] = number_format( $cache['stats']['totalphotos'] ); $cache['stats']['usertotal'] = number_format( $cache['stats']['usertotal'] ); $cache['stats']['posttotal'] = number_format( $cache['stats']['posttotal'] ); $cache['stats']['diskspace'] = ( $cache['stats']['diskuse'] / 1048576 ); $cache['stats']['diskspace'] = number_format( $cache['stats']['diskspace'], 1 ) . "{$Globals['pp_lang']['megabytes']}"; return; } function get_posterscache() { global $Globals, $link, $db_link, $cache; // Lets get the Top Posters $queryz = ppmysql_query("SELECT user,userid,COUNT(*) AS pcount FROM {$Globals['pp_db_prefix']}photos GROUP BY user ORDER BY pcount DESC LIMIT {$Globals['numtoppal']}", $link); $numfound = 1; while ( list($cache['top']['topposters'][$numfound], $uid, $cache['top']['topposts'][$numfound]) = mysql_fetch_row($queryz)) { if ( $Globals['spider'] == "yes" ) { $cache['top']['toplink'][$numfound] = "{$Globals['maindir']}/showgallery.php/ppuser/$uid/cat/500"; } else { $cache['top']['toplink'][$numfound] = "{$Globals['maindir']}/showgallery.php?ppuser=$uid&cat=500"; } $numfound++; } return; } function get_string( $stringvar, $p1 = null, $p2 = null, $p3 = null, $p4 = null, $p5 = null ) { global $Globals; $retstring = $Globals['pp_lang'][$stringvar]; if ( $p1 ) $retstring = str_replace( "%p1%", $p1, $retstring ); if ( $p2 ) $retstring = str_replace( "%p2%", $p2, $retstring ); if ( $p3 ) $retstring = str_replace( "%p3%", $p3, $retstring ); if ( $p4 ) $retstring = str_replace( "%p4%", $p4, $retstring ); if ( $p5 ) $retstring = str_replace( "%p5%", $p5, $retstring ); return( $retstring ); } // Default Style settings $Style = array(); $Style['onbody'] = "onbody"; $Style['tableborders'] = "tableborders"; $Style['tablesurround'] = null; $Style['tddetails'] = "tddetails"; $Style['tdbackground'] = "tdbackground"; $Style['tdnothumbs'] = "tdnothumbs"; $Style['menubar'] = "menubar"; $Style['menubarnb'] = "menubarnb"; $Style['catcolumn'] = "catcolumn"; $Style['photocol'] = "photocol"; $Style['commentscol'] = "commentscol"; $Style['lastphocol'] = "lastphocol"; $Style['lastcommcol'] = "lastcommcol"; $Style['small'] = "small"; $Style['medium'] = "medium"; $Style['large'] = "large"; $Style['welcome'] = "welcome"; $Style['lighttable'] = "lighttable"; $Style['alternatetable'] = "alternatetable"; $Style['formboxes'] = "formboxes"; $Style['blockquote'] = "blockquote"; // Now lets include the forum integration require "{$Globals['PP_PATH']}/forums/{$Globals['vbversion']}.php"; include "{$Globals['PP_PATH']}/{$Globals['TMPL_PATH']}/ppopen.tmpl"; include "{$Globals['PP_PATH']}/{$Globals['TMPL_PATH']}/ppclose.tmpl"; ?>

PhotoPost Upgrade
Preparing to update database...

Error performing MySQL command: CREATE TABLE pp_messages ( msgid int( 12 ) NOT NULL AUTO_INCREMENT , userid int( 12 ) NOT NULL default '0', datestamp int( 15 ) NOT NULL default '0', message mediumtext, status smallint( 1 ) NOT NULL default '0', type enum( 'c', 'f', 'i', 'm', 'r' ) default NULL , photo int( 12 ) NOT NULL default '0', PRIMARY KEY ( msgid ) ) TYPE=MYISAM
Error: Table 'pp_messages' already exists

Error performing MySQL command: CREATE TABLE pp_captcha ( id int( 12 ) NOT NULL auto_increment , code varchar( 12 ) default NULL , PRIMARY KEY ( id ) ) TYPE=MyISAM
Error: Table 'pp_captcha' already exists

Error performing MySQL command: CREATE TABLE pp_buddies ( id int( 12 ) NOT NULL auto_increment , userid int( 12 ) NOT NULL default '0', buddy int( 12 ) NOT NULL default '0', PRIMARY KEY ( id ) , KEY userid ( userid ) ) TYPE=MyISAM
Error: Table 'pp_buddies' already exists

Error performing MySQL command: CREATE TABLE pp_board ( msgid int(12) NOT NULL auto_increment, replyto int(12) NOT NULL default '0', userid int(12) NOT NULL default '0', category int(4) NOT NULL default '0', date int(15) NOT NULL default '0', subject varchar(250) default NULL, message mediumtext, replies int(6) NOT NULL default '0', views int(7) NOT NULL default '0', lastmsg int(12) NOT NULL default '0', lastdate int(15) NOT NULL default '0', lastuser int(12) NOT NULL default '0', lastusername varchar(32) default NULL, ipaddr varchar(15) default NULL, updated int(16) NOT NULL default '0', updateuser int(12) NOT NULL default '0', PRIMARY KEY (msgid), KEY date (date) ) TYPE=MyISAM
Error: Table 'pp_board' already exists

Error performing MySQL command: CREATE TABLE pp_invites ( id int( 12 ) NOT NULL AUTO_INCREMENT , code varchar( 32 ) default NULL , email varchar( 32 ) default NULL , name varchar( 64 ) default NULL , message mediumtext, datestamp int( 16 ) NOT NULL default '0', referer int( 10 ) NOT NULL default '0', status smallint( 1 ) NOT NULL default '0', uid int( 12 ) NOT NULL default '0', PRIMARY KEY ( id ) , UNIQUE KEY code ( code ) ) TYPE=MYISAM
Error: Table 'pp_invites' already exists

Error performing MySQL command: ALTER TABLE pp_users ADD realname varchar(80) default NULL, ADD title varchar(30) default NULL, ADD signature varchar(250) default NULL, ADD avatar varchar(120) default NULL, ADD mature tinyint(1) NOT NULL default '1', ADD invites int(6) NOT NULL default '0', ADD accepts int(6) NOT NULL default '0', ADD laston int(15) NOT NULL default '0'
Error: Duplicate column name 'realname'

Error performing MySQL command: ALTER TABLE pp_photos ADD votes tinyint(1) NOT NULL default '0'
Error: Duplicate column name 'votes'

Error performing MySQL command: ALTER TABLE pp_comments ADD votes tinyint(1) NOT NULL default '0'
Error: Duplicate column name 'votes'

Error performing MySQL command: ALTER TABLE pp_iponline ADD uid INT(12) NOT NULL default '0', ADD referer VARCHAR(255) default NULL, ADD agent VARCHAR(100) default NULL
Error: Duplicate column name 'uid'

Error performing MySQL command: ALTER TABLE pp_photos ADD tags INT(15) NOT NULL default '0', ADD ismature smallint(1) NOT NULL default '0', ADD exifinfo BINARY(1) NOT NULL DEFAULT '0'
Error: Duplicate column name 'tags'

Error performing MySQL command: INSERT INTO pp_settings VALUES (226,'Use lightbox integration?','lightbox','','no',32,5)
Error: Duplicate entry '226' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (227,'Width to trigger lightbox integration (if enabled)?','lbwidth','','900',33,5)
Error: Duplicate entry '227' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (228,'Height to trigger lightbox integration (if enabled)?','lbheight','','600',34,5)
Error: Duplicate entry '228' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (229,'Use mature content filter?','mature','Prevents photos marked from mature being shown without user electing to view them.','no',18,2)
Error: Duplicate entry '229' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (230,'Use uniform thumbnail feature?','uniform','','no',26,6)
Error: Duplicate entry '230' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (231,'Uniform thumbnail height?','uniheight','Can only be used when using IM for imaging.','78',27,6)
Error: Duplicate entry '231' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (232,'Uniform thumbnail width','uniwidth','Can only be used when using IM for imaging.','120',28,6)
Error: Duplicate entry '232' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (233,'Use Messaging System for PhotoPost alerts/notices?','usemsg','','yes',38,1)
Error: Duplicate entry '233' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (234,'Use CAPTCHA images when verifying registration?','usecaptcha','Requires GD2 support!','no',4,8)
Error: Duplicate entry '234' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (235,'Enable PhotoPost Message Board?','usebb','Used only for internal PhotoPost systems.','no',5,13)
Error: Duplicate entry '235' for key 1

updating photo tags...done.
scanning for exifs... done.
updating users table...done.
updating votes...done.

Upgrade complete! To prevent users from modifying your PhotoPost database settings, please be sure to delete the upgrade.php file from your PhotoPost directory before continuing.

[Chuck S]

duplicate errors are not an issue. Try reuploading your language file as it looks like it is corrupt. Post a url here so we can assist further by seeing the true errors.

[travel124]

I tried the language file and no luck. I deleted my database, created a new one and installed the the newest version. Now I am getting this error when I run the install.php

http://www.digitalscrapn.com/gallery...step=2&usegd=1

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'username'@'localhost' (using password: YES) in /home/digit124/public_html/gallery/install.php on line 550
I cannot connect to the PhotoPost MySQL server. [host:$host][mysql_user:$mysql_user][mysql_password:$mysql_password]. Check your config-inc.php for the correct settings and rerun.

I am banging my head about this. This is no picnic...lol

[Chuck S]

You need to enter the correct mysql database information on the config portion of install to continue and it appears you have not done so.

[travel124]

Are you talking about the database name, user id and password? Everything matches from the config-inc.php to the install.php

I have that entered correctly. I blanked out the username in the prev post.


correct mysql database information on the config portion of install - Where do I locate this? in the Config-inc.php?

or In this area?

Path to PhotoPost Installation (must be set properly for script to work)
Name of the PhotoPost templates directory
If you change the name of the templates directory, indicate it here

PhotoPost Database Host
PhotoPost Database Name
PhotoPost Database User
PhotoPost Database Password
PhotoPost Database Prefix (cannot be changed once set)

User Database Host (enter same info as above if not integrating with a third party forum)
User Database Name
User Database User
User Database Password
VB3 License Number (if using VB3 integration, you must enter your license number here).

You can find this number by checking your index.php file in your vB3 directory. The 4th line in the file looks like:

|| # vBulletin 3.0.0 - Licence Number ########

It is the ######## number you need to enter.

Default Gallery Language
Thumbnail Generator
Path for MOGRIFY executable


//**************** MySQL Database Configuration ****************//

// PhotoPost database host address, or leave as localhost
$host="localhost";

// PhotoPost's database name
$database="DBNAME_photopost";

// MySQL username and password to access PhotoPost's database
//
// These two variables are for the userid and password needed to access
// the PhotoPost database named above.
$mysql_user="USER";
$mysql_password="PASS";

// User database host address, or leave as localhost
$host_bb="localhost";

// If you want to use a prefix for your database, enter it here.
// NOTE: This variable can only be set PRIOR to your first installation of PhotoPost;
// existing databases will not be changed and you will be unable to connect if you change
// this variable after performing a default installation.
$pp_db_prefix = "pp_";

// User database MySQL database name
//
// This is the variable for the User Database; if you are using Internal
// as your registration system, then these variables are the same as the
// ones above. If you are linking to a message board system,
// thse variables should be set to the database, user and password for that
// database.
$database_bb="DBNAME_photopost";

// MySQL username and password to access user database
//
// These two variables are for the userid and password needed to access
// the PhotoPost or BB database.
$user_bb="USER";
$password_bb="PASS";

[Chuck S]

It would be the host username password and database name. If your using the same database as vb you can find this info in the vbulletin config.php file. The error your posting states something your entering for the photopost database is incorrect.

[travel124]

No I am not using Vb. I have Simple Machines. I would love to intergrate the two together, but that may be too difficult for me to figure that out.

So even If I have no tables in my DB when I run the install.php would that create them for me?

I tried to run the import earlier to upload the sql into the db but with no avail. I am really not sure what to do next.

Thanks for your help.

[Chuck S]

Yes if you run install and have the correct database info the photopost tables would be correct.

not sure what import your talking about here but on the install errors you note you are not entering the correct database info in both places in the config. We do offer installation service if you really thing trying to install this with smf is something beyond you.

[travel124]

Ok Can you install the photopost and my forum together? If so I will send you an email?

I want to use my gallery - (photopost) and below it I want to be able to see the forum. A gallery with a forum (SMF)

Thanks much!

[Chuck S]

You are not going to see smf and photopost together on one page. If you want one login on your site where your users login to the forum and gallery and are logged into both and have the gallery use your forum stylesheet then you install photopost to integrate with your smf forum. Our install service can be purchased from our online store by hitting buy photopost and select an install service.

[travel124]

I still need to purchase even though I bought a license up until late next year, or would that just get me to the install dept?

[travel124]

nevermind i see it.

[Chuck S]

Yes an install service is just for us to install the program on your server.

[travel124]

Well I guess it will not help me at this point to get the install. I have no database tables. I emailed my host and they only keep backup tapes for 3 days and am past that.

Is there a guide somewhere to add the tables?

I ended up going back to my original photopost version. I then went to upgrade and now I am getting this error. Is it because it is recognizing that there are no tables?

I went over and over my database names and I am positive they are correct.

Thanks for your help.




We're sorry, but we encountered an error during the installation process...



Could not connect to or create the PhotoPost database.

Be sure your user has permissions to CREATE or create a blank table before hitting REFRESH or go back to Step 1 to check your database settings.

If you have corrected the error, you may hit GO BACK and try again.

[Chuck S]

You would need to enter the proper database information on a new install now. I am sorry but the information your posting tells me this database info is correct.

You need to enter the proper mysql host database name username and password and this user has to have create permissions. You host should be able to tell you the proper mysql information to use.

[travel124]

So are you telling me to start fresh with the 6.0 install? Should I then create a new database and user & pass?

Thank-You for your help.

[Chuck S]

Well your saying you dont have backups if you did have a gallery before so yes you need to do an install because you have no tables and no application right now. The same error your posting throughout this thread is you can not connect to the database so the information your entering for mysql is incorrect. There really is nothing more you can do than to to verify whether you have a valid photopost database and enter the correct mysql to connect to that database and do an upgrade. If you have no working photopost database then you do an install and reinstall the gallery again with proper mysql information to connect to mysql on the server. You host may need to assist you in determining what you have in databases and what the proper connect strings would be.

[travel124]

Oh boy...lol

I emailed my host for some info. I might be back to be a pest again...lol

Thanks for your help.

[Chuck S]

No problem I hope I have clarified the situation and how to proceed if not let me know.

Seems to me maybe you tried doing an upgrade and you overwrote your config files by mistake. I state this again. If you find out you have a database with tables for Photopost then all you should simply need to do is input the proper information in the config file and run the upgrade.php file and select the upgrades you need to run otherwise you start with a new install.

[travel124]

Whoo hooo! I am in. I figured it out. I got from here! Thanks for all of your help Chuck!

I reinstalled the newest version and checked my email from my host all the admin stuff and I was able to get me user names and pass correct.

I see. I have learned a bit about upgrading. It's quite easy once you get it figured out and go through it once.

Now I still have my old files in a temp folder. Can I replace the news ones with the old ones - The Images - data files and how about the current users?