I have been talking with Coxy, and I have converted the entire database for the MLA into MySQL. It's just a matter of testing the new server, fixing some annoying errors that are poping up and soon we can go to a more reliable forum system.

So, don't lose hope yet, we are working on a better MLA for all.

Just for facts:

The new host will use the exact same forum software, there will be zero changes to what we already have. Please do not ask for any extras or changes, it's going to be exactly as it is now, only more reliable. The only real change is going from Access to mySQL.

When all the glitches are worked out, members will be invited to test out the new forum to finalize that it works properly under the load we have. (Posts made on the test board are lost when the final one goes active.)

`BoJ

(I guess all that lobbying worked )

_____________________________________________
I have a problem with vintage electronics. . .I am working on it.

Update: I got some of the glitches fixed...so now I have to put the database up. You can see a half empty shell at www.68kmla.org/forum/ and yes I know it's messed up..but it's just a shell..none of the important data is there....so I'm going to be updating the database. So if the database gives errors, it's just me. ;-)

- - - - - - - - - - - - -
A little knowledge is a dangerous thing, but it sure beats a blank stare for starting a conversation.

quote:

---

Obviously someone is going to back up all the data on this site..... right?

---

that is sort of the point of the whole exercise

looks good so far tBoJ

Orcadian MLA Division
68ks Liberated: 2

http://nonameproductions.dyndns.org/error.jpg look what I got when I tried to go to the new forums... lol... I thought it was hillarious. I can't wait for the new server to be up... no more errors like that or the Accessi database errors hopefully.

________________
foetoid, that's (fee-toy-duh)
http://www.foetoid.doesntexist.com
da band: http://www.burningabbey.com

quote:

---

Bear with us as we get a huge hammer and give Windows a big thrashing!

---

________________
foetoid, that's (fee-toy-duh)
http://www.foetoid.doesntexist.com
da band: http://www.burningabbey.com

When you break glass, esp. with a hammer, it spreads EVERYWHERE...

It'd be best to recycle this one

(What did windows do anyway?) (*that it deserves to be thrashed/borked) ?

b'sides, your current errors aren't because of the database engine specifically, from what I'm told that host (webicane) is down... (quite sad too...) (or their MySQL servers at least..

I do have MS SQL that can be used, but I am unsure if ODBC is required for this or not. Unlike php, ASP does not seem to have the ability to interconnect with other data sources as readily as php. One reason why when you run a php board you seldom require ODBC since php is compiled with support for databases already whereas ASP isn't so lucky.

If I can get my hands on ChiliSoft ASP I might get better luck running this on a Linux host, because frankly they are more reliable.

The main issues at this point are that the Access database has a number of key differences from MySQL that creates problems..for example, tables are missing that tally posts and keeps them organized. This is why the original test board acted odd when people posted because it's trying to index posts to update the list of topics..but the area where it's supposed to store this information doesn't exist.

The other drawback is that as of yet I don't have SSH access to do quicker database backups etc., which means if something goes wrong with the database like the other day, I would have to manually cut and paste 40MB worth of text to recreate the database. (I've done this twice) So I am hoping I can work something out.

If I still can't get the information sorted out, I will see what ODBC options the current host has and if it works, I can still host the MySQL database which would reduce the errors. (MySQL is online and running since I have other databases which are functional at this point, it's just that Windows ODBC can't get through for some reason.)

So, at this point, I am somewhat unsure. But something will get worked out.

ouchies...

(still doesn't sound like a windows proble though...)

If I can get that working I'm all good. ;-)

Plus I had Win2000 with IIS up and running but trying to troubleshoot ASp and other factors is very hard.

At this point everything is on hold since I'm unsure where this is all heading. Maybe we can all just pitch in and buy hosting...it makes it easier for all concerned.

Depending on the monthly price, I know that my next PayCheque I can put 50 dollars Canadian towards it. (Next cheque is end of January, around 27th)

We can talk about this further and I can discuss with Coxy a little about it. Like I said, I'd be happy to pitch in 50 bucks a year, maybe more.

If we can get 10 members to pitch in 1usd per month we would be set.

And I was mistaken on board software it is PhpBB

quote:

---

Also setup is very easy and includes yabb software. Though we could most likely still use the snitz software if we wanted to.

---

Orcadian MLA Division
68ks Liberated: 2

AMHosting (I use them) has fantastic deals on their expert hosting. (No support means that they don't support you with basic level stuff like, "How do I use FTP" and stuff like that. But if the server breaks, or it's out of your control, they'll fix it. I personally use their PLESK full support hosting)

$7/mo for 500MB space and 20GB transfer. Linux.

They also offer some Windows hosting which would support the Snitz software. $8/mo for 75MB space and 6GB support (fully supported account, they'll help set up Snitz and things like that if you want for free)

Now, to pay for my own hosting. I run ads on my sites, Google AdSense. They're content text ads so they reflect the content of the site. I think they could work great for this site! I made $47 last month which covers my costs ($15) 3 times plus $2 left over after that! That was for 278 clicks. Cost per click varies. Some ads can pay up to $1 and some as low as 1¢, it depends on the content of the page. I implore you to check it out. http://www.adsense.com (note, not affiliated with Google, blah blah blah, just a happy user)

======================
Current Macs:
iMac G4/700 (main)
iBook G3/700 (portable)
PowerMac 7300/180 (server)
PowerMac 6100/66 (no monitor!)
Quadra 610 (no monitor!)
Performa 400, upgraded to 475 (busted monitor!)
Apple IIe (dead but I keep it)

If you have everything in SQL, you should use it with a PHP-based system. It's cleaner, saves on bandwidth, easier to code, etc. but I digress.

I'll probably just point the 68kmla.ca to this and keep the URL cloaked..
http://www.deadgeneration.com/68kmla/
..once i get my content scripts prepared. Need them to go through my text files and spit out XML. Perfect for this sort of thing.

I won't be doing anything for quite some time most likely, but does anyone but me actually use 68kmla.ca?

Liberated 68xxx Macs: IIsi, IIci (2), LC II, Classic II (2)

Liberated PowerPC Macs:
Powerbook 5300cs, Power Mac 7500/100

Since it's not the fastest in the world it's nice that it has 2 CPU's which means even when I'm gaming, doing graphics etc., if I set the IIS system to use one CPU, it means in a performance gain.

It will have 2 18GB SCSI hard disks attached. So I think that part is good to go, I just have to wait for it to be shipped.

I'll keep folks posted.

quote:

---

I'll probably just point the 68kmla.ca to this and keep the URL cloaked..
http://www.deadgeneration.com/68kmla/
..once i get my content scripts prepared. Need them to go through my text files and spit out XML. Perfect for this sort of thing.

I won't be doing anything for quite some time most likely, but does anyone but me actually use 68kmla.ca?

---

68K: Powerbook Duo 280c, Quadra 840av (2 of 'em), Quadra 950, IIcx, Performa 460, etc. (a lot of "etc.")
PPC: 9600 (G4/700), 9500 (G3/400) & 8500 (G3/300)

quote:

---

Is it just me. Or is the fact that the 68K MACINTOSH FORUMS are hosted, and may still be hosted, on a f***ing WINDOWS machine, just DISGUSTING? It makes me vomit! I understand Literature Classics was chosen because it was available/free at the time but now there are much better choices!

---

either way, I prefer FreeBSD. . . partly made right here in Boulder, CO!

68k Macintosh Liberation Army Forums

© 2001-2003 68kMLA