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 4.0.22 - 2004-11-01 16:06:27

Changes in release 4.0.22:

Functionality added or changed:
* The --with-openssl option for configure now accepts a path prefix
as an argument. --with-openssl-includes and --with-openssl-libs
are still supported, but are needed only to override the default
values. (Bug #5494)
* Added new --without-man option to configure to suppress
building/installing the manual pages. (Bug #5379)
* InnoDB: New mysqld option --innodb-table-locks and session
variable innodb_table_locks (on by default). You can now disable
InnoDB table locks if your application depends on the way MySQL
did table locks before 4.0.20. See section "Restrictions on InnoDB
Tables" in the manual. (Bug #3299, Bug #5998)

Bugs fixed:
* Fixed bug in server which caused connection stall when one of
deprecated libmysqlclient functions mysql_create_db(),
mysql_rm_db() were called and were going to return error. (Bug
#6081)
* Fixed returning wrong query result from query cache if a temporary
table was hiding a real table after putting results to query cache.
(Bug #6084)
* Fixed ENABLE KEYS, which failed if tmpdir ran out of space. Now, a
full repair is done in this case. (Bug #5625)
* Fixed an improper error message when trying to drop a table which
is referenced by a FOREIGN KEY constraint. (Bug #5784)
* Fixed a bug that allowed FLUSH TABLE(S) to close HANDLER tables.
HANDLER tables are now reopened after a FLUSH TABLE(S) the next time
they are used. However, they lose their file position if this
happens. (Bug #4286)
* Fixed a bug that allowed HANDLER tables with the same alias to be
opened multiple times. HANDLER aliases must now be unique, even
though it is syntactically correct in versions below 4.1, to qualify
them with their base table's database name (e.g. test_db.handler_tbl,
but this will now conflict with e.g. another_db.handler_tbl). (Bug
#4335)
* Fixed crash when using MySQL 4.0 with privilege tables from MySQL
5.0.
* InnoDB: Make the check for excessive semaphore waits tolerate
glitches in the system clock (do not crash the server if the
system time is adjusted while InnoDB is under load.). (Bug #5898)
* mysqlimport now reads input files locally from the client host
only if the --local option is given. Previously, it assumed
incorrectly in some cases that files were local even without
--local. (Bug #5829)
* InnoDB: Fixed a bug in the InnoDB FOREIGN KEY parser that
prevented ALTER TABLE of tables containing `#' in their names.
(Bug #5856)
* InnoDB: Fixed problem introduced in 4.0.21 where a connection
starting a transaction, doing updates, then FLUSH TABLES WITH READ
LOCK, then COMMIT, would cause replication slaves to stop
complaining about error 1223. Bug surfaced when using the InnoDB
innobackup script. (Bug #5949)
* InnoDB: If one updated a column so that its size changed, or
updated it to an externally stored (TEXT or BLOB) value, then
ANOTHER externally stored column would show up as 512 bytes of
good data + 20 bytes of garbage in a consistent read that fetched
the old version of the row. (Bug #5960)
* InnoDB: Release the dictionary latch during a long cascaded
FOREIGN KEY operation, so that we do not starve other users doing
CREATE TABLE or other DDL operations. This caused a notorious 'Long
semaphore wait' message to be printed to the `.err' log. (Bug
#5961)
* Fixed a bug which resulted in an erroneously calculated number of
examined rows in UNIONs. This value is printed in the slow query
log. (Bug #5879)
* Fixed bug with crash of server on some values of
read_rnd_buffer_size (Bug #5492)
* Fixed bug which caused truncation of values read from or into
TIMESTAMP fields if --new mode was enabled. (Bug #4131)
* mysqladmin now returns a status of 0 even when the server denies
access; such an error means the server is running. (Bug #3120)
* InnoDB: Fixed a bug introduced in 4.0.21. An assertion failed if
one used mysqldump with the option -l or --opt, or if one used
LOCK TABLES ... LOCAL. (Workaround in 4.0.21: use --quick and
--single-transaction. (Bug #5538)
* Fixed that if the slave SQL thread found a syntax error in a query
(which should be rare, as the master parsed it successfully), it
stops. (Bug #5711)
* Fixed that if a write to a MyISAM table fails because of a full
disk or an exceeded disk quota, it prints a message to the error
log every 10 minutes, and waits until disk becomes free. (Bug
#3248)
* Fixed problem with symlinked databases on Windows being shown with
SHOW DATABASES even if the database name doesn't match the given
wildcard (Bug #5539)

Additional Notes:

* Due to a temporary hardware failure the binaries for HP-UX 11.11
are missing from the initial release. They will be provided as soon
as this HP-UX build system is online again.

Nyheten inskickad av mf22cs    



Firefox 1.0 RC1 - 2004-10-28 19:23:21

Today we have our first Firefox 1.0 candidate builds available for testing. You can get these test builds from FTP. If you've already downloaded 1.0 PR (the "feature complete" preview) and you're not really interested in testing and bug reporting, then you should probably stick with 1.0 PR for a couple more weeks and upgrade when we release the official Firefox 1.0.

The release candidates include about 250 bug fixes since Firefox 1.0 PR and we'd appreciate any feedback around any of those areas.
With this release, we're also featuring Mozilla Foundation builds for up to two dozen locales (slowly trickling in. if you don't see your language, try back in a bit.)

If you do find regressions from the Preview Release, please file bugs in Bugzilla and nominate them as Firefox 1.0 blockers using the "blocking-aviary1.0?" flag on the bug. Thanks for your help in testing Firefox!"

http://ftp.mozilla.org/pub/mozilla.org/firefox/releases/1.0rc1

--Asa

Nyheten inskickad av hagman    



Uppsala PHP Möte i November - 2004-10-28 15:26:12

Onsdagen den 17:e November, ca 19.00, har Uppsala PHP socialt möte. Vi ser gärna att många nya medlemmar dyker upp!

Detailjer och registrering.

Nyheten inskickad av cnb    



MySQL 4.1.7 - 2004-10-27 22:23:32

This is the first 4.1 production release.

News from the ChangeLog:

Changes in release 4.1.7

Functionality added or changed:
* InnoDB: Made LOCK TABLES behave by default like it did before
MySQL 4.0.20 or 4.1.2: no InnoDB lock will be taken. Added a
startup option and settable system variable innodb_table_locks for
making LOCK TABLE acquire also InnoDB locks. See section
"Restrictions on InnoDB Tables" in the manual.
(Bug #3299, Bug #5998)

Bugs fixed:
* Fixed a bug with FOUND_ROWS() used together with LIMIT clause in
prepared statements. (Bug #6088)
* Fixed a bug with NATURAL JOIN in prepared statements. (Bug #6046).
* Fixed a bug in join of tables from different databases having
columns with identical names (prepared statements). (Bug #6050)
* Now implicit access to system time zone description tables (which
happens when you set time_zone variable or use CONVERT_TZ()
function) does not require any privileges. (Bug #6116)
* Fixed a bug which caused the server to crash when the deprecated
libmysqlclient function mysql_create_db() was called. (Bug #6081)
* Fixed REVOKE ALL PRIVILEGES, GRANT OPTION FROM user so that all
privileges are revoked correctly. (Bug #5831). This corrects a
case that the fix in 4.1.6 could miss.
* Fixed a bug that could cause MyISAM index corruption when key
values start with character codes below BLANK. This was caused by
the new key sort order in 4.1. (Bug #6151)
* Fixed a bug in the prepared statements protocol when wrong
metadata was sent for SELECT statements not returning a result set
(such as SELECT ... INTO OUTFILE). (Bug #6059)
* Fixed bug which allowed one to circumvent missing UPDATE privilege
if one had INSERT and SELECT privileges for table with primary key.
(Bug #6173)
* Fixed a bug in libmysqlclient with wrong conversion of negative
time values to strings. (Bug #6049).
* Fixed a bug in libmysqlclient with wrong conversion of zero date
values (0000-00-00) to strings. (Bug #6058)
* Fixed a bug that caused the server to crash on attempt to prepare
a statement with RAND(?). (Bug #5985)
* Fixed a bug with handling of DATE, TIME, and DATETIME columns in
the binary protocol. The problem is compiler-specific and could
have been observed on HP-UX, AIX, Solaris9, when compiling with
native compiler. (Bug #6025)
* Fixed a bug with handling of TINYINT columns in the binary
protocol. The problem is specific to platforms where the C
compiler has the char data type unsigned by default. (Bug #6024)
* Fixed problem introduced in MySQL 4.0.21 where a connection
starting a transaction, doing updates, then FLUSH TABLES WITH READ
LOCK, then COMMIT, would cause replication slaves to stop
complaining about error 1223. Bug surfaced when using the InnoDB
innobackup script. (Bug #5949)

Nyheten inskickad av mf22cs    



MySQL 4.1.6 - 2004-10-15 17:12:12

Hi,

MySQL 4.1.6, a new version of the popular Open Source/Free Software Database
Management System has been released. It 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. If you
cannot find this version on a particular mirror, please try again later or
choose another download site.

This is the third 4.1 gamma release, primarily fixing bugs in preparation
for the upcoming production release.

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

News from the ChangeLog:

Changes in release 4.1.6

Functionality added or changed:
* Added option --sigint-ignore to the mysql command line client to
make it ignore SIGINT signals (typically the result of the user
pressing Control-C).
* InnoDB: Added the startup option and settable global variable
innodb_max_purge_lag for delaying INSERT, UPDATE and DELETE
operations when the purge operations are lagging. The default
value of this parameter is zero, meaning that there will not be
any delays. See section "Implementation of Multi-Versioning" in
the manual.
* InnoDB: The innodb_autoextend_increment startup option that was
introduced in release 4.1.5 was made a settable global variable.
(Bug #5736)
* TIMESTAMP columns now can store NULL values. To create such a
column, you must explicitly specify the NULL attribute in the
column specification. (Unlike all other column types, TIMESTAMP
columns are NOT NULL by default.)
* Now if ALTER TABLE converts one AUTO_INCREMENT column to another
AUTO_INCREMENT column it will preserve zero values (this includes
the case that we don't change such column at all).
* Now if ALTER TABLE converts some column to TIMESTAMP NOT NULL
column it will convert NULL values to current timestamp value (One
can still get old behavior by setting system TIMESTAMP variable to
zero).
* On Windows, the MySQL configuration files included in the package
now use `.ini' instead of `.cnf' as the file name suffix.

Bugs fixed:
* Fixed a bug which caused the server to crash on attempt to execute
a prepared statement with a subselect inside boolean expression.
(Bug#5987)
* Fixed a bug which caused the server to sometimes choose
non-optimal execution plan for a prepared statement executed with
changed placeholder values. (Bug#6042)
* InnoDB: Make the check for excessive semaphore waits tolerate
glitches in the system clock (do not crash the server if the
system time is adjusted while InnoDB is under load.). (Bug #5898)
* InnoDB: Fixed a bug in the InnoDB FOREIGN KEY parser that
prevented ALTER TABLE of tables containing `#' in their names.
(Bug #5856)
* InnoDB: Fixed a bug that prevented ALTER TABLE t DISCARD
TABLESPACE from working. (Bug #5851)
* InnoDB: SHOW CREATE TABLE now obeys the SET SQL_MODE=ANSI and SET
SQL_QUOTE_SHOW_CREATE=0 settings. (Bug #5292)
* Fixed REVOKE ALL PRIVILEGES, GRANT OPTION FROM user so that all
privileges are revoked correctly. (Bug #5831)
* Fixed a bug that caused the server to crash when character set
conversion was implicitly used in prepared mode; for example, as
in 'abc' LIKE CONVERT('abc' as utf8). (Bug#5688)
* The mysql_change_user() C API function now frees all prepared
statements associated with the connection. (Bug #5315)
* Fixed a bug when inserting NULL into an AUTO_INCREMENT column
failed, when using prepared statements. (Bug #5510)
* Fixed slave SQL thread so that the SET COLLATION_SERVER...
statements it replicates don't advance its position (so that if it
gets interrupted before the actual update query, it will later
redo the SET). (Bug #5705)
* Fixed that if the slave SQL thread found a syntax error in a query
(which should be rare, as the master parsed it successfully), it
stops. (Bug #5711)
* Fixed that if a write to a MyISAM table fails because of a full
disk or an exceeded disk quota, it prints a message to the error
log every 10 minutes, and waits until disk space becomes
available. (Bug #3248)
* Now MySQL will not prefer columns, which are mentioned in select
list but are renamed, over columns from other tables participating
in FROM clause when it resolves GROUP BY clause (e.g. SELECT t1.a
AS c FROM t1, t2 ORDER BY a will produce an error if both t1 and
t2 tables contain a column). (Bug #4302)
* Behavior of ALTER TABLE converting column containing NULL values
to AUTO_INCREMENT column is no longer affected by
NO_AUTO_VALUE_ON_ZERO mode. (Bug #5915).

Enjoy!

Matt

-- Matt Wagner, Production Engineer MySQL AB, www.mysql.com Northfield, MN, USA

Nyheten inskickad av hagman    



[ 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: 19804
Inlägg totalt: 719643
Senaste medlem: Fotvårdsprodukter
Online
Besökare just nu: 40,
0 registrerade,
0 dolda och
40 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