[nycphp-talk] Re: MySQL timestamps' format changed
Marc Antony Vose
suzerain at suzerain.com
Wed Apr 7 00:54:11 EDT 2004
hey jon:
thanks for spotting that. yeah, my version of mysql is 4.0.18, yet
it is still spitting back timestamps in the NEW way, which mysql says
requires 4.1
ditto this web host i am dealing with, who has 4.0.11. (i.e., not
"4.1", but behaving like 4.1).
i guess the mysql guys have reported this wrong, or there is a
discrepancy in the way mysql reports version numbers and the way
phpmyadmin handles it. anyway, i'm just glad i know why all this is
happening now. it was frustrating the hell out of me.
marc
>i looked into the export file (/libraries/export/sql.php) and it
>seems they have it right (~ line 413 on my copy):
>
> if ($type == 'tinyint' || $type == 'smallint' || $type ==
>'mediumint' || $type == 'int' ||
> $type == 'bigint' || (PMA_MYSQL_INT_VERSION < 40100
>&& $type == 'timestamp')) {
> $field_num[$j] = TRUE;
>} else {
> $field_num[$j] = FALSE;
>}
>
>its getting passed off as a literal value which should be quoted and
>not an int. does that part exist in your copy?
>
>_______________________________________________
>talk mailing list
>talk at lists.nyphp.org
>http://lists.nyphp.org/mailman/listinfo/talk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20040407/4eee6ca2/attachment.html>
More information about the talk
mailing list