Loading...
 
Features / Usability

Features / Usability


Database errors

posts: 14 United States

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.

posts: 14 United States

I had to reply....

When I hit "save" on the above post, I received a "database query error"! Perhaps it is not just me!


posts: 1092

3.2 was released with an error
please do this query in your database
ALTER TABLE tiki_plugin_security ADD added_by VARCHAR( 200 ) NULL AFTER status;

Or dowload the svn version of 3.0 branch


posts: 14 United States

(Resolved)

I added the field "added_by" and it is working properly now. Thanks for the assistance.


posts: 3
WOW WOW WOW... simple yet life saving. I was hitting my head on this for a while before I found this topic. Now i can put the aspirin away. Thank you sylvie

Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting