• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Devaka Cooray
  • Tim Cooke
Sheriffs:
  • Rob Spoor
  • Liutauras Vilda
  • paul wheaton
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Mikalai Zaikin
  • Carey Brown
  • Piet Souris
Bartenders:
  • Stephan van Hulst

New Install (Manual) with MySQL 3.2.3

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hhm... could you please be more specific then?

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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]
 
F is for finger. Can you stick your finger in your nose? Doesn't that feel nice? Now try this tiny ad:
Smokeless wood heat with a rocket mass heater
https://woodheat.net
reply
    Bookmark Topic Watch Topic
  • New Topic