Upgrade error

scroush · May 25th, 2005, 08:08 PM

I getting this erros.

Warning: main(/home/sites/yoursite/photopost/languages/english.php): failed to open stream: No such file or directory in /home/modernmu/public_html/photopost/pp-inc.php on line 121

Warning: main(/home/sites/yoursite/photopost/languages/english.php): failed to open stream: No such file or directory in /home/modernmu/public_html/photopost/pp-inc.php on line 121

Fatal error: main(): Failed opening required '/home/sites/yoursite/photopost/languages/english.php' (include_path='.:/usr/local/lib/php') in /home/modernmu/public_html/photopost/pp-inc.php on line 121

Michael P · May 25th, 2005, 08:10 PM

Looks like you overwrote your config-inc.php file; check that file and make sure your settings (especially $PP_PATH) are correct.

scroush · May 25th, 2005, 08:22 PM

ok I fixed that problem, but now I'm getting this errors.

Error performing MySQL command: ALTER TABLE categories ADD ismember SMALLINT(1) default '0' NOT NULL
Error: Duplicate column name 'ismember'

Error performing MySQL command: ALTER TABLE categories ADD albums TEXT AFTER children
Error: Duplicate column name 'albums'

Error performing MySQL command: INSERT INTO settings VALUES (207,'Original Image storage directory URL','origdir','Typically this path matches your DATA directory URL, unless you want to store your original images seperatly from your thumbnail/medium images','http://www.modernmustangs-na.com/photopost/data',34,1)
Error: Duplicate entry '207' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (208,'Orignial Image storage directory server path','origfull','Typically this path matches your DATA directory server path, unless you want to store your original images seperatly from your thumbnail/medium images','/home/modernmu/public_html/photopost/data/',35,1)
Error: Duplicate entry '208' for key 1

Error performing MySQL command: INSERT INTO settings VALUES (209,'When using on-the-fly image generation, do you want to overlay the watermark image?','overwater','You can use this feature for on-the-fly watermarks in combination with the on-the-fly image generation.','no',30,5)
Error: Duplicate entry '209' for key 1

Warning: unlink(/home/modernmu/public_html/photopost/adm-userg.php): No such file or directory in /home/modernmu/public_html/photopost/upgrade.php on line 2077

Warning: unlink(/home/modernmu/public_html/photopost/adm-approve.php): No such file or directory in /home/modernmu/public_html/photopost/upgrade.php on line 2078

Warning: unlink(/home/modernmu/public_html/photopost/adm-db.php): No such file or directory in /home/modernmu/public_html/photopost/upgrade.php on line 2079

Warning: unlink(/home/modernmu/public_html/photopost/adm-menu.php): No such file or directory in /home/modernmu/public_html/photopost/upgrade.php on line 2080

Michael P · May 25th, 2005, 08:45 PM

Duplicate errors are not a problem; just means they have already been added. unlink for files that have already been deleted is not a problem either.

Looks like the upgrade ran already and successfully.

scroush · May 25th, 2005, 09:10 PM

Ok I deleted the the upgraded.php and when I go to my galler I get this error

We're sorry, but the system experienced an unrecoverable error. Please try again later.

If you need access please let me know

http://www.modernmustangs-na.com/photopost/index.php

Chuck S · May 25th, 2005, 09:42 PM

You sure you ran all the upgrades? You sure in config the proper table prefix is specified?

scroush · May 25th, 2005, 09:53 PM

I have double check and triple check the config file and everything is setup correct.

Chuck S · May 25th, 2005, 10:01 PM

Thats a generic error stating there is a problem connecting to your database. Beings since you dropped your config file plus upgraded these are the two errors to check

I would check these again. Did you run all the required upgrades?

scroush · May 25th, 2005, 10:11 PM

I have ran the upgrade and check the file.

Chuck S · May 25th, 2005, 10:14 PM

Was this just an upgrade from 5.03 to just 5.1 or did you have multiple upgrades to run. You see where I am going here.

The error you have here is a mysql one saying he cant proceed cause the database is not set up properly

scroush · May 25th, 2005, 10:16 PM

From 5.03 to 5.1

Frost · May 25th, 2005, 10:19 PM

What is the full error message shown onscreen?

scroush · May 25th, 2005, 10:20 PM

Check the site

http://www.modernmustangs-na.com/photopost/index.php

Frost · May 25th, 2005, 10:22 PM

I'm not an admin so cannot see any possible SQL info the message prints out.

scroush · May 25th, 2005, 10:26 PM

there is no SQL info just the message in the middle of the page, I cannot even get into the admin page

Frost · May 25th, 2005, 10:28 PM

Open pp-inc.php and find:

Code:

Content visible to verified customers only.

And temporarily remove if ( $User['adminedit'] == 1 ) so the full message can show.

scroush · May 25th, 2005, 10:32 PM

done, now is showing, but I have no idea what to do

Chuck S · May 25th, 2005, 10:43 PM

Your forums table prefix is empty or either you have specified the incorrect database info in config.

Since an upgrade does not touch the table prefix for the forum in the database I would tend to think the database info to connect to the forum is incorrect which is why I stated above to recheck the config file and ensure you entered everything correctly.

Frost · May 25th, 2005, 10:50 PM

The wrong prefix is being prepended to your vB3 sessions table name in the query. Look in your PP config file for $pp_db_prefix and write down the value. Next, look in your vB config file for $tableprefix and write down the value. Then run the following query, where VALUE1 is the PP prefix and VALUE2 is the vB prefix:

Code:

Content visible to verified customers only.

scroush · May 25th, 2005, 10:51 PM

I really don't know what to tell you but the config file has the correct database configuration