Follow us on Twitter

1. Check the Documentation

2. Make a search

3. Read Support Rules
before posting

  • Index
  • » AceSEF
  • » Extensions Support
  • » Solved Issues
  • » Trouble with com_glossary extension...

Trouble with com_glossary extension after upgrade

Trouble with com_glossary extension after upgrade

#1 Top

Trouble with com_glossary extension after upgrade

After upgrading AceSEF to 1.5.2 and the Glossary extension to the latest release, I get to undesirable effects.  The first are these messages in my Apache error log, the second are my Apache processes growing out of control, using all available RAM, and crashing my server.

Code:

[Tue Sep 21 22:06:39 2010] [error] [client 174.132.18.34] PHP Fatal error:  Uncaught exception 'Exception' with message 'AceDatabase::loadRow failed. (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 '' at line 1 SQL=SELECT name FROM jos_glossaries WHERE id =)' in /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/library/database.php:78\nStack trace:\n#0 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/extensions/com_glossary.php(85): AceDatabase->loadRow('SELECT name FRO...')\n#1 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/extensions/com_glossary.php(102): AceSEF_com_glossary->_getGlossary(NULL)\n#2 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/extensions/com_glossary.php(42): AceSEF_com_glossary->_getTerm(85)\n#3 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/library/router.php(432): AceSEF_com_glossary->build(Array, Array, true, NULL, false)\n#4 /usr/local/www/data/tech-faq.com/libraries/joomla/m in /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/library/database.php on line 78, referer: http://www.bing.com:80/search?q=Radio+faza+2010&first=41&FORM=PORE

[Tue Sep 21 22:06:39 2010] [error] [client 58.145.148.3] PHP Fatal error:  Uncaught exception 'Exception' with message 'AceDatabase::loadRow failed. (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 '' at line 1 SQL=SELECT name FROM jos_glossaries WHERE id =)' in /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/library/database.php:78\nStack trace:\n#0 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/extensions/com_glossary.php(85): AceDatabase->loadRow('SELECT name FRO...')\n#1 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/extensions/com_glossary.php(102): AceSEF_com_glossary->_getGlossary(NULL)\n#2 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/extensions/com_glossary.php(42): AceSEF_com_glossary->_getTerm(458)\n#3 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/library/router.php(432): AceSEF_com_glossary->build(Array, Array, true, NULL, false)\n#4 /usr/local/www/data/tech-faq.com/libraries/joomla/ in /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/library/database.php on line 78, referer: http://www.google.com.au/m?q=what+is+dns&btnG=Google+Search&hl=en&source=wax&ie=UTF-8&oe=UTF-8
[Tue Sep 21 22:06:39 2010] [error] [client 116.125.140.10] PHP Fatal error:  Uncaught exception 'Exception' with message 'AceDatabase::loadRow failed. (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 '' at line 1 SQL=SELECT name FROM jos_glossaries WHERE id =)' in /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/library/database.php:78\nStack trace:\n#0 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/extensions/com_glossary.php(85): AceDatabase->loadRow('SELECT name FRO...')\n#1 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/extensions/com_glossary.php(102): AceSEF_com_glossary->_getGlossary(NULL)\n#2 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/extensions/com_glossary.php(42): AceSEF_com_glossary->_getTerm(328)\n#3 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/library/router.php(432): AceSEF_com_glossary->build(Array, Array, true, NULL, false)\n#4 /usr/local/www/data/tech-faq.com/libraries/joomla/ in /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/library/database.php on line 78, referer: http://www.tech-faq.com/
[Tue Sep 21 22:06:39 2010] [error] [client 68.55.245.159] PHP Fatal error:  Uncaught exception 'Exception' with message 'AceDatabase::loadRow failed. (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 '' at line 1 SQL=SELECT name FROM jos_glossaries WHERE id =)' in /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/library/database.php:78\nStack trace:\n#0 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/extensions/com_glossary.php(85): AceDatabase->loadRow('SELECT name FRO...')\n#1 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/extensions/com_glossary.php(102): AceSEF_com_glossary->_getGlossary(NULL)\n#2 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/extensions/com_glossary.php(42): AceSEF_com_glossary->_getTerm(108)\n#3 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/library/router.php(432): AceSEF_com_glossary->build(Array, Array, true, NULL, false)\n#4 /usr/local/www/data/tech-faq.com/libraries/joomla/ in /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/library/database.php on line 78, referer: http://www.google.com/m?hl=en&gl=us&client=ms-android-motorola&source=android-browser-key&q=clear+dns+cache
[Tue Sep 21 22:06:39 2010] [error] [client 124.178.250.18] PHP Fatal error:  Uncaught exception 'Exception' with message 'AceDatabase::loadRow failed. (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 '' at line 1 SQL=SELECT name FROM jos_glossaries WHERE id =)' in /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/library/database.php:78\nStack trace:\n#0 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/extensions/com_glossary.php(85): AceDatabase->loadRow('SELECT name FRO...')\n#1 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/extensions/com_glossary.php(102): AceSEF_com_glossary->_getGlossary(NULL)\n#2 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/extensions/com_glossary.php(42): AceSEF_com_glossary->_getTerm(608)\n#3 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/library/router.php(432): AceSEF_com_glossary->build(Array, Array, true, NULL, false)\n#4 /usr/local/www/data/tech-faq.com/libraries/joomla/ in /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/library/database.php on line 78
[Tue Sep 21 22:06:39 2010] [error] [client 195.212.74.98] PHP Fatal error:  Uncaught exception 'Exception' with message 'AceDatabase::loadRow failed. (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 '' at line 1 SQL=SELECT name FROM jos_glossaries WHERE id =)' in /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/library/database.php:78\nStack trace:\n#0 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/extensions/com_glossary.php(85): AceDatabase->loadRow('SELECT name FRO...')\n#1 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/extensions/com_glossary.php(102): AceSEF_com_glossary->_getGlossary(NULL)\n#2 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/extensions/com_glossary.php(42): AceSEF_com_glossary->_getTerm(558)\n#3 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/library/router.php(432): AceSEF_com_glossary->build(Array, Array, true, NULL, false)\n#4 /usr/local/www/data/tech-faq.com/libraries/joomla/ in /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/library/database.php on line 78, referer: http://www.google.nl/search?hl=nl&source=hp&q=vbs+gebruiken&aq=f&aqi=&aql=&oq=&gs_rfai=
[Tue Sep 21 22:06:40 2010] [error] [client 174.94.73.247] PHP Fatal error:  Uncaught exception 'Exception' with message 'AceDatabase::loadRow failed. (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 '' at line 1 SQL=SELECT name FROM jos_glossaries WHERE id =)' in /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/library/database.php:78\nStack trace:\n#0 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/extensions/com_glossary.php(85): AceDatabase->loadRow('SELECT name FRO...')\n#1 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/extensions/com_glossary.php(102): AceSEF_com_glossary->_getGlossary(NULL)\n#2 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/extensions/com_glossary.php(42): AceSEF_com_glossary->_getTerm(438)\n#3 /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/library/router.php(432): AceSEF_com_glossary->build(Array, Array, true, NULL, false)\n#4 /usr/local/www/data/tech-faq.com/libraries/joomla/ in /usr/local/www/data/tech-faq.com/administrator/components/com_acesef/library/database.php on line 78, referer: http://www.google.ca/url?sa=t&source=web&cd=2&ved=0CCcQFjAB&url=http%3A%2F%2Fwww.tech-faq.com%2Ffr%2Fhow-to-send-text-messages-free.html&rct=j&q=texter%20un%20cellulaire%20gratuitement&ei=soCZTNeTEIP88Aa79NW2AQ&usg=AFQjCNEEtZq5DMwpJRzG0GFK9LdLdGxmeQ

Will Spencer
VIP Customer
useravatar
Offline
73 Posts
User info in posts
Administrator has disabled public posting
#2 Top

Re: Trouble with com_glossary extension after upgrade

I have the same problem.
Please help.

Kind regards
J

J J
VIP Customer
useravatar
Offline
5 Posts
User info in posts
Administrator has disabled public posting
#3 Top

Re: Trouble with com_glossary extension after upgrade

Issue fixed, upgrade Glossary extension to 1.5.1, clean cache first.

Denis Dulici
Administrator
ranks
useravatar
Online
2317 Posts
User info in posts
Administrator has disabled public posting
#4 Top

Re: Trouble with com_glossary extension after upgrade

Hi Alex,

is this upgrade for Glossary v2.64, or Glossary v2.73?

Kind regards
J

J J
VIP Customer
useravatar
Offline
5 Posts
User info in posts
Administrator has disabled public posting
#5 Top

Re: Trouble with com_glossary extension after upgrade

It is for the last version v.2.73.

Ratings/Reviews on the Joomla Extension Directory are always appreciated.

Gilbert Lici
Administrator
ranks
useravatar
Offline
156 Posts
User info in posts
Administrator has disabled public posting
#6 Top

Re: Trouble with com_glossary extension after upgrade

Cool! Thanks a lot!!!
Do you know why i get this error in IE8? In Menue of Glossary 2.73:

Meldung: Das Objekt unterstützt diese Eigenschaft oder Methode nicht.
Zeile: 12
Zeichen: 43
Code: 0
URI: http://www.mydomain.de/components/com_g … puretip.js

Any ideo? I know this is not because of acesef, but the remosity guy is not answering...

Kind regards
J

J J
VIP Customer
useravatar
Offline
5 Posts
User info in posts
Administrator has disabled public posting
  • Index
  • » AceSEF
  • » Extensions Support
  • » Solved Issues
  • » Trouble with com_glossary extension...