vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Add-On Releases - vBulletin-Glossary (https://vborg.vbsupport.ru/showthread.php?t=188189)

Andreas 01-26-2009 05:14 PM

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

a squared 01-26-2009 10:21 PM

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

i156 02-01-2009 10:04 PM

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 02-03-2009 05:07 PM

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

Quote:

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 02-07-2009 12:37 AM

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.

Quote:

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 02-07-2009 12:43 AM

Repair / Optomize table seems to have fixed this error.

i156 02-07-2009 11:08 AM

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

Quote:

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 02-07-2009 11:01 PM

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 02-08-2009 12:20 PM

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? 02-08-2009 06:48 PM

@i156
I'm getting the same error

t?rkg?rc? 02-08-2009 07:03 PM

Quote:

Originally Posted by WildSoftCat (Post 1621582)
Problem with popup showing in different coding (seems as unknown language :D) fixed.

Edit functions_vbglossar.php in include folder :

1. Find

PHP Code:

function fetch_glossar_items()
{
    global 
$vbulletin

Replace with :

PHP Code:

function fetch_glossar_items()
{
    global 
$vbulletin$stylevar

2. Find :

PHP Code:

$item['description'] = htmlentities($item['description']); 

Replace with :

PHP Code:

$item['description'] = htmlentities($item['description'], ENT_COMPAT,  "$stylevar[charset]); 

Done :)

incompatible with version 1.1.0

i156 02-08-2009 10:15 PM

Quote:

Originally Posted by t?rkg?rc? (Post 1737976)
@i156
I'm getting the same error

I have talked with someone that said they can probably fix it but I was hoping to hear from the person that actually made this module instead of paying for someone to fix it. Oh well.

Chadi 02-18-2009 01:13 AM

Crosslinking css area in styles > main css is not working at all.

As a matter of fact, the mod is over-riding other css for another mod that works globally (logos.com pop-up scripture tool) that automatically highlights Scripture verses in hyperlink css. Even that is getting over-ridden by this glossary mod.


https://vborg.vbsupport.ru/external/2009/02/43.png

hover, orange link not showing

https://vborg.vbsupport.ru/external/2009/02/44.png

no hover, no css

https://vborg.vbsupport.ru/external/2009/02/45.png


The above problem happens inside the glossary itself only, not forum posts.


Another problem is that the "Display of x characters in preview popup for crosslink" is void, not doing anything. I even changed it to 1000 characters and it still displays about 250-300 chacters max on words that have over even 30k characters total. Yes, I also increased max width to 350 from default 250. The width changed, not max characters.

i156 02-18-2009 01:46 AM

Vossi, I see you have logged in since I posted the errors that I'm constantly getting everyday. I've moved to a new server so didn't get someone to fix it yet. Can you possibly tell me why I'm getting these errors before I have to pay for someone to fix it? I'm also trying to figure out if it is worth paying to get fixed or just remove the modules from my site and just deal with losing all that content.

My latest error, few minutes ago:
Quote:

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 = 1259
AND name LIKE("F%");

MySQL Error : Column 'name' in where clause is ambiguous
Error Number : 1052
Request Date : Tuesday, February 17th 2009 @ 10:42:07 PM
Error Date : Tuesday, February 17th 2009 @ 10:42:07 PM
Script : http://www.usacarry.com/forums/vbglo...name&order=ASC
Referrer :
IP Address : 82.99.30.47
Username : Unregistered
Classname : vB_Database
MySQL Version :

alehawk 02-18-2009 12:01 PM

i156 I got to different forums running and I got that error in one of them, is not the server, maybe this error is because some other product.
I read about this and it is said that is a google spider issue and you must disalow vbglossar.php in robots.txt
I havent tested yet.
Maybe you can give it a try.

ragtek 02-18-2009 12:10 PM

Quote:

Originally Posted by i156 (Post 1747470)
Vossi, I see you have logged in since I posted the errors that I'm constantly getting everyday. I've moved to a new server so didn't get someone to fix it yet. Can you possibly tell me why I'm getting these errors before I have to pay for someone to fix it? I'm also trying to figure out if it is worth paying to get fixed or just remove the modules from my site and just deal with losing all that content.

My latest error, few minutes ago:

edit the vbglossar.php

search
- line 2887
PHP Code:

$condition ' AND name NOT REGEXP("^[a-zA-Z]")'

replace with
PHP Code:

$condition ' AND entry.name NOT REGEXP("^[a-zA-Z]")'

- line 2892
PHP Code:

$condition ' AND name LIKE("' $db->escape_string_like($ltr) . '%")'

replace with
PHP Code:

$condition ' AND entry.name LIKE("' $db->escape_string_like($ltr) . '%")'

- in line 2947
PHP Code:

AND userid " . intval($userid) . " 

replace with
PHP Code:

AND entry.userid " . intval($userid) . " 


i156 02-18-2009 12:17 PM

Thanks. I've just made these changes. Hopefully that fixed my problem!

alehawk 02-19-2009 11:43 AM

Yes, yesterday I made the same changes and I didnt get any error email since then.

i156 02-19-2009 08:54 PM

Same here, no errors since.

ragtek 02-19-2009 09:00 PM

fine fine

Chadi 02-19-2009 11:12 PM

Quote:

Originally Posted by chadi (Post 1747454)
Crosslinking css area in styles > main css is not working at all.

As a matter of fact, the mod is over-riding other css for another mod that works globally (logos.com pop-up scripture tool) that automatically highlights Scripture verses in hyperlink css. Even that is getting over-ridden by this glossary mod.


https://vborg.vbsupport.ru/external/2009/02/43.png

hover, orange link not showing

https://vborg.vbsupport.ru/external/2009/02/44.png

no hover, no css

https://vborg.vbsupport.ru/external/2009/02/45.png


The above problem happens inside the glossary itself only, not forum posts.


Another problem is that the "Display of x characters in preview popup for crosslink" is void, not doing anything. I even changed it to 1000 characters and it still displays about 250-300 chacters max on words that have over even 30k characters total. Yes, I also increased max width to 350 from default 250. The width changed, not max characters.


Would appreciate help on the above.

exportforce 02-28-2009 05:52 PM

Quote:

Initialisiere Datastore/initialize datastore ...
Warnung: require_once([path]/includes/adminfunctions_vbglossar.php) [function.require-once]: failed to open stream: No such file or directory in [path]/admincp/plugin.php(1985) : eval()'d code (Zeile 22)

Fatal error: require_once() [function.require]: Failed opening required '/var/www/web10/html/forum/includes/adminfunctions_vbglossar.php' (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/web10/html/forum/admincp/plugin.php(1985) : eval()'d code on line 22
VBulletin 3.7.3
Won't get it to run.
Help please.

ragtek 03-02-2009 04:55 PM

Is this by trying to install the glossary?
if yes:

You've read the readme.txt??
Quote:

Copy all files and directories of '/upload' into your forumroot.
The following directories need 0777 FTP-permissions:

/vbglossar
/vbglossar/backup
/vbglossar/temp

Afterwards import the product file in AdminCP.
You must upload the files befor you import the productfile!

PitchouneN64ngc 03-06-2009 11:24 AM

As I'm translating your mod into French, i will report any bug I can found.

- When you're using MySQLi database connection, when you export a backup, you can see 2 lines of error code. It comes from includes/class_vbcsv_vbglossar.php at line 345. Change:
PHP Code:

while ($tablefields mysql_fetch_row($headerresult)) 

To
PHP Code:

while ($tablefields $this->registry->db->fetch_row($headerresult)) 

- In vBulletin Options, the values in dropdown menus for external addons are hardcoded into the options.

- In admin_vbglossar.php at line 701, you have some hardcoded text:
PHP Code:

$cell[] = "<b>$date$time Uhr</b>"

- The phrases 'setting_vbglossar_tagbadwordsvbglossar_taggoodwor ds_desc' and 'setting_vbglossar_tagbadwordsvbglossar_taggoodwor ds_title' are not used. You can delete them.

Anyway, when I finish this translation, i'll PM you to upload it with the mod as default ;)

PitchouneN64ngc 03-06-2009 08:38 PM

An other thing:
- Before 1.1.0, the attachment datamanager file seems named class_attachment_vbglossar.php. and when you manage attachments to be in database (for example), it tells you the file didn't exist. The file is now named class_dm_attachment_vbglossar.php.

Edit line 296 of admincp/attachment_vbglossar.php in consequence.

And I see the attachment system is buggy with me. When I'm logged in, it tells me I'm userid 0 (line 529 of includes/class_dm_attachment_vbglossar.php). This is due because $entryinfo['userid'] is not defined from vbglossar_newattachment.php (and in this way, defined to be 0).

According to this bug report, you can do the same.

PS: in this same file (vbglossar_newattachment.php), "$entryinfo = array();" is defined 2 times.

arabuser 03-12-2009 08:08 AM

I see nobody answered the guys who reported Duplicate error (( MySQL Error : Duplicate column name 'groupvbglossar' ))

when I tried first time to install the addon it take long time proccessing the script and after that time it didnt give me complete page just white error page when I tried again to install it always get the message (( MySQL Error : Duplicate column name 'groupvbglossar' )) and I dont find the product to uninstall it coz it didnt completed correctly so how I can skip this error or uninstall the product to try install it again without error.

ragtek 03-12-2009 08:28 AM

you'll have to delete the groupvbglossar column with phpmyadmin
then you can try to install it a second time

arabuser 03-13-2009 12:25 PM

thanks ragetak for your help I deleted groupvbglossar column from usergroup table
also I was need to delete the columns crosslink and popup from user table

im now looking for some help to show bbcode include images in popup and display arabic characterset

Gostemilov 03-18-2009 01:48 PM

PHP Code:

Database error in vBulletin 3.7.4:

Invalid SQL:

            
SELECT datelinethumbnail_datelinefilenamefilesizevisibleattachmentidcounter,
                IF(
thumbnail_filesize 010) AS hasthumbnailthumbnail_filesize,
                
attachmenttype.thumbnail AS build_thumbnailattachmenttype.newwindow
            FROM vbglossar_attachment 
AS attachment
            LEFT JOIN attachmenttype 
AS attachmenttype USING (extension)
            
WHERE ((posthash 'ade354c18b97ab4fe7828f5bee72dbdd')
                AND 
userid 1)
            
ORDER BY attachmentid;

MySQL Error   Illegal mix of collations (cp1251_bin,IMPLICIT) and (latin1_bin,IMPLICIT) for operation '='
Error Number  1267
Request Date  
WednesdayMarch 18th 2009 05:46:50 PM
Error Date    
WednesdayMarch 18th 2009 05:46:50 PM
Script        
http://photoshopia.ru/forum/vbglossar.php?do=updateentry
Referrer      http://photoshopia.ru/forum/vbglossar.php?do=editentry&catid=7
IP Address    62.182.79.184
Username      
Gostemilov
Classname     
vb_database
MySQL Version 
4.1.22-standard 

How to fix this problem? Thanks

Gostemilov 03-18-2009 03:03 PM

Decision found. PMA -> vbglossar_attchments ->cp1251_bin -> latin1_bin

profmikel 03-28-2009 03:54 PM

Is this mod available for 3.8x?

I tried to install with no success

interfx 04-06-2009 03:19 PM

Quote:

Originally Posted by MARKETPROFITS (Post 1779549)
Will this work on 3.8.x?

I have the same question, were youable to make it work in 3.8.x?

interfx 04-07-2009 06:53 PM

I've tried to install with 3.8.x, but can not get it working... is this mod supported? or can we donate $$$ to have a mod that is supported? and that it will work?

chick 04-10-2009 08:50 AM

Quote:

Originally Posted by MARKETPROFITS (Post 1779549)
Will this work on 3.8.x?


yes, no problems

chick 04-10-2009 09:00 AM

The time output on the PDF is backward, where do I change that at? Please!

Time output on PDF should be (for me) month day year.... currently it is....... day month year

Please advise.

kushal 04-10-2009 12:46 PM

The english phrases in usergroup permissions are completely missing, I did install the english phrases too.

chick 04-12-2009 09:02 PM

Quote:

Originally Posted by kushal (Post 1788173)
The English phrases in usergroup permissions are completely missing, I did install the English phrases too.

Same here, I had to correct many misspelled words.

Coder where do I fix the PDF output at???

There are no spaces between name and time, and time is wrong.

BB code not parsing upon overview (does parse when you open the glossary term and edit)

biocyberman 04-18-2009 11:22 AM

How do we force no duplicate entries? Before a new entry is posted, it will be nice if there is a query to check if that entry (title) has been posted. Or even better, an ajax to query and suggest existing entries that is similar or identical to the one user is going to post.

arabuser 04-18-2009 05:35 PM

anyone can help me I need to make link when the user click it, It is search for the link keyword inside glossary entries and show result of all match results to the keyword in the link for example:

mykeyword

I wasnt able to get any result all time it is go to seach page or give me message There were no search results how I can do this !!!

DieselMinded 04-25-2009 08:57 PM

will this work with 3.8 ? is there a paid version ?


All times are GMT. The time now is 02:25 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01653 seconds
  • Memory Usage 1,876KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (14)bbcode_php_printable
  • (13)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete