sample application installation and plugin problems

[marshmob]

I'm using a locally installed cf2018 and followed Getting the Example App Up and Running](https://cfwheels.org/blog/getting-the-example-app-up-and-running/) .

I'm getting index error if any plugin is present. No error if no plugins and app displays install screen but app then fails trying to find authenticate.

I did need to move the app up one level to the root directory before cfw would run and I'm using MYSQL on a win10 machine

I feel like I'm missing something simple and any help would be appreciated.

Thanks
Lee

---

Error message

Index 8 out of bounds for length 8

 
 
The error occurred in C:/ColdFusion2018/cfusion/wwwroot/wheels/plugins/initialization.cfm: line 42Called from C:/ColdFusion2018/cfusion/wwwroot/wheels/plugins/initialization.cfm: line 94Called from C:/ColdFusion2018/cfusion/wwwroot/wheels/plugins/initialization.cfm: line 26Called from C:/ColdFusion2018/cfusion/wwwroot/root.cfm: line 5Called from C:/ColdFusion2018/cfusion/wwwroot/wheels/global/internal.cfm: line 591Called from C:/ColdFusion2018/cfusion/wwwroot/wheels/global/internal.cfm: line 1011Called from C:/ColdFusion2018/cfusion/wwwroot/wheels/global/internal.cfm: line 999Called from C:/ColdFusion2018/cfusion/wwwroot/wheels/events/onapplicationstart.cfm: line 925Called from C:/ColdFusion2018/cfusion/wwwroot/wheels/events/onapplicationstart.cfm: line 881
40 : local.plugins = {}; 41 : // Within plugin folders, grab info about each plugin and package up into a struct. 42 : for (local.folder in $folders()) { 43 : // For *nix, we need a case-sensitive name for the plugin component, so we must reference its CFC file name. 44 : local.subfolder = DirectoryList("#local.folder.directory#/#local.folder.name#", false, "query");
 

---

Sysinfo (no plugins)

System

CFML Engine | Adobe ColdFusion2018,0,14,330003
CFWheels Version | 2.3.0
Java Runtime | Java(TM) SE Runtime Environment
Java Version | 11.0.1

Database

Datasource Name | svgapp1
Migrator Adapter Name | MySQL
Product Name | MySQL
Version | 8.0.20
Driver Name | MySQL Connector/J
Driver Version | mysql-connector-java-8.0.20 (Revision: afc0a13cd3c5a0bf57eaa809ee0ee6df1fd5ac9b)
JDBC Version | 4.2

Paths

Event Path | events
File Path | files
Image Path | images
Javascript Path | javascripts
Model Path | models
Plugin Path | plugins
Plugin Component Path | plugins
Stylesheet Path | stylesheets
View Path | views
Controller Path | controllers
Asset Query String |  
Asset Paths |  

[bpamiri]

Lee,

Getting the Example app up and running shouldn't be rocket science but unfortunately when you factor in different OSes, different CF engines, and different databases it gets a little complicated. Tom has a fairly thorough explanation of the manual steps involved in the wiki. Basically you have to start a CF Server, create a database, create a datasource, run the migrations and then you can log in. Have you followed the manual installation steps?

In contrast to that we've created a mechanism to distribute the Example app using ForgeBox.io and CommandBox that takes a lot of the manual steps out. With CommandBox in place, and the CFWheels CLI tools installed, you simply issue:

mkdir myApp
cd myApp
install cfwheels-example-app

Let me know if you have followed the manual installation steps in the wiki or if it's possible to get CommandBox installed to do a quick test.

[bpamiri]

It seems this is a known issue introduced in Adobe CF 2021 Update 2 and 2018 Update 12. There is a hot fix attached to that ticket for each flavor of ACF but the issue is each successive update did not incorporate the hot fix so you have to reinstall the hot fix if you update between 12, to 13, to 14. That would be a better approach for this than modifying the initialization.cfm script that I suggested above.

[marshmob]

Applied the hotfix and plugins don't crash CFW - so this problem is fixed Hooray! and thanks.

But during migration table creation works but table/fields updates fail with

Any ideas (hopefully an easier question than the initial one)

p.s.
CommandBox> install cfwheels-example-app points to CFW 2.2.0 not CFW 2.3.0

[bpamiri]

This one is probably because of MySQL 8.0. Our test suite throws some errors with MySQL 8.0. It’s on my list of things to get to and creeping up the list as other things are taken care of.

[marshmob]

My to do list just keeps getting bigger!

Thanks for all your help

p.s how do I mark a problem solved or answered

[bpamiri]

I marked it as answered for you. It's a button in the UI on the first answer in a thread.