johnoz

Thanks whooami. Hmmm! strange name Google, I’ll try and remember it. BTW I have the search and replace plugin and it’s great, but it won’t do what I need.

There used to be some helpful MySQL folk here, but I guess they have moved on. My question may not strictly be about wp but it certainly relates to wp as it is the db that wp uses and interacts with — there’s even ‘MySQL’ support tags here ?? Nevertheless, I’ll stop bumping and try and find help elsewhere. Cheers!

bump

I us a package called MAMP on my Mac and login to MySQL using phpMyAdmin with these (default) settings

Host: localhost
[Port: 8889]
User: root
Password: root

Hope it helps

John

I have a heap of photos on my site and I’d like to mass replace the current alt=”” and title=”” with “wp-post title + some text”.

So far I haven’t been able to figure out the SQL syntax. I have successfully managed to delete the alt=”” and title=”” tags and all my post a number of time ??

Looking for some help please!

bump

Can anyone point me in the right direction?

bump

Try adding a ‘/’ after wp-admin
eg ‘https://www.yourblog/wordpress/wp-admin/’

Worked for me.

2. Look for this in header.php

<a href="<?php bloginfo('siteurl'); ?>/" title="Home">Home</a></code>

and change it to

<a href="https://yourmainwebsite.com/" title="Home">Home</a>

3. Duplicate or copy and paste the content of your theme’s index.php into another file and call it category.php –Place category.php in your theme folder. Done.

Don’t really understand what you want to do in #1 –sorry!

John

The Image Rotator is an easy way to make an image on your website change every time a visitor reloads the page. The Rotator picks a randomly selected image from a folder you specify and displays it to your visitors.

https://automaticlabs.com/products/rotator

For a local mac install try

define(‘DB_NAME’, ‘The name of the database’)
define(‘DB_USER’, ”)(leave empty)
define(‘DB_PASSWORD’, ”)(leave empty)
define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value

This works for me

I either turn permalinks to default or put /index.php/ in front of what I have eg if you have /%year%/%monthnum%/%postname%/ –locally it would become /index.php/%year%/%monthnum%/%postname%/

stuartj — for a local mac install try

define(‘DB_NAME’, ‘The name of the database’)
define(‘DB_USER’, ”)(leave empty)
define(‘DB_PASSWORD’, ”)(leave empty)
define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value

This works for me

I use a Mac and I use an FTP client to upload my photos. I export the size of photo I want from iPhoto to my desktop and then use Transmit (https://www.panic.com/transmit/) to upload to my WordPress folder. I used to use Cyberduck (https://cyberduck.ch/) which is opensource and free.

G’day Dinggus >>Well supposely this WP-ShortStat doesn’t work on the newest version of WordPress.

The updated version of WP-ShortStat at this site (blog.happyarts.de/wp-shortstat/) does work with WP2x — I have it running on 4 sites…