Flickr style image annotations for cpg1.5.x

[rickmick]

Sorry I lift this out

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

[rickmick]

I was able to change the schema.sql from

Code Select Expand

) TYPE=MyISAM
to this

Code Select Expand

) ENGINE=MyISAM

I'm sure if that should be the way to do it but it works now.

[Αndré]

Remove

Code Select Expand

TYPE=MyISAM  COMMENT='Contains the data for the annotate plugin'
from schema.sql and it should work as expected.

[mr5]

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]

[Αndré]

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

[mr5]

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( 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

[Αndré]

Please use the fix that's directly above your post

[mr5]

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

[Αndré]

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

[mr5]

Thanks Andre!!!
And sorry for not seeing he fix...   

[mr5]

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

[Αndré]

Can't find how to remove attachment.

Removed as requested.

[leeni]

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

[Αndré]

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

[bobmiers]

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

[ron4mac]

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

[bobmiers]

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

[Αndré]

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

[leeni]

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.

[Αndré]

Please try if it works as expected if you replace

Code Select Expand

r.title
with

Code Select Expand

p.title
in codebase.php.