Applied : Jaws Update to 0.8.1

Just a quick note to say that this site now uses Jaws 0.8.1 which fixes some security updates and other issues, please note that any issue you may have experienced with this site during this transition have now been resolved...
The upgrade process was not as smooth as I would have liked but after some kinks the issue is now resolved......see below for the transcript...
14:09Γ‚ Lee: hello lee croucher here
Γ‚ afzcode: hello
Γ‚ Lee: I logged on the forum about the jaws 0.8 upgrade error
14:10Γ‚ afzcode: remember
Γ‚ Lee: MDB2 Error: no such field : _doQuery: [Error message: Could not execute statement] [Last executed query: ALTER TABLE `registry` CHANGE `name` `key_name` VARCHAR(128) NOT NULL, CHANGE `value` `key_value` TEXT] [Native code: 1054] [Native message: Unknown column 'name' in 'registry']
Γ‚ Γ‚ that error
Γ‚ afzcode: yes
Γ‚ Lee: you asked me to IM you
14:11Γ‚ how do I fix this error?
14:12Γ‚ afzcode: did you check log through upgrade?
Γ‚ Γ‚ in upgrade step 2
Γ‚ Lee: I can do and try again if you like
Γ‚ afzcode: you have backup of your database
Γ‚ Γ‚ ?
Γ‚ Lee: yes
Γ‚ Γ‚ totally
14:13Γ‚ afzcode: so restore it, to old jaws
Γ‚ Lee: have do that so I am on 0.7
Γ‚ Γ‚ shall I attempt a 0.8 upgrade now?
Γ‚ afzcode: yes, we try re upgrade
14:14Γ‚ but plz. check log in this upgrade
Γ‚ Lee: ok hold on a minute
Γ‚ Γ‚ extracting files now
14:15Γ‚ right ticked the log install process.....
14:16Γ‚ chose international enligsh
Γ‚ Γ‚ shall I enable secure upgrade?
Γ‚ afzcode: not nedded
Γ‚ Lee: ok
Γ‚ afzcode: *needed
14:17Γ‚ Lee: shall I enter the root MySQL account
Γ‚ Γ‚ or the normal account
Γ‚ afzcode: user that access to your databases
Γ‚ Lee: ok
14:18Γ‚ ok the status says 0.8.0 requires update
Γ‚ afzcode: ok
14:19Γ‚ Lee: then I get upgrading from 0.7.x to 0.8x will : then I get no text it is blank....is this normal
14:20Γ‚ then I get...
Γ‚ Γ‚ MDB2 Error: already exists : _doQuery: [Error message: Could not execute statement] [Last executed query: ALTER TABLE `gadget_shouters` RENAME TO `shouters`, CHANGE `gadget_call` `event` VARCHAR(32) DEFAULT NOT NULL] [Native code: 1050] [Native message: Table 'shouters' already exists]
Γ‚ Γ‚ the log is as follows....

[Tue Aug 19 ,758 2008][LOG_DEBUG]Generating new installation key
[Tue Aug 19 ,515 2008][LOG_DEBUG]Input log and session key match
[Tue Aug 19 ,533 2008][LOG_DEBUG]Checking requirements...
[Tue Aug 19 ,540 2008][LOG_DEBUG]PHP installed version looks ok (>= 4.3.6)
[Tue Aug 19 ,547 2008][LOG_DEBUG]config directory has read-permission privileges
[Tue Aug 19 ,554 2008][LOG_DEBUG]data directory has read and write permission privileges
[Tue Aug 19 ,559 2008][LOG_DEBUG]xml support is enabled
[Tue Aug 19 ,564 2008][LOG_DEBUG]PHP accepts file uploads
[Tue Aug 19 ,569 2008][LOG_DEBUG]PHP has safe-mode turned off
[Tue Aug 19 ,575 2008][LOG_DEBUG]PHP has GD or ImageMagick turned on
[Tue Aug 19 ,580 2008][LOG_DEBUG]exif support is enabled
[Tue Aug 19 ,588 2008][LOG_DEBUG]data/themes directory exists
[Tue Aug 19 ,328 2008][LOG_DEBUG]Checking if MySQLi (4.1.3 and above)(mysqli) driver is available
[Tue Aug 19 ,333 2008][LOG_DEBUG]Driver MySQLi (4.1.3 and above)(mysqli) is available
[Tue Aug 19 ,339 2008][LOG_DEBUG]Checking if MySQL(mysql) driver is available
[Tue Aug 19 ,344 2008][LOG_DEBUG]Driver MySQL(mysql) is available
[Tue Aug 19 ,350 2008][LOG_DEBUG]Checking if PostgreSQL(pgsql) driver is available
[Tue Aug 19 ,356 2008][LOG_DEBUG]Driver PostgreSQL(pgsql) is available
[Tue Aug 19 ,362 2008][LOG_DEBUG]Checking if Oracle(oci8) driver is available
[Tue Aug 19 ,367 2008][LOG_DEBUG]Driver Oracle(oci8) is NOT available
[Tue Aug 19 ,373 2008][LOG_DEBUG]Checking if MSSQL Server(mssql) driver is available
[Tue Aug 19 ,379 2008][LOG_DEBUG]Driver MSSQL Server(mssql) is available
[Tue Aug 19 ,384 2008][LOG_DEBUG]Checking if Interbase/Firebird(interbase) driver is available
[Tue Aug 19 ,390 2008][LOG_DEBUG]Driver Interbase/Firebird(interbase) is NOT available
[Tue Aug 19 ,396 2008][LOG_DEBUG]Checking if SQLite 2(sqlite) driver is available
[Tue Aug 19 ,401 2008][LOG_DEBUG]Driver SQLite 2(sqlite) is available
[Tue Aug 19 ,859 2008][LOG_DEBUG]Checking current database
[Tue Aug 19 ,870 2008][LOG_DEBUG]Connected to mysqli database driver successfully.
[Tue Aug 19 ,956 2008][LOG_DEBUG]Checking/Reporting previous missed installations
[Tue Aug 19 ,964 2008][LOG_DEBUG]0.8.0 requires upgrade
[Tue Aug 19 ,970 2008][LOG_DEBUG]0.7.4 does not requires upgrade
[Tue Aug 19 ,977 2008][LOG_DEBUG]0.7.3 does not requires upgrade
[Tue Aug 19 ,983 2008][LOG_DEBUG]0.7.2 does not requires upgrade
[Tue Aug 19 ,989 2008][LOG_DEBUG]0.7.1 does not requires upgrade
[Tue Aug 19 ,995 2008][LOG_DEBUG]0.7.0 does not requires upgrade
[Tue Aug 19 ,001 2008][LOG_DEBUG]Checking if current version (0.8.0) really requires an upgrade
[Tue Aug 19 ,203 2008][LOG_DEBUG]Upgrading core schema
[Tue Aug 19 ,785 2008][LOG_DEBUG]MDB2 Error: already exists : _doQuery: [Error message: Could not execute statement]
[Last executed query: ALTER TABLE `gadget_shouters` RENAME TO `shouters`, CHANGE `gadget_call` `event` VARCHAR(32) DEFAULT
NOT NULL]
[Native code: 1050]
[Native message: Table 'shouters' already exists]

14:21Γ‚ afzcode: restore databse not delete old tables in database
Γ‚ Γ‚ thsi table for previous faild upgrade
Γ‚ Γ‚ *Γ™Γ˜§Γ™‡Γ˜³
Γ‚ Γ‚ this
14:22Γ‚ so plz. full empty databse
Γ‚ Lee: so how do I fix this?
Γ‚ afzcode: and restore from your backup
Γ‚ Lee: drop all tables in the database
Γ‚ Γ‚ ?????
Γ‚ Γ‚ or do you want me to restore the 0.7 database over the top
14:23Γ‚ afzcode: you only have jaws table in your database?
Γ‚ Γ‚ and you have backup of thay?
Γ‚ Γ‚ yes
Γ‚ Lee: yes
Γ‚ Γ‚ i have jaws tables in my database
Γ‚ afzcode: so you can drop all tables form databse
Γ‚ Lee: so you want a blank database?
14:24Γ‚ afzcode: yes, for detect correct error
Γ‚ Lee: sorry do not understand that last somment
Γ‚ Γ‚ comment sorry
14:25Γ‚ afzcode: yes, you ask about black database
Γ‚ Lee: no blank database
Γ‚ Γ‚ you want me to delete all 61 tables the the jaws catalogue?
14:26Γ‚ afzcode: delete only jaws tables
Γ‚ Γ‚ old, and new
Γ‚ Lee: done
Γ‚ Γ‚ now what?
Γ‚ afzcode: restore old database
14:27Γ‚ from backup
Γ‚ Lee: restored
Γ‚ Γ‚ now what
Γ‚ afzcode: re proce upgrade wizard
14:28Γ‚ and check log option
Γ‚ Lee: ok
Γ‚ Γ‚ thanks it works
Γ‚ Γ‚ thats cool
14:29Γ‚ afzcode: just a quick note
Γ‚ Γ‚ today we have reported bug in upgrade from 0.7 to 0.8
Γ‚ Γ‚ you can manually fix it
14:30Γ‚ Lee: how and was is the issue
Γ‚ afzcode: just goto table "listerners"
Γ‚ Lee: ok
14:31Γ‚ afzcode: and remove all record that in method field stored "UninstallGadget" string
14:32Γ‚ i try today release 0.8.1, and this issue fixed in it
Γ‚ Lee: why do you not get the policy enforcer in the upgrade
Γ‚ Γ‚ ??
14:33Γ‚ afzcode: releasing 0.8.1 easiest than publish this policy
14:34Γ‚ Lee: does that mean this will appear in 0.81
Γ‚ Γ‚ ??
Γ‚ afzcode: 0.8.1 auto fix thsi issue
Γ‚ Lee: cool
14:35Γ‚ do i need to restore the old content and data folders....as all my photos are missing!
14:36Γ‚ afzcode: only data folder
Γ‚ Γ‚ without cache directore
Γ‚ Γ‚ *directory

5 minutes
14:42Γ‚ Lee: still there
Γ‚ afzcode: yes
Γ‚ Lee: since the update it is trying to transfer data from 192.168.0.5 no 87.194.16.70
Γ‚ Γ‚ what up?
14:43Γ‚ afzcode: where?
Γ‚ Lee: in one of the config files I guess
14:45Γ‚ did the upgrade from http://192.168.0.5
Γ‚ afzcode: goto jaws control panel
Γ‚ Lee: yes
Γ‚ afzcode: and then goto settings gadget
Γ‚ Γ‚ sorry
Γ‚ Γ‚ Registry gadget
14:46Γ‚ and finf key /config/site_url
Γ‚ Γ‚ and empty it
Γ‚ Γ‚ so save it
Γ‚ Γ‚ ok?
Γ‚ Lee: got it
14:47Γ‚ chnagin it now
Γ‚ afzcode: re check it
Γ‚ Lee: it is blank
14:48Γ‚ what should it be
Γ‚ afzcode: maybe you hardcode enter thsi ip address into your theme
Γ‚ Lee: it is a default theme
14:49Γ‚ ok changing that key screwed jaws
Γ‚ Γ‚ Error 500 - Internal server error

The server encountered an unexpected condition which prevented it from fulfilling the request.
14:51Γ‚ afzcode: you have frameset in your site
Γ‚ Γ‚ so why is it?
Γ‚ Lee: the registry database is missing the site_url field shall I add it?
14:52Γ‚ afzcode: in jaws 0.8.0, we not use site_url, and this key only for compatiblity with 0.7.x
14:53Γ‚ Lee: no CSS is working with this......
Γ‚ Γ‚ it look like a site with no CSS
14:54Γ‚ might revert the 0.7 and wait for 0.8.1
Γ‚ Γ‚ :-)
Γ‚ afzcode: your problem not fix
Γ‚ Lee: yes
Γ‚ afzcode: can you access me to jaws control panel
Γ‚ Lee: no
Γ‚ Γ‚ http error 500
14:55Γ‚ will revert to 0.7
14:56Γ‚ afzcode: http://87.194.16.70/cms/
Γ‚ Lee: yeah but it is working on 0.7 now
Γ‚ Γ‚ so that will work
Γ‚ Γ‚ will wait for 0.8.2 unless you have a copy I can use?
14:57Γ‚ love jaws hate this upgrade path
Γ‚ afzcode: if you help us, we can help you
Γ‚ Lee: are you in later on
Γ‚ afzcode: yes
Γ‚ Lee: whats the time there
14:58Γ‚ will IM you about 17:00 GMT
14:59Γ‚ afzcode: until 21 GMT
Γ‚ Lee: speak to you later then!
Γ‚ afzcode: ok
Then to resolve the issue the final transcript are as follows:
20:21 Lee: hello again
 afzcode: hi
 Lee: upgrade again to 0.8 all is now OK except for.....
20:22 all the links point back to http://192.168.0.5 not the internet address
 afzcode: good
 Lee: that is not good
  the website does not work outside this house
  ??
 afzcode: good for upgrade
20:23 not for bad urls :)
 Lee: ooohh I see
  how do I fix this final hurdle......it worked fine on 0.7
  mind you
20:24 afzcode: plz. goto database registry table
  and find record
 Lee: thast messed up jaws last time
 afzcode: /config/site_url
20:25 record /config/site_url
  and empty it
 Lee: sure this caused issues last time!
 afzcode: this time in table
  after it remove cache directory in data folder
20:26 Lee: ok going to registy in jaws admin now
20:27 afzcode: database not gadget
 Lee: aaahh OK
 afzcode: registry table
20:28 Lee: OK from MySQL clear the site_url key and delete the cache in data, right?
 afzcode: just emty it
  *empty
 Lee: done and removed cache
20:29 shall I try the website now then
  wicked that has worked
 afzcode: all thing ok?
 Lee: thanks for that
  when is 0.8.1 avaliable
  ??
20:30 afzcode: in 0.8.1, by default we empty site_url
 Lee: when can I download 0.8.1
 afzcode: 2/3 next hours
20:31 Lee: that soon
  from where do you have a link?
 afzcode: have a link?
 Lee: url link
  to the download for 0.8.1
20:32 afzcode: in jaws website we publish it
 Lee: cool
  thanks for your help
 afzcode: np