Category: Database independence (Non-Mysql, ADOdb Postgres, Oracle, etc)

Contributors

In the bottom bar of Tiki sites if activated there is some "debug" information. Notably:

{img src=images/code.png}%%% {CODE()}
[ xx database queries used ]
{CODE}

The SQL counter report is incorrect and reports higher number. Since this is making Tiki look bad for no good reason I am removing until it's fixed.

Please see:
http://sourceforge.net/mailarchive/message.php?msg_id=469E4D13.8010609%40gmail.com

Contributors

Contributors

On a new installation of TikiWiki 1.9.4 (installed via Fantastico on a LAMP server), I get the following error:

Notice: Only variable references should be returned by reference in /home/hocho/public_html/wiki/tikiwiki/lib/adodb/adodb.inc.php on line 834

Warning: Cannot modify header information - headers already sent by (output started at /home/hocho/public_html/wiki/tikiwiki/lib/adodb/adodb.inc.php:834) in /home/hocho/public_html/wiki/tikiwiki/tiki-adminusers.php on line 414


All I did was create a new group and try to assign the group to a new user.
I also don't know why it is using ADOdb when I am using MySQL.

All other functionality of TikiWiki seems fine.

Hi,

I try to install Tikiwiki 3.1 on a PostgreSQL 8.3.5 database.
I create a local.php file and installer will find and connect the database.

After clicking on "continue" during the "Install profile" screen, the installer fails, printing the following message

Fatal error: Call to a member function fetchRow() on a non-object in /wiki/dev/3.1/appli/tikidev/installer/installlib.php on line 247


Looking at the shema database, there is only 5 tables
tiki_dynamic_variables
tiki_minichat
tiki_pages_changes
tiki_plugin_security
tiki_send_newletters_files


and 2 sequences

tiki_minichat_id_seq
tiki_sent_newletters_id_seq



Is there a fix ?


Regards,
Franck.

When trying to add a new page to an existing structure I got the following error:

Field 'structure_id' doesn't have a default value


I could correct this very simply by going into the MySQL administrator and changing that column to have a default value of 0. I guess this is just that the DB set up SQL is incorrect and needs to have default value added to that column. I used the update SQL from 1.8 to 1.9 to create this tikiwiki so I guess that is the SQL that would need to be changed. I have not tested the new clean DB install of 1.9.

Cheers Mike

Hello,

~~#0c6:HELP, I spent 120 hours on the problem, and I am completely stopped in my Work because I can't install Tikiwiki on the development tool on windows. I could not find a way to understand why 4.1 installation seam's impossible on windows. A failure, that I could not find till know, on windows is not detected by the product.~~

Sorry for the length.

I try to install on windows to make test and developments an installation of tikiwiki 4.1 that is on a unix system (OVH provider with shared servers). So I can't have xdebug and many other facilities.
This local replication is needed to begin my participation to the dev.tikiwiki.org.

For this I have :
1- Changed the way to hold .htaccess (patch) For my apache I use the définition
AccessFileName access.htaccess
My various application are accessed via virtualhosts
this since six years.
2- Enable all needed extension for php : the lonely problem is that it not exists an adodb.dll for php 5.3.0 on windows (not found)

After I tried a manual installation :
- create mysql db with data 4.1
- create local.php

This crash on (see screen xdebug copy) the instruction in tikisession-pdo.php
TikiDb::get()->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);


But when I made the searches (this is the opportunity to go inside the product)
__I could not find the way how the instance of the class TikiDb inherit of the setAttribute method from probably Zend_Db_Statement_Pdo__
in lib\core\lib\Zend\Db\Statement\Pdo.php:411:

If the link exists I am interested in the fact to understand the structure.
If this come from the lack of the adodb.dll extension (functions and constants) this should be detected and I could not reach this execution point.

Generally may be a detection of php extension features could in the future avoid my "exploration".

I will redact when I will have solved all the problems a document about detail of a good implementation on windows.

Thank's for an answer, because I am locked till 15 days on this problem.

Trebly :

''__Nota1: __''I try new clean installation which don't functions, it crashes, after everything seems to be ended well installed the data are empty and a loop of to forms is without issue :
# because the data base is not populated
# because at the end we go back to the screen for validation of user and pass (second time) which calls the language form ad vitam.
The analyze shows that the POST('user') and POST('pass') are not got back into tiki-install.php and the failed installer is not run again.
Finally if I populate the data base with the data's (SQL) coming from one of the to implementations I reach the same as described upon.

''__Nota2:__'' The data's are well accessed by phpmyadmin and the parameters OK.
''
__Nota3:__'' I run Mysql with mysqli extension. 256Mo of memory for php
* Version du serveur: 5.1.37-community-log
* Version du protocole: 10
* Utilisateur: root@localhost
* Jeu de caractères pour MySQL: UTF-8 Unicode (utf8)
Serveur web
* Apache/2.2.13 (Win32) DAV/2 mod_ssl/2.2.13 OpenSSL/0.9.8k SVN/1.6.6 PHP/5.3.0
* Version du client MySQL: mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $
* Extension PHP: mysqli
phpMyAdmin
* Version: 3.2.1

May be there are other reasons that I have not found after 100hours of work...

1.9.6 w/ postgresql 8.0.8.

Click on MyTiki Home.

Error is:

An error occured in a database query!

Context:
File tiki-my_tiki.php
Url tiki-my_tiki.php
Query:
select distinct(p."pageName"), p."user" as lastEditor, p."creator", max(a."lastModif") as date from "tiki_actionlog" as a, "tiki_pages" as p where a."pageName"= p."pageName" and a."user"= ? group by p."pageName" asc order by "pageName" asc
Values:
0 andy
Message:
Error Message ERROR: syntax error at or near "asc" at character 219

PostgreSQL, SQLite

Bugs & Wish list

tikiwiki installed with mysql.
Create DSN with 'pgsql://user:password@host:port/DB'.
In wiki, use plugin SQL or REQUEST/DATATABLE.
And a lot of errors in php, select statement, mysql syntax and postgres error!
Thanks

Please see:
http://www.wikimatrix.org/wiki/feature:Text%20Files

In 5 years, there has not been a real need expressed for this feature so it will probably never happen. If you think it's important, please comment this tracker item.

Tiki supports sqlite so this would be similar (to avoid full db) but it would be slow for active sites and not really provide any benefit (vs MySQL, Postgres, etc).

Default values in tiki-integrator don't work:

{CODE}
INSERT INTO tiki_integrator_rules VALUES ('1','1','1','.*<body[^>]*?>(.*?)</body.*','\1','y','n','i','y','Extract code between <body> and </body> tags');
{CODE}

The 'i' for regex options should be 'ism' to not only ignore case, but process multiline and let '.' match newlines. As is, it only works if the original page is all on one line.

Likewise the "\1" needs an extra \, and should be '\\1'. mysql is eating the first one and thinking that it is just unmagicking the '1', which didn't need it.

I would fix this, but editing the .sql files scares me. :)

Install using PostgreSQL will still try to install to mysql

I am having an issue with installing v2.0 on IIS with MSSQL backend.

After entering all of the info such as database server, name, and login info, it returns the following error:

PHP Fatal error: Call to a member function fetchRow() on a non-object in C:\inetpub\wwwroot\tikiwiki\installer\tiki-installer.php on line 43

This appears to be the MSSQL version of bug ID 1653.

Installation error during table creates:

Command: CREATE TABLE "tiki_categorized_objects" (
"catObjectId" bigserial,
"type" varchar(50) default NULL,
"objId" varchar(255) default NULL,
"description" text,
"created" bigint default NULL,
"name" varchar(200) default NULL,
"href" varchar(200) default NULL,
"hits" integer default NULL,
PRIMARY KEY ("catObjectId"),
KEY(type, objId)
)
Message: ERROR: syntax error at or near "("
LINE 11: KEY(type, objId)

With the choice of SQLite database

When installing
Fatal error: Call to a member function fetchRow() on a non-object in P:\xampp\htdocs\tiki10\installer\tiki-installer.php on line 50

When get tiki-index.php after installation
Unable to connect to the database !
SQL logic error or missing database

Hello,

we don't get tikiwiki installed into oracle database. we used instantclient_11_1, compiled oci8 against the libraries, loaded the extension in php.ini, configured apache2 environment (LD_LIBRARY_PATH etc). then we restarted apache2 and started tiki-installer.php. Connection seems to work, but then the installion process aborts with following error:

PHP Fatal error: Call to a member function fetchRow() on a non-object in /srv/www/htdocs.oracle/installer/tiki-installer.php on line 43, referer: http://192.168.5.37/ora-tiki/tiki-install.php

get_dsn_info and get_db_by_name doesnt support a connection to firebird because they firebird-connection-string is a little bit special (no host, everthing inside the dbname).

The solution contains also code for using params in the connectionstring.

Contributors

Listing categories throws a sql error: no such function max(binary). Reason: in category library the function list_categories does a max() of some comparsions. This should be solved in another way.

I got this on October 25th 2006:

Warning: mysql error: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2) in query:

select count(*) from `tiki_banners` where `wed` = ? and `hourFrom`<=?
and `hourTo`>=? and
( ((`useDates` = ?) and (`fromDate`<=? and `toDate`>=?)) or
(`useDates` = ?) ) and
`impressions`<`maxImpressions` and `zone`=?

in lib/tikidblib.php on line 134


How could we show a more meaningful error message?


---

mysql tables sometimes crash.

When they do, the error message is cryptic, at best.

An average Tiki admin won't know what the problem is and could think it's Tiki's fault.


A graceful error message would inform the admin that:

"There are problems with the following tables: ". Please repair (link to how to repair)

Especially the tiki_sessions, which shuts down the site completely...

Some others are not so bad. Just a path disclosure.
{img src=images/code.png}%%% {CODE()}
Warning: mysql error: Can't open file: 'tiki_images.MYI' (errno: 145) in query: select count(*) from `tiki_images` where `galleryId`=? in lib/tikidblib.php on line 134
{CODE}
---

Another error to watch for:
{img src=images/code.png}%%% {CODE()}
Unable to connect to the database !
User droit_tiki has already more than 'max_user_connections' active connections
{CODE}
---
Maybe Tiki admin email should be in db/local.php? So the system could send email alerts when DB can't connect.