just trying to update an instance of ts-ng (1.5.1 I think) having downloaded the latest version (1.5.3) . the script fails ( so far) when it tries to find config table. The table that is installed is _tableprefix_configuration and the script is looking for _tableprefix_config ( line 102 i think, but im not a bash-ist)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
is there a web-based update ?
done it - but at step 2 it generates the same error
Could not check version
Database said: Table 'ts.timesheet_config' doesn't exist. the table is named ...timesheet_configuration
and once ive copied ts_configuration to ts_config the web updates says
Could not complete script
Your query said: -- copy stuff from active config to new configuration table insert into timesheet_configuration (name, value) values ('version','1.5.3')
Our database said: Unknown column 'name' in 'field list'
Last edit: paul cooper 2013-10-14
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
looks to me ( as a non-Sqlist, non-PHPist ) that the problem is in parsing timesheet_sheet_upgrade_to_1.5.3....
it thinks the SQL comment that is left in the file
"-- copy stuff from active config to new configuration table "
is an sql command , ( but there is more , i think)
Last edit: paul cooper 2013-10-14
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
solved the first bit - there is a missing return true
in function update_new_db_version. in install/index.php
so the script kept going back to attempting the database upgrade and then failing because configuration file already existed/
so ive now got the update to run and say its finished , but im still taken to the install screen , when following the link to ts-next gen.
Do i need to remove install directory or something ( but then id need to copy the two inc files back from install/ to the timesheet directory )
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
just trying to update an instance of ts-ng (1.5.1 I think) having downloaded the latest version (1.5.3) . the script fails ( so far) when it tries to find config table. The table that is installed is _tableprefix_configuration and the script is looking for _tableprefix_config ( line 102 i think, but im not a bash-ist)
Using the bash script? Try the web install, I have used that one.
is there a web-based update ?
done it - but at step 2 it generates the same error
Could not check version
Database said: Table 'ts.timesheet_config' doesn't exist. the table is named ...timesheet_configuration
and once ive copied ts_configuration to ts_config the web updates says
Could not complete script
Your query said: -- copy stuff from active config to new configuration table insert into timesheet_configuration (name, value) values ('version','1.5.3')
Our database said: Unknown column 'name' in 'field list'
Last edit: paul cooper 2013-10-14
looks to me ( as a non-Sqlist, non-PHPist ) that the problem is in parsing timesheet_sheet_upgrade_to_1.5.3....
it thinks the SQL comment that is left in the file
"-- copy stuff from active config to new configuration table "
is an sql command , ( but there is more , i think)
Last edit: paul cooper 2013-10-14
solved the first bit - there is a missing return true
in function update_new_db_version. in install/index.php
so the script kept going back to attempting the database upgrade and then failing because configuration file already existed/
so ive now got the update to run and say its finished , but im still taken to the install screen , when following the link to ts-next gen.
Do i need to remove install directory or something ( but then id need to copy the two inc files back from install/ to the timesheet directory )