Posted by Merlin on Fri Oct 20, 2006 8:03 pm.
A few days ago I checked in a LiveJournal Crossposting module, based on the WordPress plugin of the same name. I’ve seen several people using it of late and I know people who’d like to run blog sites but want more power than WordPress will give them.
I’m looking for a few people to run it through its paces; I tested the basic functionality, but I haven’t had a lot of time for the project so I didn’t really push it too hard. If anybody wants to play with it, let me know how it goes, please.
Even people grabbing it and saying “Yup, works good” would be nice.


Error trying to install it
I get an error trying to install the module on what appears to be Drupal 4.7.2. Here's the error message I get (actual paths substituted with fake ones):
user warning: 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 'custom_header longtext,site_name custom_header_format int,tags i query: CREATE TABLE ljxp ( uid int PRIMARY KEY,active int,host varchar(255),name varchar(255),pass varchar(255),community varchar(255),site_name varchar(255),site_name custom_header longtext,site_name custom_header_format int,tags int,privacy varchar(20),comments int,post_type varchar(20),cut_text varchar(255)); in /path/to/includes/database.mysql.inc on line 120.
---
BTW, on a slightly unrelated note, the first time I tried to preview my comment, it majorly complained at my webpage URL. After looking at it for a moment, copying it to firefox to make sure it was valid, I guessed that it didn't like the space at the end of it. And, sure enough, eliminating the space fixed the complaint. That, however, certainly seems to be a textbook definition of "broken". Just FYI.
Other information
Oh, other information that would be extremely relevant. I'm using MySQL 5.0.24a.
I think I found the problem.
Ok, I think I found the problem. This diff for ljxp.install seems to fix everything. I haven't tried out cross posting yet, though and now it's after midnight so that'll have to wait. :-)
--- ljxp.install~ 2006-10-18 21:55:21.000000000 -0400 +++ ljxp.install 2006-10-22 00:20:28.000000000 -0400 @@ -9,8 +9,8 @@ 'pass varchar(255),' . 'community varchar(255),' . 'site_name varchar(255),' . - 'site_name custom_header longtext,' . - 'site_name custom_header_format int,' . + 'custom_header longtext,' . + 'custom_header_format int,' . 'tags int,' . 'privacy varchar(20),' . 'comments int,' .Thanks. Yea that was
Thanks. Yea that was definitely an idiot mistake on my part. Sorry 'bout that.
Post new comment