Last night I decided to start testing version 2 RC4 SuperServer on my
development webserver running winXP sp2, apache 2.0.52 and PHP5.1.4. After
installation and restart I manually replaced the instance of GDS32.DLL that
lives in the PHP5 directory, the only other copy of the lib other than the
one in system32. When I tested a website it seemed to be working OK except
that some of the manual plans I had specified caused errors now.

select coalesce( mc.catagory, 'Other') catagory, c.menucode, i.menuitem,
i.uniquelink, i.price, n.note, c.vegetarian, c.kosher, c.halal, c.health,
c.kids from menucode c inner join menuitems i on c.link = i.link and
i.deleted = 'N' left outer join meal_catagory mc on c.mealcatagory = mc.link
and mc.deleted = 'N' left outer join menunotes n on n.menucodelink = c.link
and n.deleted = 'N' where c.available = 'Y' and c.restlink = 'BEN0000059'
and c.deleted = 'N' PLAN SORT (JOIN (JOIN (C INDEX (I_MENUCODE_RESTLINK),I
INDEX (MENUITEMS_MENUCODELINK)),N INDEX (RDB$PRIMARY24))) order by 1,
c.menucode, i.menuitem, i.price

ibase_errmsg: table MEAL_CATAGORY is not referenced in plan

This works in 1.5.3 and is probably something I am doing wrong but it does
mean that the switch to v2 is going to be a lesson in standards compliance,
not necesarilly a bad thing.

I also got the following message in the web log:

INSERT INTO WEB_LOG( SESSIONID, CUSTOMERLINK, RECDATE, RECTIME, PAGENAME,
IP) VALUES
('3sgrdpipfuo9tu4tlb5emd15h6','',current_date,current_time,'browsemenus.php','163.195.192.74')

ibase_errmsg: internal gds software consistency check (invalid SEND request
(167), file: exe.cpp line: 494)

After that it got stuck in the 'internal gds software consistency check
(can't continue after bugcheck)' loop and required a restart.

The database is huge and I haven't gotten around to doing a backup/restore
yet meaning the database is still ODS 10.1, could this be a problem?

Gary