Welcome to Geeklog Tuesday, December 12 2017 @ 03:25 am EST


Status: offline

Blaine

Forum User
Full Member
Registered: 16/07/2002
Posts: 1233
Location:Canada
Thanks very much for the feedback and noted items to address. Nothing critical and as noted, we are using this version here on geeklog.net and portalparts.com. I hope to have time over the next few days to review/address but would like to wait and see if there are any more issues reported.

I've also not seen an issue using basic html in comments but really had never seen much of a use so had not really exercised the comment feature with HTML. Just did a few more tests and saw no issues on my test instance - certainly no JS Error.
Geeklog components by PortalParts -- www.portalparts.com

Status: offline

LWC

Forum User
Full Member
Registered: 19/02/2004
Posts: 818
You're right, I've removed my comments about the comments (no pun intended). It was a Fckeditor issue. The onload javascript event it uses is disabled by my software unless I know in advance to bypass it.

I can't think of any more bugs except hardcoded language (like my hints above).

Status: offline

samstone

Forum User
Full Member
Registered: 29/09/2002
Posts: 820
LWC,

A little digression, since you mentioned FCKeditor. Have you tried FCKeditor 2.2 yet. It runs much smoother. I've never had JS error ever since I upgraded it. It works well with Blaine's original GL integration, with very little or no tweeks, that I remember.

Sam

Status: offline

Blaine

Forum User
Full Member
Registered: 16/07/2002
Posts: 1233
Location:Canada
Thanks very much for your testing and feedback. I've released version 1.5.1 which should address the noted items. I also have added the autotag feature.

For reference, this is the comment I've added to the download.

Archive has been updated to version 1.5.1
  • Added autotag feature - now able to use [ file:10 ] or [ file:10 here ] where 10 is the fileid
  • Corrected a few html issues in code and templates
  • Added script singlefile.php which was no longer being used but is needed for backwards compibility if your site had site content linking to existing files
  • Added test for anonymous access enabled for the whatsnew listing
  • Correction to auto set config settings feature for new installs
  • Removed dependency on $REMOTE_ADDR (Register Globals on variable)
  • Updated readme.htm - documentation
  • plugins update feature will update the version

Over 15 files changed - recommended that you replace all files. Follow the documented update procedure.
Geeklog components by PortalParts -- www.portalparts.com

Status: offline

LWC

Forum User
Full Member
Registered: 19/02/2004
Posts: 818
samstone, I didn't know it was up to me...how can I upgrade without Geeklog upgrading it? It's a special version for Geeklog after all.
How do I even check what's my fckeditor's version? fckeditor/_whatsnew.html reports 2.1.1 but why should I trust an independent text file?

Blaine, wow - that was a quick update! As you can see above, I've confirmed most of the bugs (that I brought up) were indeed fixed.

Status: offline

samstone

Forum User
Full Member
Registered: 29/09/2002
Posts: 820
Thanks for the quick release, Blaine.

LWC, Blaine's GL_FCKeditor integration is quite independent from the FCKeditor's core codes. All you need is to drop in the new version and change the fckconfig.js file to match the toolbars request by the java scripts in the public_html/javascipt folder; or you can look at the old fckconfig.js to create those toolbars in the new fckconfig.js.

The version came with GL1.4 is 2.1.1. If you click on the ? (help) button it will tell you everything about the version, and also remind you for a donation.

I am much less a programmer than you are, so if I could do it, that must be something really simple. And the fact that I have no notes means I didn't have to do any serious changes, except the configuration.

Why don't you try it. I started by changing the FCKeditor directory to something like fckeditor_old, then load the new version and tested it, so that I could reverse back if it didn't work. Now, since it works, I have already deleted the old version.

Sam

Status: offline

samstone

Forum User
Full Member
Registered: 29/09/2002
Posts: 820
OK, there is another file you need to change to get the FCKeditor's filemanager to work. I will post in another topic since we are going off topic.

Sam

Status: offline

donm1021

Forum User
Chatty
Registered: 31/12/2005
Posts: 56
I upgraded to 1.5 and received the "upgrade successful" message - however, whenever I try to modify a category or whenever I click on the File Download link in the menu bar - I receive the following error:

"An SQL error has occurred. Please see error.log for details."

Here is my log file:

PHP Formatted Code

Wed 22 Mar 2006 09:13:29 EST - 1054: Unknown column 'grp_access' in 'field list'. SQL in question: SELECT pid, title, imgurl, grp_access FROM gl_filemgmt_category WHERE cid='10'
Wed 22 Mar 2006 09:14:09 EST - 1054: Unknown column 'grp_access' in 'field list'. SQL in question: SELECT pid, title, imgurl, grp_access FROM gl_filemgmt_category WHERE cid='10'
Wed 22 Mar 2006 09:14:31 EST - 1054: Unknown column 'grp_access' in 'where clause'. SQL in question: SELECT COUNT(*), SUM(hits) FROM gl_filemgmt_filedetail a LEFT JOIN gl_filemgmt_category b ON a.cid=b.cid  WHERE grp_access IN (2,4,7,22,11,5,13,12,10,8,1,14,3,6,9,21,17,15)
Wed 22 Mar 2006 09:14:50 EST - 1054: Unknown column 'grp_access' in 'where clause'. SQL in question: SELECT COUNT(*), SUM(hits) FROM gl_filemgmt_filedetail a LEFT JOIN gl_filemgmt_category b ON a.cid=b.cid  WHERE grp_access IN (2,4,7,22,11,5,13,12,10,8,1,14,3,6,9,21,17,15)
Wed 22 Mar 2006 09:15:05 EST - 1054: Unknown column 'grp_access' in 'where clause'. SQL in question: SELECT COUNT(*) FROM gl_filemgmt_filedetail a LEFT JOIN gl_filemgmt_category b ON a.cid=b.cid WHERE a.lid=''  AND grp_access IN (2,4,7,22,11,5,13,12,10,8,1,14,3,6,9,21,17,15)
Wed 22 Mar 2006 09:15:41 EST - 1054: Unknown column 'grp_access' in 'where clause'. SQL in question: SELECT COUNT(*), SUM(hits) FROM gl_filemgmt_filedetail a LEFT JOIN gl_filemgmt_category b ON a.cid=b.cid  WHERE grp_access IN (2,4,7,22,11,5,13,12,10,8,1,14,3,6,9,21,17,15)
Wed 22 Mar 2006 09:15:51 EST - 1054: Unknown column 'grp_access' in 'where clause'. SQL in question: SELECT COUNT(*) FROM gl_filemgmt_filedetail a LEFT JOIN gl_filemgmt_category b ON a.cid=b.cid WHERE a.lid=''  AND grp_access IN (2,4,7,22,11,5,13,12,10,8,1,14,3,6,9,21,17,15)
Wed 22 Mar 2006 09:15:56 EST - 1054: Unknown column 'grp_access' in 'where clause'. SQL in question: SELECT COUNT(*) FROM gl_filemgmt_filedetail a LEFT JOIN gl_filemgmt_category b ON a.cid=b.cid WHERE a.lid=''  AND grp_access IN (2,4,7,22,11,5,13,12,10,8,1,14,3,6,9,21,17,15)
Wed 22 Mar 2006 09:19:07 EST - 1054: Unknown column 'grp_access' in 'where clause'. SQL in question: SELECT COUNT(*) FROM gl_filemgmt_filedetail a LEFT JOIN gl_filemgmt_category b ON a.cid=b.cid WHERE a.lid=''  AND grp_access IN (2,4,7,22,11,5,13,12,10,8,1,14,3,6,9,21,17,15)

 


Donm

Status: offline

samstone

Forum User
Full Member
Registered: 29/09/2002
Posts: 820
The error.log is in /geeklog/logs/ directory.

Sam

Status: offline

Blaine

Forum User
Full Member
Registered: 16/07/2002
Posts: 1233
Location:Canada
Did you upgrade to version 1.5 or 1.5.1?

The error.log is the standard geeklog error log file. Under the default geeklog_dir/logs
Geeklog components by PortalParts -- www.portalparts.com

Status: offline

donm1021

Forum User
Chatty
Registered: 31/12/2005
Posts: 56
Thanks I found the error log - however, I don't know what all of that means... I posted the results of my log file in the post above.

Donm

Status: offline

Blaine

Forum User
Full Member
Registered: 16/07/2002
Posts: 1233
Location:Canada
Ok - I see the problem. I had added a upgrade test for version 1.5 to 1.5.1 which was just to update the version code but in doing so broke the upgrade from the earlier version.

I will take a look and see if I can make a quick change to correct that - otherwise - change the version in the plugins/filemgmt/config.php to 1.5 and that should trigger the needed sql update.

$CONF_FM['version'] = '1.5';

Geeklog components by PortalParts -- www.portalparts.com

Status: offline

donm1021

Forum User
Chatty
Registered: 31/12/2005
Posts: 56
Ok - I did that - but it doesn't seem to trigger anything? I went to the plugin admin... and it shows that there is a Code: 1.5 Update! However, clicking on the edit button does not give me the "update" option like before. I can just save or delete.

What do I need to do from here?


Status: offline

Blaine

Forum User
Full Member
Registered: 16/07/2002
Posts: 1233
Location:Canada
I don't have more time to look at this now - you may need to change the pi_version in the plugins record back to 1.3 or 1.4 - some number less then 1.5 as the plugin editor likely does not see a need to enable the update.
Geeklog components by PortalParts -- www.portalparts.com

Status: offline

donm1021

Forum User
Chatty
Registered: 31/12/2005
Posts: 56
Thanks - I changed the pi_version number to 1.3 - ran the update and so far it sees to be working... I'll let you know if I find anything else.

Thanks for your help and awesome work!

I do have another question about this though...

I am wanting to restrict access to the downloadable files. However, just changing the category to allow that group to download the file is not enough. I actually only want certain groups to be able to see a listing of files available to their specific group.

But in the Menu whenever you click on the "My Downloads" the index shows every uploaded file - instead of just the files available to that specific group.

Does this make sense?

It looks like at this point unless there is something that I am not seeing - I will need to remove the "My Downloads" link from the top nav - and set up links through the blocks to restrict access and only show files available to respective groups?

Does that sound correct?






Status: offline

samstone

Forum User
Full Member
Registered: 29/09/2002
Posts: 820
I also don't have enough time to answer your questons. Please do a search on the forum, and FAQ to learn how to remove the plugin links from the navigation bar. That's a basic knowledge of Geeklog and it's well documented. Tip: it's in the header.thtml.

With version 1.5, you can restrict access by category. For each category you can allow all users, logged in users, or by group. If I understand you correctly, that's where you should setup permissions. Give a documentation a read and you will find how to use those features.

Sam

Status: offline

Blaine

Forum User
Full Member
Registered: 16/07/2002
Posts: 1233
Location:Canada
I have updated the archive so the update will work correctly if you have version 1.3 or 1.5 installed. The new filename is filemgmt_1.5.1b_1.4.zip

The built-in update feature will now update correctly from version 1.3 and 1.5 (released a few days ago).




Geeklog components by PortalParts -- www.portalparts.com

Status: offline

samstone

Forum User
Full Member
Registered: 29/09/2002
Posts: 820
Blaine,

One more minor bug.

If I edit a category and try to add or replace the category snap. It doesn't load. It doesn't write the new snap to the database, nor upload the snap to the category-snaps directory.

Sam

Status: offline

Blaine

Forum User
Full Member
Registered: 16/07/2002
Posts: 1233
Location:Canada
Correct - and I don't believe it worked before either. I had to stop somewhere and felt this was not critical.
Geeklog components by PortalParts -- www.portalparts.com

Status: offline

lokki

Forum User
Chatty
Registered: 19/03/2005
Posts: 59
I have a problem. I have a category "Movies" and under it a subcategory "Fiction". When I hit Fiction, I see a page which lists some of the fiction movies (url like "..../filemgmt/viewcat.php?cid=33"). And at the end there are links to next and last page. But both of them lead not to smth like ".../filemgmt/viewcat.php?cid=33&page=2" but to ".../filemgmt/index.php?page=2". So when I want to view second(or last as I have two of them) page of my fiction movies, I get a second page of 'all files' listing.
Any ideas? Thanks

All times are EST. The time is now 03:25 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content