Hello,
I was trying to install the tarballs linpha2-20080215 and linpha2-20080210. With both versions I had the same issue during installation.
In the Systems Check Tab during installation there I get the message:
Switching To AdoDB... ok
Checking For Existing Tables... mysql error: [1146: Table 'linpha2.adodb_logsql' doesn't exist] in EXECUTE("insert into adodb_logsql (created,sql0,sql1,params,tracer,timer) values( NOW(),'11.1404970508','SHOW TABLES','','
192.168.1.21/linpha2/install/step8_testing.php','0.000663')")
ok
Trying To Create New LinPHA Database User... ok
Testing Tables
Running Tests: CREATE ok INSERT ok ALTER ok UPDATE ok SELECT failed
Which is little bit surprising, as the only table in the database linpha2 is adodb_logsql.
Installation cannot continue from them - I delete the database in SQL and try again, but with the same result.
During installation I was only using the default values, let the system create a new database. My Database is MySQL 5.0.51. Older versions of Linpha2 and of course Linpha1 were running without any problem. In the var directory there is a database log, it says nearly the same:
1203102405 | ERROR | DATABASE | 192.168.1.20 | anonymous | adodb | mysql error: [1146: Table 'linpha2.adodb_logsql' doesn't exist] in EXECUTE("insert into adodb_logsql (created,sql0,sql1,params,tracer,timer) values( NOW(),'11.1404970508','SHOW TABLES','','<br>192.168.1.21/linpha2/install/step8_testing.php','0.007020')")
Please advice how to proceed - and thanks for the great software!!!
Martin
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
we have recently switched to adodb php5 only and add some adodb logging. We also are going to change to an XML based database creation design approach. So please expect things to be broken over the next 2 weeks and see the changelog for details.
thank you!
cheers bzrudi
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi bzrudi,
thanks for the extremely fast answer! Sure, I will try it again from the tarball over the next weeks.
And like all the others I am looking forward to the beta release :-)
Martin
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2008-02-16
hi
the sql logging stuff is only enabled if the file linpha/logsql.txt exists
delete the file, and try it again
the file logsql.txt is now removed from svn, but its still in the linpha2_20080210.alpha1.tar.gz ...
flo
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
I was trying to install the tarballs linpha2-20080215 and linpha2-20080210. With both versions I had the same issue during installation.
In the Systems Check Tab during installation there I get the message:
Switching To AdoDB... ok
Checking For Existing Tables... mysql error: [1146: Table 'linpha2.adodb_logsql' doesn't exist] in EXECUTE("insert into adodb_logsql (created,sql0,sql1,params,tracer,timer) values( NOW(),'11.1404970508','SHOW TABLES','','
192.168.1.21/linpha2/install/step8_testing.php','0.000663')")
ok
Trying To Create New LinPHA Database User... ok
Testing Tables
Running Tests: CREATE ok INSERT ok ALTER ok UPDATE ok SELECT failed
Which is little bit surprising, as the only table in the database linpha2 is adodb_logsql.
Installation cannot continue from them - I delete the database in SQL and try again, but with the same result.
During installation I was only using the default values, let the system create a new database. My Database is MySQL 5.0.51. Older versions of Linpha2 and of course Linpha1 were running without any problem. In the var directory there is a database log, it says nearly the same:
1203102405 | ERROR | DATABASE | 192.168.1.20 | anonymous | adodb | mysql error: [1146: Table 'linpha2.adodb_logsql' doesn't exist] in EXECUTE("insert into adodb_logsql (created,sql0,sql1,params,tracer,timer) values( NOW(),'11.1404970508','SHOW TABLES','','<br>192.168.1.21/linpha2/install/step8_testing.php','0.007020')")
Please advice how to proceed - and thanks for the great software!!!
Martin
Hey Martin,
we have recently switched to adodb php5 only and add some adodb logging. We also are going to change to an XML based database creation design approach. So please expect things to be broken over the next 2 weeks and see the changelog for details.
thank you!
cheers bzrudi
Hi,
thanks, that was it. I deleted the file, and now it works.
Great!
Martin
Hi bzrudi,
thanks for the extremely fast answer! Sure, I will try it again from the tarball over the next weeks.
And like all the others I am looking forward to the beta release :-)
Martin
hi
the sql logging stuff is only enabled if the file linpha/logsql.txt exists
delete the file, and try it again
the file logsql.txt is now removed from svn, but its still in the linpha2_20080210.alpha1.tar.gz ...
flo