Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
plugins-topic
disk space usage and lib file
Avatar
charles121
Johannesburg, South Africa
Member
Free Members
sp_UserOfflineSmall Offline
Jan 15, 2012 - 3:03 pm

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 15, 2012 - 3:43 pm

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.

andy-signature.png
YELLOW
SWORDFISH
Avatar
charles121
Johannesburg, South Africa
Member
Free Members
sp_UserOfflineSmall Offline
Jan 15, 2012 - 4:45 pm

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

Avatar
charles121
Johannesburg, South Africa
Member
Free Members
sp_UserOfflineSmall Offline
Jan 15, 2012 - 5:09 pm

Yellow Swordfish.

 

I deleted the 410 installation.

restored the 410 database,

unzipped 423,

Activated the SPF plugin - (activated no errors)

From toolbox the following:

Version: 4.2.3    Build:  3750

 

but when I run the Forum I get:

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

INSERT INTO wp_sftrack (trackuserid, trackname, forum_id, topic_id, trackdate) VALUES ( 1, 'admin', 0, 0, '2012-01-16 00:55:09')

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

 

 

 
Avatar
charles121
Johannesburg, South Africa
Member
Free Members
sp_UserOfflineSmall Offline
Jan 15, 2012 - 5:16 pm

mr Yellow Swordfish,

 

In the database itself:

SELECT *
FROM `wp_sftrack`
LIMIT 0 , 30

 

there are onlythe columns:

 

id

trackuserid

trackname

trackdate

 

None of the above contains any data.

 

Kind regards

Charles van Eeden

Avatar
charles121
Johannesburg, South Africa
Member
Free Members
sp_UserOfflineSmall Offline
Jan 15, 2012 - 5:25 pm

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 15, 2012 - 5:46 pm

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.

andy-signature.png
YELLOW
SWORDFISH
Avatar
charles121
Johannesburg, South Africa
Member
Free Members
sp_UserOfflineSmall Offline
Jan 16, 2012 - 3:52 am

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

Avatar
charles121
Johannesburg, South Africa
Member
Free Members
sp_UserOfflineSmall Offline
Jan 16, 2012 - 4:41 am

good day again Yelloe Swordfish,

 

After the above update :

 

the first line in sfmembers:

userid=1

display_name=admin

 

AND IN SFTRACK: 

id

(various big numbers

eg 154413 in all rows)

trackuserid

(all 0 in all rows)

trackname

87.253.27.227 -

all rows in above

number format

forum_id

either 0 or

1 in all rows

topic_id

numbers

eg 1772

 

trackdate

eg

2012-01-16 12:18:02

 

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 16, 2012 - 5:13 am

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

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 617
Members: 17359
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10125
Posts: 79620