Search Forums
Forums
Kiwitrees on Twitter
    Tags

    Fancy imagebar, links, Histo, PHP, error, My Page, MAC, 3.0.0. setup, fact, getClientIp, session, zend, cousins, colors theme, check, 3.0.0 widgets, googlemap, latest version, data errors, tools, hover, 3.2.2, spouse, research, age, webtrees, edit, kiwitrees theme, research tasks, logout, missing data, MYSQL, white screen, Canada, Favourites, FAQ, mobile, ckeditor, time, emmigration, media_links, menus, privacy, language, sanity, 7.0, statistics, road map, design, wish, prefix, gender change, follow, 3.2.0, release, Support/Bug Reporting, 1939 Register, pdf, help, image

    Topic:   Search box  

    This topic contains 5 replies, has 2 voices, and was last updated by grebjiem grebjiem 1 year, 4 months ago.

    Viewing 6 posts - 1 through 6 (of 6 total)
    • Author
      Posts
    • #6852
      grebjiem
      grebjiem
      Participant

      116 posts

      Wanted to search in the right top corner for my last name, the following errors pop up.

      Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row’ in /home/stambo1q/public_html/kiwitrees/library/WT/DBStatement.php:91 Stack trace: #0 [internal function]: PDOStatement->execute() #1 /home/stambo1q/public_html/kiwitrees/library/WT/DBStatement.php(91): call_user_func_array(Array, Array) #2 /home/stambo1q/public_html/kiwitrees/library/WT/DBStatement.php(103): WT_DBStatement->__call(‘execute’, Array) #3 /home/stambo1q/public_html/kiwitrees/library/WT/DBStatement.php(103): WT_DBStatement->execute() #4 /home/stambo1q/public_html/kiwitrees/includes/functions/functions_db.php(969): WT_DBStatement->__call(‘fetchAll’, Array) #5 /home/stambo1q/public_html/kiwitrees/includes/functions/functions_db.php(969): WT_DBStatement->fetchAll(2) #6 /home/stambo1q/public_html/kiwitrees/library/WT/Controller/Search.php(505): search_stories(Array, Array, ‘AND’) #7 /home/stambo1q/public_html/kiwitrees/library/WT/Controller/Search.php(268): WT_Controller_Sear in /home/stambo1q/public_html/kiwitrees/library/WT/DBStatement.php on line 91
      Fatal error: Call to a member function getClientIp() on null in /home/stambo1q/public_html/kiwitrees/includes/session.php on line 351

      Error log is full of errors
      PHP Warning: Invalid argument supplied for foreach() in /home/stambo1q/public_html/kiwitrees/library/WT/MenuBar.php on line 137
      PHP Fatal error: Call to a member function getClientIp() on null in /home/stambo1q/public_html/kiwitrees/includes/session.php on line 351

      and the last one:
      Stack trace:
      #0 [internal function]: PDOStatement->execute()
      #1 /home/stambo1q/public_html/kiwitrees/library/WT/DBStatement.php(91): call_user_func_array(Array, Array)
      #2 /home/stambo1q/public_html/kiwitrees/library/WT/DBStatement.php(103): WT_DBStatement->__call(‘execute’, Array)
      #3 /home/stambo1q/public_html/kiwitrees/library/WT/DBStatement.php(103): WT_DBStatement->execute()
      #4 /home/stambo1q/public_html/kiwitrees/includes/functions/functions_db.php(969): WT_DBStatement->__call(‘fetchAll’, Array)
      #5 /home/stambo1q/public_html/kiwitrees/includes/functions/functions_db.php(969): WT_DBStatement->fetchAll(2)
      #6 /home/stambo1q/public_html/kiwitrees/library/WT/Controller/Search.php(505): search_stories(Array, Array, ‘AND’)
      #7 /home/stambo1q/public_html/kiwitrees/library/WT/Controller/Search.php(268): WT_Controller_Sear in /home/stambo1q/public_html/kiwitrees/library/WT/DBStatement.php on line 91
      [29-Jul-2016 07:50:18 Europe/Amsterdam] PHP Fatal error: Call to a member function getClientIp() on null in /home/stambo1q/public_html/kiwitrees/includes/session.php on line 351

      No errors in the cpanel log file.

      #6865
      kiwi
      kiwi
      Keymaster

      1595 posts

      Wim

      Wanted to search in the right top corner for my last name, the following errors pop up.

      Sorry for the delay replying to this one. Not ignoring it, just trying with some difficulty to figure out the cause. I know where it is (a complex piece of code used to search texts from the stories module), but haven’t yet figured what combination of circumstances will create this error. I’m sure it’s not unique to your site, but it is so far the only place I have seen it happen.

      If I have time tomorrow I will log in to your database and try and reproduce the same query there. then I will know if it’s a php problem (trying to create a MySQL query) or the MySQL query just doesn’t always work.

      Error log is full of errors

      This I know you have now fixed, It’s the same as Paul’s issue yesterday.

      and the last one:

      Actually this is two errors. the rows #0 through to #7 are part of the first issue. But the last one is something different:

      [29-Jul-2016 07:50:18 Europe/Amsterdam] PHP Fatal error: Call to a member function getClientIp() on null in /home/stambo1q/public_html/kiwitrees/includes/session.php on line 351

      This is a small issue in the contacts module. I have already fixed it for the next release. It won’t be causing any obvious issues for you so I recommend you ignore it until the next update.

      Nigel
      My personal kiwitrees site is www.our-families.info
      1 user thanked author for this post.
      #6866
      grebjiem
      grebjiem
      Participant

      116 posts

      Sorry for the delay replying to this one. Not ignoring it, just trying with some difficulty to figure out the cause. I know where it is (a complex piece of code used to search texts from the stories module), but haven’t yet figured what combination of circumstances will create this error. I’m sure it’s not unique to your site, but it is so far the only place I have seen it happen.

      I only get this error when it’s my last name, every other name, for as far I have seen, has given no error.
      For now I use the search option for my last name in the menu, this does the search without errors.

      #6882
      kiwi
      kiwi
      Keymaster

      1595 posts

      For now I use the search option for my last name in the menu, this does the search without errors.

      In that option, if you tick to select “stories” in the search then you will get the same error.

      Nigel
      My personal kiwitrees site is www.our-families.info
      #6883
      kiwi
      kiwi
      Keymaster

      1595 posts

      I have fixed this, and uploaded the revised files to your site. Let me know if it’s now OK.

      Nigel
      My personal kiwitrees site is www.our-families.info
      1 user thanked author for this post.
      #6884
      grebjiem
      grebjiem
      Participant

      116 posts

      I didn’t see an new error this morning. The last error I saw was at 04-Aug-2016 00:01:38 Europe/Amsterdam], guesseyou were testing at that time.

    Viewing 6 posts - 1 through 6 (of 6 total)

    You must be logged in to reply to this topic.