Categories and comments not working after moving pligg to a new site

[SanDiego]

I installed pligg successfully at my webserver (1and1). However since it is very slow I'd like to move it to another server. I exported the database in SQL format and imported it at my local database. I updated libs/dbconnect.php and settings.php script with the new information. I also changed the database so that "Location Installed" to point to correct URL and base directory.

The site works fine but my categories are not showing up. When I try to admin the categories none is listed. Also I see the latest comments on the side bar but when I click on them none is displayed on the story page. I checked a lot of stories and none of them had the comments.

I checked the database using phpmyadmin, categories & comments are there. Link IDs seem to be correct. I also removed the contents of templates_c directory.

Does anybody have any idea what I might have missed?

[kbeeveer46]

in phpmyadmin, change the category__auto_id of the "All" category to 0

[SanDiego]

Originally Posted by kbeeveer46

in phpmyadmin, change the category__auto_id of the "All" category to 0

Thank you very much, category problem is resolved by changing it. :) However I still can't see the comments. They're not displayed at the bottom of the stories.

[SanDiego]

Originally Posted by SanDiego

Thank you very much, category problem is resolved by changing it. :) However I still can't see the comments. They're not displayed at the bottom of the stories.

After some further investigation I realized that javascripts are giving error. That's why the comments were not working. I can't modify the 'configure section' either because of the same problem. Firebug complains that there are illegal characters in

prototype.js.gz (line 1)
EditInPlace.js.gz (line 1)
scriptaculous.js (line 1)
dragdrop.js.gz (line 1)
admin_config.php (line 128)

I'm still not very familiar with the code but I have a feeling that Configure -> Misc -> Enable Gzip File Compression might be reason (I enabled it), and I can't revert it back from the admin menu since admin menu does not work without them.

It works fine at the first website though. I'll keep you posted. Please let me know if you have a any idea.

Thanks....

[kbeeveer46]

Disable gzip through your config table in your database. Look for the row that says "enable gzip" or something like that and edit it back to false.

[SanDiego]

I couldn't find the "enable gzip" option. Instead before backing up the database I set it to false in the admin menu. Everything works fine so far.

I'd like to summarize how I migrated from one webserver to another for future reference:

SOURCE WEBSERVER

- Disable compression (Admin -> Configure -> Misc -> Compression)
- Go to "phpmyadmin" and export database (Unfortunately I couldn't make the Pligg's backed up SQL files to work, see my question on this: #1062 - Duplicate entry '1' for key 1 who can help me?)
- Admin -> Backup -> Files & Avatars

DESTINATION
- Unzip files & avatars in the destination directory
- chmod directories according to installation README.txt
- Modify libs/dbconnect.php & settings.php
- Open the destination "phpmyadmin" and import the database. Special characters caused some problem so I chose latin1 as the character set.
- Modify "Location installed" in "configure" row with URL & directory (don't forget to add /, e.g. "/pligg" not "pligg"
- Modify first entry to 0 for "all" in "categories" row
- You can enable compression now if you want.