Free Energy | searching for free energy and discussing free energy

Discussion board help and admin topics => Help to access this discussion board => Topic started by: hartiberlin on October 01, 2008, 09:21:17 PM

Title: Downtime 29th and 30th of September 2008
Post by: hartiberlin on October 01, 2008, 09:21:17 PM
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.
Title: Re: Downtime 29th and 30th of September 2008
Post by: broli on October 01, 2008, 09:23:39 PM
Are you still with servage?

I'm also happy the forum got back up. Got kind of bored for a while there  :P.
Title: Re: Downtime 29th and 30th of September 2008
Post by: FreeEnergy on October 01, 2008, 10: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 :)

Title: Re: Downtime 29th and 30th of September 2008
Post by: hartiberlin on October 01, 2008, 10:39:09 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.
Title: Re: Downtime 29th and 30th of September 2008
Post by: FreeEnergy on October 01, 2008, 10:57:51 PM
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?
Title: Re: Downtime 29th and 30th of September 2008
Post by: poynt99 on October 01, 2008, 11:35:15 PM
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.
Title: Re: Downtime 29th and 30th of September 2008
Post by: hartiberlin on October 02, 2008, 01:50:10 AM
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.
Title: Re: Downtime 29th and 30th of September 2008
Post by: orbs on October 02, 2008, 01:52:48 AM
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.
Title: Re: Downtime 29th and 30th of September 2008
Post by: X00013 on October 02, 2008, 01:57:04 AM
Whatever u do, come jan 1st 2009, you should be able to find a good host from Brazil. That way u got no spooks.
Title: Re: Downtime 29th and 30th of September 2008
Post by: X00013 on October 02, 2008, 02:08:02 AM
@ 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.
Title: Re: Downtime 29th and 30th of September 2008
Post by: hartiberlin on October 02, 2008, 02:11:55 AM
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.
Title: Re: Downtime 29th and 30th of September 2008
Post by: X00013 on October 02, 2008, 02:17:24 AM
http://www.webhostingsearch.com/vps-hosting/brazil.php
Title: Re: Downtime 29th and 30th of September 2008
Post by: Nostradamus2 on October 02, 2008, 03:12:42 AM
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
Title: Re: Downtime 29th and 30th of September 2008
Post by: winner on October 02, 2008, 03:15:25 AM
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!
Title: Re: Downtime 29th and 30th of September 2008
Post by: hartiberlin on October 02, 2008, 03:24:29 AM
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.
Title: Re: Downtime 29th and 30th of September 2008
Post by: FreeEnergy on October 02, 2008, 08: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?

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.
Title: Re: Downtime 29th and 30th of September 2008
Post by: Paul-R on October 02, 2008, 03:47:08 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.
Title: Re: Downtime 29th and 30th of September 2008
Post by: hartiberlin on October 02, 2008, 07:17:01 PM
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.
Title: Re: Downtime 29th and 30th of September 2008
Post by: amigo on October 04, 2008, 03:17:57 AM
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?
Title: Re: Downtime 29th and 30th of September 2008
Post by: broli on October 05, 2008, 12:24:29 AM
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.
Title: Re: Downtime 29th and 30th of September 2008
Post by: hartiberlin on October 05, 2008, 12:43:15 AM
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.

Title: Re: Downtime 29th and 30th of September 2008
Post by: gyulasun on October 05, 2008, 12:49:25 AM
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!
Title: Re: Downtime 29th and 30th of September 2008
Post by: hartiberlin on October 05, 2008, 12:56:28 AM
Many thanks Gyula !
That saved my day ! ;)

Did not click that other link, stupid me !  ;D
Title: Re: Downtime 29th and 30th of September 2008
Post by: hartiberlin on October 05, 2008, 01:31:22 AM
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.
Title: Re: Downtime 29th and 30th of September 2008
Post by: gyulasun on October 05, 2008, 11:41:53 AM
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