Category: 1.9.x

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.

Perm plugin is very useful and works well. It is very similar to the group plugin. It weighs just a few k and I see no advantage of putting in mods.
http://mods.tikiwiki.org/details.php?type=wikiplugins&mod=perm

Similar to group plugin, we need "if/else" concept:
http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=994

So we could do things like this in wiki pages:
if tiki_p_edit "please click here to edit" else "please click here to login"

Also, group plugin is still in mods, but already in main code base so it should be cleaned out of mods.

RIght now, it appears that you can only move entire threads. This doesn't allow you to move a single post that's attached to a thread, even though just the one post needs to be relocated, usually to it's own thread.

Say I have a user tracker but my users speak different languages.
tiki-view_tracker_item.php?view=+user

I want to be able to {tr} the labels but also the lists (drop-down menus and categories)

1.9.0DR4 worked fine. 1.9.0 fails.
If you have a multitiki and create custom css/tpl files, they are not traversed. For example, If you have a multiwiki on www.foo.com and create a style called 'bar', the correct place to put the customized css files is
/styles/www.foo.com/bar.css
But this no longer works. It has to be in /styles/bar.css

The tpl files should be in
/templates/www.foo.com/styles/bar/
But this no longer works. It has to be in /templates/styles/bar

Please put back the old way. The current (broken) way prevents me from having styles of the same name on different multiwikis. each with customization.

I installed Mysql 5 alpha to with 1.9 from the head of the branch and found this error when I tried to enter the tiki...

Warning: mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-1' at line 1 in query:
select `permName`,`type`,`level`,`permDesc` from `users_permissions` order by `permName` desc
in C:\isense\icms\lib\tikidblib.php on line 133

Fatal error: Call to a member function on a non-object in C:\isense\icms\lib\tikidblib.php on line 151

This happened after saving http://dev.tikiwiki.org/tiki-admin_trackers.php?trackerId=5 where I had checked "and display attachments in listing?" (sub-option of Tracker items allow attachments?). I was unable to reproduce thereafter.

However, I noticed after that the ratings column had moved from first (left-hand side) to last (right-hand side).

{THUMB(id=26, url="tiki-browse_image.php?imageId=26")}{THUMB}

To reproduce:


Make a super long wiki page using:

((my super duper long extra long wiki page name the never ends because it can be difficult to find the right words sometimes and some people may be tempted to just throw in a very large number of keywords in a wiki page name and hope that it will help with search engine indexing))

The wiki page offers a question mark to create the new page but TikiWiki is unable to create a page that size so it truncates to 160 characters: ((my super duper long extra long wiki page name the never ends because it can be difficult to find the right words sometimes and some people may be tempted to jus))


A nicer error message would be nice

Our community needs some forums for the administrators only so that we can pass messages back and forth. However, there's no way to make any of this private. Any registered user can read and post what need to be private forums. In many cases you don't even have to be registered to read.

When you load the administration page for the first time of a session, you cannot see all icons. It's like if the page was truncated.
So you need to load the administration page a second time in order to see all icons.

I like the feature of nested galleries, and the nested galleries show up fine within the parent. The problem is that all the nested galleries show up in the main gallery listing along with their parents... This seems to negate the clutter reducing ability of nesting the galleries in the first place...

I would also love to see a thumb image from a gallery in the main listing - having the main listing acting like a parent gallery with thumbs of its children...

Thank you!

OC

This tracker item could not be found

If your users login has a ".", as in "firstname.lastname", the remember me feature breaks.

This is the snippets in tiki-login.php use to set the cookie:

{img src=images/code.png}%%% {CODE()}
// Now if the remember me feature is on and the user checked the rememberme checkbox then ...
if ($rememberme != 'disabled') {
if (isset($_REQUEST['rme']) && $_REQUEST['rme'] == 'on') {
$hash = $userlib->get_user_hash($_REQUEST['user']);
$hash = $userlib->create_user_cookie($_REQUEST['user']);
$time = substr($hash,strpos($hash,'.')+1);
setcookie($user_cookie_site, $hash.'.'.$user, $time, $cookie_path, $cookie_domain);
$logslib->add_log('login',"got a cookie for $remembertime seconds");
}
}
{CODE}


The cookie content has the following format:
{img src=images/code.png}%%% {CODE()}
md5($_SERVER['REMOTE_ADDR'].$_SERVER['HTTP_USER_AGENT']).(date('U') + $remembertime).$user
{CODE}

The following code in userslib.php parse the cookie content. This function will successfully returns
the user only if your users login does not have a ".", otherwise this function will always return
false, and users have to re-login everytime.

{img src=images/code.png}%%% {CODE()}
function get_user_by_cookie($hash) {
list($check,$expire,$userCookie) = explode('.',$hash);
if ($check == md5($_SERVER['REMOTE_ADDR'].$_SERVER['HTTP_USER_AGENT'])) {
$query = 'select `user` from `tiki_user_preferences` where `prefName`=? and `value`=? and `user`=?';
$user = $this->getOne($query, array('cookie',"$check.$expire", $userCookie));
if ($user) {
if ($expire < date('U')) {
$query = 'delete from `tiki_user_preferences` where `prefName`=? and `value`=?';
$user = $this->query($query, array('cookie',$hash));
return false;
} else {
return $user;
}
}
}
return false;
}

{CODE}

Move all admin settings which affect all text areas to this new panel.

ex.:
Tables syntax:

In the early days of TikiWiki, we used a bunch of modules (last_modified_wiki_pages, last_articles, Last this, Last that, etc.) to show recent changes to visitors. We ended up with many modules and it was cluttered.

All this became a lot better once the "Since your last visit" module came around to adding all the features. As a bonus, it checks permissions and shows the information since the user's last login. Very sweet.

Now, I am hoping to get to the same result for the many edit/input boxes.

In version 3.0, the quick_edit module checks (with Ajax) for names of existing wiki pages to edit. This avoids duplication. Great stuff. Wikipedia does something similar when you are searching for a page name.


I almost always have the search box on.

However, I also add "search page name" because the general search engine may not return the page I am looking for as the search result.

Here is an idea:

A new module which combines three modules:
search_wiki_page
search_new
quick_edit

See top right of http://moinmo.in/ for an example.

The action buttons are grayed out until text is entered in the text box. -> Very nice


Button should be WYSIWYCA


See top-right search box at:
http://www.ohloh.net/projects/tikiwiki
http://www.wikicreole.org/



__Alternatively, we could combine search page name and search text, and in the search results, we would first show pages names, and then, search text. This involves more work, but could be better for the end user UI.__

^I think the existing layout for the search top right in TW is fundamentally good. A text box, then a drop-down then a button. Why because the drop down is more future proof than any of the layouts from the other sites you reference.

If we make the contents of the drop down easy to customise or at the very least document how to add to it. For example the CRM function could add items to the drop down for "Contacts" and "Accounts", webmail could add "Mail Messages" and so on.

I do agree the wikipage create/edit module should be included in the top right search function.

I think this is an example of where considering the future openness of the solution would be very important - MatWho^

{THUMB(id=98)}{THUMB}

In Admin -> Login check both:
- Users can register:
- ... but need admin validation:

Admin validation isn't required, new users still can register and login immediately.

There seems to be a boundry condition in processing the HTML version of a newsletter. if the following appears in a newsletter:

~pp~

No matter which side of the door the dog or cat is on, it is the wrong side.

any tex following it is dropped. However, all of the text does appear in the plaintext version. Adding or removing any characters causes the text to appear.

After a recent CVS update, the From: address of newsletter e-mails changed from the configured SenderEmail address to (apparantly) the address of the logged on user sending the newsletter. Since a changing number of users can send newsletters, it is difficult for recipients to configure their e-mail filters to accept all of them. The change caused a number of newletters to fail delivery.

Auto-eMail is generated to subscriber using template confirm_newsletter_subscription.tpl which contains the following:

In order to confirm your subscription you must access the following URL:
{$url_subscribe}?confirm_subscription={$code}

However,the url_subscribe truncates the php extension in the pagename shown in the email sent to subscriber as follows: tiki-newsletters.ph?confirm_subscription=someString, rather than tiki-newsletters.php?confirm_subscription=someString

Newsletter is generated to all subscribers containing unsubscribe message generated using template newsletter_unsubscribe.tpl which contains the following:

You can unsubscribe from this newsletter following this link:

href="{$url_unsub}">{$url_unsub}

But, the newsletter shows a truncated php extension in the pagename of the url_unsub as follows:

tiki-newsletters.ph?unsubscribe=someString, rather than tiki-newsletter.php?unsubscribe=someString

importing users & tracker items from .CSV is possible, so why not for newsletters :-)

{syntax type="tiki" editor="plain"}
In Tiki newsletters, it is possible to subscribe a group (excellent)
It is also possible for individuals to unsubscribe from a newsletter without leaving the group (excellent)

However, newsletter admins do not have access to this list. They should know who left the list and should be able to administer this "exception" list.

In message list and for each message.

When I use newserver "news.mozilla.org" , I get several:

Notice: Undefined offset: 1 in lib/pear/NNTP.php on line 477
Notice: Undefined offset: 2 in lib/pear/NNTP.php on line 477

at the top of the page.

And in the listing of the groups, I get:

Warning: Smarty error: math: parameter x is empty in lib/smarty/libs/Smarty.class.php on line 1095
Warning: Smarty error: math: parameter x is empty in lib/smarty/libs/Smarty.class.php on line 1095
time out



I didn't set username & password. Not sure if this is relevant.

phpBB is a popular open source forum software.
Sometimes, a forum is not enough.
So, the data must be migrated from phpBB to Tiki forums...

If you want to help:
Please post links to similar scripts.
ex.: phpbb to invision board, etc
If/when we do a script, we should do for all major forums.
---
__From kerrnel22 on 11/20/07:__

I have almost completed an integrated TikiWiki forum migration tool for 1.9.8.x and 1.10. Initial release will be to migrate only Tiki forums from one Tiki install to another. However, hooks are in place, and the intention is there, to work on extending the migration tool to importing of phpBB2 (or any other forum software) into Tiki. If you would like more information, email tiki.kerrnel@kerris.com. I expect a general release of the forum migration tool (for Tiki forums only) into cvs of both branches for beta testing by December 1/07. If all goes well, I'll have something released for phpBB2 migration prior to Dec 31.

When I set the homepage in Administration: General Preferences to "Articles" (which is what I want the homepage to be for both anonymous and registered visitors), the initial viewing for "anonymous" displays a homepage of "wiki".

When I set the homepage in Administration: General Preferences to Group homepage and then set the two group homepages to a typed-in "Articles" in the empty field and then log in as any user, the display is "No page 'Articles' found".

When I set the homepage in Administration: General Preferences to Group homepage and then set the two group homepages to a custom URL (http://www.progressiveomaha.com/tikidir/tiki-view_articles.php), the display is "no such page found".

One day I thought maybe the problem had to do with using Firefox on a Linux box, because my ancient Windows 98/IE machine brought up 'Articles' as the home page.

The next day both machines bring up the Wiki page as the home page. This is with the homepage set to 'Articles' in Admin-General.

Maybe I should be clear that I am refering to which page is brought up when TikiWiki is first accessed (from www.progressiveomaha.com/tikidir/).external link Once I have logged in as a user, I will access the 'Articles' homepage whether returning as another user or as anonymous. The problem only occurs on that initial anonymous access, and only after TikiWiki has had time to "forget" any earlier logons by that user.