Database errors
Apache 2.2.9
MySQL 5.0.51b
PHP 5.2.9
TikiWiki 3.2 (Company_intranet profile used) (Coelesce theme)
Since installation, I have had database query errors at just about every turn. I had to modify things to make the calendar work. I had to set MySQL to non-strict mode in order to make the "structures" feature work.
I am now wanting to access external database information using dsn and the SQL plugin. I cannot even get to whether it works or not due to yet another MySQL database error (see blow):
An error occured in a database query!
Context:
File tiki-index.php
Url tiki-index.php?page=Mission&structure=SOP
Query:
INSERT INTO tiki_plugin_security (fingerprint, status, added_by, last_objectType, last_objectId) VALUES(?, ?, ?, ?, ?)
Values:
0 sql-9d111684819347420a661dd4a66f79e0-30277625601e3dce4018a3fe5c8eb5bf-300000-290000
1 pending
2 admin
3 wiki page
4 Mission
Message:
Built query was probably:
INSERT INTO tiki_plugin_security (fingerprint, status, added_by, last_objectType, last_objectId) VALUES('sql-9d111684819347420a661dd4a66f79e0-30277625601e3dce4018a3fe5c8eb5bf-300000-290000', 'pending', 'admin', 'wiki page', 'Mission')
I have re-run the tiki-install to "remake" the database about 10 times so far. I have strict mode off. I am using root (admin) to connect (this is an internal site) What more can I do to make TikiWiki actually function correctly with MySQL ? I really like the abilities of TikiWiki, but it's taking all of my time and patience to make it work, rather than learning/using it's features.
Any thoughts or ideas would be welcomed on this particular problem, or the whole TikiWiki/MySQL issue that I am experiencing.