tim (kumokasumi) wrote in fotobilder,
tim
kumokasumi
fotobilder

  • Mood:
  • Music:

MySQL initialization

When installing FotoBilder from CVS, initializing the MySQL database failed, claiming it didn't know about a user field, until I commented out the line
do_alter("user", "ALTER TABLE user DROP INDEX user, DROP user");
from the end of bin/upgrading/update-db-general.pl, dropped and recreated the database, and ran the update-db script again. Is this stupid, or was the script in error? (Or both?)
Update: It looks like this is from verson 1.39 of update-db-general.pl. Should I manually drop the user field now?

I'm also having a bit of trouble with styles, but I haven't looked at it very hard and I'm pretty sure it's my fault, but who knows. Should the version in CVS be usable?

Update: Traced back the style problem to, of all things, a missing record in the useridlookup table. The problem was that it couldn't find the core style... the table was missing a record for the system user, so it couldn't look up any public styles at all, even.


mysql> select * from useridlookup;
+----------+-------+------+--------+
| domainid | ktype | kval | userid |
+----------+-------+------+--------+
|        0 | N     | mote |      2 |
+----------+-------+------+--------+
1 row in set (0.00 sec)

mysql> insert into useridlookup (domainid, ktype, kval, userid) values (0, 'N', 'system', 1);
Query OK, 1 row affected (0.01 sec)



Additionally, it would be nice if there were some way to pass across the short name of a gallery through the web API.

Update again: Are capabilities implemented anywhere, at all? It looks like if I'm using this on my own site, I can't take advantage of security levels without allowing people to host pictures on my site. This is Bad. ... And I would kill for EXIF support.
Subscribe

  • 302: lj_dev

    In the interests of consolidating all FotoBilder development-related discussion, we're going to be closing down this community. The same…

  • Development stalled?

    Is the development of Fotobilder held? Stalled? I am asking because there is no activity on the community and there is no link to the Fotobilder…

  • (no subject)

    Does FotoBilder works with Apache2? I installed all the required modules on my debian sarge, and when I restart my apache server, it dies horribly…

  • Post a new comment

    Error

    Comments allowed for members only

    Anonymous comments are disabled in this journal

    default userpic
  • 4 comments