Thread

Firstly thank you, EE is compared with so many other CMS’s a breeze to update however this time going from 1.51 to 1.6 we have experienced issues.

The wiki is spitting out error messages before rendering content concerning 255 character support, reverting to the file system/wiki/mod.wiki.php from 1.52 fixes the problem.

The search is another matter however.

The file system/search/mod.search.php throws up an SQL error and refuses to render the page. the same file from 1.52 works but throws up errors header as obviously the database structure/file system dependencies have been amended on upgrade.

So the question is, before I go posting details of the error messages, is, has EE 1.6 raised the stakes in respect of of acceptable version of MySQL or PHP, as I have a feeling this may be my server rather than EE?

Can you be more specific regarding the MySQL error message?  And the PHP error message for that matter, can you copy and post both verbatim please?

wiki error from 1.6 file

Warning: Compilation failed: characters with values > 255 are not yet supported in classes at offset 36 in /******************/modules/wiki/mod.wiki.php on line 724

search sql error

MySQL ERROR:

Error Number: 1064

Description: 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 'WHERE search_date > '1182533355' AND ip_address='**********''

69-Design: Thread

See the last post from Derek Jones.

Does that help at all?

possibly thank you, it may correspond to my wiki issue this is why I askd if EE had raised the bar on PHP/MySQL versions (which no-one has answered BTW 😊

Well there is a particular use of the PCRE library that we have not used in the application before, but its compatibility standards with PHP’s default library should still be fine.  The user in that thread has not gotten back on what the details of the PHP environment are.  Can you tell me what version of PHP you are running, what the OS of the server is, and what the version information for the PCRE libraries are?  (Admin > Utilities > PHP Info)

Does the MySQL error not also output the full query for you in addition to telling you where the problem is?  I would also suggest downloading a fresh copy and replacing your mod.search.php file, in case file corruption is the cause.  I’m not seeing where the extra quote character would be coming from.  And I’m assuming that the *‘s are your own addition to hide your IP address?

PHP Version 4.3.2
Linux redhat
server, apache 2
PCRE Library Version 3.9 02-Jan-2002

yes the **** are mine to hide IP

Appreciate the help here…

That PCRE library is unbelievably old, likely the default for whatever version of Redhat the server is running (any way you could find that out for me?)  The standard for the oldest version of Redhat that they still support, I think is 4.5 01-December-2003, which though ancient in terms of technology itself, retains compatibility for this particular use.

And yes, after all information is gathered we will be able to fix this for you; you will not have to revert to 1.5.2.

Actually, we were able to nail it down to a PHP bug.  The code being used, as described by the PHP docs, should have been available since PHP 4.1, but evidently does not gain full compatibility until > 4.3.2.  Alas, we will check before executing that code to make sure that PHP can handle it first.  You may email me for a fixed file if you need it right away.

Hi, Derek.

I’m having the same problem, and I’ve sent you an email requesting a copy of that file as well. Thanks!

Thanks Perak for including the full query in your email to me.  That allowed me to nail down the problem (the file I referred to above was for the Wiki PHP error, not the Search module SQL error), and I’ll send you a new file shortly.

I’ve replaced those two files, and the search funciton is working normally again.

I upgraded the school’s sites about 10 a.m. today, and didn’t notice anything wrong until I was checking the search terms archive this evening and found no searches since about the time I upgraded. We get ~200 searches a day, and often many more depending on the season.

Thanks for the quick response, Derek!

LOL good catch, then, Perak, and no problem.  That’s it for me tonight though!

Hello

I have the same issue with the search. If users which are not logged in, do a search the get the following message:

MySQL ERROR:

Error Number: 1064

Description: You have an error in your SQL syntax near 'WHERE search_date > '1182701448' AND ip_address='80.219.146.7'' at line 1

Query: SELECT search_id FROM exp_search WHERE site_id = '1' WHERE search_date > '1182701448' AND ip_address='80.219.146.7'

if a logged in user does a research, everything works fine. Anyone a idea what is wrong?

regards from Switzerland

That’s indeed the same problem, iRouge, and same solution required.  This will be packed into a new build in the next couple of days, or you may email (not PM) me for the files if you need them sooner.