Wasting Time
Ale, music and enjoying life.
90s Leeds Centre Centre Pub Crawl
Here is a collection of images from Leeds city centre in the 90s. More specifically 1999. So, let me take you on a pub crawl around the centre of Leeds in the late 90s…..
As part of my Computing degree back in the late 90s I did a “multimedia guide to the pubs of Leeds” – This involved much careful research of the pubs in Leeds city centre (and a few in Headingly) at the time and I stumbled across a load of (badly taken) photos that I used as part of the multimedia experience!
I make no apologies for the quality of the photos and realise they’re pretty crappy. There are plenty of books with high quality images on this subject. Although none of them seem to have fairly recent media. You’ll notice some of the pubs are still standing and haven’t changed a bit. Anyway…….
Beckett Park Campus
Beckett Park Campus
“Berlins” (now Belgrave Music Hall). This seemed to be the pub everyone started their night in. Notable for the big spinning wheel in the centre of the pub where you could win a prize
“Brannigans” on Vicar Lane (now Travelodge). I remember being in here for England V Germany Euro 96 TVs and bodies everywhere (and beer everywhere when England scored).
“Feast & Firken” (now The Library).
“Felon & Firken” (now O’Neils). They had quite a lot of court/legal and judges stuff on display upstairs (along with a pretty good jukebox).
“Hyde Park Pub” Not really changed much.
“The Three Horseshoes” Not really changed (apart from the sign).
“The New Inn” . Only time I went here is when we did the “Otley Run” one year.
“Woodies Ale House” Used to go in here every Friday lunchtime for chips and gravy or something else typically Northern.
“Square on the Lane” on Boar Lane which is now Sainsburys, Cafe Nero etc.
“Yates” Boar Lane.
“The Observatory” then became “Flares” now “The Black Prince”
“Majestyks” nightclub – avoided and only went in once on a work’s do. Occasionally went to “Jumpin Jacks” round the corner for a laugh.
“Rat & Parrot” opposite Merrion Centre is now Yates/Verity. This was a massive pub. Used to go in a fair bit before Leeds started getting some decent drinking establishments.
“Dry Dock” not changed much apart from a paint job
“The Courtyard” now “Nation of Shopkeepers”.
Mojo Magazine March 2010
Was going through some old magazines in the garage and found an old Mojo magazine. Forgot I got a mention
The Dears – Leeds Brudenell Social Club – 26th February 2017
OK I’ll admit it, I’m not a massive Dears fan. I appreciate their work but I don’t listen to them much or have all their albums or anything. However, to have not seen them in Leeds at less than £20 a ticket would’ve been criminal.
Murray Lightburn’s voice is just as powerful and glorious live as it is on record (obvious comparisons to Albarn and Morrissey avoided). A great performance. The sound mix started a little muddy but half way in it was perfect.
SSIS Troubleshooting – Reporting
When running SSIS components through SQL Server Agent jobs sometimes an error may appear and when viewing the job history you’ll see the helpful “To view the details for the execution, right-click on the Integration Services Catalog, and open the [All Executions] report”. If you attempt this you may get an “Out Of Memory” exception due to the sheer amount of logging your SSIS component is producing.
So how do you troubleshoot?
There’s a way of querying the report through an SQL query and you can filter down the noise accordingly to something similar to the below:
SELECT TOP 15 *, event_message_id,MESSAGE,package_name,event_name,message_source_name,package_path,execution_path,message_type,message_source_type
FROM (
SELECT em.*
FROM SSISDB.catalog.event_messages em
WHERE em.operation_id = (SELECT MAX(execution_id) FROM SSISDB.catalog.executions)
AND event_name NOT LIKE '%Validate%'
)q
/* Put in whatever WHERE predicates you might like*/
WHERE event_name = 'OnError'
ORDER BY message_time DESC
Kudos to the following link that refreshed my memory on this:-
phpBB Forums – Upgrade pain from 3.0.14 to 3.20 and moving host!
I hope the following bits and pieces may help someone else out in a similar situation
My hand was forced really by my current web host’s (this site has a different host) inability to make sense of their overzealous anti-malware scripts. So on and off in pockets of spare time for the last week I took on the mammoth task of moving a massive phpBB forums across to a new host and upgraded to the latest version of php and phpBB. No easy task especially considering that the site’s database backup weighed in at 1.3gb! (There are posts dating back to 2001)
I realised the transition to a new web host wouldn’t be plain sailing and that I’d have to go off-piste with phpBB’s directions which assume your db size is around 2 meg 🙂
https://www.phpbb.com/support/docs/en/3.1/kb/article/transferring-your-board-to-a-new-host-or-domain/
The following describes the areas of pain experienced:
Back the hell up
First steps were backing up all phpbb files on my existing server along with exporting the forums MySQL database (I did this through phpmyadmin.
Place forums files on new host
Went down a bit of a blind alley first in attempting to install the latest phpBB software through my new hosts control panel. It just didn’t want to play with the DB and I was seeing all sorts of weird config issues. So I placed the existing forums files from my old host onto the new one.
Database size is too big to import
Once I had the forum files on the new host I needed to bring the database over. Having backed up the forums database weighing in at 1.3gig it’s not exactly the 2meg file that phpBB seems to think is standard. Therefore, I had to use “BigDump” :). Although Bigdump is a god send I did struggle initially with it. I was seeing timeout issues and it would bail half way which meant I’d have to go back into phpmyadmin – drop all tables it had brought in and restart the process.
Just when I thought I was getting somewhere with it it had processed 54% in about 3 hours then seemed to slow massively. I started to time things and it took another 3 hours to hit 64%. At this rate I’ll have to leave it going for days!.
I jumped back into phpmyadmin and had a nosey at what table it was bringing in and why it was taking so long. Turns out it was taking it’s sweet time with phpbb_search_wordlist and similar tables which relate to the forums search index. I’m no DBA but I’m guessing that as the data was being imported the process was taking exponentially slower as it went on. After a bit of digging I realised I could empty these tables and rebuild the index once the board is up and running.
Soooooo, back to the old forums, empty the offending tables (I could’ve just not backed up the data). Then back up the db again – This time it’s a much more manageable 350Mb. Onwards!
Time for another BigDump
So we now have a much more smaller DB backup file which I placed on the new host and showed it BigDump. After about an hour the restore was successful.
Forums up!
Following a successful DB restore I headed over to a browser and hit the forums url on the new board. Success! Well almost there’s a few errors appearing in different parts of the forums. After a bit more digging turns out the old phpBB software I’m running is clashing with the version of PHP on the host. Certain functions are now obsolete or replaced. So there’s only one thing for it…
Upgrade the old forums from phpBB 3.0.14 to 3.2
Ok over to the phpbb downloads for the update package https://www.phpbb.com/downloads/ . Hang on they don’t have a route from 3.0.14 to 3.2 only 3.1 and 3.2 are supported. On the footer of the site I noticed “Older Versions” which lead me to https://download.phpbb.com/pub/release/3.2/3.2.0/ . I downloaded the phpBB-3.0.14_to_3.2.0.zip and then copied the install folder across to my new forums and hit the install url.
Hmmm things didn’t look too great. Firstly, there were 100s of files flagged which are no longer supported and I would have to delete and about the same amount of files for ones that would need manually merging due to 10+ years of mods and so on. This is not an option. There’s only one thing for it…
Install of new phpBB 3.2 files
I had no other option that to bite the bullet and install the latest phpBB 3.2 files. I deleted every file on the forums apart from config.php and the following folders; \Store , \etc, \Files . I uploaded the full 3.2 set of files and folders then hit the install url. It all went through without issue.
Forums Up! (again)
I checked the forums and they were up and running. I carried out some quick checks (new post, reply, PMs etc) then got a couple of others to help me out. It all checks out fine and all posts are there dating right back to 2001. Sure, I’ve lost some mods and some styles but these can come back with time.