lots of "Table 'yacs.yacs_???' doesn't exist" errors

Pietrzak Karl -- on Jul. 7 2006

Setup scripts does not do some things, and then I get lots of "Table 'yacs.yacs_dates' doesn't exist" errors.

Hey everyone!

You may remember me from not too long ago when I asked whether YACS would meet by needs. Well, I decided to give it a try and bumped into a few road blocks.

FYI, I'm starting from scratch (a blank MySQL database for YACS, etc.) using the latest release of YACS.

The biggest problem is that eventually the setup script takes me to http://vermicelli.bioinformatics.rit.edu/yacs/control/setup.php, wwhich is a blank page! Reloading it takes me to the same blank page.

I see the YACS created some rows in the database:


mysql> show tables;
+-------+
| Tables_in_yacs  |
+-----+
| yacs_actions    |
| yacs_articles   |
| yacs_categories |
| yacs_comments   |
| yacs_decisions  |
| yacs_files      |
| yacs_images     |
| yacs_links      |
| yacs_locations  |
| yacs_members    |
| yacs_sections   |
| yacs_tables     |
| yacs_users      |
+-------+
13 rows in set (0.00 sec)

mysql>

Did I do something wrong? This blank page is not encouraging.

Page bottom

Bernard from nearby-an-airport Associate, 6728 posts	on Jul. 7 2006 Thanks to information provided, I have been able to track this bug. MySQL5 has introduced new keywords, and, unfortunately, one has been used in the new modules for dates, which is aiming to support calendars. This will be fixed in next release. Your accurate feed-back has been helpful, thank you for that.
TheAlchemist 19 posts	on Jul. 8 2006 Bernard: Actually, I'm running MySQL 4.1.20, the default for Fedora Core 4, I believe. Does that change anything? Is there a quick workaround I can use? Thanks!
Bernard from nearby-an-airport Associate, 6728 posts	inspired from TheAlchemist on Jul. 8 2006 TheAlchemist: I you don't intend to use calendars yet, you can change the file `dates/dates.php` as follows: change line 921 to `$fields['date_stamp'] = "DATETIME";` change line 929 to `$indexes['INDEX date_stamp'] = "(date_stamp)";` And then launch the setup script again. Does this allows you to finalize the installation?
TheAlchemist 19 posts	on Jul. 8 2006 Thanks for the quick response, Bernard! No, actually, that did not allow me to finalize the installation. Actually, I could not exactly apply the changes you specified. I: changed line 921 from: `$fields['edit_date'] = "DATETIME";` ...to: `$fields['date_stamp'] = "DATETIME";` changed line 928 (line 929 is blank, so I'm guessing you meant 928) from: `$indexes['INDEX edit_date'] = "(edit_date)";` ...to: `$indexes['INDEX date_stamp'] = "(date_stamp)";` I still get the same situation: I get redirected to /yacs/control/setup.php, which is blank. Oh, BTW, I'm using I'm using 20060705_yacs_6.6.1.zip, PHP 5.0.4, MySQL 4.1.20, all on Fedora Core 5. Did I miss something? Thanks!
Bernard from nearby-an-airport Associate, 6728 posts	inspired from TheAlchemist on Jul. 8 2006 TheAlchemist: instead of changing lines related to 'edit_date', try to alter lines mentioning 'date'. 'Date' is the keyword reserved by MySQL.
TheAlchemist 19 posts	on Jul. 8 2006 Also, lots of other stuff brings me to a blank page. For example, if I go to /yacs/control/populate.php, and select some options and click 'Submit', I get a blank page. Is there anything else I can do to help debug this?
Bernard from nearby-an-airport Associate, 6728 posts	inspired from TheAlchemist on Jul. 8 2006 TheAlchemist: Yeap, can you test the nightly build of YACS prepared tonight? Several files have been updated. Thank you for your feed-back.
TheAlchemist 19 posts	on Jul. 8 2006 FIXED! I'm so sorry for the trouble, Bernard. It turns out I was reaching the PHP memory limit of 8MB. I decided to check out the Apache logs when I discovered this. Changing php.ini. If you're ever in upstate NY, let me know. I owe you a beer.
Bernard from nearby-an-airport Associate, 6728 posts	inspired from TheAlchemist on Jul. 10 2006 TheAlchemist: Sorry, I have to visit San Francisco first... It happens we will visit natural parks for next two weeks in family... Glad to see it working properly. We will take the beer when you will come in France

9 comments

Rate this page
Posted by TheAlchemist on Jul. 7 2006, edited by Bernard on Jul. 7 2006, (popular)