Thread: [Phpsurveyor-developers] Release date for PHPSurveyor
The leading Open Source survey tool
Brought to you by:
c_schmitz
From: Carsten S. <car...@gm...> - 2007-02-21 22:32:39
|
Hi guys, The next phpsurveyor release will be on this Saturday, February 24th (night to Sunday) and the version number will 1.45a (alpha). So.. now its time to wrap up and make the last changes. Translators: Last chance to update your translation! Please remember to document all your new/modified features in the new Wiki on http://docs.phpsurveyor.org This version will be an alpha version (time for testing was very short) but there will be an ongoing effort to make it more stable with more releases following timely, depending on the users feedback. With getting more stable we will name it beta and then release candidate. Thank you for you help! Best regards Carsten |
From: Tom T. <tom...@he...> - 2007-02-22 06:52:45
|
Hi folks Just a wee note about string literals in table names. It looks like MySQL copes pretty well with statements like SELECT * FROM "phpsv_tokens"_85382 but MS SQL just chokes. It's not a big problem - it's only happened once so far and undoubtedly it was in the code before porting to SQL Server was ever an issue - but as it's done my head in today I feel the need to rant :) But seriously.. just bringing it to the group so everyone's aware of this subtle little difference between MySQL and SQL Server.=20 Cheers Tom |
From: Thibault Le M. <Thi...@su...> - 2007-02-22 09:33:30
|
Hi Tom, In rev 2377 save.php you wrote: //TODO: Special case for MS SQL Server, as the default value for = submitdate=20 // isn't appearing in schema for the table created in activate.php.=20 // This is a quick hack until I figure out what happened to the default value=20 Not sure it is this, but I had to patch your activate code in (rev: = 2291) because it broke mysql support. "DEF" was not recognized as a valid keyword for mysql and PRIMARY key = needed to be defined. See my patch: --- source/phpsurveyor/admin/activate.php 2007/02/09 11:56:15 2290 +++ source/phpsurveyor/admin/activate.php 2007/02/09 14:53:54 2291 @@ -249,9 +249,9 @@ else { //Create the survey responses table - $createsurvey =3D "id I NOTNULL AUTO,\n"; + $createsurvey =3D "id I NOTNULL AUTO PRIMARY,\n"; // --> START NEW FEATURE - SAVE - $createsurvey .=3D " submitdate T NOTNULL DEF '0000-00-00 00:00:00',\n"; + $createsurvey .=3D " submitdate T NOTNULL DEFAULT '0000-00-00 00:00:00',\n"; $createsurvey .=3D " startlanguage C(20) NOTNULL ,\n"; // --> END NEW FEATURE - SAVE //Check for any additional fields for this survey and create necessary fields (token and datestamp) |
From: Tom T. <tom...@he...> - 2007-02-23 01:00:41
|
DEF - if I'm reading the docs right - should just be a synonym for DEFAULT. I'm surprised that the ADOdb layer didn't convert it to the native keyword, but there you go. I'll have a play today and see it that fixes the problem at this end. In any case there is a work around. Cheers Tom=20 -----Original Message----- From: php...@li... [mailto:php...@li...] On Behalf Of Thibault Le Meur Sent: Thursday, 22 February 2007 8:03 PM To: php...@li... Subject: [Phpsurveyor-developers] activate.php and DEFAULT date for MSSQL Importance: High Hi Tom, In rev 2377 save.php you wrote: //TODO: Special case for MS SQL Server, as the default value for submitdate // isn't appearing in schema for the table created in activate.php.=20 // This is a quick hack until I figure out what happened to the default value=20 Not sure it is this, but I had to patch your activate code in (rev: 2291) because it broke mysql support. "DEF" was not recognized as a valid keyword for mysql and PRIMARY key needed to be defined. See my patch: --- source/phpsurveyor/admin/activate.php 2007/02/09 11:56:15 2290 +++ source/phpsurveyor/admin/activate.php 2007/02/09 14:53:54 2291 @@ -249,9 +249,9 @@ else { //Create the survey responses table - $createsurvey =3D "id I NOTNULL AUTO,\n"; + $createsurvey =3D "id I NOTNULL AUTO PRIMARY,\n"; // --> START NEW FEATURE - SAVE - $createsurvey .=3D " submitdate T NOTNULL DEF '0000-00-00 00:00:00',\n"; + $createsurvey .=3D " submitdate T NOTNULL DEFAULT '0000-00-00 00:00:00',\n"; $createsurvey .=3D " startlanguage C(20) NOTNULL ,\n"; // --> END NEW FEATURE - SAVE //Check for any additional fields for this survey and create necessary fields (token and datestamp) ------------------------------------------------------------------------ - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D= DEVDE V _______________________________________________ PHPSurveyor-Developers mailing list PHP...@li... https://lists.sourceforge.net/lists/listinfo/phpsurveyor-developers |