PHP-OpenID server is not working , blank page is coming while using it from other sites

[Kushal Das]

On Tuesday 29 January 2008 11:26:54 am Jonathan Daugherty wrote:
> Which association store are you using?  I've seen problems with some
> MySQL versions due to a bug in index creation that prevents the
> required tables from being created.  You might need to look for
> failing queries in your database statement log, and you'll need to
> turn on statement logging if it's not on by default.
Just found only few of the tables are actually being created

# accounts
# oid_associations
# oid_nonces
# oid_settings
# personas
# personas_id_seq

Except the above six tables none other tables are being created :(
From the mysql log file I can see queries like:

141 Init DB     php_openid_server
                    141 Query       CREATE TABLE identities (id INTEGER 
AUTO_INCREMENT NOT NULL PRIMARY KEY, account VARCHAR(255) NOT NULL, url TEXT 
NOT NULL, UNIQUE (account, url(255)))
142 Init DB     php_openid_server
                    142 Query       CREATE TABLE sites (account VARCHAR(255) 
NOT NULL, trust_root TEXT, trusted BOOLEAN, UNIQUE (account, 
trust_root(255)))
                    142 Quit


But the tables are not in the database.

Kushal
-- 
Fedora Ambassador, India
http://kushaldas.in
http://dgplug.org (Linux User Group of Durgapur)