Hi All,
I wanted to upgrade the forum software to the latest TinyPortal 1.05 Beta Version,
but that did not work out, as it still has too many bugs and there were
errors inside the block codes.
As this also changed the MySQL database, I had the problem, that the changed
Database was not compatible anymore with the now used TinyPortal 0.983 version.
Luckily I had a backup of the database still in old format.
But as the database was 205 Mbytes big it took
ages to reimport into a new MySQL database server.
I am also thinking about moving the OverUnity.com site to the
new SMF 2.04 Beta software with a different portal PortaMX.com
but I still have to test it all, how stable it all is.
Also this could run on SQlite and does not need MySQL servers...
But I have first to test this all on a non-live forum version, to
be sure it all works out.
So now I know, that MurphyÃ,´s law has again truth...
Never change a running system..
Regards, Stefan.
Are you still with servage?
I'm also happy the forum got back up. Got kind of bored for a while there :P.
i recommend not to use any type of beta upgrades even if it seems like everything works. just wait for stable version, then upgrade :)
Quote from: FreeEnergy on October 01, 2008, 04:03:07 PM
i recommend not to use any type of beta upgrades even if it seems like everything works. just wait for stable version, then upgrade :)
Very true.
Yes,I am still on servage.
Have not decided yet, where else to go for hosting.
As the hosting runs okay in this moment on Servage,
there is no fast need to change.
Also I am looking into SQLite database solutions, so we will
not be limited to the MySQL database access.
I am not sure, if the current SMF 1.1.6 version runs on a SQLite
setup, but the new SMF2.04B runs on SQLite, I just tested it last night.
But I would have to change many things in the template, cause the Azure template
is not yet available for SMF 2.x and I would like to keep this.
Also the PortaMX.com portal is also still Beta and it does not have a download
section like Tinyportal has, so I would have to move the files
from the Tinyportal Download area to somewhere else and
this has to be linked then again to some forum pages, so it is a lot of work
to do this all... So I decided to keep the current software and
better work on the upcoming Video Portal and article website.
Regards, Stefan.
ever thought about owning your own server?
i think in the long run you will be saving a lot of money and you would be in total control.
use ubuntu as the server, then install apache :) then use www.opendns.com or some kind of www.no-ip.com service.
you would have to leave your server computer on 24/7 but still i think in the long run you would save a lot more money. no?
Stefan, a suggestion:
Go back to SMF 1.1.4 and get rid of the fancy gum-ball look. The forum will probably run 10 times faster with much fewer problems. As a minimum, lose the fancy graphics.
btw, the site isn't running that great right now. Some pages take 30 seconds or more to load, and some don't load at all unless you hit refresh.
Well, SMF 1.1.4 is old and has security problems.
The actual version is 1.1.6 which I am running here.
To have my own server is the goal, but that would cost about 50 to100 US$ per month,
much more than the Servage account right now.
It must be in a good datacenter and I would need to take care of a lot more things like
security updates and other server maintenance stuff, which I right now
donÃ,´t have the time for.
Also I want to build up my Newman scooter,
which I did not yet have time for.
Well, the database is located now on a different SQL server, which seems
to be slower.
I guess I will change this again and try to upload the current database to the faster
one which I was before the downtime.
I have to ask Servage, what their fastest SQL is right now.
The one we are currently on is probably a bit overcrowded.
Has anyone of you got any experience with SMF 1.1.6 on SQLite ?
http://www.sqlite.org
is a SQL less database solution using only one file, so
no database servers needed...
Regards, Stefan.
Die Umlaute scheinen noch nicht wieder ganz da zu sein. Dem Symptom nach sieht es so aus, als ob ein Teil der Daten in der Datenbank als CP1252 ("Windows-1252", Obermenge von ISO-8859-1) oder ISO-8859-15 kodiert abgelegt sind und nun als UTF-8 ausgelesen werden.
Whatever u do, come jan 1st 2009, you should be able to find a good host from Brazil. That way u got no spooks.
@ Stef, do not worry about cost of running this site on a fast server. Keep it simple. Let everyone view the sight at no cost. If you want to post, u must join 4 a fee, and that fee will be what ever amount you feel as thou will justify your post/ou hosting. Put up a link ( paypal would b good ), and i will donate.
Quote from: orbs on October 01, 2008, 07:52:48 PM
Die Umlaute scheinen noch nicht wieder ganz da zu sein. Dem Symptom nach sieht es so aus, als ob ein Teil der Daten in der Datenbank als CP1252 ("Windows-1252", Obermenge von ISO-8859-1) oder ISO-8859-15 kodiert abgelegt sind und nun als UTF-8 ausgelesen werden.
Yes, I tried to convert the database from ISO to UTF-8 format,
but it ran not through completely... also some quircks I still have to fix...
Many thanks for this hint.
Where does it show ?
Vielen Dank für den Hinweis,
wo tauchen genau die Fehler auf ? URL ?
Gruss, Stefan.
http://www.webhostingsearch.com/vps-hosting/brazil.php
Quote from: hartiberlin on October 01, 2008, 07:50:10 PM
Has anyone of you got any experience with SMF 1.1.6 on SQLite ?
http://www.sqlite.org
is a SQL less database solution using only one file, so
no database servers needed...
Regards, Stefan.
Don't use SQLite with forum like this one, because it lacks many features and uses very simple multi transaction handling, SQLlite uses simple file lock to insert/update data, better use MySQL or Postgresql
Thanks for the update, Stefan!
Glad you were able to get things back as quickly as you did; I know that these things can sometimes take many, many hours to repair!
Quote from: Nostradamus2 on October 01, 2008, 09:12:42 PM
Don't use SQLite with forum like this one, because it lacks many features and uses very simple multi transaction handling, SQLlite uses simple file lock to insert/update data, better use MySQL or Postgresql
Yes,I heard this too from a friend, that a 200 Mbyte database file is too big for SQLite...
Or maybe running it totally in the RAM inside the server ?
Would this help ?
I will probably run my upcoming article site
free-energy.tk
on SQLite though, as this will be no forum
but just the summary of many threads of the forum..
So the forum over here will be for discussion
and the free-energy.tk website will be for
summary articles.
I think this is the best way, not to censor anything over here,
but just only copy the technical stuff from over here to
the new free-energy.tk site for a quick read.
Over here there will stay the discussion and posting
of new stuff and I will summarize and convert it into
fast readable pages at free-energy.tk
Regards, Stefan.
why not have a summarized section/category over here? .tk is free but has ads last time i checked, unless you want to spend even more money?
probably better off pointing free-energy.tk to overunity.com or point to the section/category of overunity.com or is this what you had in mind to begin with?
stick with mysql or postgresql. do a search on "mysql vs postgresql" you will find that they are both excellent and it really comes down to personal preference between the two. mysql has features that postgresql lacks, and vice versa.
Quote from: hartiberlin on October 01, 2008, 03:21:17 PM
So now I know, that MurphyÃ,´s law has again truth...
Never change a running system..
Murphy's Law states that if something can go wrong, then, in time, it will.
Your problem is that to retrieve 1k of useful data, we need to download 200k.
This burden, a caravan full of brick rubble, must be born by your system as well
as by us. it makes no sense to me.
Paul.
Quote from: FreeEnergy on October 02, 2008, 02:59:27 AM
why not have a summarized section/category over here? .tk is free but has ads last time i checked, unless you want to spend even more money?
probably better off pointing free-energy.tk to overunity.com or point to the section/category of overunity.com or is this what you had in mind to begin with?
I want to be on page 1 on google with the keyword "free energy"
I can only achieve this, if I have a domain name which has the
word free energy in it.
As the .tk domain is a paid domain I own it and it will have no
ads from the dot.tk nic.
Quote
stick with mysql or postgresql. do a search on "mysql vs postgresql" you will find that they are both excellent and it really comes down to personal preference between the two. mysql has features that postgresql lacks, and vice versa.
I see.
Many thanks for the tips.
I will keep overunity.com running on MySQL anyway, as it seems
the SMF1.1.6
software does not support SQLite in this moment.
free-energy.tk will be running on
SQLite but this will be only for articles and summarizes
of the overunity.com threads.
Regards, Stefan.
Hi Stefan,
I am not sure why do you want to downgrade your database from MySQL to SQLite, have you looked at the differences between the two?
In all honesty, SQLite is not something you want to run when you have a site of this size. Matter a fact you wouldn't run it on a website of any magnitude at all. Simple low traffic sites might be able to get away with it but not overunity.com.
And what's with this obsession about ranking on Google? Is this related to making profit or personal prestige?
I thought that it did not matter because that's not why we are all here, but maybe I was wrong to think that?
Stefan,
The forum being up and down is getting quite annoying to be frank. There's not many ways you can mess up a forum for it to be this messed up.
Well, I just had to move the database again and that takes time.
Sorry for the inconvenience...
ALso I tried to fix the UTF-8 fonts problem, but currently the
fonts package is not available from Simplemachines.org
The database is now fully converted to UTF-8, but there are
still some missing fonts in the forum setup.
Have to wait, until the
smf_1-1-6_english-utf8.zip
is again available from
Simplemachines.org
Sorry, as theforum is already very big
and the database getting bigger and bigger,
it is not so easy to do all these steps just in 5 minutes only.
Takes time, if you need to import a 210 Mbytes database file
into a new database, as sometimes the hosting scripts also
put it into a que, so it is not instantly done.
Also I am will move the site soon to a new hoster and have to
prepare this move the right way and have to test a few things.
But I will let you all know, when the move will be made as
then for 1 or 2 days the forum will not be available due to the
DNS changes.
But now it is working again faster, as I am now again on a faster SQL server again.
Regards, Stefan.
Stefan,
Do you need this file smf_1-1-6_english-utf8.zip ? It is here:
http://www.simplemachines.org/download/?languages;lang=english
rgds, Gyula
EDIT Just noticed it is has zero byte... but smf_1-1-6_english-utf8.tar.gz is ok!
Many thanks Gyula !
That saved my day ! ;)
Did not click that other link, stupid me ! ;D
Well, I installed now the UTF-8 fonts,
but when I switch to English_UTF-8
in the admin panel,
there are then many errors like:
Notice: Undefined index: tp-admin2 in /....../overunity/Sources/Subs.php on line 2779
Notice: Undefined index: tp-admin5 in /....../overunity/Sources/Subs.php on line 2782
Also the strange characters are still there...
Well I have to read and post inside the SMF forum what this still could be.
Maybe the conversion of the database to UTF-8 did not run through without errors.
Also I see, that some of my personal messages are gone now.
But at least the forum is faster now again, as I moved it again to a faster
and not so crowded MySQL server.
Hi Stefan,
There was a mention of similar problem last month on the forum site of simplemachines.org, maybe it gives some hint for you?
http://www.simplemachines.org/community/index.php?topic=261698.0
At the end, it just recommends using English but not English-utf 8...
rgds, Gyula