forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 plugins => Topic started by: magnum on October 09, 2010, 11:20:25 am

Title: Smart_Catlist for 1.5x?
Post by: magnum on October 09, 2010, 11:20:25 am
Hi all,

i would like to hide some of my categories from unregistered users. There is the Plugin Smart Catlist  (http://forum.coppermine-gallery.net/index.php/topic,60118.html)for Version 1.4x.
I've tried to set it up on version 1.5x with the necessary modification for the 1.5x database tablenames.

But when i try to open my default main page i get a critical error.

During debug there is a message coming from MySQL that the column "visibility" in table "cpg15x_categories" is ambiguous.

Any ideas how to solve this?
Many thanks

Uwe
Title: Re: Smart_Catlist for 1.5x?
Post by: Nibbler on October 09, 2010, 01:20:53 pm
I would suggest modifying the plugin to use a different name than 'visibility' for its new column. Naming it 'visibility' is ambiguous because the albums table has a column with the same name.
Title: Re: Smart_Catlist for 1.5x?
Post by: magnum on October 09, 2010, 02:15:58 pm
Hi,

thanks for your suggestion. Will give it a try and post the results here.

Greetings Uwe
Title: Re: Smart_Catlist for 1.5x?
Post by: magnum on October 09, 2010, 02:58:12 pm
It's me again.

I've changed the column name and i've changed with two new errors as result. The call to the database coming from index.php and catmgr.php didn't work.

I've changed these queries to my newly set column name and the errors disappeared.

But i got a new problem which isn't solved until now. Maybe you've an idea for that.
The problem is, that there is the field for visibility in category manager, but there are no values in the dropdown box. And if i try to create a category, nothing happens and i am returned to the cat manager. There is no creation of a category.

Now my little coding expierience is at the end, but maybe somebody have an answer to this.

Thanks Uwe
Title: Re: Smart_Catlist for 1.5x?
Post by: phill104 on October 09, 2010, 03:35:12 pm
Please zip and attach your work as is to your next post