Follow

work, fixing other people's messes 

Migrating a home-brew CMS. First issue was hard-coded paths in includes which reference a GoDaddy account ID. Fixed that with find and sed.

Now the navigation doesn't work. Sloppy SQL syntax in the query works on Ye Olde MySQL, but not on the current version.

Have to figure just WTF the query is trying to achieve (not commented) so that I can re-write it to work. *sigh*

This whole thing would have been better done in fucking WordPress.

· · Web · 2 · 0 · 1

work, fixing other people's messes 

OK, I really can't figure the logic in generating the menu.

So I'll just tell MySQL to suck it.

MYSQL_QUERY("set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'");

work, fixing other people's messes 

@grumpysmiffy People say bad things about off-the-shelf software like Wordpress but there is a place for it.

work, fixing other people's messes 

@futzle I could have ported a WP site in an hour. Been farting around getting this working for four days now.

Haven't the patience to figure the logic of this, so I've just gone and turned off strict mode for the query instead.

Sign in to participate in the conversation
Aus.Social

Welcome to thundertoot! A Mastodon Instance for 'straya