sheesh, why are we yelling??????????

comments?  we dont have comments in the forum… do you mean posts?

and since very little, if any forum data is stored on disk, no clue how you would get 2.5GB of data… unless you have large amounts of uploaded files, images or avatars, I would look into that…  certainly the forum code does not consume anywhere near that amount of space…

yes you can delete any core.xxxx files… they are NOT from simple press but your server…  when your server has a problem (ie exceed time or memory) it core dumps and leaves these mostly useless and large files around… nothing we can do about that but you should be able to configure your serve to not leave those core dump files around…

before upload the sp files (in your older 4.x version) archive is about 2.2MB of size… obviously will expand to more when extracted, but maybe 10MB…  the rest of space would be how you run your forum, ie uploads…

you can increase your php execution time in your php.ini file…  most reasonable hosts will give you 60 seconds min… but normally not an issue…

if you are on 4.4.5 or or 4.5.x, you can easily upgrade to 5.0…  the newer version (still in RC) does include quite a few performance enhancements…

THANKS for THE VERY QUICK AND TO THE POINTreply.  not shouting – just desperate.

correct – not comments but posts. +69000 in number with 13000 topics.

1 when upgrading – are the same database files used?

2 when upgrading – where can I view the benefits of upgrading.

3 I have 23000+ guests in the list – see forum in http://www.justmail.za.net.   –

3A CAN I EXTRACT OR VIEW THEIR EMAIL ADDRESSES – THEY WERE REQUIRED TO LIST EMAIL ADDRESSES.

3B  CAN I EMAIL GUESTS AND USERS – IS THERE SUCH A FACILITY

KIND REGARDS

CHARLES VAN EEDEN

Within accepted forum etiquette writing in capital letters is considered to be SHOUTING. In fact you seem to be more bellowing.

So – before these new questions – have you now removed all the garbage from your folders? And worked out why your MySQL database is so big? Have you run an optimisation on the database lately for example?

Ok – new questions:

1. Yes, of course. That is where all the forum data is stored.
2. Well we traditionally write a blog post for upgrades detailing most of the new features and bug fixes. Quite a lot of upgrades also contain important security fixes.
3. The easiest and quickest way would be to run a query against the database. You could also then extract the email addresses and do what you like with them. SP itself does not have a bulk email feature because SP is s forum plugin.

One important word of caution if you do decide to upgrade your SP. You are using a very old version there and while our upgrades should just work and upgrade all older versions (up to 4.5.1) a few users have had some problems with such a large upgrade being made. It would probably be better to upgrade in smaller increments than all in one go. A pain perhaps but safer. And of course, make the database backups as you go just in case.

Thanks for quick answer!

You are a great sport – from past experience with other software it is sometimes necessary to shout.

Thanks for advice.

Please advice how to implement the below key:

0bf63a2d-94aa-4ff3-9f13-c1b96d92b15d

Also, please inform me if there are ways to:

1)   verify email addressess of users on sign-up.

2)   any plugins or widgets to monetize the forum

3)  SPF blog address please.

4) Is there a facility to email users and guests??

I am at moment deleting the garbage!!!

Kind regards.

Charles van Eeden

Key? What is the key? I have no idea what you are referring to.

1. SP does not handle registrations (or logins etc., for that matter). This is all handled by WP. There are plugins available for WP that enhance registrations including, I believe, email verification in some instances. I suggest you search the WP plugin repository initially.
2. No. Not directly anyway. If you want to include advertising then there are various places you can hook code into.
3. This site. News.
4. No. As I said before this is a forum plugin not a bulk email system. again there are plugins available for emailing users although it must be noted these will probably not pick up guest email addresses as guests do not have a WP user record.

good evening, here from South Africa.

the key i am referring to is the feed key: 

No shouting tonight.

I forgot to ask, please let me know the MYSQLtable names for users and guests

kind regards

Charles van Eeden

we are a plugin for wp… as such we just use the users in the wp users table…

what do you want to do with the feedkey?  its a way to have private forums and let the members that can view the forum also use the rss feed…  look at any rss feed when logged in, you will see the url for the feed including the feedkey…  if you are using a reader, use that url including the feedkey as the url for rss feed…  you will be able to have private rss feeds that way…

good evening Mr Pappa.

I nowcontinue with the saga of upgrading from 410 to 415.

i have now downloaded 451, 423, 413 – in that sequence.

I first tried to upgrade to 451, but no success.

The following error showed up: 

WordPress database error:[Unknown column ‘forum_id’ in ‘field list’]

I inserted these fields into the database and re-connected to SPF – but the following showed up:

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 8192 bytes) in /problem-with-post-edit-buttonome/sainfodi/public_html/justmail.za.net/wp-content/plugins/simple-forum/admin/sfa-menu.php on line 1

despite the ini file being:

memory_limit = 448M ; Maximum amount of memory a script may consume (64MB)

max_execution_time = 90;

upload_max_filesize = 10M;

post_max_size = 20M;

I found with firebug that the wordpress automatic upgrade plugin is a cause (with its JS),  however I had to deactivate all other plugins before memory was sufficient.

then the following 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 1707

I now deleted the installation, restored the data base and “upgraded ” to 423.

on upgrading the folling showed up:

Upgrade Simple:Press Forum From Version 4.5.1 to 4.2.3 – (Build 6401 to Build 3750)

The above shows that somewhere, despite deleting the 451 installation, the info of 451 is stored.

the following error showed up with this upgrading:

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 1737

re-installed, the following 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 1658

deleted the 423 installation and installed 413.  the upgrade did not go through in firefox but did in IE.

the following 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 1658

=====================

to me this would mean that there is a database compatibility problem.

in

al the trackuserid’s are 0 except the one for admin being ‘1’ (inserted by upgrade).

and “trackname” column filled with the user IP address.

in this table there are only 12 records.

I closed

and went to :

the first record is for ‘1’, ‘admin’

the next record is ‘1373’ ‘barnetty’

HOWEVER:  as userid the above 1373 runs up to 1394 AND THEN continious as follows 2,3,4,etc.

onpage 50 of this table the last number is 1485.

i have upgraded the WP installation to the latest version.

Mr. Pappa, as said in my very fisrt post, in the FORUMthere are

in the forum there are:

72000+ comments

23000+ guests

12000+ topics.

THE VERSION I AM USING: 4.1

AND NOW NOT A WORKING FORUM.

WOULD YOU BE SO KIND AS TO ASSIST IN GETTING THE FORUM WORKING AGAIN!!!

Kind Regards

Charles van Eeden

I am confused… in another topic (two actually) you said you were good to go on the install…  is this resolved or unrelated?

good evening mr Pappa,

no unfortunately the forum is not yet running.

when connecting to the forum the following shows: 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      

OR

1662 WHEN RERUN

(in line 1658 of above – it is blank without any code in that line)

In previous installs – those of 451 and 423 colums in

(eg forum_id) the database were missing.

With 413 install there are no colums missing for

.

BEFORE UPGRADING TO 413:

For the 410 install column “trackuserID” of

.contains only “0”s  and column “trackname” the IP addresses. for each row of information.

In

the “id” colums has id’s running from “154289” to “154389”  WITH NUMBERS MISSING INBETWEEN. – there are in total 25 rows of information.  

AND IN

the first record is for ‘1’ as ISERID and , ‘admin’ admin as display name.

the next record is ‘1373’ ‘barnetty’

HOWEVER:  as userid the above 1373 runs up to 1394 AND THEN continious as follows 2,3,4,etc. up to 1485 on page 50.

on page 50 of this table the last number is 1485.  IN OTHERWORDS NOT IN NUMERICAL SEQUENCE – SHOULD IT??

AFTER UPGRADING TO 413 –

In

ONLY 1 item left the “id” 154393, trackuserid “1”   and trackname admin.

(after rerunning more lines appeared)

When running Forum after upgrade it gives:

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 1662

below quote from sf-database.php

1658

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

1660

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

1662

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

(it looks as if there is a missing column since there is no forum_id in

)

NOTE:  there is no forum_id     in 

  of 413 although in the upgrade to 451 I had to insert it manually.

Mr Pappa is there not an upgrade 411 or  412 which I can try to follow the upgrade path since I really need to get the Forum going again.

PLEASE ASSIST

Kind Regards

Charles van Eeden

have you thought about restoring the backup database and starting over, one steo at a time so we can advise along the way?

mr Pappa,

Unfortunately the forum is not yet running.

I posted a reply to this effect last night but it is not yet showing.

I will wait till this afternoon and re-post if not showing.

KInd regards

charles van Eeden

good day Mr. Pappa.

As I said afore the forum is not yet running again.

I downloaded 413 and upgraded using IE – it did not want to upgrade in Firefox.

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) . “) “;

On upgrade to 451 it looked for column:

$forum_ids

in`wp_sftrack`

of the database.

This column is not in  `wp_sftrack`

Perhaps I should upgrade from 410, to 411 to 412 if those upgrades are available.

please assist since I am getting desperate.

Kind regards

charles van Eeden

You did not answer my question in post 12 above which was a rational suggestion.