[help] pwadmin import files

[CoG]

Whenever I try to import the character's speech, how do I solve?

COMMAND: http://localhost:8080/pwAdmin/index....rocess=sqlsync
ERROR: Importing Roles to MySQL Failed

Starts importing ... there delay and failure, it only matters to the 256.

[MentaL]

[ronny1982]

Whenever I try to import the character's speech, how do I solve?

COMMAND: http://localhost:8080/pwAdmin/index....rocess=sqlsync
ERROR: Importing Roles to MySQL Failed

Starts importing ... there delay and failure, it only matters to the 256.

• make sure database settings in pwAdmin configuration are correct
• when using an older pwAdmin you must have preinstalled a corresponding roles table

[CoG]

I know it's boring, plus you can give me a clue what to do exactly?

[tbnanubis]

if your character database has invalid characters it would crash at some point, because some releases of pwAdmin don't escape the strings properly. Your problem is an sql error because of invalid strings like "'"

to fix it you need to change your role.jsp at several points to something like this:

rolename = StringEscapeUtils.escapeJava(StringEscapeUtils.escapeHtml(chr.base.name.getString()));

[CoG]

Edit only the line 450 and failed, what other line should be edited?