java.lang.reflect.InvocationTargetException: Base table or view not found message from server: "Unknown table 'jforum_roles' in MULTI DELETE"
Caused by: java.sql.SQLException: Base table or view not found message from server: "Unknown table 'jforum_roles' in MULTI DELETE"
I have a couple of forums on a staging server. when I export the databases to the production server and redeploy the web app I get this error
The table is certianly there.
I have even tried a fresh install with the same results.
Is this possibly an MySQL versioning issue:
$ mysql --version
mysql Ver 14.7 Distrib 4.1.8a, for pc-linux-gnu (i386) (production fails)
Connection to linode closed.
don@blackbox:~$ mysql --version
mysql Ver 12.22 Distrib 4.0.23, for pc-linux-gnu (i386) (staging works)
I *guess* that the problem in fact occurs due mysql version imcompatibilities. Since version 4.1, mysql ab has changed some architectural points of mysql, and one of them is related to unicode. You will have to do some more stepts in order to migrate a base from 4.0.x to 4.1.
Take a look at http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html
Rafael [originally posted on jforum.net by Rafael Steil]
Are you saying that JForum out of the box will NOT install with mysql 4.1? My experience is that the sql scripts run and the app installs and you can acess messages, add messages etc but when you try to change permissions you get the file not found exception jforum_roles. You can see from the following interactive mysql session the it has no trouble accessing/reading the table;
From within mysql i can read the table edit rows etc without issue. It is just from JForum that this fails.