Hi guys,
This is the continuation to my posts in sept 2014. We have updated to 1.7 but our plugin ceased to work. I have log the entry and exit points of the methods in the plugin’s main.cfc file, and it enters the db function but doesn’t leave it, neither enters into the load function that registers our logic into the Razuna hooks. This tells me that that’s why the plugin doesn’t work.
Now, upon leaving the db function I have a SQL Exception telling me that the db-table for the plugin already exists.
Entering db function
+-----------------+--
| type | Database
| detail | Database reported: Table 'raz1_lturnotify' already exists
| message | General SQL Error
| errorcode | errorCode.sqlError
| extendedinfo |
| tagcontext | {CFML Type::array}
| sql | CREATE TABLE raz1_lturnotify
(
callback_url varchar(500)
)
ENGINE=InnoDB CHARACTER SET
| nativeerrorcode | 1050
| sqlstate | 42S01
| queryError | Table 'raz1_lturnotify' already exists
| datasource | MYSQL
| tagname | CFQUERY
| template | /usr/local/razuna_1_7/webapps/razuna/global/plugins/ltur/cfc/main.cfc
| line | 58
| column | 4
+-----------------+--
By the way, Razuna seems to be working alright, I can add, remove, and search my assets, so I get SQL-update went fine.
I have tried to manually carry DROP TABLE raz1_lturnotify with the razuna SQL user, but it seems it doesn’t have the privilege to do it remotely. So, should I really try to drop the table? I bet there is a good reason it is not suppose to, I before I do something stupid, I wanted to check with you guys.
Now I have also notice that the WEB-INF/bluedragon/work/cflog/application.log is missing, but instead there a new logs/Catalina.out. We logged onto the application.log file and that’s how we notice. Was there a change in the logging system? I checked with our administrator who update to 1.7 and he says he did not change anything on the logging. Whlle I get the plugin to work again I’m logging onto the Catalina.out. How can I set up a logging back to the application.log file?
As always, thanks a bunch! You guys are heroes and I love Razuna!
– Juan Pablo