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
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]
[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.
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
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