SQL syntax error - SMF 1.0.1 with database from 1.00

[nokonium]

PS.: I am curious -

So am I, I have now migrated servers twice, second time because of DNS issues, and have downloaded and reloaded to my original server the files from the current server (with me?) and to my surprise the problems that had bugged me are gone.

Understanding why is important to me.

[[Unknown]]

Some hosts do not give you permission to create "temporary tables".  These are tables that only work for your connection, and don't exist for a long period of time.  They are used, like in this case, to increase the speed of heavy operations.  Why these hosts disallow this privilege is not known to me; perhaps because of some possible or now-fixed security problem.

Most hosts do not, though.  That's why it's only affecting a small number of you - those of you who don't have temporary tables were getting errors, because the "no temporary table" searching algorithm had not seen the best testing and still had a few problems.

-[Unknown]

[nokonium]

Thank you [UNKNOWN]

At last our board appears to be stable.

[bluevoodu]

Some hosts do not give you permission to create "temporary tables".  These are tables that only work for your connection, and don't exist for a long period of time.  They are used, like in this case, to increase the speed of heavy operations.  Why these hosts disallow this privilege is not known to me; perhaps because of some possible or now-fixed security problem.

Most hosts do not, though.  That's why it's only affecting a small number of you - those of you who don't have temporary tables were getting errors, because the "no temporary table" searching algorithm had not seen the best testing and still had a few problems.

-[Unknown]

you know.. I am on a dedicated server and I believe that I am setup for temp tables (no problems there)

unless things changed without me noticing...

†B†V†

[nokonium]

Strangely, an issue with viewing attachments with Opera has gone away with the last migration and a more recent version of MySQL.

[bluevoodu]

!@#@!#%

I had to do a few searches for somethings.... and after about 7 searches, and then trying the advanced search... I got:

Code Select Expand

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 '' at line 3
File: /home/www/egameaddiction/forums/Sources/Search.php
Line: 648

WTH?!

†B†V†

[[Unknown]]

Try the attached.

-[Unknown]

[bluevoodu]

so far so good

I tried about 13 searches.

Do you know what the problem was?

Is it a problem with temp tables?

†B†V†

[[Unknown]]

Again, yes.  Every problem in this topic can only happen if you don't have temporary tables.

-[Unknown]

[bluevoodu]

what is the directive within php.  I did a search through my phpinfo.php and didn't see the temp tables.

thanks,
†B†V†

[[Unknown]]

what is the directive within php.  I did a search through my phpinfo.php and didn't see the temp tables.

http://dev.mysql.com/doc/mysql/en/privileges-provided.html

It's a MySQL privilege; nothing to do with PHP at all.

-[Unknown]

[bluevoodu]

ah ha...  yes.. I am an idiot.


um....  1 last question.... is there any performance decreases... or anything "bad" that could happen when temp tables are enabled?

I don't know why.... but I never had a problem with SMF, searching..etc.. until I moved to 1.0.1.... that included on both servers.

†B†V†

[[Unknown]]

um....  1 last question.... is there any performance decreases... or anything "bad" that could happen when temp tables are enabled?

Nope, it'll actually get faster.  Other things will too - and the shoutbox requires this permission, currently, as well.

I don't know why.... but I never had a problem with SMF, searching..etc.. until I moved to 1.0.1.... that included on both servers.

Temporary tables were used in RC1 to RC2 exclusively, I think.  After that they were made optional.

-[Unknown]

[bluevoodu]

yeah.. we were with you since beta 4 I think ..  and did every upgrade.


you had us sold early on lol



thanks,
†B†V†

[bluevoodu]

ok... so they enabled the temp table option.

Is there anything else I need to do?


†B†V†

[[Unknown]]

Well, under Edit Features and Options, Search... turn on the option to use temporary tables.

-[Unknown]