CMS Not visible in admin after upgrade

lord_alan · Post by **lord_alan** » Wed Feb 03, 2010 6:31 pm

Any pointers?

I've upgraded our system from 5.5.1 to 6.0.1 using the manual method described in the README.txt file.

I've created (several times) the openemm_cms database using either the empty or the demo schema sql file.

I've checked the cms.properties file has the right url set on the cms.ccr.url line.

There is nothing obvious in any log files.

When I log in to the system, I do not have the Content Manager menu.

Everything else seems to be working just fine BTW.

TIA

Al

Post by **maschoff** » Wed Feb 03, 2010 9:40 pm

Did you update the database first from 5.5.1 to 6.0 and then from 6.0 to 6.0.1?

Is the new import wizard visible (new: profile management)?

lord_alan · Post by **lord_alan** » Thu Feb 04, 2010 12:16 am

Did you update the database first from 5.5.1 to 6.0 and then from 6.0 to 6.0.1?

Yes.

Is the new import wizard visible (new: profile management)?

In the recipients section? Yes.

Al

Post by **maschoff** » Thu Feb 04, 2010 8:32 am

Does your file sidemenu.properties contain these 3 lines at the end?

Code: Select all

msg_11=ContentManagement
href_11=/splash_cms.jsp
token_11=cms.central_content_management

lord_alan · Post by **lord_alan** » Thu Feb 04, 2010 8:59 am

Does your file sidemenu.properties contain these 3 lines at the end?
Code: Select all
msg_11=ContentManagement
href_11=/splash_cms.jsp
token_11=cms.central_content_management

Unfortunately yes. It does.

Post by **maschoff** » Thu Feb 04, 2010 9:08 am

That is really strange - So you have the item in the side menu but you can not see it? Or can you only not click on it?

When you launch OpenEMM do you have an error report in log file openemm_stdout.log?

lord_alan · Post by **lord_alan** » Thu Feb 04, 2010 9:37 am

Hi Martin,

No, the menu option in the sidebar is not present at all.

Here's a paste on the html source of the main admin screen

http://pastebin.com/m3171fc24

And I took a couple of screenshots just to prove it

The login screen:
http://twitpic.com/11b1vg

The main admin screen
http://twitpic.com/11b1yj

Thanks for helping to diagnose this.

Al

Post by **maschoff** » Thu Feb 04, 2010 9:47 am

Do you have the user rights for the CMS extension?

Have a look at table admin_group_permission_tbl:

Do you have entries for the two CMS permissions (field security token)?

Code: Select all

cms.central_content_management
cms.mailing_content_management

If so, what is the corresponding value in field admin_group_id?

lord_alan · Post by **lord_alan** » Thu Feb 04, 2010 9:52 am

Yes, they are both in the table.

Code: Select all

4    cms.central_content_management
4    cms.mailing_content_management

And all items in the table have the same admin_group_id: 4.

Weird.

lord_alan · Post by **lord_alan** » Thu Feb 04, 2010 10:01 am

ma wrote:When you launch OpenEMM do you have an error report in log file openemm_stdout.log?

No. There are the following log files in /home/openemm/var/log:

Code: Select all

/home/openemm/var/log$ ls -l
total 80
-rw-r--r-- 1 openemm openemm   104 2010-02-03 17:11 20100203-extbounce.log
-rw-r--r-- 1 openemm openemm    51 2010-02-03 17:10 20100203-tolc-bavd.log
-rw-r--r-- 1 openemm openemm    54 2010-02-03 17:10 20100203-tolc-bav-trigger.log
-rw-r--r-- 1 openemm openemm 14227 2010-02-03 23:58 20100203-tolc-bav-update.log
-rw-r--r-- 1 openemm openemm   151 2010-02-03 23:11 20100203-tolc-pickdist.log
-rw-r--r-- 1 openemm openemm   173 2010-02-03 17:10 20100203-tolc-recovery.log
-rw-r--r-- 1 openemm openemm   151 2010-02-03 23:10 20100203-tolc-slrtscn.log
-rw-r--r-- 1 openemm openemm   419 2010-02-03 23:12 20100203-tolc-update.log
-rw-r--r-- 1 openemm openemm 18156 2010-02-04 08:52 20100204-tolc-bav-update.log
-rw-r--r-- 1 openemm openemm   150 2010-02-04 08:11 20100204-tolc-pickdist.log
-rw-r--r-- 1 openemm openemm   150 2010-02-04 08:10 20100204-tolc-slrtscn.log
-rw-r--r-- 1 openemm openemm   150 2010-02-04 08:13 20100204-tolc-update.log
-rw-r--r-- 1 openemm openemm  3375 2010-02-03 22:47 velocity.log

I have noticed the following repeating error in the bav-update.log

Code: Select all

[04.02.2010  08:52:20] 8503 ERROR/data: Unable to read virtusertable (2, 'No such file or directory')
[04.02.2010  08:55:20] 8503 ERROR/data: Unable to read virtusertable (2, 'No such file or directory')

And in velocity.log is the following:

Code: Select all

2010-02-03 22:47:04,262 - SimpleLog4JLogSystem initialized using logfile '/home/openemm/var/log/velocity.log'
2010-02-03 22:47:04,262 - ************************************************************** 
2010-02-03 22:47:04,262 - Starting Jakarta Velocity v1.4
2010-02-03 22:47:04,262 - RuntimeInstance initializing.
2010-02-03 22:47:04,262 - Default Properties File: org/apache/velocity/runtime/defaults/velocity.properties
2010-02-03 22:47:04,262 - Trying to use logger class org.apache.velocity.runtime.log.AvalonLogSystem
2010-02-03 22:47:04,262 - Couldn't find class org.apache.velocity.runtime.log.AvalonLogSystem or necessary supporting classes in classpath. Exception : java.lang.NoClassDefFoundError: org/apache/log/format/Formatter
2010-02-03 22:47:04,263 - Trying to use logger class org.apache.velocity.runtime.log.SimpleLog4JLogSystem
2010-02-03 22:47:04,263 - Using logger class org.apache.velocity.runtime.log.SimpleLog4JLogSystem
2010-02-03 22:47:04,270 - Default ResourceManager initializing. (class org.apache.velocity.runtime.resource.ResourceManagerImpl)
2010-02-03 22:47:04,278 - Resource Loader Instantiated: org.apache.velocity.runtime.resource.loader.FileResourceLoader
2010-02-03 22:47:04,278 - FileResourceLoader : initialization starting.
2010-02-03 22:47:04,278 - FileResourceLoader : adding path '.'
2010-02-03 22:47:04,278 - FileResourceLoader : initialization complete.
2010-02-03 22:47:04,283 - ResourceCache : initialized. (class org.apache.velocity.runtime.resource.ResourceCacheImpl)
2010-02-03 22:47:04,283 - Default ResourceManager initialization complete.
2010-02-03 22:47:04,286 - Loaded System Directive: org.apache.velocity.runtime.directive.Literal
2010-02-03 22:47:04,291 - Loaded System Directive: org.apache.velocity.runtime.directive.Macro
2010-02-03 22:47:04,298 - Loaded System Directive: org.apache.velocity.runtime.directive.Parse
2010-02-03 22:47:04,316 - Loaded System Directive: org.apache.velocity.runtime.directive.Include
2010-02-03 22:47:04,319 - Loaded System Directive: org.apache.velocity.runtime.directive.Foreach
2010-02-03 22:47:04,387 - Created: 20 parsers.
2010-02-03 22:47:04,407 - Velocimacro : initialization starting.
2010-02-03 22:47:04,407 - Velocimacro : adding VMs from VM library template : VM_global_library.vm
2010-02-03 22:47:04,415 - ResourceManager : unable to find resource 'VM_global_library.vm' in any resource loader.
2010-02-03 22:47:04,416 - Velocimacro : error using  VM library template VM_global_library.vm : org.apache.velocity.exception.ResourceNotFoundException: Unable to find resource 'VM_global_library.vm'
2010-02-03 22:47:04,416 - Velocimacro :  VM library template macro registration complete.
2010-02-03 22:47:04,416 - Velocimacro : allowInline = true : VMs can be defined inline in templates
2010-02-03 22:47:04,416 - Velocimacro : allowInlineToOverride = false : VMs defined inline may NOT replace previous VM definitions
2010-02-03 22:47:04,416 - Velocimacro : allowInlineLocal = false : VMs defined inline will be  global in scope if allowed.
2010-02-03 22:47:04,416 - Velocimacro : messages on  : VM system will output logging messages
2010-02-03 22:47:04,416 - Velocimacro : autoload off  : VM system will not automatically reload global library macros
2010-02-03 22:47:04,416 - Velocimacro : initialization complete.
2010-02-03 22:47:04,416 - Velocity successfully started.

Do these help?

Post by **maschoff** » Thu Feb 04, 2010 10:36 am

No. I need the output in log openemm_stdout.log when OpenEMM is started.

Post by **maschoff** » Thu Feb 04, 2010 2:31 pm

From the log you sent me I saw that it is a (complicated) database problem. Do you work with more than one OpenEMM session at the same time (i.e. tabbed browsing of the same application)? Are property system.url in emm.properties and cms.ccr.url in cms.properties set correctly?

lord_alan · Post by **lord_alan** » Thu Feb 04, 2010 2:43 pm

Do you work with more than one OpenEMM session at the same time (i.e. tabbed browsing of the same application)?

Quite often I do yes. I have one tab open with a mailing content preview panel open and then in another tab I make edits to the content etc. and then review the changes by reloading the preview in the other tab.

Are property system.url in emm.properties and cms.ccr.url in cms.properties set correctly?

I believe they are:

Code: Select all

system.url=http://tolc.xx.xxxxxxxx.co.uk:8080

cms.ccr.url=http://tolc.xx.xxxxxxxx.co.uk:8080

Al

Post by **maschoff** » Thu Feb 04, 2010 2:52 pm

To track down the problem you can set up a fresh installation of OpenEMM 6.0.1 with a copy of your database. If the CMS is still invisible, delete everything you don't want us to see (addresses, mailings, etc.) and send us a DB dump so that we can replicate the issue.

lord_alan · Post by **lord_alan** » Thu Feb 04, 2010 3:00 pm

ma wrote:To track down the problem you can set up a fresh installation of OpenEMM 6.0.1 with a copy of your database. If the CMS is still invisible, delete everything you don't want us to see (addresses, mailings, etc.) and send us a DB dump so that we can replicate the issue.

OK. Thanks. I can do that.

This is essentially a "fresh install" though. I used the instructions in the README.txt file and so moved my 5.5.1 /home/openemm to openemm_backup and then untarred the 6.0.1 bin tarball into a new openemm directory.

I should get some time tomorrow to build a new install and will see how it goes.

Thanks

Al