corbeeresearch

Nevermind it's now working

Hi, I'm trying to theme dynamically, but I can't seem to get to fit the sidebars and content to be aligned with each other. What am I doing wrong? here is my code. css #content-wrapper{ width: 922; background-color: #FFFFFF; } /* Content */ #content { /*float: left; color: #333; font-size: 14px; background: #FFF; margin: 0px 0px 0px 0px; padding: 10px; height: auto; width: auto; */ display:inline; float:left; position:relative; text-align:left; } /* sidebar */ #leftcolumn{ /* color: #333; margin: 0px 0px 0px 0px; padding: 10px; height: auto; width: 150px; font-size:11px; */ float: left; border-right: 1px solid #000; background: #FFF; display:inline; position:relative; } #rightcolumn { /* color: #333; margin: 0px 0px 0px 0px; padding: 10px; height: auto; width: 150px; font-size:11px; */ float: left; border-left: 1px solid #000; background: #FFF; display:inline; position:relative; } html <div id="content-wrapper"> <?php if ($page['sidebar_first']): ?> <div id="leftcolumn"><div class="section"> <?php print render($page['sidebar_first']); ?> </div></div> <?php endif; ?> <div id="content" class="column"><div class="section"> <?php if ($breadcrumb): ?> <div id="breadcrumb"><?php print $breadcrumb; ?></div> <?php endif; ?> <?php print render($title_prefix); ?> <?php if ($title): ?> <h1 class="title" id="page-title"> <?php print $title; ?> </h1> <?php endif; ?> <?php print render($title_suffix); ?> <?php if ($tabs): ?> <div class="tabs"> <?php print render($tabs); ?> </div> <?php endif; ?> <?php if ($action_links): ?> <ul class="action-links"> <?php print render($action_links); ?> </ul> <?php endif; ?> <?php print render($page['content']); ?> <?php print $feed_icons; ?> </div></div> <?php if ($page['sidebar_second']): ?> <div id="rightcolumn"><div class="section"> ?php print render($page['sidebar_second']); ?> </div></div> <?php endif; ?> <span> </span><br/> </div>

Hi, After successfully creating a cron job that runs a php script to update the database. I thought everything was okay until I saw that outside public_html there are LOTS of duplicates of cron.php.n Where n are numbers. I suspect cron jobs are causing these. Does anyone knows why this is happening? and Is there something I could do to stop the system from generating something like this? I also a lot of dbn.sdb I'm not sure if this is related too.

Nevermind, I did it again from scratch and it appears to work

Hi This part of code `FK_user_project` FOREIGN KEY (`user_id`) REFERENCES `tbl_user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT; Won't work in the following code. CREATE TABLE IF NOT EXISTS `tbl_issue` ( `id` INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, `name` varchar(256) NOT NULL, `description` varchar(2000), `project_id` INTEGER, `type_id` INTEGER, `status_id` INTEGER, `owner_id` INTEGER, `requester_id` INTEGER, `create_time` DATETIME, `create_user_id` INTEGER, `update_time` DATETIME, `update_user_id` INTEGER ) ENGINE = InnoDB ; CREATE TABLE IF NOT EXISTS `tbl_user` ( `id` INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, `email` Varchar(256) NOT NULL, `username` Varchar(256), `password` Varchar(256), `last_login_time` Datetime, `create_time` DATETIME, `create_user_id` INTEGER, `update_time` DATETIME, `update_user_id` INTEGER ) ENGINE = InnoDB ; CREATE TABLE IF NOT EXISTS `tbl_project_user_assignment` ( `project_id` Int(11) NOT NULL, `user_id` Int(11) NOT NULL, `create_time` DATETIME, `create_user_id` INTEGER, `update_time` DATETIME, `update_user_id` INTEGER, PRIMARY KEY (`project_id`,`user_id`) ) ENGINE = InnoDB ; -- The Relationships ALTER TABLE `tbl_issue` ADD CONSTRAINT `FK_issue_project` FOREIGN KEY (`project_id`) REFERENCES `tbl_project` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT; ALTER TABLE `tbl_issue` ADD CONSTRAINT `FK_issue_owner` FOREIGN KEY (`owner_id`) REFERENCES `tbl_user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT; ALTER TABLE `tbl_issue` ADD CONSTRAINT `FK_issue_requester` FOREIGN KEY (`requester_id`) REFERENCES `tbl_user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT; ALTER TABLE `tbl_project_user_assignment` ADD CONSTRAINT `FK_project_user` FOREIGN KEY (`project_id`) REFERENCES `tbl_project` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT; ALTER TABLE `tbl_project_user_assignment` ADD CONSTRAINT `FK_user_project` FOREIGN KEY (`user_id`) REFERENCES `tbl_user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT; -- Insert some seed data so we can just begin using the database INSERT INTO `tbl_user` (`email`, `username`, `password`) VALUES ('[email protected]','Test_User_One', MD5('test1')), ('[email protected]','Test_User_Two', MD5('test2')) ; Where did I go wrong? Thanks

Actually two type of website first site is largely pure article information plus voting, contact form, flash movie, download of mp3's. The login is strictly for administrative purpose. expected numbers of visitors per day would be 15,000. 2nd site is a private social networking with something like project planning, journals, forums, and some sort of complicated journal that connects all other journals like a wiki. users would probably less than a hundred. In addition to this, if it at a distant future the first site reached millions of visits and the second site thousands of users, how large should I increase the ram and process power?

Hi, if ever I'm planning to build a typical web 2.0 php website. How much RAM should I choose and how many processing power do I need? Thanks