Acronyms Block/Module Installation

Blues · Regular Joined: Jun 17, 2006 Posts: 81 Location: MD

Not sure if anyone else is running this, but I thought I would ping you all and see if you have any idea how to resolve. I am trying to install Acronyms V2.0 and in importing the acronyms.sql code

Code:

CREATE TABLE nuke_acronyms (
id int(11) NOT NULL auto_increment,
acronym varchar(20) NOT NULL default '',
meaning` text NOT NULL,
UNIQUE KEY id (id)
)

in mysqladmin I receive the following error:

Code:

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 119
STR: `
SQL: CREATE TABLE nuke_acronyms (
id int(11) NOT NULL auto_increment,
acronym varchar(20) NOT NULL default '',
meaning` text NOT NULL,
UNIQUE KEY id (id)
)

SQL query:

CREATE TABLE nuke_acronyms ( id int(11) NOT NULL auto_increment, acronym varchar(20) NOT NULL default '', meaning` text NOT NULL, UNIQUE KEY id (id) )

MySQL said: Documentation
#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 '` text NOT NULL,
UNIQUE KEY id (id)
)' at line 4

I am running phpnuke 8.0 with phpbb 2.0.20 and MySQL - 5.0.45-log and phpMyAdmin - 2.8.0.1

I already moved all the files to the appropriate location and I suspect this is a simple table format issue that I am just missing. Any feedback and assistance would be appreciated.

Raven · Posted: Mon Dec 24, 2007 2:40 am

Modify
CREATE TABLE nuke_acronyms (
id int(11) NOT NULL auto_increment,
acronym varchar(20) NOT NULL default '',
meaning` text NOT NULL,
UNIQUE KEY id (id)
)

To
CREATE TABLE `nuke_acronyms` (
`id` int(11) NOT NULL auto_increment,
`acronym` varchar(20) NOT NULL default '',
`meaning` text NOT NULL,
UNIQUE KEY id (`id`)
)

Blues · Regular Joined: Jun 17, 2006 Posts: 81 Location: MD

Thanks Raven, worked like a champ. I was even able to add some acronyms via the Module and phpmyadmin.

However, even as "GOD" admin it wont let me access the Admin Section of it from the Admin Panel. One step at a time though.

Thanks again.

Blues · Regular Joined: Jun 17, 2006 Posts: 81 Location: MD

Looks like it doesn't actually work though in the sense that when entering an acronym and posting that acronym in the forums it doesn't display the typical pop-up of what that acronym stands for. Confused

I think maybe I am trying to install the wrong one. In looking at another site I implemented this on, it's table is nuke_bbacronyms where this is nuke_acronyms

Raven · Posted: Mon Dec 24, 2007 10:53 am

I am not familiar with the mod so I can't really advise on that part. However, if it is using a table prefixed with _bb then that sounds like a Forum mod. If so, as you probably know, most Forum mods need some tweaking to be used in nuke.

Have a great Christmas!

Blues · Regular Joined: Jun 17, 2006 Posts: 81 Location: MD

Well, I downloaded this off an Air Force Communications Career Field web site (not AF sponsored!) and the webmaster at that site had updated it for Nuke specifically with a block an all. But the previous one I had installed was for a nuke site, but correlates to the forums.

Basically, you enter the acronym and meaning in a table/database and when it is in a forum posting if you hover your mouse over it a mouseover identifies the definition.

In the case of this new one I am trying to install, either it needs the tweaking or it is meant as a static location for looking them up manually with no forum integration.

Thanks for your help though.

Raven · Posted: Mon Dec 24, 2007 11:20 am

Then it is a Forum mod. It sounds like you are missing the changes to the forum code to link it to the table.