good day Mr. Pappa.

Yes, sir, with every reinstall I restored the 410 database.

Sorry I missed the question earlier.

Thanks for trying to help me.

good day again, mr Pappa,

(THIS IS FOR UPGRADE TO 413)

form the above:

Still get error:

Fatal error: Maximum execution time of 90 seconds exceeded in /problem-with-post-edit-buttonome/sainfodi/public_html/justmail.za.net/wp-content/plugins/simple-forum/library/sf-database.php on line 1658

Extract from sf-database.php on those line numbers:            }

            # create where clause based on forums that current user can view

            $list = explode(‘@’, $list);

            $where = ” WHERE “.SFPERMISSIONS.”.forum_id IN (” . implode(“,”, $forum_ids) . “) “;

AND

$forum_ids

in`wp_sftrack`

of the database.

This column is not in  `wp_sftrack`

I do not know if `wp_sftrack` requires column forum_ids

should I add such into `wp_sftrack` , and if so what infor should I add to it – AND IS IT forum_ids OR forum_id

thanking you for trying to help me.

As soon as I get 413 to work I want to upgrade all the way, in steps, to 5, if you will let me have that download.

the total wordpress gzip database is 32mb, is there a way that I could exctract or backup only the SPF database file so as to send it to you to have a look at.

Kind regards

Charles van Eeden

charles121 said

good day Mr. Pappa.

 

Yes, sir, with every reinstall I restored the 410 database.

 

Sorry I missed the question earlier.

 

Thanks for trying to help me.

OK this is good.

Now – this is my suggestion. With your working 4.1.0 system, go to the forum admin > Toolbox. It will tell you there exactly what Version and Build are being used.

You reply here and tell me what those numbers are AND what version you are trying to upgrade to and before you try again I will look at the upgrade script for that version to see if I can locate why there is this problem.

Thanks mr Pappa,

the block with the information is below.

the version I want to upgrade to is 413, then all the way to 5.

or go to 5 straight away!, if possible.

I reinstated 410 which I had as a zipfile on the server.

re-instated the database – and activated 410. activation OK BUT

A problem was perhaps lurking all the time since, with the db backed up as shown below in the table,

I now get the following error when running 410.Fatal error: Maximum execution time of 90 seconds exceeded in /problem-with-post-edit-buttonome/sainfodi/public_html/justmail.za.net/wp-content/plugins/simple-forum/library/sf-database.php on line 1656

A problem was perhaps lurking all the time since, with the db backed up as shown below in the table, and now reinstated I nowget the above error.

I downloaded 451 on 12/01/2012 but before installation upgraded to wp 3.3

then I downloaded 435 then 423, then 413.

As a note.:

even with the plugin deleted when trying to “upgrade”from 451 to 435 and the same with 435 to 423, this message appeared:

Upgrade Simple:Press Forum From Version 4.5.1 to 4.2.3 – (Build 6401 to Build 3750) (if that would have any bearing on the problem)

Please have a look – perhaps I need to change column names and insert new colums – or whatever it takes,to get the SPF going again.

(i cannot enter any contents below the table below since my cursor gets stuck in the table below) BUT THANKING YOU VERY MUCH FOR ASSISTING

OK – 2 questions:

1. Is this the ONLY error you get with version 4.1.0 ?
2. Is your WP still at version 3.3 ?

good day Yellow Swordfish,

No, there are 2 errors:

1) when I go to Forum under admin I get OUT OF MEMORY,

However when I deactivate wordpress automatic update this error falls away.

2) The other error is as mentioned:

I now get the following error when running 410.Fatal error: Maximum execution time of 90 seconds exceeded in /problem-with-post-edit-buttonome/sainfodi/public_html/justmail.za.net/wp-content/plugins/simple-forum/library/sf-database.php on line 1656 

originally line 1656 as per above,

on re run 2 min ago it showed as line no 1660

on re run 1 min ago it showed as line no 1656

Yes I am still on wordpress 3.3

thanking you for trying to help me

Kind regards

Charles van Eeden

Actually thinking about it I am surprised you are not getting more errors or getting anything SP related to work at all as WP3.3 and SP410 are really not intended to ever work together.

OK – if you have a genuine 4.1.0 system at build number 2491 AND if that database has not been contaminated by any SP db changes post version 4.1.0 then I would try and update it first to version 4.2.3 which is available on our download page. I have checked the upgrade script and can see no reason why it should cause you problems.

The caveat here is that as you are running this under WP 3.3, I can not guarantee that the upgrader will even work as that was written for WP 2.9 and there are a lot of changes between WP 3.9 and WP 3.3, especially to the javascript libraries which the upgrader uses.

If this starts however, it should say at the top upgrading from build 2491 to build 3750. If it says anything else then I would not go ahead.

I am afraid this is the best advice I can give you at the moment and, as I stress, I can nit guarantee this will work.

Yellow Swordfish, I amgoing to do that straight away, just bear in mind that the error:

Fatal error: Maximum execution time of 90 seconds exceeded in /problem-with-post-edit-buttonome/sainfodi/public_html/justmail.za.net/wp-content/plugins/simple-forum/library/sf-database.php on line 1656 

points to a probable problem in the database i.e.line number 1655 to line no 1660:

# create where clause based on forums that current user can view

            $list = explode(‘@’, $list);

            $where = ” WHERE “.SFPERMISSIONS.”.forum_id IN (” . implode(“,”, $forum_ids) . “) “;

        }

al that said and done.

Will report back soonest.

Kind regards

Charles van Eeden

Yellow Swordfish.

I deleted the 410 installation.

restored the 410 database,

unzipped 423,

Activated the SPF plugin – (activated no errors)

From toolbox the following:

but when I run the Forum I get:

WordPress database error: (Straight away)[Unknown column ‘forum_id’ in ‘field list’]

AND AFTER 90 SECONDS:

Fatal error: Maximum execution time of 90 seconds exceeded in /problem-with-post-edit-buttonome/sainfodi/public_html/justmail.za.net/wp-content/plugins/simple-forum/library/sf-database.php on line 1707

AND IN sf-database.php lines 1701 to line no 1709 the following:

if ($search != ”)

        {

            if ($where == ”) $where = ‘WHERE ‘; else $where .= ‘ AND ‘;

            $where.= ‘display_name LIKE “‘.$search.’%”‘;

        }

I do hope we make progress.

Kind Regards

Charles van Eeden

mr Yellow Swordfish,

In the database itself:

there are onlythe columns:

id

trackuserid

trackname

trackdate

None of the above contains any data.

Kind regards

Charles van Eeden

If I should enter the required fields, as what type of field, what length of field, null (yes or no) should I create the colums?

The below error – which “field list” is being referred to? [Unknown column ‘forum_id’ in ‘field list’]

Kind regards

Charles van Eeden

Yes – best to create these two fields
The table is ‘sftrack’.
Create ‘topic_id’ and ‘forum_id’
They are both to be defined as BIGINT(20) with a default of NULL.

Then I would suggest you make another full database backup. Keep it safe and try to uograde what you have to the latest 4.5.1

See what happens next.

good day Yellow Swordfish,

The next upgrade I did was to:

Version: 4.3.5    Build:  5040

it did upgrade but only after I de-activated all other plugins.

when running the SPF the following error showed up:

Fatal error: Maximum execution time of 90 seconds exceeded in /problem-with-post-edit-buttonome/sainfodi/public_html/justmail.za.net/wp-content/plugins/simple-forum/library/sf-database.php on line 1852

I copy thoses lines from sf-database.php:

1851 to 1857

{

                                    if ($where == ”) $where = ‘WHERE ‘; else $where .= ‘ AND ‘;

                                    $where.= SFMEMBERS.’.display_name LIKE “‘.$search.’%”‘;

                        }

It seems as if it something is missing in sfmembers???

This is the only error!!!!!

Thanks for trying to assist

Kind Regards

Charles van Eeden

good day again Yelloe Swordfish,

After the above update :

the first line in sfmembers:

userid=1

display_name=admin

AND IN SFTRACK: 

So are you going to do the same again. I would have gone straight for 4.5.1 as I suggested but I understand you taking it slowly.

So – backup the database again just in case and this time go for 4.5.1.

as to this error you are getting we really can not do anything about that until you are running 4.5.1 as none of these versions are compatible with the Wp 3.3 you are using. Get all the right versions of both installed and then if there are still errors we can deal with them at the end