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.

Wim

stamboommeijberg.nl

 

 

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.

Wim Meijberg

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.

Wim

stamboommeijberg.nl

 

 

grebjiem wrote:

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

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.

Wim Meijberg

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.

Wim

stamboommeijberg.nl