The database value you're trying to insert does not exist: id_search

[v1rotate]

Hi all,

i'm using SMF2.0 B4 for sometime now and evrything is working fine.
today i got a report from members that say that our search isn't working. i tried it out and some search do work and others don't

The database value you're trying to insert does not exist: id_search
or simply no result even when it should give a result

This is a error report i got

Code Select Expand



Templates: 3: index (default), Search (default), Errors (default).
Sub templates: 6: init, html_above, body_above, fatal_error, body_below, html_below.
Language files: 2: index+Modifications.english (default), Search.english (default).
Style sheets: 1: index(default).
Files included: 19 - 636KB. (show./index.php, ./Settings.php, ./Sources/QueryString.php, ./Sources/Subs.php, ./Sources/Errors.php, ./Sources/Load.php, ./Sources/Security.php, ./Sources/Subs-Compat.php, ./Sources/Subs-Db-mysql.php, ./cache/data_cbf023dbed818473d61958818043e860-SMF-modSettings.php, ./cache/data_cbf023dbed818473d61958818043e860-SMF-theme_settings-1.php, ./Sources/ManageMaintenance.php, ./Themes/default/languages/index.english.php, ./Themes/default/languages/Modifications.english.php, ./cache/data_cbf023dbed818473d61958818043e860-SMF-log_online-update.php, ./Sources/Search.php, ./Themes/default/languages/Search.english.php, ./Sources/Display.php, ./Sources/DbSearch-mysql.php)
Cache hits: 5: 0.00264s for 8104 bytes (showget modSettings: 0.00086 - 6810 bytes, get theme_settings-1: 0.00067 - 1281 bytes, get log_online-update: 0.00055 - 13 bytes, put modSettings: 0.00040 - 0 bytes, get menu_buttons-1_5_9-english: 0.00016 - 0 bytes)
Queries used: 16.

         SET NAMES utf8
   in /home/v/v1-rotate.org/public_html/forum/Sources/Load.php line 148, which took 0.0009861 seconds.

      SELECT data
      FROM smf_sessions
      WHERE session_id = '85d8d86fe32e6483cfe652d63adb2697'
      LIMIT 1
   in /home/v/v1-rotate.org/public_html/forum/Sources/Load.php line 2194, which took 0.00177217 seconds.

            SELECT mem.*, IFNULL(a.id_attach, 0) AS id_attach, a.filename, a.attachment_type
            FROM smf_members AS mem
               LEFT JOIN smf_attachments AS a ON (a.id_member = 1)
            WHERE mem.id_member = 1
            LIMIT 1
   in /home/v/v1-rotate.org/public_html/forum/Sources/Load.php line 351, which took 0.00176716 seconds.

         SELECT variable, value, id_member, id_theme
         FROM smf_themes
         WHERE id_member = 1
            AND id_theme = 1
   in /home/v/v1-rotate.org/public_html/forum/Sources/Load.php line 1306, which took 0.00125504 seconds.

         UPDATE smf_log_online
         SET log_time = 1226603711, ip = IFNULL(INET_ATON('83.101.13.21'), 0), url = 'a:2:{s:6:\"action\";s:7:\"search2\";s:10:\"USER_AGENT\";s:111:\"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)\";}'
         WHERE session = '85d8d86fe32e6483cfe652d63adb2697'
   in /home/v/v1-rotate.org/public_html/forum/Sources/Subs.php line 2531, which took 0.00132203 seconds.

         SELECT COUNT(*)
         FROM smf_boards
   in /home/v/v1-rotate.org/public_html/forum/Sources/Search.php line 548, which took 0.00074196 seconds.

      DELETE FROM smf_log_floodcontrol
      WHERE log_time < 1226603709
         AND log_type = 'search'
   in /home/v/v1-rotate.org/public_html/forum/Sources/Subs.php line 2909, which took 0.00105 seconds.

      REPLACE INTO smf_log_floodcontrol(`ip`, `log_time`, `log_type`)
      VALUES
         (SUBSTRING('83.101.13.21', 1, 16), 1226603711, 'search')
   in /home/v/v1-rotate.org/public_html/forum/Sources/Subs.php line 2917, which took 0.00089908 seconds.

      REPLACE INTO smf_settings(`variable`, `value`)
      VALUES
         (SUBSTRING('search_pointer', 1, 255), SUBSTRING('8', 1, 65534))
   in /home/v/v1-rotate.org/public_html/forum/Sources/Subs.php line 630, which took 0.00097799 seconds.

            DELETE FROM smf_log_search_results
            WHERE id_search = 8
   in /home/v/v1-rotate.org/public_html/forum/Sources/Search.php line 978, which took 0.00077701 seconds.

                  DROP TABLE IF EXISTS smf_tmp_log_search_topics
   in /home/v/v1-rotate.org/public_html/forum/Sources/Search.php line 1190, which took 0.00058699 seconds.

                  CREATE TEMPORARY TABLE smf_tmp_log_search_topics (
                     id_topic mediumint(8) unsigned NOT NULL default '0',
                     PRIMARY KEY (id_topic)
                  ) TYPE=HEAP
   in /home/v/v1-rotate.org/public_html/forum/Sources/Search.php line 1200, which took 0.00064206 seconds.

                     DELETE FROM smf_log_search_topics
                     WHERE id_search = 8
   in /home/v/v1-rotate.org/public_html/forum/Sources/Search.php line 1210, which took 0.00071883 seconds.

                     INSERT IGNORE INTO smf_log_search_topics
                        (id_search, id_topic)
                     SELECT 8, t.id_topic
                     FROM smf_topics AS t
                        INNER JOIN smf_log_search_subjects AS subj1 ON (subj1.id_topic = t.id_topic)
                     WHERE subj1.word LIKE '%dc-8%'
                     LIMIT 1200
   in /home/v/v1-rotate.org/public_html/forum/Sources/Search.php line 1311, which took 0.00309706 seconds.

      INSERT INTO smf_log_errors(`id_member`, `log_time`, `ip`, `url`, `message`, `session`, `error_type`, `file`, `line`)
      VALUES
         (1, 1226603711, SUBSTRING('83.101.13.21', 1, 16), SUBSTRING('?action=search2', 1, 65534), SUBSTRING('The database value you\'re trying to insert does not exist: id_search<br />Function: plushsearch2', 1, 65534), 'be5b203cf1d43bebb0f76fa1d218cb89', 'critical', SUBSTRING('/home/v/v1-rotate.org/public_html/forum/Sources/Search.php', 1, 255), 1538)
   in /home/v/v1-rotate.org/public_html/forum/Sources/Errors.php line 150, which took 0.00123191 seconds.

any ideas?

Regards
Ken

[v1rotate]

anyone has an sollution for this?

greetings
Ken

[青山 素子]

Do you have any modifications installed? Has anything been changed recently?

[v1rotate]

Do you have any modifications installed? Has anything been changed recently?

nope just dutch and german language but thats up since the release of b4

[N3RVE]

Are you using PostgreSQL for the database?
This issue was logged in the BugTracker, but was closed as the developers were unable to replicate the issue, I have re-oped the report.

Bug #2196: empty() check for smf_db_insert causes problems when trying to insert 0 or an empty string

-[n3rve]

[indra00]

I AM ALSO FACING THIS PROBLEM SINCE SMF INSTALLATION! I DONT USE PostgreSQL AND NOW AS MY FORUM HAS GONE BIGGER IT HAS BECOME A REAL ISSUE!

THE SEARCH WORKS FINE IF U SELECT THE OPTION " SEARCH ONLY IN SUBJECT TOPICS" BUT NEITHER QUICK SEARCH OR ANY ELSE SEARCH WORKS IF I DONT CHECK THAT OPTION!

PLEASE HELP ME URGENTLY! I REALLY NEED A SOLUTION!

[aldo]

If you need help make your own topic, don't post your problems in someone elses...

[Rumbaar]

These are the threads I linked too in another thread:
Search error
Search Facility
Search not working after upgrade