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 10, 2012 - 3:38 pm

I have been using forum for considerable time.

THE FORUM I SET UP IS VERY POPULAR.

 

in the forum there are:

72000+ comments

23000+ guests

12000+ topics.

THE VERSION I AM USING: 4.1

 

PROBLEM:  I DO NOT HAVE UNLIMITED DISK SPACE.

THE FORUM USES 2.5 GB OF DISK SPACE AND ALSO MYSQL DATABASE OF 600MB.

IN THE LIB FIL THERE ARE 50 FILES 0F +- 40MB EACH.

I HAVE SEARCHED SUPPORT AND FAQ BUT COULD NOT FIND ANSWERS TO MY PROPBLEMS:

 

1) WHAT INFO IS CONTAINED IN THE FILES IN THE WP-CONTENT, PLUGINS, SIMPLEFORUM,LIBRARY DIRECTORY- FILES NAMED core.10090 - etc. CAN THESE FILES BE DELETED SAFELY???

 

2) HOW CAN I DELETE COMMENTS TO MAKE SPACE?

3) I TRIED TO PRUNE THE DATA BASE. IT HAS +- 2000 PAGES AND I MANAGED WITH DIFFICULTY TO DELETE 100 POSTS AT A TIME. ANY SUGGESTIONS - ??? WOULD RATHER DELETE COMMENTS THAN POSTS???

4) WOULD IT BE POSSIBLE TO STORE FILES WITH A LINK TO SUCH FILES ON A WEBSITE WITH UNLIMITED DISK SPACE?

5) AND ALSO THE FOLLOWING: Fatal error: Maximum execution time of 45 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

 

6) WOULD UPGRADE BE OF ANY ASSISTANCE WITH MY PROBLEMS?

7) CAN THE DATABASE BE UPGRADED TO NEW VERSION?question

I WOULD APPRECIATE YOUR HELP URGENTLY

 

KIND REGARDS,

CHARLES VAN EEDENembarassed

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jan 10, 2012 - 8:26 pm

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...

Avatar
charles121
Johannesburg, South Africa
Member
Free Members
sp_UserOfflineSmall Offline
Jan 11, 2012 - 3:49 am

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

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

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.

andy-signature.png
YELLOW
SWORDFISH
Avatar
charles121
Johannesburg, South Africa
Member
Free Members
sp_UserOfflineSmall Offline
Jan 11, 2012 - 7:57 am

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 11, 2012 - 8:18 am

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.
andy-signature.png
YELLOW
SWORDFISH
Avatar
charles121
Johannesburg, South Africa
Member
Free Members
sp_UserOfflineSmall Offline
Jan 11, 2012 - 12:38 pm

good evening, here from South Africa.

 

the key i am referring to is the feed key: 

 

No shouting tonight.

laugh

 

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

 

kind regards

Charles van Eeden

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jan 11, 2012 - 8:45 pm

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...

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

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']

INSERT INTO wp_sftrack (trackuserid, trackname, forum_id, topic_id, trackdate) VALUES ( 1, 'admin', 0, 0, '2012-01-13 14:35:31')

 

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

`wp_sftrack`

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

`wp_sftrack`

and went to :

`wp_sfmembers`

 

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

 

 

 

 

 

 

 

 

 

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jan 13, 2012 - 8:36 pm

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

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