Category: 1.9.x

Hello,

I am trying to install Tiki 1.9.11 for a client that is currently using this version and cannot upgrade. After running the installer I get the following message when I try to access tiki-index.php:

Notice: this site is currently unavailable.

Please try again later or contact the admin.


-Ashley

The "Location: " prefix for bradcrumbs should be made optional. Need to keep for compliance with 3Rules and because sites are using the feature already, but most wil want to turn it off.

Hi,

After translation of language.php, it does not seems reflect the translation work.

When I reload a related page, sometimes reflect and sometimes does not reflect.

I am not sure but I guess tikiwiki has some cache page.
If so, how to clear the cache?

Or more straight, how to reflect language.php immediately?

Please give me a hint.

Thanks,
Shigerusz3

The ID generated by get_user_cache_id is used to create a new directory in templates_c/ . This ID is generated by concatenating all the groups a user is in.
When a user is in many groups the ID exceeds the maximum filename length of my system (FreeBSD 4.11).

lib/smarty_tiki/modifier.duration.php and lib/smarty_tiki/modifier.duration_short.php are both using hardcoded strings for display of time units (seconds,days,etc).

This problem was introduced in BRANCH-1-9 and is tough to solve. We need a senior dev on this one.

''Needs more description...''

I will provide more details later.

I saw this
tiki-mobile.php -> link to HAWHAW
charts -> with use of sameurl plugin
user_tasks module -> when trying to add a module

server: Dreamhost, not at root of domain.


__Seems related__
[tiki-view_tracker_item.php?itemId=441|not possible to ADD new task into user tasks in user-task module]

Please see:

"Put simply, I have a text box, and people commonly cut + paste
information into this text box from Microsoft word. The problem is that
word has all types of funky characters (smart quotes, em-dashes), that
the system (php-based) doesn't understand. Does anyone know of a way to
filter out these Microsoft-specific characters? Does PHP have a special
function for this? Thanks a lot!"
http://www.thescripts.com/forum/thread159156.html

I have problems with oe, and OE too. (used in French)

In Tiki, when the page is saved, it is OK for viewing & printing.
However, newsletters & email notifications (of articles & wiki pages)
are sent with a question mark instead of these characters.

Has anyone figured this out for Tiki? We'd need some sort of cleaning
code in the email class?

Even though global perms allow viewing wiki pages (to Anonymous, for example), assigning an edit perm to another group for a specific wiki page overrides the view perm and Anonymous can't see it anymore unless a specific tiki_p_view perm is assigned to the page for Anonymous.

this is a feature - it is how it works . As soon as you hjave a special perms, you need to redefine all the perm for the page

This is a perfect use for mods.

words_en.sql weighs 7.5 Megs. This is not super easy to upload via phpmyadmin.

Hi:

I just tried spellcheck, with the provided english dictionary at sf.net (words_en.sql, etc.). And also added another one as a trial (words_ca.sql, with 15 catalan words, etc.), coded words with utf-8.

Enabled feature, Created a new page with some words:
^
abaconarà
Abaconarà
abaconará
Abaconarà
Abaconara
abaconara
perquè així però vinyals calçador
howto
howtee
yeouhooo
spellchek
^

The only one shown in red at preview state is "~~red:vinyals~~", having interface either in English or Catalan.
There must be something wrong in the feature.

The only word included in words_ca.sql is abaconarà (non of the others is)

And in words_en.sql, non of the catalan words are, and I guess yeouhooo is not either...

spellcheck should get lang from wiki page lang, not from users' interface language, or elsewhere.

For instance, I have firefox in catalan, tiki lang pref. in catalan. If I edit an English page in doc.tw.o site, and I clikc on spellcheck, Tiki should search for dictionary tables of English lang, and nowadays it searches for Catalan tables on db.

----
Update: I confirm this is still happening. On doc.tw.o, for instance...

---------------------------
Context:
File /tiki-editpage.php
Url /tiki-editpage.php
Query:
select `word` from `babl_words_ca` where `word`=?
Values:
0 Tiki
Message:
Error Message Table 'doctwo_doctwo.babl_words_ca' doesn't exist
---------------------------

As of today (pre 1.9.8), if I activate the Spellcheck, I get:

{img src=images/code.png}%%% {CODE()}
An error occured in a database query!

Context:
File php.cgi
Url tiki-editpage.php
Query:
select `word` from `babl_words_fr` where `word`=? or `word`=?
Values:
0 test
1 test
Message:
Error Message
{CODE}


I need to know from:
http://doc.tikiwiki.org/Spellcheck

That I need to install the word dictionary database separately from the rest of Tiki.


Tiki should check that the table exists and return a nicer error message.


And why is Tiki searching for "babl_words_fr"? My browser and Tiki are in English...

The Admin>General page has a default message which spells "maintenance" incorrectly: "Site is closed for maintainance, please come back later."

Please see:
http://sourceforge.net/mailarchive/forum.php?thread_id=10026369&forum_id=12569

In tiki-browse_gallery.php, there is Sort Images by [ Name | Date | Hits | User | Size ] so robots can think these are all different 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`=?";

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."url" as "url", i."status" as "status", i."priority" as "priority", c."name" as "calname", i."calendarId" as "calendarId", i."locationId" as "locationID", i."categoryID" as "categoryID", i."nlId" as "nlId" from "tiki_calendar_items" as i left join "tiki_calendars" as c on i."calendarId"=c."calendarId" where ((i."calendarId"=?) and ((i."start" > ? and i."end" < ?) or (i."start" < ? and i."end" > ?)) and ((c."personal"='y' and i."user"=?) or c."personal" != 'y')) order by "start" asc
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.

When using the SQL plugin to connect to an MSSQL database, TikiWiki throws a database error when parsing the SQL. However, the error is related to Tiki's SQL code, and not the code entered in the page.

strtok does not return empty tokens. If the password is empty in the DSN the parser comes out of order.

Hello there,

I just upgraded our TikiWiki from 1.9.11 to 2.0. I am really happy with 2.0 by the way! Way to go!

Everything went well during the upgrade, except that I get this error message every time I try to administer our categories:

http://dev.tikiwiki.org/tiki-browse_image.php?imageId=52

Everything else seems to have upgraded just fine. Yes I did follow the instructions during the tiki-install.php and run the 1.8 -> 1.9 SQL script prior to the 1.9 -> 2.0 SQL script. I noticed that there were around 150 SQL "errors" during the upgrade script, but I thought nothing of this.

Thanks a million!
Russ
rfruhwirth2@unl.edu

Hello Friends,

I am not a technical person. After I installed latest version of TikiWiki using Fantastico I went to Admin Area and when I finished some modifications in Login Configuration Page I was suddenly kicked out (logged out) but even after several tries I was not able to login again.

Because of this problem I removed my site: http://hub.cc completely. I downloaded the latest version from site: www.tikiwiki.org and re-installed it using my FTP clients. But unfortunately once again faced the same problem.

I therefore request you to please check my site and guide to me how can I Debug this issue!

Many thanks and best regards

Kamaal Makrani

-----

1.9.7 - validation error due to a stray opening div tag in tiki-searchindex.tpl.

default.css fails to render correctly because of some wrong syntax.
- "* Links to extend/collapse menus */" is missing the comment start "/*".
- "llistfileslink:active" has its '.' in the line above instead of infront of it.

See the patch below:

Subject field empty after a reply to a post...

e.g.
* a topic is posted "aaa"
* the subject for the reply to at the bottom is "Re: aaa"
* a reply is posted to the topic
* the subject for the reply to at the bottom is EMPTY, whilst it should be "Re: Re: aaa"
* click on the topic or post link once again, then the subject for the reply to at the bottom is "Re: Re: aaa"

I'd like to send a new blog post (configurable for each blog) to a mail adress (in particular a mailinglist). It is of cause possible to create a new tiki-user for the mailinglist and watch the blog, but we do not want the unwatch-link to appear in the mail, and we do not want to change the template for the blog-watch-mail.