New category added, category became parent for all

[neostar]

Hi,
I've got a strange problem. I've exported a s9y database with drop tables, and add auto increment. The import via phpmyadmin to my live website went fine.

I've created a new category and now this category is parent for all other categories. If I try to change the parent category for each of the categories manually, the browser just goes blank after 30 seconds.

When I return to the admin interface nothing has changed. I can't create new categories either after this incident.

The database was created with S9Y version 1.01 and the same version on the server. I've upgraded now to S9Y 1.04, just in case that it had been a bug.

Software used:
Apache API Version 20020903
PHP Version 4.3.10-18
mySQL Version 4.0.24

[garvinhicking]

Hi!

That sounds as if the parent_ids of your serendipity_category table got mangled somehow.

Compare the current table with the one of your SQL export, what is the difference?

Regards,
Garvin

[neostar]

Ok, I'm a bit lost on this one. As it seems a lot of the database settings didn't get transferred the auto_increment value is one of them, also the charset. Even though I think I checked the right boxes.

So it's quite obvious why it's not working as planned. What would be the steps to make sure the mySQL database can be transferred as close as possible to the original database? The mySQL version on my development system is 4.1.

[garvinhicking]

Hi!

MySQL 4.0 has no charsets for tables, so there is nothing to import there...

You should use a recent phpMyAdmin version and then export with all settings checked?

Regards,
Garvin

[neostar]

Well I checked all boxes, the auto_increment value doesn't get transferred. It seems I have mySQL 5 on my development system (was mislead by the phpinfo()).

My solution now is to check all tables by hand to see where the auto_increment value is missing. The other values don't seem to matter to keep S9Y working.

Adding categories is now working again. Thanks for your help Garvin!