[Link14716]

Originally Posted by djohn

In non-htl install i get this error when i try to run shoutbox.sql in phpMyAdmin:

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 @ 48
STR: '
SQL: DELETE FROM phrase WHERE varname LIKE %shoutbox%';
SQL-query :  

DELETE FROM phrase WHERE varname LIKE %shoutbox%'; 

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 '%shoutbox%'' at line 1

and an erro when i run phrases.sql:

Error

SQL-query :  

INSERT INTO phrase( phraseid, languageid, varname, text, phrasetypeid ) 
VALUES (

NULL , '0', 'shoutbox_shoutbox_leaderboard', 'Shoutbox Leaderboard', '153'
) 

MySQL said: 


#1062 - Duplicate entry 'shoutbox_shoutbox_leaderboard-0-153' for key 2

It looks like there are lots of dublicate entries in phrases.sql
Could you please fix the files in the non-htl install folder. I really want to install that hack, but I have problems using htl.

Finally, someone doing a Non-HTL install to tell me what errors I have in it.

The last query in shoutbox.sql should be this:
[sql]DELETE FROM phrase WHERE varname LIKE '%shoutbox%';[/sql]

And I suggest you run it as well. The error in phrases.sql - I'll look into it and release a fixed shoutbox.sql and phrases.sql today in 1.03e.