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
Tags
Geekyness