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 |
natokpe | tracker item |
PostGres errors on attempted post/insert of long emails to forums with email-to-forum enabled
Postgres returns row length error to tiki-view_forum.php upon attempt to write data from long e-mail to a forum with email-to-forum functionality enabled. |
tracker item |
postgres7 error: operator does not exist
Hi all! I am building a tiki in italian, english, german, french and spanish (not published yet). My development environment: - XAMPP 2.5 for Windows - Apache/2.2.8 (Win32) DAV/2 mod_ssl/2.2.8 OpenSSL/0.9.8g mod_autoindex_color PHP/5.2.5 - PHP Version 5.2.5 - DBMS Postgres 8.3.1 (running remotely on an Ubuntu box) tikiwiki version: 1.9.10.1 I'm having a problem using the i18n feature: if I activate "Multilingual" and I select "Italiano (it)", and then I try to update my homepage, I get the following error message: --- Warning: postgres7 error: ERROR: operator does not exist: bigint = character varying LINE 1: ...cts" as t2 LEFT JOIN "tiki_pages" p ON p."page_id"=t2."objId... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in query: select t2."objId", t2."lang", p."pageName"as "objName" from "tiki_translated_objects" as t1, "tiki_translated_objects" as t2 LEFT JOIN "tiki_pages" p ON p."page_id"=t2."objId" where t1."traId"=t2."traId" and t2."objId"!= t1."objId" and t1."type"=? and t1."objId"=? in C:\xampp\htdocs\tikiwiki\lib\tikidblib.php on line 134 Context: File tiki-index.php Url tiki-index.php Query: select t2."objId", t2."lang", p."pageName"as "objName" from "tiki_translated_objects" as t1, "tiki_translated_objects" as t2 LEFT JOIN "tiki_pages" p ON p."page_id"=t2."objId" where t1."traId"=t2."traId" and t2."objId"!= t1."objId" and t1."type"=? and t1."objId"=? Values: 0 wiki page 1 2 Message: Error Message ERROR: operator does not exist: bigint = character varying LINE 1: ...cts" as t2 LEFT JOIN "tiki_pages" p ON p."page_id"=t2."objId... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. --- The some operation, running on a MySql5 based installation, doesn't happen. Which is my fault ? What another thing I must check and where ? Thanks in advance ! Giuseppe |
tracker item |
PostgreSQL - cannot present user files
When user files area is empty it causes error displaying the content. My tikiwiki is 1.9.1 with php5 and Postgresql 8.x For more details see --> https://sourceforge.net/tracker/index.php?func=detail&aid=1283628&group_id=64258&atid=506846 |
tracker item |
PostgreSQL - cannot upload user avatar
when downloading image/jpeg type of user avatar it fails due to problem in execution of SQL query. It seems that binary uploads that for sure contains special characters destroys the SQL statament to be queries. My TikiWiki is 1.9.1 configured with Postgersql 8.x For more info see --> https://sourceforge.net/tracker/index.php?func=detail&aid=1283624&group_id=64258&atid=506846 |
tracker item |
Problem in adodb when using Chinese characters in browser title
using long Chinese characters as browser title will cause the browser title borken, for example, if you use '机电工程师' as browser title, the browser will show '机电工程帛'. it's maybe an adodb problem. |
tracker item |
Scope for object singleton TikiDb::get() access to Pdo function : incompatibility with php 5.3.2 (on windows)
Hello, !A problem completely identified This is a new formulation of 3029 and 3057 problem after near 200 hours of test and debug. !The problem is now precise and (I hope so) near solution (but depends of quality team (this part has been rewrite for 5.0): __The solution that I propose establish the compatibility of 4.2 with php 5.3.2.__ !!Not alone may be !!!Can't end test of changes to submit (just tiki-db-dbo.php) I can't affirm that I wrote a complete debug version because the execution stop on another problem (track [http://dev.tikiwiki.org/tiki-view_tracker_item.php?trackerId=5&itemId=3115], so it is not ended. I can't be sure that everything is OK. !!!Note about time spent to be able to participate efficiently to the team The time spend is not only on TikiWiki, a had to solved installation problems and find a bug into easyphp and addresses resolution on the server. The problem began with 4.1 and php 5.3.0 and I upgrade to 4.2 and 5.3.2 to be sure of the problem and the available solution. !Span of the problem : # Definition of main classes TikiDb and TikiDb_Pdo and PDO->function execution # Progs : tiki-db-pdo.php, tikisession-pdo.php and naturally pdo.php, tikiDb.php # PDO extension and behavior of objects and classes !Description of the nature of the problem and is generation note : Because I found the nature of the problem, I don't start from the nature of the crash but the analysis, but I produce a selected track made with xdebug var_dump) # In tiki-db-pdo.php:40 we create the Pdo object <$dbTiki = new PDO("$db_tiki:$db_hoststring;dbname=$dbs_tiki", $user_tiki, $pass_tiki); > # just later In tiki-db-pdo.php:49 we set the singleton of TikiDb_Pdo into TikiDb abstract class with scope operator <TikiDb::set( new TikiDb_Pdo( $dbTiki ) ); > # further we call In tikisession-pdo.php:28 we can find the session read < $sth = TikiDb::get()->prepare($qry); > This instruction generates the fatal error : __ Fatal error: Call to undefined method TikiDb_Pdo::prepare() in D:\Trebly\Teawik-ld8-422a\lib\tikisession-pdo.php on line 28__ !Explanation and solution implemented The reason is simple and explained by the error comment : we try to run the prepare function which is a PDO function on a TikiDb_Pdo object which has no reason to inherit of these Pdo function even <TikiDb::get()->db->prepare> could have a meaning. Then the solution is in what is made in ZEND lib (not yet used in 4.2), create an interface to PDO into Class TikiDb_Pdo. This functions and it is written. ! A major question One important question is why and how the same instructions seems to be available and functions well on Linux (I have a site which runs normally with 4.1, not yet upgraded to 4.2, a to-do) I believe that the actual solution that I have developed for 4.2 on Windows with PDO (compiled) extension, should be extended to the normal version. As I have said before I can't confirm completely that the solution is correctly tested and free of bug because, the program have a FATAL ERROR PDOException: SQLSTATE[HY093] later on the prefs restoration I create another report for this. !!!Complements of information (working around finding and solving bugs): Note 1 (complement, I will made another little track for this) : the execute statement written execute() without parameter generates each time a warning message when xdebug is used and php error management activated with STRICT option (default in 5.3.2). This makes necessarily the code lightly slower. Note 2 : I developed for other debug for this an enhanced error template according to the error handler which displays much more informations about the context and, into these, the parameter (title) of execute statement. This make an enhancement to find much more quickly the errors. I will implement a test so that it should be displayed only for administrator. |
tracker item |
Scope operator to access PDO properties and methods for $Tikidb fails : execution fail wit php 3.3.1
Hello, These is a partial solution to ticket 3029 which I can't access. I was wrong in my search of causes of the problem. __The installation in my configuration described in 3029 don't supports the following :__ The TikiWiki sequence with tiki-setup_base and tikisession-pdo first creates the object $dbTiki = new PDO(......) just after seems to extends the class by TikiDb::set( new TikiDb_Pdo( $dbTiki ) ); Most installations are able to hold the following (tikisession:open) TikiDb::get()->setAttribute(PDO:....); TikiDb::get()->getAttribute(PDO:....); and just after execute tikisession:read with this $sth=TikiDb::get()->prepare($sql); $sth->execute(); This don't functions (probably php 3.3.1), the PDO methods and attributes can't be accessed by this mean. The scope operator is not able to reach PDO (builtin by extension) class PDO in my context : either windows version (improbable) and php 3.3.1 On my services provider OVH which run php 3.2.x everything functions Zend uses interfaces and other objects. In my opinion : $sth must be set as new object with "PDO_Statement" properties (interface of zend and implementation) When I implement the good properties and class I go much more further in the execution. But how to make function whole 4.1 with this scope operator problem ? |
tracker item |
Scoring Mods for PostGres installs
lib/tikilib and lib/score/scorelib.php functions send no timestamp argument to tiki_users_score isert queries. This results in query failure because tiki_users_score tstamp column in Tiki 1.9 distrib. contains a 'not null' constraint. --- The following PostGres query sets the default timestamp of tiki_users_score alter column tstamp to 'now', which ensures against attempted insertion of NULL values from the tiki co alter table tiki_users_score alter column tstamp set default now(); |
tracker item |
ShowCaseSupport@projectashenfire.org | tracker item |
SQL error with SQLite db engine on Orphan Pages
Within lib/stats/statslib.php there is a missing space between an identifier and the WHERE token, for SQLite ADOdb strips out the backtick resulting in an SQL error. After grepping the code I can see that there are a few places that are going to cause this error. lib/stats/statslib.php $query_cant = "select count(*) from `tiki_pages` tp left join `tiki_links` tl on tp.`pageName` = tl.`toPage` left join `tiki_structures` ts on tp.`page_id`= ts.`page_id`where tl.`toPage` IS NULL and `ts`.page_id IS NULL"; $query = "select `pageName`, `hits`, `page_size` as `len` ,`lastModif`, `user`, `ip`, `comment`, `version`, `flag` from `tiki_pages` tp left join `tiki_links` tl on tp.`pageName` = tl.`toPage` left join `tiki_structures` ts on tp.`page_id`= ts.`page_id`where tl.`toPage` IS NULL and `ts`.page_id IS NULL $mid order by ".$this->convert_sortmode($sort_mode); lib/faqs/faqlib.php $query = "delete from `tiki_faqs`where `title`=?"; lib/charts/chartlib.php $query = "delete from `tiki_charts_votes`where `user`=? and `itemId`=?"; lib/admin/adminlib.php $query = "delete from `tiki_dsn`where `name`=? and `dsn`=?"; $query = "delete from `users_permissions`where `permName`=?"; $query = "delete from `tiki_tags`where `tagName`=? and `pageName`=?"; |
tracker item |
SQL errors
Several SQL queries only work with mysql because it is not SQL92 compliant. Some bugs are already fixed now but at least the case sensitivity bug is still there. If you create a table with columns and later use a query you have to use the exact name and not a name with different cases, an example is: Warning: postgres7 error: ERROR: column i.categoryID does not exist in query: select i."calitemId" as "calitemId", i."name" as "name", i."description" as "description", i."start" as "start", i."end" as "end", i."ur in /usr/share/tikiwiki/lib/tikidblib.php on line 134 this is because the column is named categoryId and not categoryID. I think in this example i manually fixed on my side another Id that is locationId where the query used locationID which is not existent. This not only occurs in the calender section but this is just the sections that i remember where the error occurs. |
tracker item |
SQL-Script for PostgreSQL failed
In the new version of tikiwiki 3.0 is the tiki-3.0-pgsql.sql wrong. It looks like a copy of the mysql file. BUT: not only the pgsql, also the sqlite and oci8-file. There are still the ENGINE elements, and some special types from mysql like KEY instead of INDEX or Triger for pgsql |
tracker item |
Start of tikiWiki with Windows and PDO extension (Apache-php-mysql win) - DB Main Classes problem and functions calls - Makes unable to start Tikiwiki
Hello, This is a new formulation of 3029 problem after near 200 hours of test and debug. !The problem is now precise and near solution : I can't affirm that I wrote debug because the execution stop on another problem. The time spend is not only on TikiWiki, a had to solved installation problems and find a bug into easyphp and addresses resolution on the server. The problem began with 4.1 and php 5.3.0 and I upgrade to 4.2 and 5.3.2 to be sure of the problem and the available solution. !Span of the problem : # Definition of main classes TikiDb and TikiDb_Pdo and PDO->function execution # Progs : tiki-db-pdo.php, tikisession-pdo.php and naturally pdo.php, tikiDb.php # PDO extension and behavior of objects and classes !Description note : Because I found the nature of the problem, I don't start from the nature of the crash but the analysis, but I produce a selected track made with xdebug var_dump) # In tiki-db-pdo.php:40 we create the Pdo object <$dbTiki = new PDO("$db_tiki:$db_hoststring;dbname=$dbs_tiki", $user_tiki, $pass_tiki); > # just later In tiki-db-pdo.php:49 we set the singleton of TikiDb_Pdo into TikiDb abstract class with scope operator <TikiDb::set( new TikiDb_Pdo( $dbTiki ) ); > # further we call In tikisession-pdo.php:28 we can find the session read < $sth = TikiDb::get()->prepare($qry); > This instruction generates the fatal error : __ Fatal error: Call to undefined method TikiDb_Pdo::prepare() in D:\Trebly\Teawik-ld8-422a\lib\tikisession-pdo.php on line 28__ !Explanation and solution implemented The reason is simple and explained by the error comment : we try to run the prepare function which is a PDO function on a TikiDb_Pdo object which has no reason to inherit of these Pdo function even <TikiDb::get()->db->prepare> could have a meaning. Then the solution is in what is made in ZEND lib (not yet used), create an interface to PDO into Class TikiDb_Pdo. This functions and it is written. ! A major question One important question is why and how the same instructions seems to be available and functions well on Linux (I have a site which runs normally with 4.1, not yet upgraded to 4.2, a to-do) I believe that the actual solution that I have developed for 4.2 on Windows with PDO (compiled) extension, should be extended to the normal version. As I have said before I can't confirm completely that the solution is correctly tested and free of bug because, the program have a FATAL ERROR PDOException: SQLSTATE[HY093] later on the prefs restoration I create another report for this. Note : the execute statement written execute() without parameter generates each time a warning message when xdebug is activated with STRICT option (default in 5.3.2) for errors handling in php, and necessarily makes the code lightly slower. I developed an enhanced error template according to the error handler which displays much more informations about the context and, into these, the parameter (title) of execute statement. This make an enhancement to find much more quickly the errors. |
tracker item |
Suggested shell backup procedure using existing scripts
tiki-backup.php was like performing surgery on yourself. It can work but it's risky. |
tracker item |
Test if the db upgrade script has been run and put a note in tiki-admin.php
This would avoid this type of issue: http://tikiwiki.org/tiki-view_forum_thread.php?topics_offset=1&forumId=6&comments_parentId=21274 Maybe at each release, we could add one test of the DB to see if the most recent sql additions were done. phplist does this well. Once click and your DB is in the right format. |
tracker item |
Tiki does not install clean on Oracle
many object names too long for oracle which has max size of 30 for any object (column, table, sequence, etc.) able to modify some items such as sequence and trigger that are internal to db and not in tiki code. initial oracle-1.9-oci8.sql had many errors including the use of datatype integer and auto-increment which doe not exist in oracle. additional insert to blob column not formed to use oracle utl_raw.cast_to_raw. oracle quote in sql field insert should be two quotes ('') instead of backslash quote (\') main tables still not available tiki_content_templates_sections tiki_forums because outbound_mails_for_inbound_mails column tiki_live_support_message_comments is there a workaround that if I change the object name in the database to be <=30, that the code will not abort. - Usage of "CLOB" in Oracle different from "Text" in MySQL, so usage of every table has to be checked. (especially where LOB-Index is used as a reference (e.g. tiki_languages)) - Oracle can not use CLOBs for indices so search functionality has to be checked (fulltext index?) |
tracker item |
varchar(256) fails on MySQL 4.0
fields defined varchar(256) fail on MySQL 4.0 db/tiki.slq lines 4868 and 4877 the last two tables added: tiki_webmail_contacts_ext and tiki_webmail_contacts_fields I would fix it if i had check-in powers sorted out (working on it) but i'm not sure that wouldn't it break anything else (in webmail?) |
tracker item |