From: George C. <ga...@sp...> - 2004-09-09 02:36:11
|
Hi, I just did a clean install onto a new system from CVS tag T_2_5_0_24. No local customization done at all. Install appeared to go okay, but I'm seeing a few issues with the system. Is 2_5_0_24 a reasonable tag to try, or should I go with an older 2_5 tag? First error: [Thu Sep 9 02:00:48 2004] [error] /admin.pl:Slash::DB::MySQL:/usr/lib/perl5/site_perl/5.8.4/i686-linux-thread-multi/Slash/DB/MySQL.pm:1354:DB='wapav' -- hostinfo='Loc alhost via UNIX socket' -- Unknown column 'content_type' in 'where clause' -- SELECT extras_textname, extras_keyword, type FROM topic_nexus_extras WHERE tid = '1' AND content_type = 'story' I got past this by running the following from the mysql/updates file: ALTER TABLE topic_nexus_extras add column content_type enum("story","comment") DEFAULT 'story' NOT NULL; So it appears as though some of the upgrades have not made it into the initial database setup. 2) When I tried to submit a story, I get a foreign key error. Here is the report from innodb. ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 040909 2:14:35 Transaction: TRANSACTION 0 6125, ACTIVE 0 sec, process no 19024, OS thread id 6619148 inserting, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320, undo log entries 1 MySQL thread id 395, query id 10354 localhost slashuser update INSERT INTO submissions (uid,story,ipid,tid,subj,email,signature,time,primaryskid,subnetid) VALUES( '2', 'Here is the scoop, for what tis worth.', '059a8c05fd9067b0ffd148426cc37059', '5', 'This is a test subject submission', 'mailto:te...@sp...', 'cef509a0b8f8166fae752a7ac2c2f Foreign key constraint fails for table `slashdb/submissions`: , CONSTRAINT `submissions_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `users` (`uid`) Trying to add to index `uid` tuple: DATA TUPLE: 2 fields; 0: len 3; hex 000002; asc ;; 1: len 3; hex 000001; asc ;; But the parent table `slashdb/users` does not currently exist! And when I visit "New Story" page to create a story, the following errors are logged: [Thu Sep 9 02:22:43 2004] [error] /admin.pl:Slash::DB::MySQL:/usr/lib/perl5/site_perl/5.8.4/i686-linux-thread-multi/Slash/DB/MySQL.pm:8765:DB='wapav' -- hostinfo='Localhost via UNIX socket' -- 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 '' at line 1 -- SELECT *, 0 AS is_future FROM stories WHERE stoid= [Thu Sep 9 02:22:43 2004] [error] Which was called by:Apache::ROOTwww_2eworcesterapa_2eorg::admin_2epl:/usr/local/slash/site/www.worcesterapa.org/htdocs/admin.pl:1172:DB='wapav' -- hostinfo='Localhost via UNIX socket' -- 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 '' at line 1 -- SELECT *, 0 AS is_future FROM stories WHERE stoid= \n [Thu Sep 9 02:22:43 2004] [error] /admin.pl:Slash::DB::MySQL:/usr/lib/perl5/site_perl/5.8.4/i686-linux-thread-multi/Slash/DB/MySQL.pm:9836:cannot getSkin for empty skid [Thu Sep 9 02:22:43 2004] [error] Which was called by:Apache::ROOTwww_2eworcesterapa_2eorg::admin_2epl:/usr/local/slash/site/www.worcesterapa.org/htdocs/admin.pl:1549:cannot getSkin for empty skid\n [Thu Sep 9 02:22:43 2004] [error] [client 192.168.1.19] File does not exist: /usr/local/slash/site/www.worcesterapa.org/htdocs/admin-topic-popup.css [Thu Sep 9 02:22:43 2004] [error] [client 192.168.1.19] File does not exist: /usr/local/slash/site/www.worcesterapa.org/htdocs/admin-topic-popup.js |