[plugin] [ORPHAN] ob1_advanced_search

Patrik · 2007-10-08 11:20:31

Tried to install it, got the following error message-any help appreciated:

Tag error: <txp:ob1_advanced_search setup=“1” /> -> Textpattern Warning: Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen (diese kann f�r verschiedene Server-Versionen unterschiedlich sein) bei ‘WHERE `Key_name` = ‘searching_total’‘ in Zeile 1
SHOW KEYS FROM textpattern WHERE `Key_name` = ‘searching_total’
textpattern/publish.php:963 ob1_advanced_search() on line 84

textpattern/lib/txplib_db.php:84 trigger_error()
textpattern/lib/txplib_misc.php(534) : eval()’d code:161 safe_query()
textpattern/publish.php:963 ob1_advanced_search()
processtags()
textpattern/publish.php:922 preg_replace_callback()
textpattern/publish.php:456 parse()
index.php:39 textpattern()

Tag error: <txp:ob1_advanced_search setup=“1” /> -> Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource on line 165

textpattern/lib/txplib_misc.php(534) : eval()’d code:165 mysql_fetch_array()
textpattern/publish.php:963 ob1_advanced_search()
processtags()
textpattern/publish.php:922 preg_replace_callback()
textpattern/publish.php:456 parse()
index.php:39 textpattern()

obeewan · 2007-10-08 17:12:04

Patrik:

What MySQL version are you running on your server? You can find it under Admin -> Diagnostics in your TXP install.
What Textpattern version are you using?

Patrik · 2007-10-09 05:16:17

obeewan wrote:

Patrik:

What MySQL version are you running on your server? You can find it under Admin -> Diagnostics in your TXP install.
What Textpattern version are you using?

Dear Obeewan,
thanks for the fast reply. Textpattern 4.0.5 and MySQL: 4.1.20-log

obeewan · 2007-10-09 09:29:00

I’m currently at work but I’ll investigate when I get back home.

Patrik · 2007-10-13 07:23:43

http://dev.mysql.com/doc/refman/5.0/en/extended-show.html
So this plugin only works with 5.0x MySql currently.

obeewan · 2007-10-13 08:26:29

Hmmm .. Well .. I do run a 5.0 install on my local machine. Just installed v4.1 of MySQL to test the whole thing out.

Patrik · 2007-10-13 08:42:06

I guess you’d have to create a workaround, something like this was what i found on a similar problem:

function checkKey($sTable, $sKey)
	{
		$aIndex = $this->getRows("SHOW INDEX FROM ". $this->getT($sTable) ."");
		foreach($aIndex as $index)
		{
			if ( $index['Key_name'] == $sKey)
			{
				return true;
			}
		}
		return false;

Last edited by Patrik (2007-10-13 08:59:37)

obeewan · 2007-10-13 08:47:20

Patrik wrote:

function checkKey($sTable, $sKey)
       {
               $aIndex = $this->getRows("SHOW INDEX FROM ". $this->getT($sTable) ."");
               foreach($aIndex as $index)
               {
                       if ( $index['Key_name'] == $sKey)
                       {
                               return true;
                       }
               }
               return false;
}

—-

It was actually something like that in the old version of the plugin. I’ll see what my digging with MySQL v4.1 does to the plugin.

(add bc. before a block of code)

Last edited by obeewan (2007-10-13 08:48:19)

obeewan · 2007-10-13 09:43:05

MySQL v4.1 problem solved and added to 1.031b version. I tested the plugin with the rest of the features and found no more “problems” with that MySQL version.

See first post for details.

v1.031b [2007-10-13]

Bug fix

Didn’t work with MySQL v4.1 since it didn’t support SHOW KEYS FROM table WHERE that was added in MySQL v5. Thanks to Patrik for spotting this and pointing the solution in the right direction.

Last edited by obeewan (2007-10-13 09:46:14)

Patrik · 2007-10-13 10:32:47

Thank you very much for your efforts, I appreciate it. Now the install appearently worked fine, however when I try to use the search form and click the advanced search button, it forwards me to a non existing page (Folder url is /gdb/search/ and it redirects to /gdb/search/gdb/?bts=1&rpp=1&q=&wh=1&ww=&oc=1&ad=1&sd=&ed=&bts=Advanced+search) which causes a 404 error page to show.
If I’m manually changing the url and removing the added /search/gdb/ it does work – could it have to do with the clean url’s option using a htaccess with mod_rewrite or so?

Last edited by Patrik (2007-10-13 10:51:26)

obeewan · 2007-10-13 10:57:23

Hard to say what actually makes it happen. I am currently helping Stuart with a problem he’s having with the plugin and this came up there aswell. Probably some replace that needs my attention.

obeewan · 2007-10-13 11:19:36

v1.032b released. See first post for details.

v1.032b [2007-10-13]

Bug fix

Subfolders and clean URLs didn’t work. The plugin added the subfolder twice to the URL.
Used safe_pfx_j instead of safe_pfx when checking the KEYS and INDEXes of the table. Created errors.

Last edited by obeewan (2007-10-13 11:23:24)

Textpattern CMS

Textpattern CMS support forum

#61 2007-10-08 11:20:31

Re: [plugin] [ORPHAN] ob1_advanced_search

#62 2007-10-08 17:12:04

Re: [plugin] [ORPHAN] ob1_advanced_search

#63 2007-10-09 05:16:17

Re: [plugin] [ORPHAN] ob1_advanced_search

#64 2007-10-09 09:29:00

Re: [plugin] [ORPHAN] ob1_advanced_search

#65 2007-10-13 07:23:43

Re: [plugin] [ORPHAN] ob1_advanced_search

#66 2007-10-13 08:26:29

Re: [plugin] [ORPHAN] ob1_advanced_search

#67 2007-10-13 08:42:06

Re: [plugin] [ORPHAN] ob1_advanced_search

#68 2007-10-13 08:47:20

Re: [plugin] [ORPHAN] ob1_advanced_search

#69 2007-10-13 09:43:05

Re: [plugin] [ORPHAN] ob1_advanced_search

#70 2007-10-13 10:32:47

Re: [plugin] [ORPHAN] ob1_advanced_search

#71 2007-10-13 10:57:23

Re: [plugin] [ORPHAN] ob1_advanced_search

#72 2007-10-13 11:19:36

Re: [plugin] [ORPHAN] ob1_advanced_search

Board footer