Bienvenue, Invité
Nom d'utilisateur : Mot de passe :


I have developed a range of add-ons for webtrees available only from my kiwitrees.net web site: kiwitrees.net/simpl-add-ons/. For any queries related to those items contact me direct from that site.

SUJET : Customized install - Reason for fatal error?

Customized install - Reason for fatal error? il y a 6 ans 8 mois #1

  • adem_genc
  • Portrait de adem_genc
  • Hors Ligne
  • Junior
  • Messages : 219
Hello,

The reason for this error is that?
<b>Fatal error</b>: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND l_type LIKE 'CHIL' AND l_from LIKE 'A2'' at line 1' in D:\www\www\webtrees\library\WT\DBStatement.php:88
Stack trace:
#0 [internal function]: PDOStatement->execute()
#1 D:\www\www\webtrees\library\WT\DBStatement.php(88): call_user_func_array(Array, Array)
#2 D:\www\www\webtrees\library\WT\DBStatement.php(100): WT_DBStatement->__call('execute', Array)
#3 D:\www\www\webtrees\library\WT\DBStatement.php(100): WT_DBStatement->execute()
#4 D:\www\www\webtrees\modules_v3\simpl_cousins\module.php(92): WT_DBStatement->__call('fetchAll', Array)
#5 D:\www\www\webtrees\modules_v3\simpl_cousins\module.php(92): WT_DBStatement->fetchAll(2)
#6 D:\www\www\webtrees\individual.php(258): simpl_cousins_WT_Module->getTabContent()
#7 {main}
thrown in <b>D:\www\www\webtrees\library\WT\DBStatement.php</b> on line <b>88</b><br />


Adem
webtrees 1.3.2
PHP Version: 5.3.13
MySQL Version: 5.0.91-log
L'administrateur a désactivé l'accès en écriture pour le public.

Customized install - Reason for fatal error? il y a 6 ans 8 mois #2

  • ToyGuy
  • Portrait de ToyGuy
  • Hors Ligne
  • Moderator
  • Live like it's Christmas every day - Santa Stephen
  • Messages : 4925
Adem
Your signature states you are using webtrees v1.3.1. Is this so? If it is, please upgrade and test your system again. If you have, be sure you don't have mixed files and that you completely replaced the older version with the new files and code.
If it is necessary to repost, please advise us how to duplicate this error. Where were you in the program? What were you attempting to do? ETC.

EDIT: simpl_cousins_WT_Module->getTabContent
You are using a custom module. If you did upgrade, did you also upgrade this module?
Thanks.
Santa Stephen the Fabled Santa
Latest webtrees at MyArnolds.com
Hosted by webtreesonline.com, a division of GeneHosts LLC
MacOS 10.6.8, Apache 2.2+, PHP 5.4.16, MySQL 5.5.28
Dernière édition: il y a 6 ans 8 mois par ToyGuy.
L'administrateur a désactivé l'accès en écriture pour le public.

Customized install - Reason for fatal error? il y a 6 ans 8 mois #3

  • kiwi
  • Portrait de kiwi
  • Hors Ligne
  • Platinum
  • Messages : 4949
Adem

Stephen's questions are quite right (you really should upgrade to 1.3.2 as soon as possible) BUT, it will not fix this problem. So we can still help, I hope.

I have moved this topic to the simpl_add-ons category, as that is where the error appears (in simpl_cousins), but I suspect the problem is either incorrect or missing data.

The code
AND l_type LIKE 'CHIL' AND l_from LIKE '
appears in four places in the module, so it is hard to be certain which causes the problem.

But clearly it is the 'A2' that is the issue. That should be a Xref for one of the families. Is "A2" a correct reference for your family records?

EDIT: I can see that A2 is correct. Have you used "Check for errors" in administration to see if you have any broken links?
Nigel

www.our-families.info

Hosted at:
Follow me at:
Dernière édition: il y a 6 ans 8 mois par kiwi.
L'administrateur a désactivé l'accès en écriture pour le public.

Customized install - Reason for fatal error? il y a 6 ans 8 mois #4

  • adem_genc
  • Portrait de adem_genc
  • Hors Ligne
  • Junior
  • Messages : 219
English Family->Turkish Aile "A2" a family
This error available in all areas



Now, no error, Disabled Simpl cousins

Thanks
webtrees 1.3.2
PHP Version: 5.3.13
MySQL Version: 5.0.91-log
L'administrateur a désactivé l'accès en écriture pour le public.

Customized install - Reason for fatal error? il y a 6 ans 8 mois #5

  • kiwi
  • Portrait de kiwi
  • Hors Ligne
  • Platinum
  • Messages : 4949
Adem

In the last few hours since your report we had another report identical to yours. webtrees.net/index.php/en/forum/26-the-s...dual-pages-disappear

As a result I found a problem in that version of simpl_cousins. You can either download a copy of the replacement from that discussion (post #10), or in an hour or so there will be a new version at my kiwitrees site.
Nigel

www.our-families.info

Hosted at:
Follow me at:
L'administrateur a désactivé l'accès en écriture pour le public.

Customized install - Reason for fatal error? il y a 6 ans 8 mois #6

  • adem_genc
  • Portrait de adem_genc
  • Hors Ligne
  • Junior
  • Messages : 219
Okay, thank you very much
webtrees 1.3.2
PHP Version: 5.3.13
MySQL Version: 5.0.91-log
L'administrateur a désactivé l'accès en écriture pour le public.
Propulsé par Kunena