Author Topic: HACK: AutoGen Metadata Metatag. Product, Category. Title, Description, Keywords  (Read 313696 times)

mbit

  • Jr. Member
  • **
  • Posts: 323
need some help again :?
i am trying to enable the joomfish meta hack. i downloaded aricak's files http://forum.virtuemart.net/index.php?topic=65697.msg297783#msg297783, replaced them with mine + added joomfish contentelements files. when i tried to run sql #__vm_category_metakeys.sql & #__vm_product_metakeys.sql i got errors :
Quote
SQL query:

INSERT INTO `jos_vm_product_metakeys` (`id`, `banned`, `remove_less_than`, `number_of_keywords`, `append_category`, `general_append_end`, `general_append_end_title`, `general_append_keys`, `general_append_keys_phrase`, `append_prod_name_phrase`, `append_par_cat_name_phrase`, `turn_on_edit`, `add_abstract`, `generator`, `subject`, `classification`, `author`, `organization`, `copyright`, `country`, `content_language`, `language`, `designer`, `comments`, `no_email_collection`) VALUES (1, 'na, u, about, above, across, after, afterwards, again, against, all, almost, alone, along, already, also, although, always, am, among, amongst, amoungst, amount, an, and, another, any, anyhow, anyone, anything, anyway, anywhere, are, around, as, at, back, be, became, because, become, becomes, becoming, been, before, beforehand, behind, being, below, beside, besides, between, beyond, bill, both, bottom, bull, but, by, call, can, cannot, cant, co, computer, con, could, couldnt, cry, de, describe, detail[...]

MySQL said:

#1054 - Unknown column 'id' in 'field list'
Also at joomfish when i choose content element :vm category metakeys or vm product metakeys i get the following error :
Quote
DB function failed with error number 1054
Unknown column 'c.id' in 'field list' SQL=SELECT c.id, c.banned, c.remove_less_than, c.number_of_keywords, c.append_category, c.general_append_end, c.general_append_end_title, c.general_append_keys, c.general_append_keys_phrase, c.append_prod_name_phrase, c.append_par_cat_name_phrase, c.turn_on_edit, c.add_abstract, c.generator, c.subject, c.classification, c.author, c.organization, c.copyright, c.country, c.content_language, c.language, c.designer, c.comments, c.no_email_collection, jfc.id as jfc_id, jfc.value as titleTranslation, jfc.modified as lastchanged, jfc.published as published, jfc.language_id, jfl.name as language, jfc.reference_id as jfc_refid FROM jos_vm_product_metakeys as c LEFT JOIN jos_jf_content as jfc ON c.id=jfc.reference_id AND jfc.reference_table='vm_product_metakeys' AND jfc.language_id=2 LEFT JOIN jos_languages as jfl ON jfc.language_id=jfl.id LIMIT 0, 10

any ideas whats goes wrong?

edit: "..jos_vm_product_metakeys` (`id`, ..."  in my db, at jos_vm_product_metakeys there is no 'id' field, but 'mid'.

sodego

  • Beginner
  • *
  • Posts: 18
    • iturist.eu
Can anybody help with encoding problem?

Quote
But I confirm that there is a problem with language settings
semewhere in script , I use polish UTF-8 language charset
and script shred words metatags when the polish special character is
used (for one word we receive 2 words divided).
For exapmle instead of one word kt√≥ry  we recive two words kt , ry
without polish cut out character.

Grettings, SODEGO

cerhio

  • Beginner
  • *
  • Posts: 20
i hacked vm 1.1.4 (j 1.5.23)

now i have two description meta-tags: one from joomla core, one generated by hack. and title is always from joomla core.

i have joomla sef on and... hm. what else to say? i don't know, where the problem could be

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10352
  • VirtueMart Version: 3+
cerhio, how did you hack?
J3.9+ VM 3.4.2
Slowest Page Speed Score (88) (Category)
Fastest Page Speed Score (94-96) (productdetails)

cerhio

  • Beginner
  • *
  • Posts: 20
shit!

i found, previous webmaster hacked joomla core with no comments in code on the site. brrrr.

so that's not a vm hack problem.

i repeared head.php in joomla libraries and now i see all meta data on vm pages as it should be. the only thing is there are still two descriptions. are there any other files in joomla core or in vm, that create description tag?

i rewrite vm files when applying this hack, so problem is somewhere else

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10352
  • VirtueMart Version: 3+
IS is product and category meta?

OR is the Joomla global meta doing it?
J3.9+ VM 3.4.2
Slowest Page Speed Score (88) (Category)
Fastest Page Speed Score (94-96) (productdetails)

cerhio

  • Beginner
  • *
  • Posts: 20
now it looks this way



<meta name="keywords" content="..." />  from vm hack
  <meta name="description" content="..." /> from vm hack
  <meta name="description" content="..." /> from joomla global meta

  <title>...</title> from hack

cerhio

  • Beginner
  • *
  • Posts: 20
any ideas?

this happens both in vm categories and produst pages, on other site pages  global joomla metadata is displayd ok

PRO

  • Global Moderator
  • Super Hero
  • *
  • Posts: 10352
  • VirtueMart Version: 3+
I dont understand the problem

whats the problem?
J3.9+ VM 3.4.2
Slowest Page Speed Score (88) (Category)
Fastest Page Speed Score (94-96) (productdetails)

cerhio

  • Beginner
  • *
  • Posts: 20
meta tag DESCRIPTION displays two times on one page. that's the problem

cerhio

  • Beginner
  • *
  • Posts: 20
solved

i comment in shop.browse.php

Quote
$mainframe->prependMetaTag( "description", substr(strip_tags($desc ), 0, 255) );

cam92

  • Beginner
  • *
  • Posts: 2
Just want to say Thank you !
This is exactly what I was looking for and it works just fine ! (and easy to install and very flexible to use...which is key with my low level of knowledge in this area !).

And Happy New Year !

radicalfightershop

  • Beginner
  • *
  • Posts: 25
Does anyone know if this Meta Hack is compatible with SH404SEF ie does cause any ill effects if installed with SH404SEF also in use?

davishuang

  • Beginner
  • *
  • Posts: 2
It's a great hack,i installed it ,it works well in back-end,but when brwose the "product details" ,there is problem :Not Found

The requested URL /www.kiying.com was not found on this server.  Please help!! Thanks

Stonedfury

  • Jr. Member
  • **
  • Posts: 266
    • Stonedfury
  • Skype Name: Stonedfury
  • VirtueMart Version: 2.0.24
Is this compatible with the J1.5.25 & VM1.1.9? I would love to try this out.
No such thing as a stupid question, only a stupid answer. I won't ask if I know the answer or found it using the search as you suggested.