Help

KlausM · September 25th, 2007, 05:23 PM

Help I got theese errors after upgrade from 5.62 to 6.0

Code:

Content visible to verified customers only.

Chuck S · September 25th, 2007, 06:50 PM

Please ensure you have uploaded all the build files except config files and run your upgrade script also please post a url here.

KlausM · September 25th, 2007, 07:13 PM

My url are: www.godtfoto.dk

I have uploaded all the files and run the upgrade script.

The first time I did it all went fine.

But when I try again I got a lot of errors.

You can see it here:

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) ) ENGINE=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 lightbox integration?','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 · September 25th, 2007, 07:18 PM

Please send us webhosting control panel login and ftp so we can see mysql as well as an admin login to photopost to support@photopost.com

KlausM · September 25th, 2007, 07:36 PM

Hi Chuck
I have send you the informations

When I use the new pp-inc.php you can only see one picture.

When I copy the old pp-inc.php all the pictures come back.

KlausM · September 25th, 2007, 07:42 PM

You can´t get into the administration with the new pp-inc.php

KlausM · September 26th, 2007, 08:49 AM

Hi Chuck

Have you got my mail?

Chuck S · September 26th, 2007, 09:03 AM

As of last night late we had recieved no email

However this morning I see all 3 or 4 emails you sent have arrived. You where dealing with support at a late hour last night and as such need to give us time to respond. I will look at your site and let you know what I see.

KlausM · September 26th, 2007, 09:09 AM

Ok Thanks, but right now I had copied the old pp-inc.php to get the site to work.

Would you have the new one back again? But then you can´t get into the admin panel. What would you have me to do?

Chuck S · September 26th, 2007, 11:28 AM

Klaus

I uploaded all the proper files and ran the upgrade and see no issues here at all your site is fine.

http://www.godtfoto.dk/

I can only conclude with the error being posted that you had a mix of old and new files present on your site not uploading all the new files. You should be all good now.

KlausM · September 26th, 2007, 11:41 AM

Hi Chuck

Yes I can see that you have been working on my site - Thanks.

But I had uploaded all the proper files files???

There are still problems.
I have a monthly contest where people can vote on a picture.
In Danish "Månedens billede september" on the front page.

I got 2 errors.

1 The program tells me that I can not vote in that categori.

2 I got this error in the top of the page:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /customers/godtfoto.dk/godtfoto.dk/httpd.www/misc.php on line 135

Would you please look at that. The votes for the contes is starting today :-(

Chuck S · September 26th, 2007, 11:51 AM

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

Script: misc

Query: SELECT p.userid,p.cat,c.ratingtype,c.takevotes,v.id FROM pp_photos p LEFT JOIN pp_categories c ON (c.id=p.cat) LEFT JOIN pp_comments v ON (v.cat=c.id AND v.userid=1 AND v.vote > 0) WHERE p.id=3616

Result: Unknown column 'v.vote' in 'on clause'

Database handle: Resource id #6

In misc.php line 1365 the query should be this it is votes not vote.

Code:

Content visible to verified customers only.

KlausM · September 26th, 2007, 12:01 PM

I´m not sure I understand what you mean.

Would you have me to correct the spelling?

But mine line 1365 doesn´t look like yours????

KlausM · September 26th, 2007, 12:14 PM

Ok I found out. You wrote line 1365 but i was 135

I had tried to correct it, but I still get the error:

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

KlausM · September 26th, 2007, 01:16 PM

Now I got this:

Script: misc

Query: INSERT INTO pp_comments (id,username,userid,date,vote,photo,cat,approved,ipaddress) values(NULL,'Klaus',1,1190830498,1,3531,537,'1','90.184.85.247')

Result: Unknown column 'vote' in 'field list'

Database handle: Resource id #6

KlausM · September 26th, 2007, 01:47 PM

I have lots of problems.

My Admin panel doesnt work????

I can get into it, and I can change some tings and save it, but nothing happens on the index page????

Hmmm weird somethings are working and somethings are not working in the admin panel???

Chuck S · September 26th, 2007, 03:43 PM

Your admin panel appears to work for me as far as the voting it should work I applied the change I had shown you above.

KlausM · September 26th, 2007, 03:50 PM

No its not everything that works.
Try eg. to change title on the Announcement box.

And the voting are still not working, you can try to vote on one of the pictures.
I get the error:
We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script: misc

Query: INSERT INTO pp_comments (id,username,userid,date,vote,photo,cat,approved,ipaddress) values(NULL,'Klaus',1,1190839750,1,3531,537,'1','90.184.85.247')

Result: Unknown column 'vote' in 'field list'

Database handle: Resource id #6

Chuck S · September 26th, 2007, 04:31 PM

Code:

Content visible to verified customers only.

Line 162 of misc.php also needs fixing try it now

KlausM · September 26th, 2007, 05:08 PM

Hi Chuck

Yes yes yes now is the voting system working - Thanks

But I can´t edit the Announcement box, and that a thing I use a lot???