GlossWord + Mambo

[0zz0n0]

Hola a todos.

Tengo un diccionario realizado con Glossword y leí en algún lado que es posible integrarlo al Mambo.
Alguno sabe algo al respecto? En los foros en inglés hay un par de msg pero las paginas linkeadas ya no existen....
Necesito esa información realmente. Alguien tiene alguna idea?

Saludos.

[afaton]

see here http://www.mambers.com/showthread.php?t=11351



I want to integrate glossword dictionary into my mambo-driven site.
The instructions are given here: http://glossword.info/dev/glossword1/en/doc/66/66.xhtml

I fumbled at the second step:
Apply SQL-query to Mambo database:
SQLINSERT INTO mos_components (name, link, option, iscore)
VALUES ('Glossword', 'option=com_glossword', 'com_glossword', 0);

When I paste the code into the SQL-query box and hit GO, the code gets messed up and an error occurs, as follows:

Error

SQL-query :

INSERT INTO mos_components( name, link,
OPTION , iscore )
VALUES (

'Glossword', 'option=com_glossword', 'com_glossword', 0
)

MySQL said:


#1064 - 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 'OPTION , iscore )
VALUES ( 'Glossword', 'option=com_glosswor

Can you help me

quanto
View Public Profile
Send a private message to quanto
Send email to quanto
Find More Posts by quanto
Add quanto to Your Buddy List
28.09.2004, 20:53 #2
Ektoras
Baby Mamber

Join Date: Jul 2004
Posts: 18
Ektoras is online now

Re: Help with SQL-query
Hi.

The problem you have here is with the word OPTION. It is a MySQL reserved word and its use as a column name is causing the error message.

To prevent the error message, re-issue the SQL query but surround the word OPTION with backquotes (`) and you should be ok.

Example:
Code:

INSERT INTO mos_components(name, link, `OPTION` , iscore) VALUES ('Glossword', 'option=com_glossword', 'com_glossword', 0)

[0zz0n0]

i read that.
But i don't understand.
the page http://glossword.info/dev/glossword1/en/doc/66/66.xhtml don't work now....

You know install the script Glossword before import the SQL to MAMBO ???
I use the Glossword 1.63 and I have the Mambo 4.5.1a


Regards.
sorry my english.

[afaton]

Hola!

Actually the first time I installed glossword (a year ago) it was with the help of the developer (there always seemed something going wrong). I have tried again recently but although I reach to the final setup screen "installed successfully" I get a blank page both on frontend and backend. I suggest you contact the developer... (he has not replied yet to my e-mail).

Also see this http://mambers.com/showthread.php?t=...ight=glossword

As far as this page is concerned
http://glossword.info/dev/glossword1/en/doc/66/66.xhtml
perhaps you could get a cache version from Google? (using the cache: parameter)

Originally Posted by 0zz0n0

i read that.
But i don't understand.
the page http://glossword.info/dev/glossword1/en/doc/66/66.xhtml don't work now....

You know install the script Glossword before import the SQL to MAMBO ???
I use the Glossword 1.63 and I have the Mambo 4.5.1a


Regards.
sorry my english.

[0zz0n0]

I don' t have luck. cache it was cleared or it does not exist.
I follow without solving this problem

[afaton]

I got an answer from the developer

Answer
Mambo is Open Source Content Management System ▷http://www.mamboserver.com/.

Requirements:

Glossword 1.6.4-beta (September 10, 2004) or newer
Mambo 4.5 (july 26, 2004) or newer
Instructions:

Create file ‘/mambo/components/com_glossword/glossword.php’ with the following contents:

/mambo/components/com_glossword/glossword.php
<?php
/**
* Glossword integration with Mambo
*/
defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );

$tmp['this_dir'] = getcwd();
chdir('components/com_glossword');
include_once('index.php');
chdir($tmp['this_dir']);
mysql_select_db($mosConfig_db);
?>
Apply SQL-query to Mambo database:

SQL
INSERT INTO mos_components (name, link, `option`, iscore) VALUES ('Glossword', 'option=com_glossword', 'com_glossword', 0);
Log in to Mambo, create new menu:
Menu Manager → Main Menu → Add Menu Item → Component → type `Glossword'

Upload contents of Glossword package to ‘/mambo/components/com_glossword’.

Install Glossword
‘http://domain.tld/mambo/components/c...l/install.php’

Make changes:

/mambo/components/com_glossword/db_config.php
$sys['server_dir'] = '/dev/mambo/components/com_glossword';
$sys['server_url'] = 'http://domain.tld/mambo';
/mambo/components/com_glossword/inc/config.inc.php
$sys['path_tpl'] = 'templates';
$sys['path_tpl_v'] = 'templates';
$sys['ar_url_append'] = array('option' => 'com_glossword');
/mambo/components/com_glossword/inc/lib.prepend.php
$sys['page_index'] = $sys['server_dir'] .'/../../index.php';
/mambo/components/com_glossword/templates/*/header.html
/* Remove everything from `<?xml' to `<body>' */
{block:counters}
/mambo/components/com_glossword/templates/*/footer.html
/* Remove `</body></html>' */
/mambo/components/com_glossword/templates/*/footer_inside.html
/* Remove `</body></html>' */
Glossword administration interface:
‘http://domain.tld/mambo/components/c.../gw_admin.php’

Uncovered problems:

CSS-styles. You need to adjust font sizes in Glossword CSS-styles.

HTML-templates. Documents will be not XHTML 1.1 Valid untill you did not modify Mambo templates.

Last updated
3 november 2004
Creation date
10 october 2004
Author
Dmitry N. Shilnikov

[0zz0n0]

Very good! Thanks. I am going to prove it and later I comment to you as it were to me '!



sorry my english.

[afaton]

Now there is a link to it http://glossword.info/dev_term/mambo.xhtml. Download the latest stable release 1.6.4

Did you manage to integrate it succesfully?

[0zz0n0]

perfect!!

Now I have problems with new hosting. When it solves them I put to do that.


thank you!

sorry my english

[0zz0n0]

Hello, I again...

I arrived until step 5.

step 5:
Install Glossword
‘http://domain.tld/mambo/components/c...l/install.php’

my path is this:

http://misite.freeserverhost.com/com...ll/install.php


I obtain the following error: ERROR 500. Internal server error

some suggestion?