cookiedude

I used to do a bit of mysql as part of my job training, so I’m kind of familiar with what I need to do, it’s just I wasn’t sure of the date syntax for mysql anymore ??

Ah thanks. Found out that setting export compatibility to “MYSQL40” also did the trick and imported the database just fine. Unfortunately I do use “unusual symbols”, the special characters from the German alphabet. I’ve read that I need to set the character encoding to latin1 when importing in phpMyAdmin, but I don’t have that option. Are there any tools that will let me convert the character encoding of the SQL dump? I tried Notepad++, but that doesn’t have the options I need, I can only convert from UTF-8 to ANSI etc.

I get nearly the same error. Only in my scenario it says:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate utf8_unicode_ci NOT NULL default '',category_nicen</code>

And also, the import stops at this point (according to phpMyAdmin):
CREATE TABLE wp_categories (
cat_ID bigint( 20 ) NOT NULL AUTO_INCREMENT ,
cat_name varchar( 55 ) COLLATE utf8_unicode_ci NOT NULL default ”,
category_nicename varchar( 200 ) COLLATE utf8_unicode_ci NOT NULL default ”,
category_description longtext COLLATE utf8_unicode_ci NOT NULL ,
category_parent int( 4 ) NOT NULL default ‘0’,
PRIMARY KEY ( cat_ID ) ,
KEY category_nicename ( category_nicename )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci AUTO_INCREMENT =15;`

Any idea what needs to be done? Thanks in advance for your help!

podz:
yeah, that helped. Now there’s only one minor thing I’d like to change. I get a bullet for the category names, which looks a bit daft. How do I remove those?
Something with the CSS?

edit: nevermind, i actually got the loop working in the end. Instead of get_links(-1), I simply put get_links($link_cat->cat_id) – and it works. yay me!

I installed this theme and found that none of my links (eg. to other blogs etc.) are showing up, everything else is working fine though. I’m afraid to mess around with the PHP files, as I’m basically in the “hello world” stage of PHP.

[edit] Okay, I fiddled around a bit and found that basically all I need is <?php get_links_list(‘id’); ?>, however that puts bullets in front of the link categories. So now, all I need to know is how to get rid of these bullets. Anyone? ??

there is no blank space in the blacklist and it’s not working ??

And then? Leaving the blacklist empty is not going help a whole lot when I want to blacklist comments, is it? *desperate* (sorry if I sound a little cranky, but this is doing my head in)

Downloaded it. Will give it a go and let you know how it turns out ??
Should I email you feedback or reply to a certain thread?

I didn’t have then. Now I am using Kitten’s Spam Words, which worked well with 1.2 but now it only puts comments in moderation instead of deleting them. So I am currently at the mercy of the spammers again ??

the WP1.5 builtin blacklist also wipes out every comment regardless of whether they contain relevant phrases or not. I removed everything but IP addresses from my blacklist and still my own comments didn’t make it through and when I went through the wp_comments table I found a bunch of comments by other people that got caught (most likely by the blacklist) as well. And no, there was no white-space in my blacklist

heh, thanks. I eventually got there by playing around with phpMyAdmin for a while – and found some comments that were labelled spam even though they weren’t in the process ??

Hmm… ok then. I’ll have a go at setting up a permalink structure. I’ll blame you though if I can’t get it to work ??

No, I don’t. Where do I get it and what do I have to do? ??