Deja vu all over again

[whobutdrew]

Now running on Ubuntu 11.04 x64.

Reinstalled, redownloaded, reconfigured, restored... I now have a live site. Mostly, as is my usual state when I am working with this code.

I get the same "Oops, something is broken!" message that I originally got back in the day when i started about 2-3 years ago. Past fixes were to change the @LANGS line in config.pl (already done) and the fact that my first DW foray was on an x86 server. (Boy, did I hvae my history wrong in my previous post.)

Here is the line from my Apache error log:

Invalid userprop opt_viewjournalstyle passed to preload_props. at /home/dw/cgi-bin/LJ/User.pm line 853.

I'm now having to run off, else I'd elaborate more on the code that it is pointing to.

Comments

[mark]

That sounds like you haven't populated the database:

$LJHOME/bin/upgrading/update-db.pl -r -p

[whobutdrew]

I think the problem is with how I re-imported my database from backup.

I dropped my tables, recreated, reimported, and now have a different problem - it appears CSS is broken. Pages load, albeit slowly, and with the styles not loading at all - everything is straight text.

I used mysqldump and I also have the raw frm/etc. files to work with.

[foxfirefey]

Hmm, if it's just the CSS for the styles, maybe you haven't set up the CSSProxy correctly:

http://wiki.dwscoalition.org/notes/Cssproxy

The styles pretty much rely on it by default since it's a good performance booster.

[whobutdrew]

I never touched anything on my old 9.04 server that was CSS related and never had any issues. But that was running ancient code.

I just tried turning on wildcards on my DNS service, didn't seem to help. Nor did confirming those config.pl settings, unfortunately.

I'm thinking about sleeping on it and testing with a blank/default database next time I get the chance to crack at this.

[whobutdrew]

Dropped my database, recreated it, and tried to load a page that utilized CSS. Same issue - slow, eventually loads, but stylesheet-less.

I did hg update -C tip after reading about the code push that fixed CSS-related issues. Didn't look like any files changed...

To recap:
I have a mysqldump export of my old (working) database as well as the raw FRM/MYD/etc files, for all of you MySQL people.

Ideas?

[fu]

Hmm. What path is it to the style sheets. Do you get a 404 if you try to visit them directly or...?

[whobutdrew]

I got code when I navigate to stc/siteviews/layout.css. Is there a better one I should test with?

As I look at the page source, though, I see this, which struck me as strange:

{link rel="stylesheet" href="http://cssproxy.$DOMAIN/?u=http://$DOMAIN_WEB/users/system/res/0/stylesheet%3F1340407627" type="text/css" /}

($VARS are subbed for my domain)

The syntax of that code just looks... odd to me.

[fu]

That looks oddly like a single quotes versus double quotes issue. I say oddly because it's odd that that happens to your 'hack but not on others.

Can you take a look at the function that's generating that?

[whobutdrew]

While it isn't what you asked for, here is something else I noticed:


{script type="text/javascript" src="http://$DOMAIN/js/lj_ippu.js?v=1340135908"}[/script}

I don't seem to have an htdocs/js folder... zhe plot thickens.

[fu]

Hmmm. Is any other perl code being executed on BML pages at all?

[whobutdrew]

That I'm not 100% sure how to check... I haven't customized any of the code outside of config changes and the like, and I haven't edited any pages outside of textual changes and adding/changing links.

Does that help? Sorry, my Perl class in college was a lot longer ago than I realize sometimes.

[whobutdrew]

I tried dropping and re-downloading the code, and it didn't change anything. Didn't expect it to, but I figured, what the hell.

Let me know if you need to see any of my config files.

[whobutdrew]

Figured out CSS - Since I'm running my server out of my home, port 80 is blocked by my ISP, so I have to run the server off of a non-standard port.

(Cue the, 'oh yeah him comments! :P)

I didn't have to add the port to the cssproxy var before, but I do now. I added it and all is shiny.

MySQL keeps blowing up whenever I try to introduce the old data to it, so I'm just nuking and paving in that regard.

As always, you all are wonderful, amazing, fantastic people for your efforts at assisting a non-web-or-programming-oriented techie who knows just enough in those areas to get himself into big trouble.