Re: [WP-pg-devel] Problems with wordpress-pg 1.5 so far

[William A. C. <wil...@ca...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


On May 16, 2005, at 8:59 AM, Eric Hochberger wrote:

> First off I want to say how much I appreciate the work you're doing  
> to convert Wordpress to support Postgresql.  Very very much  
> appreciated.  Now for my bugs :

It's no small task.  Thanks from all of us for your encouragement.

> 1) During the install
>
> While running
> http://www.litique.com/wordpress/wp-admin/install.php?step=2
> I encountered...
> SQL/DB Error -- [ERROR: null value in column "link_rss" violates  
> not-null constraint]
> From this point on I get a lot of errors due to the transaction.
>
> Once I comment out the creation of the default links:
> /*
> $wpdb->query("INSERT INTO $wpdb->links (link_url, link_name,  
> link_category, link_rss) VALUES ('http://wordpress-pg.sf.net/',  
> 'WordPress-Pg', 1, NULL);");
> $wpdb->query("INSERT INTO $wpdb->links (link_url, link_name,  
> link_category, link_rss) VALUES ('http://codex.wordpress.org/',  
> 'WordPress Codex', 1, NULL);");
> $wpdb->query("INSERT INTO $wpdb->links (link_url, link_name,  
> link_category, link_rss) VALUES ('http://wordpress.org/support/',  
> 'WordPress Support Forums', 1, N\
> ULL);");
> $wpdb->query("INSERT INTO $wpdb->links (link_url, link_name,  
> link_category, link_rss) VALUES ('http://wordpress.org/',  
> 'WordPress-MySQL', 1, NULL);");
> */
> Things are peachy

Alright, that's probably my bad.  That's what I get for trying to  
enforce database coherency in this schema.  link_rss should probably  
be okay to be NULL.  If I was to venture a guess the WordPress-MySQL  
folks were using '' instead of NULL to denote that there wasn't  
anything there and they put a NOT NULL on it.  (Trivia: using ''  
instead of NULL will make Oracle sad too because it treats them the  
same from what I've heard.)

> 2) After the install I get the following error when attempting to run
> http://www.litique.com/wordpress/wp-admin/
> I encounter:
> Fatal error: Call to undefined function: __() in /var/sites/ 
> litique.com/htdocs/wordpress/wp-admin/index.php on line 3
>
> No solution to this bug yet.  If I comment out the require line  
> nothing appears on the screen.

Yeah.  They break the debugging output in several places so it's a  
real pain to try and figure out what code is actually breaking  
anything.  Most often the problem starts with a blank screen.  The  
debugging method here is to stick echo or print statements all over  
the place in the required file and see which ones get printed to  
determine where the code is bailing out.  This may help in tracking  
this down in a little more detail.  I will gladly acknowledge that  
it's pretty tedious work drilling down all those includes/requires...

- -- 
wac

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)

iD8DBQFCi/ZNyWl2oUGFZkwRAjacAJ986Uhed1hZzOIbTs6P2lhrxhRD0ACeMuM8
Nomb33TJjjyKPiYocXQOfwM=
=1nek
-----END PGP SIGNATURE-----