Post Upgrade Problem

[Dogen]

Hi Ben,

Well, I guess I spoke to soon. Everything seemed to be in working order but I just found out that cannot view submissions via the admin. Forms are updating the database just fine, e-mails are been sent, but when you click on the "VIEW" link, you get a blank page after the form title appears. IE is reporting errors on the page. I've attached a screen capture.

   

---

I just installed the Database Integrity Manager. It found errors in the Core and Export Manager:

FORM TOOLS CORE - hook_calls - Invalid column: action_location
- is: enum('start','end')
- should be: varchar(100)

Export Manager - module_export_groups - missing column: form_view_mapping

Export Manager - module_export_groups - missing column: forms_and_views

[Ben]

Hi Dogen,

hah, I responded to your previous post too soon too. :-)

For the javascript error, empty your browser's cache. Most probably, it's just cached an old version of one of the JS files which is causing the error you're spotting. Or, possibly, it's related to the Export Manager module problem.

For the Export Manager problem, have you made any customizations to the module? If not, simply uninstall then re-install it. That will recreate the module database tables.

Lastly, for the Core problem, that's a worry... still, it's easy to fix. Do you have access to phpMyAdmin? If so, edit the table column and change the type from an ENUM field to a VARCHAR field of size 100. It's very simple to do through the phpMyAdmin interface.

Let me know how it goes!

- Ben

[Dogen]

Hi Ben,

Thanks again for helping me work through these issues.

So, I followed your instructions. Export Manager is now installed correctly. Changed the database structure. Database Integrity Manager now reports NO problems.

However....

The View Submissions issue is still unresolved. Cleared cache, cookies, temp files, etc. Tried with Firefox and IE. Both fail to show submissions. However, I also found something else wonky that is probably related.

On the Forms page, in IE the links to pages 2, 3 and 4 of our forms will not work. IE is reporting an error on the Forms page itself:

Line: 1
Char: 1
Error: 'ft' is undefined
Code: 0

In Firefox, however, the links to the other pages work just fine!

So I browsed around the admin menu some more. IE is reporting various errors on nearly every page (Settings, Clients, Modules, etc.). The Update button won't even work in IE.

Hi Dogen,

hah, I responded to your previous post too soon too. :-)

For the javascript error, empty your browser's cache. Most probably, it's just cached an old version of one of the JS files which is causing the error you're spotting. Or, possibly, it's related to the Export Manager module problem.

For the Export Manager problem, have you made any customizations to the module? If not, simply uninstall then re-install it. That will recreate the module database tables.

Lastly, for the Core problem, that's a worry... still, it's easy to fix. Do you have access to phpMyAdmin? If so, edit the table column and change the type from an ENUM field to a VARCHAR field of size 100. It's very simple to do through the phpMyAdmin interface.

Let me know how it goes!

- Ben

[Ben]

Hi Dogen,

Hmm... yeah, if it's in one of the main JS files, it'll throw errors all over the place and a lot of the functionality won't work.

The fact that it works in FF kind of makes me think it's still the cache, though... What theme are you using? If it's not the default, could you try switching temporarily to the default theme and try again in IE? I'm just wondering if it's theme-specific...

Oh - and also, what version of IE? (Form Tools 2 has never supported IE6!)

- Ben

[Dogen]

Hi Ben,

I'm using IE 7 and the default theme.

Tried clearing all browsing data from Chrome, FF and IE. No dice.

D.

Hi Dogen,

Hmm... yeah, if it's in one of the main JS files, it'll throw errors all over the place and a lot of the functionality won't work.

The fact that it works in FF kind of makes me think it's still the cache, though... What theme are you using? If it's not the default, could you try switching temporarily to the default theme and try again in IE? I'm just wondering if it's theme-specific...

Oh - and also, what version of IE? (Form Tools 2 has never supported IE6!)

- Ben

[Ben]

HI Dogen.

I'm stumped. Any chance I could log in and take a look myself?

(ben.keen@gmail.com).

- Ben