dgs_search

[cs1]

Hi Fred,
I 've got the following error message on the version 2.9.00:
Date/time : 29 June 2010, 13:50:34
File: /mnt/web3/22/16/593316/htdocs/sats/starnet/modules/dgs_search/libs/search/db.php
Line: 186
Code: 512
Message: Table 'DB101649.sn_m_pictures_cat' doesn't exist"
Query : "SELECT id, pagename, welcome FROM sn_m_pictures_cat WHERE (pagename LIKE '%bewerbung%' OR welcome LIKE '%bewerbung%' ) ORDER BY id, pagename, welcome".
Url: http://www.bbs-buxtehude.de/sats/index.php?page=113&section=37
The table doesn't exist.
If I create such an empty table with theese fields, the error is gone.

[Fred Stuurman]

Did you run the 2.8-2.9 migration, this should have fixed this:

these are the statements:

Code: [Select]

mysql_query("UPDATE $table_configuration SET config_value = 'sn_allbum,m_album_cat,1,0,0' WHERE config_key = 'search_module_name4'");
mysql_query("UPDATE $table_configuration SET config_value = 'id,pagename,welcome' WHERE config_key = 'search_module_returnfield4'");
mysql_query("UPDATE $table_configuration SET config_value = 'pagename,welcome' WHERE config_key = 'search_module_searchfield4'");
mysql_query("UPDATE $table_configuration SET config_value = '&modoption=list&cat_id=@0@' WHERE config_key = 'search_module_url4'");

[cs1]

Hi, Fred,
in the file migrate2.8_2.9.php I've found the following line 194:

Code: [Select]

//search module
mysql_query("UPDATE $table_configuration SET config_value = 'pictures,m_pictures_cat,0,1,0' WHERE config_key = 'search_module_name4'");
With the code, you have posted above, the problem is fixed.
Thank you very much.
Greetings from
Carsten

[Rob Verhoeff]

Hello Fred,

Thanks for posting 2.9.00.
After migrating from 2.8.02 to 2.9.00 I've encouterd the next problem:
When using the search module on the front end I get this error

SyndeoCMS - Error page
Er is een probleem met de site opgetreden, neem kontakt op met de beheerder.
There has been a problem with the site, please contact the webmaster.

Is this related to the problem above, and if so, how do I correct it?

Greetings Rob.

[Fred Stuurman]

Rob,
Check the error log, without the real error it is hard to say.

[Rob Verhoeff]

Sorry,

Here it is:

Bestand: /usr/local/psa/home/vhosts/verhoeff-online.nl/httpdocs/starnet/modules/dgs_search/libs/search/db.php
error code: 2
line: 190
error: mysql_fetch_row(): supplied argument is not a valid MySQL result resource
Url: http://verhoeff-online.nl/index.php?page=4§ion=4
Backtrace:
#0: myErrHandler(())
#1: mysql_fetch_row(/usr/local/psa/home/vhosts/verhoeff-online.nl/httpdocs/starnet/modules/dgs_search/libs/search/db.php(190))
#2: searchMySQL(/usr/local/psa/home/vhosts/verhoeff-online.nl/httpdocs/starnet/modules/dgs_search/libs/search/db.php(38))
#3: db(/usr/local/psa/home/vhosts/verhoeff-online.nl/httpdocs/starnet/modules/dgs_search/search.php(52))
#4: search(/usr/local/psa/home/vhosts/verhoeff-online.nl/httpdocs/starnet/modules/dgs_search/search.php(93))
#5: include(/usr/local/psa/home/vhosts/verhoeff-online.nl/httpdocs/starnet/themes/Nautica02Liquid/main.inc.php(92))
#6: include(/usr/local/psa/home/vhosts/verhoeff-online.nl/httpdocs/index.php(281))

I disabled the function for the time being

[Fred Stuurman]

Rob,
Looks indeed like the same error, can you do the following sql in phpmyadmin:

Code: [Select]

UPDATE syn_configuration SET config_value = 'sn_allbum,m_album_cat,1,0,0' WHERE config_key = 'search_module_name4';
UPDATE syn_configuration SET config_value = 'id,pagename,welcome' WHERE config_key = 'search_module_returnfield4';
UPDATE syn_configuration SET config_value = 'pagename,welcome' WHERE config_key = 'search_module_searchfield4';
UPDATE syn_configuration SET config_value = '&modoption=list&cat_id=@0@' WHERE config_key = 'search_module_url4';
That should fix it.

[Rob Verhoeff]

Hi Fred,

I think you're a genius  , it works!

Post it as a hotfix! I think I will not be the only one.

Greets Rob