[Resolved] mysq 4.1.10a and 4.1.1 WHAT??

BEFOR

After spending the majority of the week finding a host that runs 4.1.1 (is 4.1.10a) in order to do subqueries, and taking a day to switch servers, I just loaded my 1st subquery having:

WHERE Table.primaryid < (select max (Table.primaryid) FROM Table)

But this is giving an error message "1064" and within a browser:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(Table.primaryid) FROM Table)

How could this possibly be?

bradgrafelman

What are you trying to do? SELECT the row with the highest primaryid?

If so, I would just do an 'ORDER BY primaryid DESC' and then retrieve the first row.

Otherwise, I don't know how to fix your query. Sorry.

BEFOR

won't work when I'd doing joins with many to many tables, and tables with repeat rows.

mtmosier

Are you running this query from php or from a query tool (phpmyadmin or whatever you use)? If from php then echo the query separate from the mysql call and copy/paste it into your query tool.

As a sanity check I'd run "select version()" and make sure you're on 4.1.10. Some hosts offer multiple mysql installs.

BEFOR

HAH!!!

SELECT VERSION(), CURRENT_DATE;

gives:

VERSION() CURRENT_DATE

4.0.24-standard-log 2005-05-07

Even though I've verified it four times with this host.

Either someone is not being honest or they are very confused.

thanks bradgrafelman !

bradgrafelman

Afraid it wasn't I who helped, but mtmosier. All thanks should be directed at him 😉

BEFOR

thanks mtmosier,

they're still telling me its 4.1.10a

I'm on the verge of quitting them.

Can there be any way VERSION() CURRENT_DATE could give a false reading? I am doing this through phpmyadmin.

mtmosier

Yes, if they edited the source code and changed the version number. But why would anyone do that? And subselects would be working in that case.

Of course you could also be connecting to the wrong db if they have more than one installed.

To be sure subselects aren't working you could try an extremely simple one. Like this

select 1, (select 0);

That works for me on 4.1.11 and fails on 4.0.24.

BEFOR

select 1, (select 0);

returns:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select 0)' at line 1

mtmosier

So looks like it's not 4.1. Might want to forward them your version output, and point out that subselects don't work. Maybe there's some sort of honest misunderstanding.

BEFOR

I did forward them the output, more than once.

they gave quite a bit of denial. Then finally apologized and upgraded the server to 4.1.10a saying my site was on a new server.

They were never actually checking the version all along, only some pre-entered table value.

Nice work mtmosier

-thanks again.

mtmosier

Glad you got it resolved in a positive manner. Speaking of resolved, remember to mark your thread as such if it is.

BEFOR

I'm looking for where to mark it resolved - found it.