New Install (Manual) with MySQL 3.2.3

[Migrated From Jforum.net]

Greetings;

I am trying to do a clean install with JForum 2.1.5 on MySQL 3.2.3 using a Manual Install.

I am not sure what to do with the the MySQL_323.sql file?

Please advise.

--Dave


[originally posted on jforum.net by dcrumb]

[Migrated From Jforum.net]

Delete the existing mysql.sql and rename mysql_323.sql to "mysql.sql"

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Raphael;

Im sorry.. I guess I don't follow. I am doing a manual install so Im not sure what that is going to do.

--Dave


[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

hhm... could you please be more specific then?

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Well.. I am doing a manual install.. and I see a file in the database mysel folder called mysql_3.2.3 and I read somewhere on here (though I couldn't find it again) that there was some issues with 3.2.3 databases.

If I am doing a manual install (manually creating the databases etc, running the scripts manually) what do I do with the mysql_3.2.3 script.

Sorry if Im not being clear.

--Dave

[originally posted on jforum.net by dcrumb]

[Migrated From Jforum.net]

So, you should do exactly what I said in the first answer

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Sorry to keep beating a dead horse... But I don't understand what that is supposed to do. I am doing a manual install.

Besides.. THIS doesn't look like valid SQL code in mysql

# ################
# PermissionControl
# ################
PermissionControl.deleteRoleValuesByRoleId = DELETE FROM jforum_role_values WHERE role_id IN (?)

PermissionControl.getRoleIdsByGroup = SELECT DISTINCT rv.role_id \
FROM jforum_role_values rv, jforum_roles r \
WHERE r.role_id = rv.role_id \
AND r.group_id = ?


Is this script (from mysql_3.2.3) supposed to replace some JSP code?

--Dave


(sorry, but the documentation isn't really clear on what to do with this)
[originally posted on jforum.net by dcrumb]

[Migrated From Jforum.net]

I assure you it is valid SQL code.

You don't have to edit any of these files. Just keep them where they are.

The only thing you have to do is to rename the file "mysql_323.sql" to "mysql.sql". That's all: just rename the file, and you're done

Rafael
[originally posted on jforum.net by Rafael Steil]