Date: 07/26/05 (PHP Community)    Keywords: php, programming, software, database, sql, postgresql, web

Having recruited a small army to help me code, I've been trying to sort out a distributed development system. The only problem with this is the fact that I can't find a system that caters for what I need, and building one from scratch is a minor ballache (not to mention was taking far too long - that was my original tactic).

Basically, I need web software that does the following: Bug tracking, project and task management, static content, project and general discussion, SCM/version control (CVS/SVN preferably, SVN looks nicer, either can be installed as needed).

In real terms, I need something to be able to hand out documentation on the web, throw projects up that people can choose to take on, a bug tracking system (for obvious reasons), somewhere to talk about the projects and in general, and manage code. We've looked at GForge - it's nice, but requires PostgreSQL, and I don't have time to rewrite it into ADODB. Combining that with a wiki (or something similar) plus discussion board would probably fit it beautifully, but again, it'd also mean rewriting the login systems and integrating them - which would be a pain in the neck for two seperate database systems. Tried TUTOS, but it's unrefined, and missing many of the things we need - it's more resource and personnel planning. Flyspray is good for tracking bugs, and MediaWiki is good for static code. phpBB of course is an excellent piece of forum software. But none of them actually fit together. Writing a system to combine them is possible, but expensive in terms of time, as I said earlier.

I can't find anything that seems to fit the bill. I could write one, but it takes far too long, especially with a one-man programming team.

Is there anything that anyone knows of out there that may fit the bill? Either that, or it's going to be a long few days coding for me :-/

(X-posted to my own journal, and a couple of communities.)

Source: http://www.livejournal.com/community/php/325046.html

Date: 07/26/05 (Algorithms)    Keywords: php, mysql, sql, java

Сабж.Для создание многопользовательской игры на flash.
Труд будем оплачивать. Можно удалённо. Знание Java и Php. Также очень желательно MySQL.

Source: http://www.livejournal.com/community/algorithms/61549.html

Date: 07/28/05 (PHP Community)    Keywords: mysql, sql

how can i get the date range for the current week, from sunday to saturday? i.e., this week would be 24-30. i've tried playing around with a the date function but can't figure out how to do this. a mysql query would be ok, too.

Source: http://www.livejournal.com/community/php/325885.html

Date: 07/29/05 (MySQL Communtiy)    Keywords: mysql, sql, web, google

I am trying to execute a delete using a subquery but I keep getting the same error and google and mysql.com are both no use as to what the error actually means

My query is this

delete from exon where exon_id in(select exon.exon_id from exon left join exon_transcript on exon.exon_id = exon_transcript.exon_id where exon_transcript.exon_id is NULL);


and this is the error

ERROR 1093 (HY000): You can't specify target table 'exon' for update in FROM clause

do you have any ideas what I am doing wrong?

exon_transcript is a table which links the exon table with another table called transcript and there were a series of rows missing from exon transcript so the links weren't present

I have been able to use other methods to delete the links from transcript but I can't see any other way of deleting the links from exon

if you want to see the schema description have a look here

http://cvsweb.sanger.ac.uk/cgi-bin/cvsweb.cgi/ensembl/sql/table.sql?rev=1.229&view=log

I am using this version of mysql

mysql Ver 14.7 Distrib 4.1.12, for dec-osf5.1b (alphaev68) using readline 4.3

thanks

Source: http://www.livejournal.com/community/mysql/64885.html

Date: 07/30/05 (Web Development)    Keywords: php, mysql, sql, web

About a week ago I made a post asking for references on PHP because I had just interviewed for a job at a web design firm and my lack of PHP knowledge was one of the things holding me down. Well, like I said, I spent all weekend studying PHP (thanks for all the references everyone!) and tearing apart existing PHP scripts until I was able to write my own scripts without using any reference. By Tuesday I had written a blog system using PHP and MySQL (complete with login authentication using sessions, add, edit and delete entries, and add or remove posters on the system, plus much much more...which, I'm pretty sure you would agree is a pretty easy task, but having only started learning PHP three days prior, I'm quite proud of myself).

Anyway, I went in for the second interview on Wednesday this week and showed them what I had accomplished over the four days between interviews.

This morning I got a call from them offering the job to me :o) I start on the 15th.

Anyway, I just wanted to thank everyone for hooking me up with the PHP references.

Source: http://www.livejournal.com/community/webdev/228601.html

Date: 07/30/05 (WebDesign)    Keywords: php, mysql, sql, web

About a week ago I made a post asking for references on PHP because I had just interviewed for a job at a web design firm and my lack of PHP knowledge was one of the things holding me down. Well, like I said, I spent all weekend studying PHP (thanks for all the references everyone!) and tearing apart existing PHP scripts until I was able to write my own scripts without using any reference. By Tuesday I had written a blog system using PHP and MySQL (complete with login authentication using sessions, add, edit and delete entries, and add or remove posters on the system, plus much much more...which, I'm pretty sure you would agree is a pretty easy task, but having only started learning PHP three days prior, I'm quite proud of myself).

Anyway, I went in for the second interview on Wednesday this week and showed them what I had accomplished over the four days between interviews.

This morning I got a call from them offering the job to me :o) I start on the 15th.

Anyway, I just wanted to thank everyone for hooking me up with the PHP references.

Source: http://www.livejournal.com/community/webdesign/942191.html

Date: 07/31/05 (Computer Geeks)    Keywords: php, programming, software, css, html, xml, database, asp, sql, java, security, web

A few weeks ago, I asked about programming languages and which I should learn, and your reaction had me thinking that I could have offered more info about what I hoped to do with computers. My request was so vague that I can see why you found it difficult to reply. Perhaps this time I'll do better. To make things easier, I'm providing a list of what I want to do, and I ask you if you know what languages or applications I should consider in order to fulfill my technological goals. I'd like to: build web pages provide internet security for large & small clients make computer games build my own OS from scratch (a big task, I know) create, edit, download, and manipulate multi-media images and files develop application software build and manage my own server develop databases get a general feel for everything else, in case I ever need it So my current list of stuff I wish to learn now includes: Java Java Script Perl C, C+, & C++ PHP SQL CSS HTML XML Adobe Photoshop Adobe Illustrator Flash & Dreamweaver .Net (VB.net, ASP.net, C#) CGI If you know anything about the above, feel free to post: What are each of the above used for? How did it come out? Are any of them similar or used for similar tasks? Etc., etc., etc. Finally, I was told to learn some Assembly language, but unless I am mistaken, I think I learned that already. If someone could give me a rundown on what it is, I could be sure if its what I think it is. I think I learned 8086 in my day (came with a card, too), so all I have to do is review it I think. Your help and suggestions are welcome and I thank you in advance for your time.

Source: http://www.livejournal.com/community/computergeeks/740093.html

Date: 08/02/05 (C Sharp)    Keywords: mysql, sql

I am nearly done with a DB Tool for C# and MySQL. Please See My Entry for more details...

Source: http://www.livejournal.com/community/csharp/32384.html

Date: 08/05/05 (Web Development)    Keywords: php, mysql, css, xml, sql, java

ILoveJackDaniels.com has some really great cheat sheets that you may find handy.



He just added some javascript cheats which includes XMLHTTPRequest cheats, function cheats, etc.

http://www.ilovejackdaniels.com/cheat-sheets/

He has Javascript cheats, PHP cheats, RGB Hex Color chart, mySQL, CSS, mod_rewrite, regular expressions and others.

x-posted to itprofessionals.

Source: http://www.livejournal.com/community/webdev/231417.html

Date: 08/05/05 (IT Professionals)    Keywords: php, mysql, css, xml, sql, java, web

ILoveJackDaniels.com has some really great cheat sheets that you may find handy.



He just added some javascript cheats which includes XMLHTTPRequest cheats, function cheats, etc.

http://www.ilovejackdaniels.com/cheat-sheets/

He has Javascript cheats, PHP cheats, RGB Hex Color chart, mySQL, CSS, mod_rewrite, regular expressions and others.

x-posted to webdev.

ps. Are any of you from the Bay Area?

Source: http://www.livejournal.com/community/itprofessionals/16669.html

Date: 08/05/05 (MySQL Communtiy)    Keywords: php, mysql, sql, web, apache

hey guys, me again -

i've got mysql 4.1.13a-nt running on win xp pro (apache and php4 as well, shouldn't be relevant tho) and I'm trying to set up and use InnoDB (for the foreign keys) - whenever I make a new table in EMS MySQL Manager or through the command-line utility and try to set it as InnoDB, when the table appears, it's always MyISAM

I'm sure my MySQL Manager version supports InnoDB since it works when I create an InnoDB table on my webhost, it's only not working locally

I did the InnoDB config on install of MySQL - is there anything else I have to set or enable to use InnoDB?

Source: http://www.livejournal.com/community/mysql/65658.html

Date: 08/09/05 (PHP Community)    Keywords: php, database, sql, web

Thought I'd share this with the community. I'll be writing a real walkthrough soon, as this combo is too good to keep to myself.
Would love to hear any comments, criticisms, or alternatives. If anyone is interested in helping write a few pages on the topic, send me an email or something too.


What do you get when you combine an automated database object abstraction layer, an embedded templating engine, and an AJAX library?

Unparalled rapid modular development fusing the web's hottest technologies.
And it's easy.

PEAR DB_DataObject
PHP Smarty
xajax

What's it look like? Here's a teenie example.

index.php

	
		printJavascript(); ?>
		
	
	
		

			
ID: 
			

		
		

	

addAssign("content","innerHTML", $v->getNote($id));

	return $objResponse->getXML();
}

$xajax = new xajax();

$xajax->registerFunction("getNote");
$xajax->processRequests();
?>

template_dir = 'tpl/';
		$this->compile_dir = 'tpl/comp';
		$this->config_dir = 'tpl/conf';
		$this->cache_dir = 'tpl/cache';
	}

	function getNote($id = null) {
		$note = DB_DataObject::Factory('notes');
		$note->get($id);
		$this->assign('note', $note);
		return $this->fetch('note.tpl');
	}
}
?>

	

		
{$note->name}
	
	

		
{$note->body}
	

CREATE DATABASE organizer;
USE organizer;

CREATE TABLE notes (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT,
	name VARCHAR(32),
	body TEXT,
	PRIMARY KEY(id)
);

Source: http://www.livejournal.com/community/php/333380.html

Date: 08/11/05 (Web Development)    Keywords: php, mysql, sql

I posted in php but no one has given me help yet. I'm x-posting here in hopes there is someone in here that isn't in php that can help me. Here's my question.

Uh... Is it possible to insert some sort of php echo to display descriptions under a picture?

It's not the same as exif_read_data, because these pictures are my scanned artwork images, not photographs. I have been searching for some sort of script or explanation on how to do this, but can't find it so I'm asking here.

This is the page in question:
http://www.luckycatstudio.com/galleries/World/index.php

The six thumbnails at the top, are scripted in JS for onClick action, on a php page (for php includes and date functions), to load the full sized image below the row of thumbnails. I want to add an area under each full-sized picture that will display a description of what the picture is about each time a picture is clicked on. I'm thinking something in php's echo function. But how would it get the description of the image if not an exif? Save the description in separate individual files? Embed the description in the image in my Photoshop 7's File Info option? Or iPhoto? Use MySql?

Anyway, I'm fairly sure that there are better PHP codes for onClick loading and displaying full-size images with their descriptions.

If anyone can help me, I'd greatly appreciate it.

Thanks.

Source: http://www.livejournal.com/community/webdev/233503.html

Date: 08/11/05 (PHP Community)    Keywords: php, mysql, sql

Uh... Is it possible to insert some sort of php echo to display descriptions under a picture?

It's not the same as exif_read_data, because these pictures are my scanned artwork images, not photographs. I have been searching for some sort of script or explanation on how to do this, but can't find it so I'm asking here.

This is the page in question:
http://www.luckycatstudio.com/galleries/World/index.php

The six thumbnails at the top, are scripted in JS for onClick action, on a php page (for php includes and date functions), to load the full sized image below the row of thumbnails. I want to add an area under each full-sized picture that will display a description of what the picture is about each time a picture is clicked on. I'm thinking something in php's echo function. But how would it get the description of the image if not an exif? Save the description in separate individual files? Embed the description in the image in my Photoshop 7's File Info option? Or iPhoto? Use MySql?

Anyway, I'm fairly sure that there are better PHP codes for onClick loading and displaying full-size images with their descriptions.

If anyone can help me, I'd greatly appreciate it.

Thanks.

Source: http://www.livejournal.com/community/php/334132.html

Date: 08/12/05 (Asp Dot Net)    Keywords: sql, microsoft

gotta love it when you research a weird error you're getting and microsoft says this.

SYMPTOMS
When you use the Microsoft Visual Studio .NET debugger to debug an ActiveX Data Objects (ADO) application that contains Transact-SQL code, you may receive the following error message:
System.Data.SqlClient.SqlException: General network error. Check your network documentation.
You may notice this behavior when you restart Microsoft SQL Server while debugging the ADO application.
Back to the top Back to the top

STATUS
This behavior is by design.

...

BY DESIGN?

ok, microsoft. you win today. :|

anyways, on a related but not so related note.. our middle tier component that handles data connections started giving us the infamous "General network error. Check your network documentation." upon an executenonquery call on a stored procedure after we applied service pack 4 on SQL Server. anyone know why oh why SP4 is doing this?

please enlighten while i sniff out the chatter on the .NET boards.

xposted to sqlserver and csharp

Source: http://www.livejournal.com/community/aspdotnet/39907.html

Date: 08/12/05 (SQL Server)    Keywords: asp, sql, microsoft

gotta love it when you research a weird error you're getting and microsoft says this.

SYMPTOMS
When you use the Microsoft Visual Studio .NET debugger to debug an ActiveX Data Objects (ADO) application that contains Transact-SQL code, you may receive the following error message:
System.Data.SqlClient.SqlException: General network error. Check your network documentation.
You may notice this behavior when you restart Microsoft SQL Server while debugging the ADO application.
Back to the top Back to the top

STATUS
This behavior is by design.

...

BY DESIGN?

ok, microsoft. you win today. :|

anyways, on a related but not so related note.. our middle tier component that handles data connections started giving us the infamous "General network error. Check your network documentation." upon an executenonquery call on a stored procedure after we applied service pack 4 on SQL Server. anyone know why oh why SP4 is doing this?

please enlighten while i sniff out the chatter on the .NET boards.

xposted to aspdotnet and csharp

Source: http://www.livejournal.com/community/sqlserver/30271.html

Date: 08/12/05 (C Sharp)    Keywords: asp, sql, microsoft

gotta love it when you research a weird error you're getting and microsoft says this.

SYMPTOMS
When you use the Microsoft Visual Studio .NET debugger to debug an ActiveX Data Objects (ADO) application that contains Transact-SQL code, you may receive the following error message:
System.Data.SqlClient.SqlException: General network error. Check your network documentation.
You may notice this behavior when you restart Microsoft SQL Server while debugging the ADO application.
Back to the top Back to the top

STATUS
This behavior is by design.

...

BY DESIGN?

ok, microsoft. you win today. :|

anyways, on a related but not so related note.. our middle tier component that handles data connections started giving us the infamous "General network error. Check your network documentation." upon an executenonquery call on a stored procedure after we applied service pack 4 on SQL Server. anyone know why oh why SP4 is doing this?

please enlighten while i sniff out the chatter on the .NET boards.

xposted to sqlserver and aspdotnet

Source: http://www.livejournal.com/community/csharp/32809.html

Date: 08/13/05 (PHP Community)    Keywords: php, mysql, database, sql, web

[Error: Irreparable invalid markup ('') in entry. Owner must fix manually. Raw contents below.]