[REQUEST] Spell Check Feature

Looking for a MOD? Have a MOD request? Post here for help. (Note: This forum is community supported; phpBB does not have official MOD authors)
Scam Warning
Locked
User avatar
rarmy
Registered User
Posts: 147
Joined: Tue Nov 13, 2007 5:26 am
Location: San Diego, CA
Name: Roy Army
Contact:

Re: [REQUEST] Spell Check Feature

Post by rarmy »

rarmy wrote:OK, code select from what file??? seems to be the missing info here...have read both side of this post an am unable to figure out... never mind, it's late....now have to see if I still have that mod installed or if I blew it out in frustration...

of course, try'd it out...don't have a spell_phpbb.php file, I have a spell_phpbb3.php file, and the very first search string is non-existent...naturally...now what??

modded the phpbb3 file, had to go and add the table myself, got this error

Error

SQL query:

CREATE TABLE [phpbb_spelling_words](
[id][int] PRIMARY KEY identity( 1, 1 ) NOT NULL ,
[word][varchar]( 40 ) NOT NULL ,
[sound][varchar]( 40 ) NOT NULL
) ON [ PRIMARY ] CREATE INDEX [IX_phpbb_spelling_words_WORD] ON [phpbb_spelling_words](
word
) ON [ PRIMARY ] CREATE INDEX [IX_phpbb_spelling_words__SOUND] ON [phpbb_spelling_words](
sound
) ON [ PRIMARY ]

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 '[phpbb_spelling_words] ([id] [int] primary key identity (1,1) NOT NULL , [word] ' at line 1

Version = MySQL(i) 4.1.22-standard
Host, Chief Geek and WebMaster
http://www.reenactorswire.net
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: [REQUEST] Spell Check Feature

Post by D¡cky »

To create the table yourself, enter this in the SQL tab of phpMyAdmin:

Code: Select all

DROP TABLE IF EXISTS phpbb_spelling_words;
CREATE TABLE IF NOT EXISTS phpbb_spelling_words (
  id mediumint(9) NOT NULL AUTO_INCREMENT,
  word varchar(30) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  sound varchar(10) NOT NULL,
  PRIMARY KEY (id),
  UNIQUE KEY word (word),
  KEY sound (sound)
);
Have you hugged someone today?
User avatar
rarmy
Registered User
Posts: 147
Joined: Tue Nov 13, 2007 5:26 am
Location: San Diego, CA
Name: Roy Army
Contact:

Re: [REQUEST] Spell Check Feature

Post by rarmy »

D¡cky wrote:To create the table yourself, enter this in the SQL tab of phpMyAdmin:

Code: Select all

DROP TABLE IF EXISTS phpbb_spelling_words;
CREATE TABLE IF NOT EXISTS phpbb_spelling_words (
  id mediumint(9) NOT NULL AUTO_INCREMENT,
  word varchar(30) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  sound varchar(10) NOT NULL,
  PRIMARY KEY (id),
  UNIQUE KEY word (word),
  KEY sound (sound)
);
THANK YOU...it said it worked...but am getting following error on the updated ENGLISH.DIC

Installing ENGLISH.DIC (English)...
Processed: 4232... (2%)
Processed: 8908... (5%)
Processed: 13293... (7%)
Processed: 17776... (9%)
Processed: 22144... (11%)
Processed: 26729... (13%)
Processed: 31102... (16%)
Processed: 34683... (17%)
Processed: 38178... (19%)
Processed: 42631... (22%)
Processed: 47037... (24%)
Processed: 51219... (26%)
Processed: 55347... (28%)

Fatal error: SQL ERROR [ mysqli ]

Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' [12thth 67]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists. in /home/rarmy/public_html/wire/forum/includes/db/dbal.php on line 697

When I look at the .dic file, it's just words, with no other coding that I can see...I don't know sql enough to fix, not sure what to do next... the bible_english worked fine...
Host, Chief Geek and WebMaster
http://www.reenactorswire.net
User avatar
rarmy
Registered User
Posts: 147
Joined: Tue Nov 13, 2007 5:26 am
Location: San Diego, CA
Name: Roy Army
Contact:

Re: [REQUEST] Spell Check Feature

Post by rarmy »

Trying to be proactive instead of just sitting here and complaining, tried something...

changed latin1 to utf8 in the above query, am getting dupe errors now...

DROP TABLE IF EXISTS phpbb_spelling_words;# MySQL returned an empty result set (i.e. zero rows).

CREATE TABLE IF NOT EXISTS phpbb_spelling_words (
id mediumint(9) NOT NULL AUTO_INCREMENT,
word varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
sound varchar(10) NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY word (word),
KEY sound (sound)
)

;# MySQL returned an empty result set (i.e. zero rows).

Added Dictionary ENGLISH.DIC recieved the following error...

Installing ENGLISH.DIC (English)...
Processed: 5496... (3%)
Processed: 14116... (7%)
Processed: 22596... (11%)

Fatal error: SQL ERROR [ mysqli ]

Duplicate entry 'caf' for key 2 [1062]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists. in /home/rarmy/public_html/wire/forum/includes/db/dbal.php on line 697

obviously I did it wrong,,,but noticed that all the other tables were utf8 except the phpbb_spelling words wich were latin1 and swedish...
Host, Chief Geek and WebMaster
http://www.reenactorswire.net
User avatar
rarmy
Registered User
Posts: 147
Joined: Tue Nov 13, 2007 5:26 am
Location: San Diego, CA
Name: Roy Army
Contact:

Re: [REQUEST] Spell Check Feature

Post by rarmy »

OK, tried to run the following...

CREATE TABLE IF NOT EXISTS phpbb_spelling_words (
id mediumint(9) NOT NULL AUTO_INCREMENT,
word varchar(40) ,
sound varchar(40) NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY word (word),
KEY sound (sound)
)

(tried NOT to force charset...I think...)

still got this error on ENGLISH.DIC...

Installing ENGLISH.DIC (English)...
Processed: 3749... (2%)
Processed: 8264... (4%)
Processed: 12488... (6%)
Processed: 16892... (8%)
Processed: 21336... (11%)
Processed: 25321... (13%)
Processed: 29527... (15%)
Processed: 33906... (17%)
Processed: 38327... (20%)
Processed: 42716... (22%)
Processed: 46905... (24%)
Processed: 51464... (26%)
Processed: 55706... (28%)

Fatal error: SQL ERROR [ mysqli ]

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' [1267]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists. in /home/rarmy/public_html/wire/forum/includes/db/dbal.php on line 697

Table shows...

phpbb_spelling_words Browse Structure Search Insert Empty Drop 55,031 MyISAM latin1_swedish_ci 2.7 MiB -

Where ALL other tables show

utf8_bin for Collation column

Ideas???
Host, Chief Geek and WebMaster
http://www.reenactorswire.net
User avatar
rarmy
Registered User
Posts: 147
Joined: Tue Nov 13, 2007 5:26 am
Location: San Diego, CA
Name: Roy Army
Contact:

Re: [REQUEST] Spell Check Feature

Post by rarmy »

Still looking for a fix, anybody???

is there a way to reformat the .dic file to utf8???
Host, Chief Geek and WebMaster
http://www.reenactorswire.net
Locked

Return to “[3.0.x] MOD Requests”