DCF+ upgrade from 4.7 to 4.8...

[thorzzzten]

Hy,

the upgrade was running through properly but ends in the result of showing following as output for index aswell for admin-index:

Fatal error: Call to undefined function: update_whoonline() in /home/www/web1/html/galerie/pp-inc.php on line 336

Site is here

Thanx for your help!


cheers
Thorsten

Did you upload the contents of the /forums directory?

[thorzzzten]

Originally Posted by donb

Did you upload the contents of the /forums directory?

Hy,

yes, /forums content is uploaded.

[thorzzzten]

hy,

any ideas?

thx
thorsten

[Chuck S]

I would delete your /forums photopost subdirectory and reupload. Your FTP program or other is not allowing some files to upload if you do indeed say you uploaded them.

In the dcf.php file which is in your forums directory under photopost there is indeed a function called update_whoonline

The only way your going to get that error of an undefined function is if the files you have uploaded are not correct

[thorzzzten]

hy,

you were right, I deleted all files in /forums and reloaded them. Now I come some steps further ending with following error message:

MySQL error reported!

Script: index

Query: SELECT cpaccess,modaccess,diskspace,uploadsize,uploads,comments,editpho,editposts,useralbums,reqmod,canassign FROM ppusergroups WHERE groupid=99 LIMIT 1

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

Database handle: Resource id #1



how to preceed here?

thx
thorsten

Sounds like you may not have run all of the needed upgrade scripts.

[thorzzzten]

hy,

it's running

I had an other mistake in the config, wrong username for forum's db.
additional somehow the column reqmod was not created in the pp usergroups table, which I have insert manually now.

there is only one error left. in the admin-centre on the "statistics" script I get following message:



MySQL error reported!

Script: adm-main

Query: DELETE FROM ppecards WHERE (readdate > 0 AND readdate < 1088837657) OR date < 1088837657

Result: Unknown column 'readdate' in 'where clause'

Database handle: Resource id #1



also to add column "readdate" in table ppecards???


cheers
thorsten

[thorzzzten]

hy,

after adding the column "readdate" the adm-index.php proceeds for a while and ends with that error:


Fatal error: Maximum execution time of 30 seconds exceeded in /home/www/web1/html/galerie/adm-main.php on line 23



any ideas on that?


cheers
thorsten

[thorzzzten]

hy,

it looks like there are more mistakes in the database.
e.g. opening a catagorie gives the folowing:


MySQL error reported!

Script: showgallery

Query: SELECT c.id,c.catname,c.thumbs,c.cattype,c.parent,c.password,c.theme,c.sortorder,n.userid FROM ppcategories c LEFT JOIN ppnotify n ON (n.photo=c.id AND n.type=1) WHERE c.id='2'

Result: Unknown column 'n.type' in 'on clause'

Database handle: Resource id #1


I startet all update scripts again:

- upgrade.php
- upgrade47.php
- upgradecats.php
- and also tried to run the install.php over all...


any idea's?


thx
thorsten

[Chuck S]

As Don already suggested. You did not run all upgrade scripts.

reqmod for one was added back in 4.6 I beleive. You basically need to run every upgrade script from the last version you where running

If you let us know what Photopost version you where running we can tell you which upgrade scripts to run.

[thorzzzten]

hy,

ok, i did now the following:

- upgrade45.php
- upgrade46.php
- upgrade467.php
- upgrade47.php

I think also, there must be something went wrong in one of the past updates...
Unfortunetly I do not remember with which version I've started with photopost.

Actualy I'm updating from 4.7 to 4.8c.

After running the scripts above everything looks smoth except the thing in the admin panel "statistics".



cheers
thorsten

[Chuck S]

OKay well looks like alot of the stuff you were trying to add in manually was from the upgrade467.php update