Nyheter på PHPportalen

På PHPportalen försöker vi i så hög grad som möjligt engagera våra medlemmar. Därför har du som medlem chansen att vara med och hjälpa till. Nedan finner du en länk till en sida där du kan lägga till nyheter till vårt nyhetsarkiv. Våra trivsel- och förhållningsregler gäller givetvis även här. Posta inte heller någonting som inte är av allmänt intresse, reklam i alla dess former kommer redigeras bort.

Lägg till nyhet


MySQL 5.0.17 - 2005-12-19 20:48:40

Hi,

MySQL 5.0.17, a new version of the popular Open Source Database
Management System, has been released. The Community Edition is now
available in source and binary form for a number of platforms from our
download pages at
http://dev.mysql.com/downloads/
and mirror sites.

Note that not all mirror sites may be up to date at this point in time -
if you can't find this version on some mirror, please try again later or
choose another download site.

This is a bugfix release for the current production version.

Please refer to our bug database at http://bugs.mysql.com/ for more
details about the individual bugs fixed in this version.


News from the ChangeLog:

Functionality added or changed:
* The syntax for CREATE TRIGGER now includes a DEFINER clause for
specifying which access privileges to check at trigger invocation
time. See Section 18.1, "CREATE TRIGGER Syntax" for more
information.
* Added a DEFINER column to the INFORMATION_SCHEMA.TRIGGERS table.
* Invoking a stored function or trigger creates a new savepoint
level. When the function or trigger finishes, the previous
savepoint level is restored.
(See Bug #13825 (http://bugs.mysql.com/13825) for more
information.)
* Recursion is allowed in stored procedures. Recursive stored
functions and triggers still are disallowed.
(Bug#10100 (http://bugs.mysql.com/10100))
* In the latin5_turkish_ci collation, the order of the characters
A WITH CIRCUMFLEX, I WITH CIRCUMFLEX, and U WITH CIRCUMFLEX was
changed. If you have used these characters in any indexed columns,
you should rebuild those indexes.
(Bug#13421 (http://bugs.mysql.com/13421))

Bugs fixed:
* NDB Cluster: Using ORDER BY primary_key_column when selecting from
a table having the primary key on a VARCHAR column caused a forced
shutdown of the cluster.
(Bug #14828 (http://bugs.mysql.com/14828),
Bug #15240 (http://bugs.mysql.com/15240),
Bug #15682 (http://bugs.mysql.com/15682),
Bug #15517 (http://bugs.mysql.com/15517))
* NDB Cluster: Under certain circumstances, when mysqld connects to a
cluster management server, the connection would fail before a node
ID could be allocated. (Bug #15215 (http://bugs.mysql.com/15215))
* NDB Cluster: There was a small window for a node failure to occur
during a backup without an error being reported.
(Bug #15425 (http://bugs.mysql.com/15425))
* mysql --help was missing a newline after the version string when
the bundled readline library was not used.
(Bug #15097 (http://bugs.mysql.com/15097))
* Implicit versus explicit conversion of float to integer (such as
inserting a float value into an integer column versus using
CAST(... AS UNSIGNED before inserting the value) could produce
different results. Implicit and explicit typecasts now are done the
same way, with a value equal to the nearest integer according to
the prevailing rounding mode.
(Bug #12956 (http://bugs.mysql.com/12956))
* GROUP BY on a view column did not correctly account for the
possibility that the column could contain NULL values.
(Bug #14850 (http://bugs.mysql.com/14850))
* ANALYZE TABLE did not properly update table statistics for a MyISAM
table with a FULLTEXT index containing stopwords, so a subsequent
ANALYZE TABLE would not recognize the table as having already been
analyzed. (Bug #14902 (http://bugs.mysql.com/14902))
* The maximum value of MAX_ROWS was handled incorrectly on 64-bit
systems. (Bug #14155 (http://bugs.mysql.com/14155))
* NDB Cluster: A forced cluster shutdown occurred when the management
daemon was restarted with a changed config.ini file that added an
API/SQL node. (Bug #15512 (http://bugs.mysql.com/15512))
* Multiple-table update operations were counting updates and not
updated rows. As a result, if a row had several updates it was
counted several times for the "rows matched" value but updated only
once. (Bug #15028 (http://bugs.mysql.com/15028))
* A statement that produced a warning, when fetched via
mysql_stmt_fetch(), did not produce a warning count according to
mysql_warning_count(). (Bug #15510 (http://bugs.mysql.com/15510))
* Manual manipulation of the mysql.proc table could cause a server
crash. This should not happen, but it is also not supported that
the server will notice such changes.
(Bug #14233 (http://bugs.mysql.com/14233))
* Revised table locking to allow proper assessment of view security.
(Bug #11555 (http://bugs.mysql.com/11555))
* Within a stored procedure, inserting with INSERT ... SELECT into a
table with an AUTO_INCREMENT column did not generate the correct
sequence number. (Bug #14304 (http://bugs.mysql.com/14304))
* SELECT queries that began with an opening parenthesis were not
being placed in the query cache.
(Bug #14652 (http://bugs.mysql.com/14652))
* Space truncation was being ignored when inserting into BINARY or
VARBINARY columns. Now space truncation results in a warning, or an
error in strict mode. (Bug #14299 (http://bugs.mysql.com/14299))
* The database-changing code for stored routine handling caused an
error-handling problem resulting in a server crash.
(Bug #15392 (http://bugs.mysql.com/15392))
* Selecting from a view processed with the temptable algorithm caused
a server crash if the query cache was enabled.
(Bug #15119 (http://bugs.mysql.com/15119))
* REPAIR TABLES, BACKUP TABLES, RESTORE TABLES within a stored
procedure caused a server crash.
(Bug #13012 (http://bugs.mysql.com/13012))
* Creating a view that referenced a stored function that selected
from a view caused a crash upon selection from the view.
(Bug #15096 (http://bugs.mysql.com/15096))
* ALTER TABLE ... SET DEFAULT had no effect.
(Bug #14693 (http://bugs.mysql.com/14693))
* Creating a view within a stored procedure could result in an out of
memory error or a server crash.
(Bug #14885 (http://bugs.mysql.com/14885))
* InnoDB: A race condition allowed two threads to drop a hash index
simultaneously. (Bug #14747 (http://bugs.mysql.com/14747))
* mysqlhotcopy tried to copy INFORMATION_SCHEMA tables.
(Bug #14610 (http://bugs.mysql.com/14610))
* CHAR(... USING ...) and CONVERT(CHAR(...) USING ...), though
logically equivalent, could produce different results.
(Bug #14146 (http://bugs.mysql.com/14146))
* The value of INFORMATION_SCHEMA.TABLES.TABLE_TYPE sometimes was
reported as empty. (Bug #14476 (http://bugs.mysql.com/14476))
* InnoDB: Activitity on an InnoDB table caused execution time for
SHOW CREATE TABLE for the table to increase.
(Bug #13762 (http://bugs.mysql.com/13762))
* DELETE from CSV tables reported an incorrect rows-affected value.
(Bug #13406 (http://bugs.mysql.com/13406))
* The server crashed if compiled without any transactional storage
engines. (Bug #15047 (http://bugs.mysql.com/15047))
* Declaring a stored routine variable to have a DEFAULT value that
referred to a variable of the same name caused a server crash. (For
example: DECLARE x INT DEFAULT x) Now the DEFAULT variable is
interpreted as referring to a variable in an outer scope, if there
is one. (Bug #14376 (http://bugs.mysql.com/14376))
* Perform character set conversion of constant values whenever
possible without data loss.
(Bug #10446 (http://bugs.mysql.com/10446))
* mysql ignored the MYSQL_TCP_PORT environment variable.
(Bug #5792 (http://bugs.mysql.com/5792))
* ROW_COUNT() returned an incorrect result after EXECUTE of a
prepared statement. (Bug #14956 (http://bugs.mysql.com/14956))
* A UNION of DECIMAL columns could produce incorrect results.
(Bug #14216 (http://bugs.mysql.com/14216))
* Queries that select records based on comparisons to a set of column
could crash the server if there was one index covering the columns,
and a set of other non-covering indexes that taken together cover
the columns. (Bug #15204 (http://bugs.mysql.com/15204))
* When using an aggregate function to select from a table that has a
multiple-column primary key, adding ORDER BY to the query could
produce an incorrect result.
(Bug #14920 (http://bugs.mysql.com/14920))
* SHOW CREATE TABLE for a view could fail if the client had locked
the view. (Bug #14726 (http://bugs.mysql.com/14726))
* For binary string data types, mysqldump --hex-blob produced an
illegal output value of 0x rather than ''.
(Bug #13318 (http://bugs.mysql.com/13318))
* Some comparisons for the IN() operator were inconsistent with
equivalent comparisons for the = operator.
(Bug #12612 (http://bugs.mysql.com/12612))
* In a stored procedure, continuing (via a condition handler) after a
failed variable initialization caused a server crash.
(Bug #14643 (http://bugs.mysql.com/14643))
* Within a stored procedure, exception handling for UPDATE statements
that caused a duplicate-key error caused a Packets out of order
error for the following statement.
(Bug #13729 (http://bugs.mysql.com/13729))
* Creating a table containing an ENUM or SET column from within a
stored procedure or prepared statement caused a server crash later
when executing the procedure or statement.
(Bug #14410 (http://bugs.mysql.com/14410))
* Selecting from a view used filesort retrieval when faster retrieval
was possible. (Bug #14816 (http://bugs.mysql.com/14816))
* Warnings from a previous command were not being reset when fetching
from a cursor. (Bug #13524 (http://bugs.mysql.com/13524))
* RESET MASTER failed to delete log files on Windows.
(Bug #13377 (http://bugs.mysql.com/13377))
* Using ORDER BY on a column from a view, when also selecting the
column normally, and via an alias, caused a mistaken Column 'x' in
order clause is ambiguous error.
(Bug #14662 (http://bugs.mysql.com/14662))
* Invoking a stored procedure within another stored procedure caused
the server to crash. (Bug #13549 (http://bugs.mysql.com/13549))
* Stored functions making use of cursors were not replicated.
(Bug #14077 (http://bugs.mysql.com/14077))
* CAST(expr AS BINARY(N)) did not pad with 0x00 to a length of N
bytes. (Bug #14255 (http://bugs.mysql.com/14255))
* Casting a FLOAT or DOUBLE whose value was less than 1.0E-06 to
DECIMAL would yield an inappropriate value.
(Bug #14268 (http://bugs.mysql.com/14268))
* In some cases, a left outer join could yield an invalid result or
cause the server to crash, due to a MYSQL_DATA_TRUNCATED error.
(Bug #13488 (http://bugs.mysql.com/13488))
* For a invalid view definition, selecting from the
INFORMATION_SCHEMA.VIEWS table or using SHOW CREATE VIEW failed,
making it difficult to determine what part of the definition was
invalid. Now the server returns the definition and issues a
warning. (Bug #13818 (http://bugs.mysql.com/13818))
* The server could misinterpret old trigger definition files created
before MySQL 5.0.17. Now they are interpreted correctly, but this
takes more time and the server issues a warning that the trigger
should be recreated. (Bug #14090 (http://bugs.mysql.com/14090))
* mysqldump --triggers did not account for the SQL mode and could
dump trigger definitions with missing whitespace if the
IGNORE_SPACE mode was enabled.
(Bug #14554 (http://bugs.mysql.com/14554))
* Within a trigger definition the CURRENT_USER() function evaluated
to the user whose actions caused the trigger to be activated. Now
that triggers have a DEFINER value, CURRENT_USER() evaluates to the
trigger definer. (Bug #5861 (http://bugs.mysql.com/5861))
* CREATE TABLE tbl_name (...) SELECT ... could crash the server and
write invalid data into the .frm file if the CREATE TABLE and
SELECT both contained a column with the same name. Also, if a
default value is specified in the column definition, it is now
actually used. (Bug #14480 (http://bugs.mysql.com/14480))
* A newline character in a column alias in a view definition caused
an error when selecting from the view later.
(Bug #13622 (http://bugs.mysql.com/13622))
* mysql_fix_privilege_tables.sql contained an erroneous comment that
resulted in an error when the file contents were processed.
(Bug #14469 (http://bugs.mysql.com/14469))
* On Windows, the server could crash during shutdown if both
replication threads and normal client connection threads were
active. (Re-fix of Bug #11796 (http://bugs.mysql.com/11796))
* The grammar for supporting the DEFINER = CURRENT_USER clause in
CREATE VIEW and ALTER VIEW was incorrect.
(Bug #14719 (http://bugs.mysql.com/14719))
* Queries on ARCHIVE tables that used the filesort sorting method
could result in a server crash.
(Bug #14433 (http://bugs.mysql.com/14433))
* The mysql_stmt_fetch() C APP function could return MYSQL_NO_DATA
for a SELECT COUNT(*) FROM tbl_name WHERE 1 = 0 statement, which
should return 1 row. (Bug #14845 (http://bugs.mysql.com/14845))
* A LIMIT-related optimization failed to take into account that
MyISAM table indexes can be disabled, causing Error 124 when it
tried to use such an index.
(Bug #14616 (http://bugs.mysql.com/14616))
* A server crash resulted from the following sequence of events:
1) With no default database selected, create a stored procedure
with the procedure name explicitly qualified with a database
name (CREATE PROCEDURE db_name.proc_name ...).
2) Create another stored procedure with no database name qualifier.
3) Execute SHOW PROCEDURE STATUS.
(Bug #14569 (http://bugs.mysql.com/14569))
* Complex subqueries could cause improper internal query execution
environment initialization and crash the server.
(Bug #14342 (http://bugs.mysql.com/14342))
* For a table that had been opened with HANDLER OPEN, issuing
OPTIMIZE TABLE, ALTER TABLE, or REPAIR TABLE caused a server crash.
(Bug #14397 (http://bugs.mysql.com/14397))
* A server crash could occur if a prepared statement invoked a stored
procedure that existed when the statement was prepared but had been
dropped and recreated prior to statement execution.
(Bug #12329 (http://bugs.mysql.com/12329))
* A server crash could occur if a prepared statement updated a table
for which a trigger existed when the statement was prepared but had
been dropped prior to statement execution.
(Bug #13399 (http://bugs.mysql.com/13399))
* Statements that implicitly commit a transaction are prohibited in
stored functions and triggers. An attempt to create a function or
trigger containing such a statement produces an error.
(Bug #13627 (http://bugs.mysql.com/13627))
(The originally reported symptom was that a trigger that dropped
another trigger could cause a server crash. That problem was fixed
by the patch for Bug #13343 (http://bugs.mysql.com/13343).)


Enjoy!
Joerg

Nyheten inskickad av hagman    



Firefox 1.5 - 2005-11-30 00:35:20

Firefox 1.5
http://www.mozilla.com/firefox/

  • Bättre stöd för popup blocking
  • Drag and drop för att ordna tabbar
  • Stöd för SVG, CSS 2, CSS 3 och JavaScript 1.6
  • m.m.

What's New in Firefox 1.5
http://www.mozilla.com/firefox/releases/1.5.html

Nyheten inskickad av suamiperkele    



PHP 5.1.1 - 2005-11-28 18:20:51

The PHP Development Team would like to announce the immediate release of
PHP 5.1.1.

This is a regression correction release aimed at addressing several
issues that may cause issues for some applications. The main fixes
found in this release include the following:

* Native date class is withdrawn to prevent namespace conflict with
PEAR's date package.
* Fixed fatal parse error when the last line of the script is a PHP comment.
* eval() hangs when the code being evaluated ends with a comment.
* Usage of \{$var} in PHP 5.1.0 resulted in the output of {$var} instead
of the $var variable's value enclosed in {}.
* Fixed inconsistency in the format of PHP_AUTH_DIGEST between Apache 1
and 2 sapis.
* Improved safe_mode/open_basedir checks inside the cURL extension.

The full details of the changes in PHP 5.1.1 can be found here:
http://www.php.net/ChangeLog-5.php#5.1.1


PHP Development Team.

Nyheten inskickad av hagman    



PHP 5.1.0 - 2005-11-25 01:05:45

The PHP development team is proud to announce the release of PHP 5.1.
Some of the key features of PHP 5.1 include:

* A complete rewrite of date handling code, with improved timezone support.
* Significant performance improvements compared to PHP 5.0.X.
* PDO extension is now enabled by default.
* Over 30 new functions in various extensions and built-in functionality.
* Bundled libraries, PCRE and SQLite upgraded to latest versions.
* Over 400 various bug fixes.
* PEAR upgraded to version 1.4.5

The full details of the changes in PHP 5.1.0 can be found here:
http://www.php.net/ChangeLog-5.php#5.1.0

In addition to new features, this release includes a number of important
security fixes:

* Fixed a Cross Site Scripting (XSS) vulnerability in phpinfo() that
could lead f.e. to cookie exposure, when a phpinfo() script is
accidentally left on a production server.
* Fixed multiple safe_mode/open_basedir bypass vulnerabilities in
ext/curl and ext/gd that could lead to exposure of files normally not
accessible due to safe_mode or open_basedir restrictions.
* Fixed a possible $GLOBALS overwrite problem in file upload handling,
extract() and import_request_variables() that could lead to unexpected
security holes in scripts assumed secure. (For more information, see here).
* Fixed a problem when a request was terminated due to memory_limit
constraints during certain parse_str() calls. In some cases this can
result in register_globals being turned on.
* Fixed an issue with trailing slashes in allowed basedirs. They were
ignored by open_basedir checks, so that specified basedirs were handled
as prefixes and not as full directory names.
* Fixed an issue with calling virtual() on Apache 2. This allowed
bypassing of certain configuration directives like safe_mode or
open_basedir.
* Updated to the latest pcrelib to fix a possible integer overflow
vulnerability announced in CAN-2005-2491.
* Possible header injection in mb_send_mail() function via the “To”
address, the first parameter of the function.

All users of PHP 5.0 and early adopters of 5.1 betas are strongly
advised to upgrade to 5.1 as soon as possible. An upgrade is available
at http://www.php.net/README_UPGRADE_51.php.

Enjoy,

PHP Development Team.

Nyheten inskickad av hagman    



Mozilla Firefox 1.5 RC3 - 2005-11-18 13:00:47

Senaste release av älskade browser!
Direktlänk: http://ftp.mozilla.org/pub/mozilla.org/firefox/releases/1.5rc3/win32/en-US/Firefox%20Setup%201.5rc3.exe

Nyheten inskickad av manijak    



[ 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 ]
Välkommen Anonymous
Logga in
Registrera
Snabblänkar
Markera alla forum som lästa
Skriptarkivet [86 av 97]
Visa nya inlägg
Visa dina inlägg
Visa obesvarade huvudinlägg
Läs vår skola
  Introduktion
  Programmera i webbmiljö
  Installationen i Windows
  Variabler och konstanter
  Vektorer
  Operatorer
  Villkorssatser
  Slingor
Statistik
Registrerade medlemmar: 19816
Inlägg totalt: 719721
Senaste medlem: licmarcos
Online
Besökare just nu: 39,
0 registrerade,
0 dolda och
39 gäster
Besökare som mest var 501 den 2019-05-02 15:53

Våra medlemmar
Inloggade medlemmar
Bra att veta
Förhållningsregler
Trivselregler
phpBB-FAQ
För dig som vill länka
Kontakta oss på adressen: info@phpportalen.net
Webbplatsen bygger i grunden på phpBB © 2001, 2002 phpBB Group

Modifieringar har senare gjorts i systemet av PHPportalen
Sid och logotypdesign skapad av Daren Jularic