Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: 1 2 3 4 [5]   Go Down

Author Topic: Flickr style image annotations for cpg1.5.x  (Read 120038 times)

0 Members and 1 Guest are viewing this topic.

rickmick

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Flickr style image annotations for cpg1.5.x
« Reply #80 on: September 13, 2013, 10:22:03 pm »

Sorry I lift this out

File: /home/rickmick/public_html/include/functions.inc.php - Line: 272
Logged

rickmick

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Flickr style image annotations for cpg1.5.x
« Reply #81 on: September 13, 2013, 11:30:37 pm »

I was able to change the schema.sql from
Code: [Select]
) TYPE=MyISAMto this
Code: [Select]
) ENGINE=MyISAM
I'm sure if that should be the way to do it but it works now.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Flickr style image annotations for cpg1.5.x
« Reply #82 on: September 14, 2013, 08:35:29 pm »

Remove
Code: [Select]
TYPE=MyISAM  COMMENT='Contains the data for the annotate plugin'from schema.sql and it should work as expected.
« Last Edit: October 29, 2013, 04:30:04 pm by Αndré »
Logged

mr5

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 49
Re: Flickr style image annotations for cpg1.5.x
« Reply #83 on: October 29, 2013, 02:46:29 pm »

Tried to apply V3.
Get critical error. I have enabled the debug for all. Details in attachment. user=test; psw=test   Thanks.


[removed attachment by request]
« Last Edit: October 29, 2013, 04:49:58 pm by Αndré »
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Flickr style image annotations for cpg1.5.x
« Reply #84 on: October 29, 2013, 03:57:46 pm »

Unfortunately your screenshot doesn't contain an error message. Without an error message I cannot fix anything.
Logged

mr5

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 49
Re: Flickr style image annotations for cpg1.5.x
« Reply #85 on: October 29, 2013, 04:02:36 pm »

Here is the text, sorry

While executing query '















CREATE TABLE IF NOT EXISTS `cpg15x_plugin_annotate` (
  nid smallint(5) unsigned NOT NULL auto_increment,
  pid mediumint(8) unsigned NOT NULL,
  posx smallint(5) unsigned NOT NULL,
  posy smallint(5) unsigned NOT NULL,
  width smallint(5) unsigned NOT NULL,
  height smallint(5) unsigned NOT NULL,
  note text NOT NULL,
  user_id smallint(5) unsigned NOT NULL,
  PRIMARY KEY  (nid)
) TYPE=MyISAM  COMMENT='Contains the data for the annotate plugin'' in plugins/annotate/codebase.php on line 328

mySQL error: 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 'TYPE=MyISAM  COMMENT='Contains the data for the annotate plugin'' at line 11
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Flickr style image annotations for cpg1.5.x
« Reply #86 on: October 29, 2013, 04:07:57 pm »

Please use the fix that's directly above your post ::)
« Last Edit: October 29, 2013, 04:29:35 pm by Αndré »
Logged

mr5

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 49
Re: Flickr style image annotations for cpg1.5.x
« Reply #87 on: October 29, 2013, 04:26:17 pm »

But there is no such text in codebase.php  of the plugin....  ????  Or am I completely crazy...
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Flickr style image annotations for cpg1.5.x
« Reply #88 on: October 29, 2013, 04:29:07 pm »

It's in schema.sql, sorry. I've just fixed the typo in my previous post.
Logged

mr5

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 49
Re: Flickr style image annotations for cpg1.5.x
« Reply #89 on: October 29, 2013, 04:39:58 pm »

Thanks Andre!!!
And sorry for not seeing he fix...   :)
Logged

mr5

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 49
Re: Flickr style image annotations for cpg1.5.x
« Reply #90 on: October 29, 2013, 04:47:47 pm »

Can't find how to remove attachment. Don't wnt for anyone to see. Thanks
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Flickr style image annotations for cpg1.5.x
« Reply #91 on: October 29, 2013, 04:50:14 pm »

Can't find how to remove attachment.
Removed as requested.
Logged

leeni

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Estonian translation for Annotate
« Reply #92 on: November 16, 2015, 08:00:48 pm »

Hello!
I am sending an Estonian translation for Annotate Plugin v3.0 / cpg1.5x. You can use it as you like.
Regards, Leeni
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Flickr style image annotations for cpg1.5.x
« Reply #93 on: November 23, 2015, 12:37:16 pm »

Added in SVN revision 8834. Thank you for your contribution.
Logged

bobmiers

  • Coppermine newbie
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 11
    • Foxglove Software
Attempting to useannotations for cpg1.5.x(38 or 40)
« Reply #94 on: December 31, 2015, 12:28:49 am »

I'm attempting to use Flickr style image annotations for cpg1.5.x - using: cpg1.5.x_plugin_annotate_v3.0.zip (45.63 kB - downloaded 552 times.) from the announcement thread.  I'm doing this on a virgin copy of 1.5.40 from the admin login config plugin manager and get the following error:

"Critical error
There was an error while processing a database query"


Other plugins seem to work OK.

I note that the last time several files were edited was back in July and August of 2012, so I'm wondering if anyone has used this plugin in the most recent version of CPG?

Also, what php debugging program to the developers use.  Being able to step through code probably would lead me to the cause of the error.

A note to: Αndré & allvip, thanks to your help I've made my project "live" a couple of weeks ago and it works GREAT.

Any insight will be appreciated.

Bob Miers

Logged

ron4mac

  • Administrator
  • Coppermine addict
  • *****
  • Country: us
  • Offline Offline
  • Posts: 2026
Re: Attempting to useannotations for cpg1.5.x(38 or 40)
« Reply #95 on: January 01, 2016, 01:41:05 am »

In the plugin file, schema.sql, remove "TYPE=MyISAM" in the last line of the file. (or change it to "ENGINE=MyISAM")
Logged

bobmiers

  • Coppermine newbie
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 11
    • Foxglove Software
Re: Attempting to useannotations for cpg1.5.x(38 or 40)
« Reply #96 on: January 01, 2016, 02:40:13 pm »

ron4mac

Thank you so very much.  I would have never discovered the fix.

Now I can see if it will accomplish the job that I want it to do.

Thank you,
Bob Miers
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Flickr style image annotations for cpg1.5.x
« Reply #97 on: January 09, 2016, 10:17:23 pm »

Merged with announcement thread. Will update the plugin as soon as possible.
Logged

leeni

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Flickr style image annotations for cpg1.5.x
« Reply #98 on: February 06, 2016, 01:15:27 am »

There is possibly a bug in how the annotation links are formed above the photo. When a person appears on several photos in different categories and albums, clicking on such a link initiates a search. However, the results of such a search display the album title under the search result (instead of the actual title of the photo). Even more problematically, upon opening such a photo from such a link, the wrong caption is still displayed below the photo itself.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Flickr style image annotations for cpg1.5.x
« Reply #99 on: February 08, 2016, 12:03:30 pm »

Please try if it works as expected if you replace
Code: [Select]
r.titlewith
Code: [Select]
p.titlein codebase.php.
Logged
Pages: 1 2 3 4 [5]   Go Up
 

Page created in 0.027 seconds with 20 queries.