frostfire

lol - probably fake, but still unique.

I am going to accelerate the push for the latest version of the software. We may have to go without a skin or with a skin that goes thru a few iterations before its right, but at least we will be on the latest version.

Site issues should now be resolved. I did reboot the server, so there was about 5 minutes or so of downtime, but the result should be a good speed again. Frosty

Yup, im working on it. Will update as soon as I am sure a fix is in place.

LOL... I can't tell if your being serious or not there. RAID - Redundant Array of Independent Disks - essentially its a piece of hardware that combines multiple physical drives (in this case 16), in to a single usable logical drive that the operation system can see. In short it can keep working even if 2 of the physical drives fail, tho it will run slow until the damaged drive(s) are replaced. That is not what is happening here tho - all 16 drives show as online and healthy. Something else is wrong. But it will fix itself. I have turned off all but 2 of the VPSs running on it to speed things up, so hopefully most of the speed issues will not be noticeable until the scan is complete.

ok so I am just going thru this trying to figure out whats going on, and I think I have a partial explanation. The server this site is running on is a VPS, and the host computer its running on is not even near its useful load, but it does have a very complex storage system known as a RAID. This essentially keeps the data safe in case of a drive failure (or multiple drive failure in this case). One of the downsides to running a RAID is that it sometimes has issues and needs to re-build itself, or in this case do whats called a Consistency Check. These checks take a god-awful amount of time and slow the drive (and thereby the whole system) down to a crawl when running. One of those scans is running now. Worse, its going a lot slower than it should be, and I have no idea why. Its been running now for 2 days and is only at 10%. I could cancel the check, but I dare not as its the second time its run itself - the last time just a few days back I cancelled it for taking too long and slowing down everything. This time I am going to let it run so it can find and fix whatever issue that prompted it to check in the first place. Once completely finished the issue slowing things down whatever it is should be resolved. In the meantime, I will look in to moving the pattayatalk VPS to one of my other servers. Not sure if that is a viable option or not, but if it is I will get that done today.

Fair suggestion. It may well be that there are new ones with the new board version - in fact I would be surprised if there were not new ones. If not tho, its something ill look at.

Ah I see. Are you using a new or temporary account? Looks like your account is not verified.

There may be an issue with your browser. You should get a menu when you hover over a name. You can also go here: http://www.pattayatalk.com/forums/members/ Search for the mod you want, click on their name and message them from their profile there. You can also start a new message from your own mailbox and just type in the name: http://www.pattayatalk.com/forums/index.php?app=members&module=messaging&section=send&do=form Hope this helps.

AH yes we were. So... Annabells: Very quiet. We walked in and were about to walk right back out when the manager (who appeared to be known to Big Brian?) walked up... Brian says something to the effect of " is going to buy us some drinks, so we can stay" ...and the manager appeared to agree... but that never happened, so we drank a quick one and moved on. I'm surprised I forgot to mention this bar because I was going to mention that this place was also owned by Dave (windmill), and was the 3rd bar that was a disappointment last night. Very surprising. Ive always liked his places - and he always seemed to find good girls. I hope he's ok and will return to making things great again some day.

Ok, so... If the barcrawl is judged on the hangover, it must have been epic 555. Great time was had by all. Here are a couple notes about the bars we visited: LePub - as always, Mr. Egg is a great host. Excellent place to start off an evening. Windmill - I never thought i would say this... but it was kinda disappointing. Unless your in to quantity vs price. Then it may have been epic. Really wish some of those girls kept some clothes on. Upstairs was moderately better with at least 3-4 fairly cute girls, but kinda over-shadowed by the 20 or so heifers. Tho most of those obviously don't climb stairs, so remained downstairs. Sugar Baby. Now right off the start before getting in to the details of the bar, I need to shout an apology out to Mr. Egg. Ever since Sugar Baby opened years ago, I have had a really bad tendency to say "baby dolls" instead. I have no idea why, and this got us a bit confused last night as Mr. Egg was going to meet us after our windmill fun, but he went to Baby Dolls and we went to Sugar Baby. now, as a mitigating factor I can almost guarantee that Egg had a lot more fun than we did... cause sugar baby was e.m.p.t.y. Like 10 girls in the entire place and most of those entertaining around the shower area in back. I think there were 4 girls on stage and another 3 wandering? In any case, it was not the sugar baby of old. I asked where Dave was as he usually did a great job of seeing that there were plenty of girls, but he was MIA and the staff had no idea where he was or when/if he would be there. Very disappointing. Fahrenheit - Ok, so this is where the evenings fun really began. LOTS of really hot girls, all really friendly, and one in particular I will be visiting again very soon. Top rate place and well worth a visit. Lots of old faces - like the infamous Wa from Misty's fame (think: service girl that usually ran around naked), as well as her sister Ja with the DDs - and plenty of fresh young faces as well. Crazy House - This place lived up to its name in spades. Great staff and very friendly - not a lot of stunners, but a great time was had by all. Now without naming any names I do want to shout out to the guy that had the best time in the place last night. You know who you are, you dog! he munched down on the smallest girl on walking street for a good 30 minutes and had her screeching reaching levels not heard since she was 20. Which may well have been a really long time ago - nobody knows for sure, since shes been in every gogo on walking street for as long as I can remember. Shes changed names a few times as well, but the one from '08 that I remember is Ploy - and shes fairly infamous on walking street as well. Anyway, the BM in question (who shall remain nameless unless he decides to shout out), was having a absolutely great time - and the rest of us enjoyed the show as well. Well done! Mistys - Misty's has always been a walking street staple. Always a good number of cute and friendly girls, and while there was a bit of a shortage last night compared to my memories of the past, it did not disappoint. I think most if not all of the guys had at least one hand somewhere fun. Great place as always. Dollhouse VIP room - So it was mentioned that Dollhouse now has a VIP room upstairs which was supposed to be pretty expensive but worth it. So of course we had to check that out. Mistys was the last official bar on the crawl, but almost all of us decided to keep going, so there were several of us that went up to check this out... First off, the drink I had was priced the same I think as dollhouse downstairs, and I did not buy a lady drink there so I am not sure if those prices are high or not, but in any case I was not too impressed with the lineup. I don't recall the girls now having slept since then, but I would surely remember if there was anything even remotely memorable. So ya, not worth the visit to be honest. Tho since things change daily in this town, I will be back to check it out again perhaps earlier in the evening when things might be more lively. Babydolls! - While this place was not officially on the crawl this week, I always make it a habit to visit Paul and Larry whenever I am in the neighborhood, so we all popped in for a cold one. Larry was not there as it was past his bedtime (lol), but Paul was - and there were a good dozen girls there, including one very big surprise. Now I usually don't make a habit of outing girls and where they work in case they have a sponsor and are moonlighting, but I asked her if I could mention it and she said ok, so here is the scoop of the night. BAM of FLB fame is now working at Babydolls - dancing in all her glory. Shes up a few kilos but still looks great! If you know/knew and liked Bam in FLB, consider stopping in and saying hi. I am sure she would love to see everyone. Shes a great girl with a great attitude and is as lovely as ever. Ill add a pic for those of you that need to put a face to the name. The pic is quite old tho... from a party years ago in FLB. Summery: Was a really good crawl, and while a bit short on people due to songkran, a great time was had by all. Now... on to the pics of Bam! :)

A lot of people leave for Songkran, and may not be back in town yet. Starting on the May crawl, I will see about sending out a notification email about the crawl, as well as start advertising on facebook - neither of which is being done just yet.

If you are in town, please come join us for our first (in a long time) monthly board meeting and bar crawl. We will be meeting up at 8pm at LePub, and then moving on to Walking Street for a crawl. In future meetings I will be posting the announcement a month ahead of time, and will include a poll asking those that will be attending what area of pattaya they wish to crawl (walking street, soi 6, soi LK, etc) - those votes will be tallied on the night of the event and off we will go. For this first one, lets just do Walking Street to keep it simple :) If you are planning on attending, please post something here so we can get an idea of the numbers. Hope to see you all there! Frosty

Credit card is easy, following the link above - it uses PayPal which accepts Credit card. Bitcoin is a bit tougher, but can be arranged if necessarily.

I've made a minor change that will show only a single line for birthdays for each day. If there is only 1 birthday that day, the members name will show. If not, it will show something like (4) birthdays and clicking on that will take you to the Day page where all the birthdays will be shown (as well as any other events).

Already working on that. :)

Hi Guys, Looking back over the data from years past (as I had to do for the site upgrade test I just completed), I noticed something that I remember from back in '07 but somehow forgot about between then and now. The Pattayatalk calendar can be edited by anyone. In the past it was standard practice for BMs to create an "event" for the time they will be in LOS, so that the calendar view would show to everyone who was in town at a certain period of time. Usually people plan their holidays months in advance, which allowed Martin to see where there were time periods of greater activity. I would really like things to get back to that point again - it would help a ton in organizing meetings and barcrawls. So... a simple request. Please start to use the calendar again, if you don't have a particular reason to keep your trip confidential that is. When the time comes to upgrade, the data will go with us, so nothing will be lost. The calendar also shows birthdays... might come in handy at some point. Assuming people are honest on their profiles. lol. Here is a link: http://www.pattayatalk.com/forums/calendar/ If your curious about what it looked like back when it was being used, click the link above, then click Jump To and select March (or whatever), of 2011 (the longest you can go back for some reason). If it becomes too crowded with data, ill find a way to compress it.

OK, another update. The "background processes" finished about 2 hours ago, making it a total of right around 20 hours to run. Again, we will not need to do that when we port the live site over, but I wanted it to be finished before I did my initial testing. When I first visited the forum after the completion of the processes, it looked... ok. The skin was obviously gone, and I noticed another heretofore invisible (to me) link to agoda that I will need to find and kill (since nobody can ever collect that money lol), but when I tried to log in or visit a forum (browse), I got hit with a 404 error (page not found). Oops. After consulting with Invision, we finally deduced that mod_rewrite was not working for some reason, even tho it was active in PHP... turns out the apache config file needed a small change to allow access to the .htaccess files in order for things to work properly. Now why couldn't the forum detect that little problem? Strange, but fixed. So, I now have a fully working test version of Pattayatalk upgraded to the latest Invision, sans skin. Its naked as a jaybird. But it works. Now the fun part will begin... I need to learn how to skin the bugger to look and feel like the Pattayatalk we all know and love. (or hate. Whatever). This is the process that will likely take a bit of time, since I know fuck-all about skinning and will be learning from scratch with zero knowledge base to work from. But it should not be too tough - we don't have a very complex skin here I don't think. There are some UI changes that will have to happen tho once the upgrade is done, since there are new features that this old version does not have and we will want to take advantage of - but I will attempt to get as much as possible to appear like it does now. For anyone interested, a screenshot of the forum as it is freshly upgraded is below. Also, if I know you personally and/or you are a mod here, and if you want to take a look at the new forums, send me a PM and I will send you a link to it, where your existing user/pass will work to check it out - just don't get it confused with the real one and start posting shit, cause all of that will be deleted at some point :)

With any luck then, this will complete and it will work properly. I suspect the reputation and calendar systems will be intact now too, which leaves the only open issue being the Skin. We have a fairly simple skin I think... but I say that with absolutely no experience in working with skins to back it up lol. My current plan rather than learn the ins and outs of skin design, I am likely going to go to freelancer.com and get someone to create a new skin for me, using the live site as a template. That way it gets done right.

Btw, I do not have the Conversions sub-section that you show there. Perhaps because I have already upgraded... the bottom most section on mine is "Support"

I have been in constant communication with them. They did offer to do it for me, but I felt (and still do) that my learning all of this is essential to the future well-being of the site as a whole, and so I opted to do it all myself. I may bring them in to do the live site upgrade when the time comes, or may not... will see how it goes. This is step one - thats like step 5. :)

My first degree in 1991 (at age 18 - almost 19) was in Electronic Engineering Tech, and my 2nd a year later was in Automation Technology (Robotics its called now I think). I still love hardware, and miss the old school Radio Shack. That place was like walking in to a candy store for me. I still have and use breadboards from time to time to test circuits out, but have not yet found a place in Thailand to buy stuff to make my own boards. Technology has changed a whole lot too, so I likely wouldn't know how anymore lol. Still I used to love doing that stuff.

Ok, So… In other threads I mentioned upgrading PattayaTalk.com to the latest version of Invision Power Board (That’s our forum software). The first step in upgrading such a large site is to set up a test server and clone the site over there, then upgrade the test server completely and fix any issues that arise (recording everything so you can reproduce it easily), and then once its all done and your happy with it, upgrade the live site and fix the same issues hopefully quickly since you have the notes and files from your last attempt. Some of the issues so far I have found interesting, and some of them quite challenging - so I figured I would share in the public area, so that anyone else going down this road may learn a few tricks (searchable via Google) Martin worked on this upgrade for several weeks a while back and eventually gave up. At the time he preferred to do this himself and did not consult me on the technical issues, so the info I got was informal - discussed over beer (or likely in a gogo bar), but I remember him telling me that both the reputation system and the calendar were broken beyond repair after attempting the upgrade, which is the reason the board is still on a several year old version. Another issue was the skin, but again at the time I seem to remember him telling me we could get around that issue. This website is hosted on a Linux server. My experience with Linux until this pretty much consisted of a lot of laughing and eye rolling. As a lifelong enterprise windows developer I have always held a bit of contempt for Linux… not because its useless, but rather because in my view it is way too limiting to be taken seriously in the “Enterprise” world. As I’ve gotten older that belief has softened, but not totally disappeared. I still believe it to be way too limiting for Enterprise use, except in a very narrow area, but I do also realize that there are things Linux does better than windows. One of those things is serving up static websites. The forum is not a static website, obviously, but it is written in PHP, which is another thing Linux does better than Windows - or if not better, than at least with less hassle and overhead. If I were starting this community up from the start I would be tempted to use a .NET based solution instead, so I could customize it to my hearts content using the skills I have honed over a lifetime of professional practice. But, since it already exists - I decided it is time to set my prejudice aside and learn how to properly administer Linux/Apache so that I can properly handle things going forward. So begins this journey to upgrade pattayatalk.com :) So, Martin told me about vague problems with Skins, Reputation System and Calendar. If he had told me the specifics of the problems, we may have been upgraded years ago. But he didn’t, so I had to learn all this myself. So, I got a new server set up with CentOS 7, and since I am a linux newbie, it took me a few days (a hour here and there) to get that installed, configured and working properly. I eventually learned all the “gotchas” of installing linux, mysql, apache and php. Turns out that, like windows, you can’t just pick those from the installer for the OS to pre-install and expect them to work. I ended up having to re-install CentOS 4 different times due to various conflicts, and this last time (which seems to have done the trick), I opted for the “minimal install” with no features added automatically - and then I installed everything I needed manually. The main reason for this was PHP. Picking that from the start installs a old version… 5.4? I forget the exact version, but its 5*. That works for our forum as it is now, but the upgrade needs version 7 - and removing 5.4 and installing 7 caused so many errors that after several hours of trying to fix it, I just reverted and tried again. Lesson: Install minimal and load the versions of each program you need one at a time. I am skipping over all the lessons learned in getting to that point - simply because most linux people will have already learned the same things (like how to use Nano, Sudo, what a wheel is and why you need to plaster one on the bottom of your user account to get around (lol)), locking out root, and what to do when your trusty internet instructions don’t work. (Nano is not installed by default - and installing it requires editing a text file. Which requires Nano. According to one article anyway - another taught me about vi ) All told so far it has been very simple technically, but it is still a new language and while my knowledge of how things work allows a great deal of insight, how things are MADE to work is not always intuitive, and sometimes google is a bit slow in giving up the gold. One other area I will touch on is permissions. Permissions in linux a bit weird from a windows perspective. And SELinux (Security Enhanced Linux) is a right pain in the ass. In fact (and all you linux heads keep ur traps shut on this one for now), I ended up just turning off Selinux for the time being on this test server as it was causing way too many issues that just magically went away once I turned it off. I do realize that will not work for us in the long run, but it will for now on this test server so I can get the important parts of the upgrade done. On our live site, I take the time to learn it properly. In fact my favorite go-to training site (https://www.pluralsight.com/) has a course on SELinux that I plan on watching over next weekend, after which ill turn it back on here on the test server and get it configured properly. If any of you are techies and need to keep sharp on areas of technology you are not fully up to date on (and anyone that says there are no such areas is a liar lol), Plural Sight is great. It does cost $300 a year, but its value is far beyond that. I tend to turn on the odd video when I’m working on something else… and while my absorption rate isnt even close to 100%, I do pick up enough to be competent even in areas I have never touched. Well worth the expense for anyone actively working in the software world. You would think since I do use it so often I would have thought to watch a linux basics course of which it turns out they have several. Doh. (Including one called “Deploying a Linux Web Server for Windows Admins”). Double Doh. Well, I did not watch that… but guess I need to now, just to see how stupid I was and how many hours I wasted on google. But then again, I like many other techies before me tend to learn more and faster by hands on, not watching videos. So I don’t consider it a waste of time - just a Doh moment. :) - I also noticed they have one titled “CompTIA Linux+”... I think I see yet another certification in my future, just for the hell of it (if they test that one in bangkok that is - not sure if they do or not). So… at this point we have the forum backup (files) and database installed and working on the test server (able to log in, see posts and admin and nothing obviously broken). I logged in as a standard user, posted a test post, then moderated it, deleted it and the user (as admin), and everything was working - so I made another checkpoint and downloaded the latest forum software and followed the instructions for uploading the proper files to the server and initiating the upgrade process. Now, while I touched on this earlier I will do so again here real fast. The initial screen for the upgrade told me to create a folder named /var/www/html/forums/datastore and make it writable. I found the folder, it already existed, so I checked its permissions and it was already writable by “Apache”, which should have worked. After well over a hour of trying to fix that, I finally gave up and set it to 777 (writable and executable by all, which is a bad thing!) thinking that would at least get things moving… wrong. Still no go. Turns out this was some vague setting inside SELinux. I set SELinux to permissive mode (temporarily), and whoa and behold problem (that problem anyway) solved. At that point I had done so much crap with the folders and files trying to figure out what permissions were hosed (including replacing the owner/group and all permissions on all nested files (recursive) on the whole damn folder), that I decided it would be better to revert back to my last checkpoint so as to make sure permissions were not messed up anywhere. So I did that, and my first course of action was to disable SELinux (lol). That got me to the login screen for the upgrade process. After logging in (admin account), I was immediately hit with a huge wall of red. Error messages galore. Over 300 of them. But… after looking a bit closer I found that all but a handful were related to IP.Gallery, which was still installed and as far as I could see, enabled - but not actively used anywhere, and checking our account online we had not paid for it for a couple years and we did not have a current license. After consulting with Invision, I reverted back to the last checkpoint, turned off SELinux again, then logged in to (the old) admin and removed the Gallery app from IPB. I then uploaded the latest IPB files again, and took another checkpoint before starting the upgrade process again. This time around there were only a handful of issues… but one of them will be a PIA. Most of them were permissions issues - certain folders (about a dozen, maybe 10) that needed to be writable and were not. Easily fixed. One however, was PHP. We had version 5.6 or 5.4 or something like that (I forget the exact version, but it was 5*), and the minimum version for the new upgraded IPB needed 6.something at a minimum, and 7.0.0 recommended. And since we were upgrading anyway, I figured I would get the latest version - 7.0.28. This version required adding a new repository, which after learning how to do was quite simple. Trying to install it on top of the current version failed however. I had to remove the old version first. I did that… then installed the latest version. All went very smooth… (which should have worried me). From that point on and for the next 4 hours nothing I did would make php pages load in apache. Something was seriously broken. After a few hours I simply gave up trying and this is when I deleted all my existing checkpoints and did a new re-install of CentOS with no features added, adding in everything manually instead. Now, at this point it had been well over a week since starting this project (10 days?), but of course not at all full time - just a hour or 3 per day. On this last attempt getting the install done, configured, updated and ready to try again took well under an hour (I’m getting pretty good at this). Kinda reminds me of that time I found and installed a very old copy of The Bards Tale (my favorite Commodore 64 game from WAY the fuck back in the day), but for some reason it just wasn’t quite the magical experience it was before puberty. Funny how that works. (DOS anyone?) So, after all that I was back at square one. But it was very fast getting back to the upgrade wizard this next time, and setting permissions was even faster than last time (it really is very simple), so there we were at step 2: Database conversion. Turns out that IPB v4.+ needs the database to be based on UTF8, and the old one is not. So it needed to do some fairly extensive updates to the database using a tool they provide for the job. The name of the tool is convertutf8 and the main executable is convertutf8/cli.php (I put that here to be searchable by google). This tool is great, but oh so flawed. The first time I ran it in the browser, and after starting it (which makes no sense) it tells me in text at the bottom that if the process hangs repeatedly you can run this in the command line and gave the process to do so. I ignored that for now, trying to keep things simple. It started running… after about 2 hours it seemed to hang, or at least not move forward, but it was very hard to tell because it only updated its status on each table - and the table it stuck on was the Posts table, which has well over a million rows and I would have expected it to take some time. Eventually I refreshed the page, which resulted in a 500 server error. Back to the front page of the upgrade and it was nice enough to tell me that the upgrade to the database was in process and had finished x of x tables, and click here to continue. That was nice. Clicked there… and it was still on the posts table. 1 hour later I got the bright idea to check the server CPU to see if it was busy. It wasn't. (by the way, found a nice external tool called htop that works great in monitoring that). Turns out it was failing (or at least the CPU was dropping off) just a few seconds in to the update. So… I went to the command line version. Oh so much more informative. The CLI version said that a upgrade was in process and did I want to continue or revert and start over. I opted to start over. This time it went faster I think - at least it got to the posts table within 15 minutes, and did not die on it at all - it made it to one of the reputation tables, then it died. It died with this error message (putting it here to be google searchable) fatal error: allowed memory size of 134217728 bytes exhausted (tried to allocate 32 bytes) 2 subsequent attempts at restarting this failed at the exact same place. Googling found that this was due to a limitation in PHP settings of 128MB of memory. Well, I have 12GB on the machine, so screw that. Right? I changed the php setting (easy enough to do) to 2048MB, restarted apache… restarted the process… reverted conversion and started from begining (just to make sure)... and poof. Failed with the exact same fucking error message. I confirmed that the change I made to the php settings took (phpinfo anyone?), and spent the next 2 hours trying different things - setting memory_limit to -1, to 4GB and then 10GB… nothing worked. It all failed with the exact same error message, implying that it had a cap of 128MB. So I downloaded a copy of /convertutf8/ and all its various files, and scanned them (text search) to find if it was somehow or somewhere setting the memory value to 128MB manually for the script. Nothing found. So I got to thinking… it must be setting that value somewhere or somehow. So I ran that script again, with verbose logging and let it fail. This time it failed and was nice enough to tell me the exact file and line number the failure was happening on: /var/www/html/forums/admin/convertutf8/system/Db/Db.php line 368 Again, I posted that to make it searchable here. So, looking at that method inside the php file, there were a shitload of for and foreach loops in the method. The methed itself was called “public function preparedQuery( $query, array $_binds )” - so I tried a little “hack” - I added this line to the very begining of that method: ini_set(‘memory_limit’, ‘-1’); That, in theory, should allow the proceeding code to use as much memory as it wanted up to the amount installed on the server. Now I am not a php developer, so I was not very confident, but it turns out that did the trick. Next run the program completed 100% without any error. I am hopeful that anyone having the same issue will find this here as the solution is not to be found on google (well, it is now!). So, after that I returned to the upgrade wizard and was hit with a new error. It was a file missing or corrupt error on: /var/www/html/forums/admin/convertutf8/system/Db/Db.php Lol. So now it decides to get smart. Bastard. I replaced the file I modified with the original, which made that error go away. Checksum’s suck when your trying to hack shit. Just sayin. Next the upgrade process started going thru a process whereby it made changes to the database tables (remember that last bit was just converting to UTF8). This required some commands to be run in the console to prevent long running queries from stopping (nice, now the damn thing gets smart about that), and so on we go thru about a hour of that (about 30 or so manual queries and a shitton of automatic ones). The next error happened on the ibf_cal_events table. This was not a manual code run thing - it was (or tried to be) automated. The error was “0000-00-00 00:00:00” is not a valid Date for field ‘event_end_date’. When it crashed, it gave me the option to "continue". Rather than do that, since this was one of the places Martin said failed so badly, I investigated instead. Tried the command in the command line, same result. I think the command it was running was: Alter table ibf_cal_events drop index approved Again, for google. So, I loaded up phpmyadmin to take a look at the data in the table. Total of about 4500 rows (not so bad). Sorted the data by event_end_date, and immediately noticed that most of the data either had a valid date/time in that field or it was set to NULL. There were, however, about 200 rows where the value was ‘0000-00-00 00:00:00’ - and funnily enough searching for this value in that field failed, since that value is not a valid date time. So rather than screw around with advanced SQL to detect that value without actually detecting it, I just exported the whole table to excel, sorted by that field, selected all the affected event IDs, and wrote custom sql to update those rows with a event_end_date of NULL. That fixed that problem. At that point I restarted the process again and it continued all the way thru to the end this time. Initial upgrade of the board was complete. Ish. Next I logged in to the new admin interface, and right away I really like the look of it. But the first thing on the screen showed a queue of “background tasks for the upgrade” that are taking place, and will finish when they finish. It gives the option to run those now to get them done faster - which I am doing at the moment. Its been running for the last 4 hours, and is not even close to being done. Just upgrading the posts table if it maintains its current speed will take somewhere in the neighborhood of 15 hours to complete. That said, the process is proceeding smoothly and so far no more errors. So… there it is so far. The successful upgrade to the forum software, at least on the back end. I have not even looked at the forum yet to see whats wrong with it, but based on what I’ve seen in the upgrade process, I can bet my hat that I successfully fixed all of the errors (except the skin) that plagued Martin. The major SQL related errors were related to the Reputation system and and the Calendar. The 2 areas Martin said were irreparably damaged during his run of the scripts. So while I have not yet looked at the forum, I am fairly confident that those major issues are resolved - and I kept my code and all that in a onenote notebook, so when I go to do the upgrade for real, it will go fairly quickly. For now, I am going to wait for these upgrade processes to completely finish before I do anything else - even before I look at the forum. When I do the real upgrade I will let them run in the background, provided I find no issues once they are done, to prevent the upgrade from taking more than a couple hours. From what I understand these processes are making minute changes to the data for posts and such, and the way it works so I understand is if a post that has not been updated in this way is requested by a user via the main website, the update process is done on that post/object just before it is served to the customer - so running the processes over a period of time while the forum is live will not impact anything. Even so, since this is a test I am going to let it run until its finished before I continue my testing. I am going to post this today and update it as soon as I complete the next step in the testing/upgrade procedure.

Ya.... I don't want to do that. I know there are some of the guys that live here on a very strict budget. While 100b is not a lot of money for most people, It may be to others - and I do not want our events to be about money. Again, I would rather just continue fronting the costs myself if it came to that. We have had a great response to this thread so far tho, with enough to cover several months of costs, so its not critical by any means looking forward. Currently to register and actually see the members section users have to send a email to me, and in the email explain why they want access. These emails were going to Martin until just 3 days before his passing, but since that time I have activated about 20 new accounts, and I have rejected 3 other requests. One because he only wanted the account to sell stuff (I almost let him in, but instead I suggested he join the pattaya selling groups on facebook), and the other 2 because their use of broken English made me wonder if they were Thai nationals (e.g. police), and their email accounts were a bit weird. There are other checks I do as well before letting someone in... and yes I would like to semi-automate that process, and will be looking at ways to do that. ID will not be one of them. Anyone can get a copy of someone's photo ID - you can even find a few on google - and the privacy issue associated with asking for and recording that data is not something I'm interested in. I want it to be easier, not harder, to become a member. Now that said, I will be creating a new group for "Advanced" members at some point, and will be providing multiple pathways to join - such as being known by another known member, or coming on one of the bar crawls or monthly meetings. This advanced section will be totally invisible to people that are not in that group, and will contain anything even remotely "iffy" so that we can relax our grip on the standard members section a bit. To be honest I have no idea what threads there are currently that may be an issue - some trip reports surely, etc. Its going to be a huge job to find and move those... but I'll figure something out on that. I don't expect any of these changes to come fast, but they will come.

Ya... I'm actually pretty good at this stuff... seein' as I've been in I.T. for 25 years :)