• 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
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

cvs 12/21 Admin Group Edit fails with mysql

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
edit groups and with MySQL ver 4.1 cause a MULTIPLE delete error on jforufoum role vales table.

server version: 4.1.12-standard-log


Removed the delete all from the special mysql queries files made that work again

as below

#PermissionControl.deleteAllRoleValues=DELETE jforum_role_values FROM jforum_role_values rv, jforum_roles r WHERE r.role_id \= rv.role_id AND r.group_id \= ?

[originally posted on jforum.net by mqjoe1]
 
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
JIRA JF-455
[originally posted on jforum.net by mqjoe1]
 
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
Hm, JForum was supposed to correctly handle this versioning thing, if the webserver's user had write permissions to the WEB-INF/config/database/mysql directory.

Ok, I'll take a look

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
I'm seeing the same thing with JForum 2.1.4 / MySQL 4.1.14 / Tomcat 5.0.27 too.

Go to: Admin Console - Groups / "General" / Permissions - then save.

This error is returned:

An error has ocurred. For detailed stack trace, please see the page's source code.

Unknown table 'jforum_role_values' in MULTI DELETE


I was trying to disable anonymous posting for my forums when I found it. And, the table exists with data in it.

From a web search:
"This is expected behavior for MySQL post version 4.1. Check out:
http://dev.mysql.com/doc/mysql/en/DELETE.html
particularly the 'Note:' section just before the user comments. If you use table aliases you must use those aliases to refer to the tables you want to delete, not the table names themselves."
[originally posted on jforum.net by GatorBait3]
 
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
Found a solution / work-around!

In the /${CATALINA_HOME}/webapps/jforum/WEB-INF/config/database/mysql directory (or appropriate directory for your app engine install), rename the mysql.sql to something else (i.e. mysql-org.sql), then copy the mysql_41.sql to mysql.sql. Restart the application / app server.

In my case, the mysql.sql file had the direct table references in it. The mysql_41.sql has the table aliases references, and works correctly.

Rafael, does the installer copy the mysql_41.sql file to the mysql.sql file if mysql 4.1 is selected during the install? Or is there a config file somewhere that references the mysql_41.sql file instead (I couldn't find any reference in the SystemGlobals or jforum-custom files).
[originally posted on jforum.net by GatorBait3]
 
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
The new installer does the correct thing

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
I just got CVS from today clean rebuilt new DB fresh install, but I am still having the problem

this time I had to comment out the

#PermissionControl.deleteAllRoleValues = DELETE jforum_role_values \
FROM jforum_role_values rv, jforum_roles r \
WHERE r.role_id = rv.role_id \
AND r.group_id = ?

from the mysql_40.sql

Yet my db is:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 155098 to server version: 4.1.12-standard-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


Seems like somewhere its not picking up the db version yet

[originally posted on jforum.net by mqjoe1]
 
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
mqjoe,

When you comment out this section, do you replace it with the correct statement using the alias instead of table reference? Seems like it wouldn't work correctly just commenting out the command.

Like I said in my other post, copying the mysql_41.sql to mysql.sql works just fine too.

But good for everyone to know that the problem still exists.

[originally posted on jforum.net by GatorBait3]
 
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
commenting it out, makes it use the sql in the generic file, which seems to make my ver of Mysql happy 4.1.12

[originally posted on jforum.net by mqjoe1]
 
reply
    Bookmark Topic Watch Topic
  • New Topic