unixfan2001
Forum Replies Created
-
Forum: Plugins
In reply to: [BuddyPress Activity Plus] Change "Add Photos" to "Post Photos"Hi there.
There’s at least three ways to achieve this.
1. Navigate PoEdit into the plugin directory and edit its language files.
2. Manually edit the .po file (bpfb-default.po, found under /languages inside the plugin’s directory) and recompile (not really sure how to do that myself, unfortunately).
3. Install Quick Localization (https://wordpress.org/plugins/quick-localization/) and patch it through its interface.I’ve chosen the latter.
Inside old you put “Add photos”, inside new “Post photos” and for the domain you can choose “_ALL_”, provided you know none of your other plugins have an “Add photos” text you’d like to keep intact.
Forum: Plugins
In reply to: [WP Job Manager] No job listings under [jobs]Not much of a client guy. Especially as most PostgreSQL clients sucked equally as much as phpmyadmin for MySQL 😉
The one that was actually good was Windows only and I spend less than 1% of my time on that OS (as I’m currently unemployed, it’s a straight 0%).
Anyhow. I just enabled debug mode. As I was thinking, it’s DB related.
WordPress database error: [ERROR: operator does not exist: text + integer LINE 5: ) ORDER BY wp_postmeta.meta_value+0 DESC, wp_posts.post_dat... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.] SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (2,3,4,5,6) ) AND wp_posts.post_type = 'job_listing' AND ((wp_posts.post_status = 'publish')) AND ( wp_postmeta.meta_key = '_featured' ) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value+0 DESC, wp_posts.post_date DESC LIMIT 0, 10Since PostgreSQL doesn’t even have the “SQL_CALC_FOUND_ROWS” option, I can see the issue now. Thanks 🙂
Forum: Plugins
In reply to: [WP Job Manager] No job listings under [jobs]Any specific logs I should look into?
I’m still somewhat new to WordPress.Running into similar issues with two other plugins and they all seem to point into the direction of PostgreSQL.
I even just migrated the Bitnami WordPress stack from MySQL to PostgreSQL and it leads to the same issues, again.
Will do some more debugging (after finding out which logs are the key) but if it turns out to be indeed the DB, I’ll probably have to get used to MySQL (I want to use this inside a production environment, so applying workarounds to half a dozen plugins might be a bad idea). Thankfully, I recently found MyWebSQL, so while I’m still missing out on a solid procedural language (PL/pgsql), I at least won’t have to deal with phpmyadmin (AKA the bane of my existence).
Forum: Plugins
In reply to: [WP Job Manager] No job listings under [jobs]I just created a MySQL based WordPress blog and, strangely, it works there.
Not sure if it’s just a coincidence or perhaps a database issue, after all.