SQL syntax error - SMF 1.0.1 with database from 1.00

[Ross316]

Same error - 5 lines down

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 4
File: /var/www/html/forums/Sources/Search.php
Line: 704

[nokonium]

In that case I'll errr take a rain check

[bluevoodu]

Same error - 5 lines down

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 4
File: /var/www/html/forums/Sources/Search.php
Line: 704

I have this same error as well.

I upgraded with out a hitch... but I trasnferred servers and databases as well (BEFORE the 1.0.1 upgrade).... and I updated after I transferred servers..  Everything worked until the upgrade to 1.0.1

Any other suggestions?

yes, I uploaded the new search.php file that was given in this forum.

†B†V†

[bluevoodu]

um... I got another error now?

I didn't even change the code or anything:

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 ' (0, 1319, 7, 23208, 2),, (0, 1372, 5, 23053, 1),, (0, 1370, 20
File: /home/www/egameaddiction/forums/Sources/Search.php
Line: 648

anyone know what the deal is?

†B†V† :hat

[[Unknown]]

How's about this one?

-[Unknown]

[nokonium]

I've tried it with my backup and on a very quick run through it doesn't make anything die. Search worked, biggest 'find' went to 5 pages.

I'll wait for some more feedback before I try it on the main site though.

Thanks

[bluevoodu]

How's about this one?

-[Unknown]

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 ' (0, 1319, 7, 23208, 2),, (0, 1372, 5, 23053, 1),, (0, 1370, 20
File: /home/www/egameaddiction/forums/Sources/Search.php
Line: 648

here's the error after updating with the new php code.

sorry for being in the thread at the same time, Nokonium.... hopefully 2 birds can be killed with 1 stone.

†B†V†

[nokonium]

I tried it this morning, I'm still getting an error with some results probably over a page, up to 20 seems OK.

Code Select Expand

Database Error
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 ' (4, 352, 12, 4033, 11),, (4, 388, 4, 4010, 1),, (4, 391, 14, 3
File: /home/fhlinux198/k/[URL]/user/htdocs/smf/Sources/Search.php
Line: 648

[[Unknown]]

This one, then?

Darn it this is getting annoying .

-[Unknown]

[nokonium]

Code Select Expand

Database Error
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 ' (4, 406, 20, 4104, 1),, (4, 362, 4, 3642, 1),, (4, 199, 4, 355
File: /home/fhlinux198/k/[URL]/user/htdocs/smf/Sources/Search.php
Line: 648

[[Unknown]]

I've set up a user without create temporary and I can't reproduce that problem with the latest file I gave you?

I can't even figure out what could cause such an error :/.

-[Unknown]

[nokonium]

The Search isn't the only 'feature' we have with this board, we cannot run mods and last post icons exist but do not show.

Could a corrupted or missing file cause this?

[bluevoodu]

well... 1 common issue is here.... we both switched server and databases.

could the problem be within that?

And ....  I haven't had a chance to test the new file yet... the techs @ my hosting company are working on my server 

†B†V†

[Oldiesmann]

Line 699 has a slight mistake in it [Unknown]...

Code Select Expand

AND ID_MSG IN (" . implode(', ', array_keys($context['topics'])) . ')', __FILE__, __LINE__);

Should be

Code Select Expand

AND ID_MSG IN (" . implode(', ', array_keys($context['topics'])) . ")", __FILE__, __LINE__);

That's most likely what's causing the problem.

nokonium - try the attached file...

[nokonium]

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 ' 0)(5, 222, 25, , 0)(5, 245, 25.2, , 0)(5, 290, 26.2, , 0)' at
File: /home/fhlinux198/k/[url]/user/htdocs/smf/Sources/Search.php
Line: 643

[Oldiesmann]

Many people have run into that error... Try the solution posted here.

[nokonium]

Done that, uploaded upgrade.php, run it and deleted it again....

[thinks]

If we have two peeps with similar problems who did similar things.....

Could the way we saved/backed up the database be a factor?

I selected to not compress and preserve table structure.

[bluevoodu]

well... all I did was a database dump from the ssh command line

the reuploaded via ssh to the databases new location.



†B†V†

[Oldiesmann]

Done that, uploaded upgrade.php, run it and deleted it again....

[thinks]

If we have two peeps with similar problems who did similar things.....

Could the way we saved/backed up the database be a factor?

I selected to not compress and preserve table structure.

What happened when you tried that last fix?

[nokonium]

By jove I think he's got it........

6 pages of search results for one that had always got an error.



Thanks everyone