Loading...
 

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

Database independence (Non-Mysql, ADOdb Postgres, Oracle, etc)
Show subcategories objects

Name Type
Koichi
Contributors
tracker item
database queries counter: remove until it is fixed
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
tracker item
Humphrey
Contributors
tracker item
balezin
Contributors
tracker item
Add SQL/DB Link Tracker field type
tracker item
Adodb script errors on a new installation when working with groups
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.
tracker item
Can not install on PostgreSQL
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.
tracker item
Cannot add new page to Structure
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
tracker item
Citation
wiki
Crash on a replication of site from Unix to Windows - and windows installation
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...

tracker item
Database error on click on "mytiki home"
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
tracker item
Database independence
PostgreSQL, SQLite
wiki
#1266
Bugs & Wish list
tracker item
DSN/postgres in tikiwiki/mysql
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
tracker item
Flat Files backend instead of DB (maybe ADOdb could do this?)
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).

tracker item
initialization of tiki_integrator_rules doesnt work
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. :)
tracker item
Install using PostgreSQL will still try to install to mysql
Install using PostgreSQL will still try to install to mysql
tracker item
installation issues with v2.0 and MSSQL backend
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.
tracker item
Installation on PostgreSQL: syntax error creating 'tiki_categorized_objects'
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)
tracker item
Installation with SQLite
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
tracker item
Installer fails against Oracle 10 DB
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

tracker item
DSN-Parsing not suitable for Firebird
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.
tracker item
Kissaki
Contributors
tracker item
List categories broken in postgres
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.
tracker item
More graceful error message when database is unavailable or crashed
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.
tracker item
  • «
  • 1 (current)
  • 2

Keywords

The following is a list of keywords that should serve as hubs for navigation within the Tiki development and should correspond to documentation keywords.

Each feature in Tiki has a wiki page which regroups all the bugs, requests for enhancements, etc. It is somewhat a form of wiki-based project management. You can also express your interest in a feature by adding it to your profile. You can also try out the Dynamic filter.

Accessibility (WAI & 508)
Accounting
Administration
Ajax
Articles & Submissions
Backlinks
Banner
Batch
BigBlueButton audio/video/chat/screensharing
Blog
Bookmark
Browser Compatibility
Calendar
Category
Chat
Comment
Communication Center
Consistency
Contacts Address book
Contact us
Content template
Contribution
Cookie
Copyright
Credits
Custom Home (and Group Home Page)
Database MySQL - MyISAM
Database MySQL - InnoDB
Date and Time
Debugger Console
Diagram
Directory (of hyperlinks)
Documentation link from Tiki to doc.tiki.org (Help System)
Docs
DogFood
Draw -superseded by Diagram
Dynamic Content
Preferences
Dynamic Variable
External Authentication
FAQ
Featured links
Feeds (RSS)
File Gallery
Forum
Friendship Network (Community)
Gantt
Group
Groupmail
Help
History
Hotword
HTML Page
i18n (Multilingual, l10n, Babelfish)
Image Gallery
Import-Export
Install
Integrator
Interoperability
Inter-User Messages
InterTiki
jQuery
Kaltura video management
Karma
Live Support
Logs (system & action)
Lost edit protection
Mail-in
Map
Menu
Meta Tag
Missing features
Visual Mapping
Mobile
Mods
Modules
MultiTiki
MyTiki
Newsletter
Notepad
OS independence (Non-Linux, Windows/IIS, Mac, BSD)
Organic Groups (Self-managed Teams)
Packages
Payment
PDF
Performance Speed / Load / Compression / Cache
Permission
Poll
Profiles
Quiz
Rating
Realname
Report
Revision Approval
Scheduler
Score
Search engine optimization (SEO)
Search
Security
Semantic links
Share
Shopping Cart
Shoutbox
Site Identity
Slideshow
Smarty Template
Social Networking
Spam protection (Anti-bot CATPCHA)
Spellcheck
Spreadsheet
Staging and Approval
Stats
Survey
Syntax Highlighter (Codemirror)
Tablesorter
Tags
Task
Tell a Friend
Terms and Conditions
Theme
TikiTests
Timesheet
Token Access
Toolbar (Quicktags)
Tours
Trackers
TRIM
User Administration
User Files
User Menu
Watch
Webmail and Groupmail
WebServices
Wiki History, page rename, etc
Wiki plugins extends basic syntax
Wiki syntax text area, parser, etc
Wiki structure (book and table of content)
Workspace and perspectives
WYSIWTSN
WYSIWYCA
WYSIWYG
XMLRPC
XMPP




Useful Tools