Skip to main content.

Testing Croissanga Xanga cross-poster

April 15th, 2006

I have been testing the Croissanga cross-poster for posting WordPress articles to Xanga. It seems to work perfectly, and does not create a duplicate when you edit a post as the Xanga Crossposter does. If you delete your WordPress post, the plugin will delete the Xanga cross-post as well.

The only trick to installing it is that you have to manually create a table in the SQL database. My host is Bluehost.com, and they provide phpMyAdmin in the control panel. So adding the table is simple. Here’s how to do it:

  1. Go into phpMyAdmin and open the database for your WordPress installation. You do this by selecting the appropriate database from the drop down box on the left side. If you installed WordPress via Fantastico, it is probably named something like _wpdp1.
  2. In the database, select the SQL tab at the top of the page.
  3. Go to the file named croissanga.sql that came with the plugin. Open it up and copy out the CREATE TABLE command (you can omit the two comment lines starting with “–“). The command is on several lines, so be sure not to leave anything out.
  4. Go to the “Run SQL Query” box and clear out whatever is in there, then paste the CREATE TABLE command in there, then click on “Go.”
  5. If everything works correctly, you should see a message saying that the table has been created

That’s the only tricky part. Now you just need to open up the file croissanga.php and put in your Xanga user name and password in the place indicated near the top of the file. Then just upload the file and activate the plugin.

Posted by Ken in Wordpress

7 Responses to “Testing Croissanga Xanga cross-poster”

  1. Kathy says:

    Thanks for these instructions. They rescued me from hours of frustration!

  2. Ken says:

    I’m glad that they were helpful!

    Your site does not display correctly in Firefox. The title in the sidebar comes out on top of the menu. (I just thought you would want to know.)

  3. Serving Bread » Double Posting says:

    […] I found this cool new plugin that allows me to post simultaneously on http://www.servingbread.net and on http://www.xanga.com/EddyE (yes, I have a xanga account). This is useful to be connected to blogrings on the popular xanga site, but to route it all through my own website. Get the croissanga plugin and make sure to follow these instructions. Filed under: Nerdy by Eddy E | […]

  4. sputnik says:

    Ken, thanks for posting this. I got the tables created with no problem. However, when I tried publishing a post, I got errors saying the table “databaseName.xanga_wp_post_map” does not exist. I didn’t change anything in the plugin except to enter my Xanga user details. I’m running WordPress 2.0.4 and Croissanga 1.2.9.

    I realize you’re not the plugin’s author, but perhaps you can help me.

  5. Ken says:

    Are you sure that you created the table in the right database? I ask because I have move than one install of WordPress on my server. I use a separate one for testing.

    You could go into phpMyAdmin and open your WordPress database. Verify that there really is a table called xanga_wp_post_map.

    My Croissanga version is 1.2.7, but I don’t see why that should matter unless the new version has a bug. Does your error message include any other information?

  6. sputnik says:

    Funny thing, even though it said the table didn’t exist, the plugin was still posting to my Xanga account. Anyway, I’ve just figured out what the problem was: My server recently upgraded to mySQL 5. I’d already converted the database but, unfortunately, didn’t realize “localhost” still pointed to my mySQL 4. I converted the old database again and changed the host setting in “wp-config.php” and everything seems to be working now.

  7. Ken says:

    I’m glad you found the problem.