Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#1751 weird MySQL syntax error

duplicate
Marc Delisle
5
2013-06-11
2005-08-10
Sebastian Mendel
No

i have 3 systems, all running with latest CVS of phpMyAdmin

Problems: some styles doesnt seems to work, simple
query like: "SELECT SEC_TO_TIME(500) FROM `table`"
brings syntax error, other Querys seems to work fine ...

i treid so far:
- disabling byte-cache
- register_globals on/off
- fresh cvs of phpMyAdmin

pls can someone take a look at the configuration of
system 3, phpMyAdmin is a clean install

in time, i will do further checks, and try the latest
release of phpMyAdmin

2 of them running fine

Windows XP SP 2
Apache 2.0.52
PHP 4.4.0
MySQL 5.0.10a / 4.1.7 / 4.0.24

Fedora Core 4-dev
Apache 2.0.54 (Fedora)
PHP 5.0.4 (Fedora)
Zend Platform 1.1.2b

1 making problems:

Red Hat 7.3
Apache 2.0.54
MySQL 4.1.13 (MySQL rpms)
PHP 4.3.11
Zend Platform 1.1.2b

details:
PHP:
'./configure' 'i386-redhat-linux' '--prefix=/usr'
'--exec-prefix=/usr' '--bindir=/usr/bin'
'--sbindir=/usr/sbin' '--sysconfdir=/etc'
'--datadir=/usr/share' '--includedir=/usr/include'
'--libdir=/usr/lib' '--libexecdir=/usr/libexec'
'--localstatedir=/var' '--sharedstatedir=/usr/com'
'--mandir=/usr/share/man' '--infodir=/usr/share/info'
'--prefix=/usr' '--with-config-file-path=/etc'
'--with-exec-dir=/usr/bin' '--disable-cgi'
'--with-png-dir=/usr' '--with-jpeg-dir=/usr'
'--with-gd' '--enable-exif' '--with-png'
'--with-regex=system' '--with-zlib' '--with-layout=GNU'
'--with-pear=/usr/share/pear' '--enable-track-vars'
'--enable-trans-sid' '--with-mysql=/usr'
'--enable-memory-limit' '--with-apxs2=/usr/sbin/apxs'
'--enable-mbstring'

Apache:
./configure --enable-layout=RedHat --enable-file-cache
--enable-cache --enable-disk-cache --enable-mem-cache
--enable-deflate --enable-logio --enable-mime-magic
--enable-so --disable-userdir --enable-speling
--enable-rewrite --disable-imap --enable-dav-fs
--enable-cgi --enable-cgid --enable-dav --disable-include

Discussion

  • Logged In: YES
    user_id=326580

    very weird ... i can reproduce this only with Firefox-CVS
    (not IE) on one machine (2 others work fine) qith original theme

    fix: add additional line of comment before first comment, or
    add bogus style-tag body{} after first comment

     
  • Marc Delisle
    Marc Delisle
    2005-08-12

    Logged In: YES
    user_id=210714

    On the system experiencing this problem, does the error
    happen when you try the same query with command-line mysql?

     
  • Marc Delisle
    Marc Delisle
    2005-08-12

    • assigned_to: nobody --> lem9
     
  • Logged In: YES
    user_id=326580

    using mysql query browser or mysql command line or another
    php script does not raise this error,

    my previous fix fixes only half of the bug: not recognizing
    stylesheets

     
    • labels: 642016 --> MySQL Parser
    • status: open --> closed-duplicate
     
  • Michal Čihař
    Michal Čihař
    2013-06-11

    • Status: closed-duplicate --> duplicate