Add-On Releases - vBulletin-Glossary

What is vBulletin-Glossary:

A professional glossary with features like :

• crosslinking
• attachments in entries
• edit-history
• synonyms
• optional entryfields
• vb-SEO compatible
• etc.

Installation:

- Upload all files in 'upload' to your server

- set 777-permission for the following directories:

• /vbglossar
• /vbglossar/backup
• /vbglossar/temp

- Import 'product-vbglossar.xml' in AdminCP as Add-On.

Right after the import of the productfile, go and set the usergroups. Afterwards edit the setting in AdminCP (Settings and Crosslinking). Now go to 'manage categories' and create the wanted cats.

Now the glossary should be configured and ready to use.

Update from version 1.0.0 to version 1.0.1/version 1.0.1 to version 1.1.x:

Follow the instruction of a new installation, also check the file permissions. After importing the product (overwrite: yes), check the grouprights and the settings of the glossary as there are some new features. In case the entries won't show up, please rebuild the datastore in the tools-section of the glossarin in admincp.

General:

This addon has been developed by the follwing people (a-z): Andreas, Captainslater, G?rome, Surviver and me. We spent every free minute for this project (coding, translation, tests, etc). Also MrD and Ragtek have tested during the time when this addon got developed.

In directory '/tools' you might find a usefull Script by G?rome. User of vBCMS will find a module for their portal in directory 'vbcms' which shows a random entry of the glossary.

History:

• 1.0.0 - First version
• 1.0.0 PL 1 - Fixed Version by G?rome, users can't write unwnated entries anymore.
• 1.0.1 - overwork of the code, now working with datastore and datamanager. Also we included some small new features into the addon (e. g. revert entries, inlinemod, etc).
• 1.0.2 - overwork of the code, bugs removed, a lot of new features
• 1.0.3 - fixed more small bugs and added new functions (create threads for discussions, more options for crosslinking, better options for mods/admins, etc).
• 1.0.4 - bugfix-release.
• 1.1.0 - added more main-features (synonyms can be used now, optional use of entryfields within categories, PDF-functions included, vB-SEO kompatible, TOC-list, etc)

Languages:

By default you will find the complete germany and english phrases in the product (look at ZIP-file), done by Captainslater. The turkish translation has been done by t?rkg?rc?.

More translations are welcome and it would be nice if those will be published here.

[Andreas]

A hook is missing in profile.php, which is a show-stopper for addons to let users set their privacy options.

[a squared]

Is it not possible to add the hook manually to profile.php?

[i156]

I just updated and everything works fine. But I turned on crosslinking and the popup just came up blank, it didn't have the term text in it. I also noticed that I've got some short terms in there under one glossary. It would be nice to be able enable crosslinking after a minimum number of characters.

[i156]

I'm getting the following database errors every once in a while. I can't figure out what the problem is. Any help?

Database error in vBulletin 3.8.0:

Invalid SQL:

SELECT COUNT(*) AS count
FROM vbglossar_entry AS entry
LEFT JOIN vbglossar_category AS cat ON(cat.id = entry.categoryid)

WHERE entry.status IN (1)
AND cat.status IN(1)
AND userid = 3846
AND name NOT REGEXP("^[a-zA-Z]");

MySQL Error : Column 'name' in where clause is ambiguous
Error Number : 1052
Request Date : Monday, February 2nd 2009 @ 11:18:45 PM
Error Date : Monday, February 2nd 2009 @ 11:18:45 PM
Script : http://www.usacarry.com/forums/vbglo...name&order=asc
Referrer :
IP Address : 82.99.30.51
Username : Unregistered
Classname : vB_Database
MySQL Version :

[i156]

My server went down a few times today due to out of memory error. Not sure if this mod is the issue or what but I got this right before it went down once.

Database error in vBulletin 3.8.0:

Invalid SQL:

INSERT INTO taggregate_temp_1233964560
SELECT threadid, COUNT(*) AS views
FROM threadviews
GROUP BY threadid;

MySQL Error : Table './usacarry/threadviews' is marked as crashed and should be repaired
Error Number : 145
Request Date : Friday, February 6th 2009 @ 08:18:44 PM
Error Date : Friday, February 6th 2009 @ 08:18:49 PM
Script : http://www.usacarry.com/forums/cron.php?rand=1233969519
Referrer : http://www.usacarry.com/forums/glossary-1/
IP Address : 74.170.14.141
Username : Unregistered
Classname : vB_Database
MySQL Version :

[i156]

Repair / Optomize table seems to have fixed this error.

[i156]

More errors this morning. Can anyone help me with this?

Database error in vBulletin 3.8.0:

Invalid SQL:

SELECT COUNT(*) AS count
FROM vbglossar_entry AS entry
LEFT JOIN vbglossar_category AS cat ON(cat.id = entry.categoryid)

WHERE entry.status IN (1)
AND cat.status IN(1)
AND userid = 767
AND name LIKE("B%");

MySQL Error : Column 'name' in where clause is ambiguous
Error Number : 1052
Request Date : Saturday, February 7th 2009 @ 02:51:53 AM
Error Date : Saturday, February 7th 2009 @ 02:51:53 AM
Script : http://www.usacarry.com/forums/vbglo...name&order=asc
Referrer :
IP Address : 82.99.30.5
Username : Unregistered
Classname : vB_Database
MySQL Version :

[i156]

Got home and had about 5 db error emails like the ones above. Can anyone help me with this? I am almost to the point where I am going to disable this plugin and use something else in its place.

[i156]

I'm going to look for an alternative plugin since I'm getting no response here and constantly getting db errors everyday. I hate to do this but I can't just leave my site broken especially when I can't figure out exactly what is broken.

[t?rkg?rc?]

@i156
I'm getting the same error