Category: All / Undefined

{syntax type="tiki" editor="plain"}
Hello,

This happens in the same context as my others reports.

The database has been saved in SQL and loaded with upgraded versions of mysql, php 5.3.2.
There is in my opinion no relation with the context.

During start the current session prefs contain the query launch the previous current session.

A fatal error occurs in tikisession-pdo.php on line 44 function write statement <$sth->execute();>

PDOException: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound in D:\Trebly\Teawik-ld8-422a\lib\tikisession-pdo.php on line 44

The var_dump($qry) in "prepare" function (see my interface in Class TikiDb_Pdo) gives (extract)

''object(PDOStatement)[42]
public 'queryString' => string 'update sessions set data='need_reload_prefs|b:0;serialized_prefs|a:9:{i:0;s:27:"feature....''

The problem comes from the fact that into the session->data you can find the HOMEPAGE article "title" which is, in this case (French):

''__s:46:"Page d'accueil spécifique des administrateurs";__''

so the " ' " not escaped generates the crash of the request.

Hello,

As I told about, during upgrading from 4.2 (I am testing from 4.3) many errors occurs. This threated in a global way in id4377.

Here the problem comes from tra.php this generates a __fatal ERROR__

Reason during first tiki-setup __tra.php__ can be called when $tikilib is not yet set then __the function tra_impl crashes__.

It seems that at this stage of installation (managing session prefs) is it, as if getone() should answer false, nothing particular to do :
I have justed added a first level isset on $tikilib

See the joined patched source with comments.

I have some unused pictures and i would delete them.

At tiki-admin.php?page=wiki the link "Remove unused pictures" ( tiki-admin.php?page=wiki&rmvunusedpic=1 ) does not work.

What can I do?

cu!
WALKLiFE

Turning on 'Show user's info on mouseover:'in the community section will trash the data in other mouseovers, for example, mod-upcoming_events will generate stuff like:

{CODE(wrap=1)}
<a class="linkmodule summary" href="tiki-calendar_edit_item.php?viewcalitemId=57" title="Thu 28 of Feb., 2008 11:07 PST, by  152 ',HAUTO,VAUTO,CAPTION,' User information - Click for more info ');" inhibited_mouseout="nd()" target='_top' href='tiki-user_information.php?userId=13' >Jeanna  ">
Mike Bday </a>{CODE}



Which is not at all right... Not only is the title messed up, but the HTML is trashed as well with an extra "> shoved in for no reason, etc.

A few video games have a feature that lets you see how long the individual has been logged onto the video game for. It also tracks this per session and totals it up into a sort of "total time spent online" total.

Session Time: 2hrs, 20mins, 13sec.
Total Time: 7days, 9hrs, 20mis.

I think it would be an excellent option to see which of your users spend the most time at your website. What do you think?

To reproduce this bug, you need to set up a Tiki within a subdirectory with tilda, e.g.

http://localhost/~user/tiki

Then login, go to the admin panel and click around, say to some of the feature admin panels.

You will be logged out. The problem is that (if you look in tiki-phpinfo.php) that the cookie_path is set to /%7Euser/tiki

If you move the tiki to a path with no tilde it is ok.

Just too many servers with no datetime setting right now. This needs to be addressed at least at the minimum with a more graceful check and error, perhaps on running the installer?

FYI: There were no issues in the same server with Tiki 12.x installs. (=>"regression" category added)

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.

The list of tiki pages presented for selection and addition to a structure is truncated at 50 records for no apparent reason and there's no way to add records >50 without running a filter.

I just parroted what I saw in tiki-admin_categories.php for its similar page list and it works.

The diff is below - hope I did that correctly.

*.backup is the original file from the official tiki releast. *.php is the version I modified.

13.x: --Forum Thread Rating doesn't display icons for value 0, wrong icon for value 1-- (fixed) {sign user="xavi" datetime="2014-06-03T22:14:56+00:00"}, and no icons when labels are set beyond values (unfixed still) {sign user="xavi" datetime="2014-06-03T22:14:56+00:00"}

I have it reproduced reusing the show instance of this other bug report:
https://dev.tiki.org/item5253
(linked here in case I need to go there to "__svn up__" again)

{BOX()}
See this thread started by admin:
http://xavi-9794-5253.show.tikiwiki.org/tiki-view_forum_thread.php?comments_parentId=1

admin:
u: admin
p: 12345

Log in as user1
u: user1
p: user1
{BOX}

And here you can see a screenshot of the issue reproduced similarly in local:

{img fileId="785" thumb="y" width="500" rel="box[g]"}


With these values in __Wiki rating options__:
{CODE()}
0=foo,1=bar,2=bar2,3=bar3,4=bar4,5=bar5
{CODE}

This should be migrated to the community site, and handled with ((doc:Organic groups)) and ((doc:User Trackers))

An anonymous user without edit permissions can edit create a new page.

To Repeat:
1. Be logged into a user with no edit permisssions
2. Find a red ? link to an uncreated page.
3. Click the link
4. Note you don't have permission to edit/create the page.

5. Log out
6. Click the red ? link as Anonymous
7. Note you can edit the new page
8. Save the page - Note the error:

An error occured in a database query!

Context:
File tiki-editpage.php
Url tiki-editpage.php
Query:
insert into `tiki_user_watches`(`user`,`event`,`object`,`email`,`type`,`title`,`url`) values(?,?,?,?,?,?,?)
Values:
0 NULL
1 wiki_page_changed
2 LinkToLocPageFigs
3 NULL
4 wiki page
5 LinkToLocPageFigs
6 tiki-index.php?page=LinkToLocPageFigs
Message:
Column 'user' cannot be null
Built query was probably:
insert into `tiki_user_watches`(`user`,`event`,`object`,`email`,`type`,`title`,`url`) values(NULL,'wiki_page_changed','LinkToLocPageFigs',NULL,'wiki page','LinkToLocPageFigs','tiki-index.php?page=LinkToLocPageFigs')


9. Take note that though the error happened, the page was created.

Tikiwiki HTML Purifier version is 2.1.3.
Current version is 3.1.1 or 2.1.5.

There is risk of security attacks if not updated.

page 1/1 can stay (although some could prefer nothing instead), but the "1" below should be removed.

When installed from source code, in panorama.freewebhosting247.com, there is only blank screen when:

1) using old 2.0rc4 user modifed "basic profile"
2) clean database with "basic profile"

I only see blank screen.

This is despite using header_simple.tpl and my own empty header.
The error must be in a script after the header but because by default, there is no error shown at all, this is impossible to guess.


When I reinstalled "default profile", it worked. It shows the menu. I can do some maintainance now, including changing passwords, and the admin menu.

Many times, in random places, the www will get knocked off the hostname. I think it mostly occurs when I submit a confirmation to do something. I noticed it again today on: ./tiki-removepage.php when I confirmed the page removal at www.casesofinterest.com, I was returned to casesofinterest.com - kind of annoying, as I wasn't logged in to casesofinterest.com. The www should not be dropped.

This should be migrated to the community site, and handled with ((doc:Organic groups)) and ((doc:User Trackers))

Tutos uses this one:
http://php-pdb.sourceforge.net/

http://prdownloads.sourceforge.net/tutos/palm-1.2.20050306.zip?download

This should be migrated to the community site, and handled with ((doc:Organic groups)) and ((doc:User Trackers))

This should be migrated to the community site, and handled with ((doc:Organic groups)) and ((doc:User Trackers))

This should be migrated to the community site, and handled with ((doc:Organic groups)) and ((doc:User Trackers))

~pp~
[19:57:51] <ReWoP> when i type tiki-index.php?page="some page name" there should be a error msg that would say "page does not exist, want to go back or grate page" now there is the browser error "The page cannot be found
[19:58:26] <sylvieg> did you type the url with the "
[19:58:37] <ReWoP> *(not "grate page" but "create page")
[19:58:42] <ReWoP> nop
[19:59:32] <ReWoP> i tryed to erase DB and re-intall tiki and nothing....
[20:00:14] <sylvieg> what url did it display at the error
[20:00:46] <ReWoP> u coul try it its online -> http://dme.uma.pt/jcardoso/Research/Projects/seed/tiki-index.php?page=fgbn
[20:02:35] <sylvieg> mdavey around?
[20:03:24] <sylvieg> I don't know why it is done like this but when there is an error the header sent is HTTP/1.0 404 Not FOund with the clssic tiki page
[20:03:49] <sylvieg> I suppose your browser catches the 404 and yop
[20:04:14] <sylvieg> better to ask mdavey ... I suppose it is himl that added that why this line is here
[20:04:40] <sylvieg> you can always try to delete the liens in tiki-index.php
[20:05:02] <ReWoP> could it be permitions on the folder ??
[20:05:26] <ReWoP> i gave the web server all perms...
[20:05:27] <sylvieg> I don't think so
[20:06:30] <ReWoP> ...
[20:06:37] <ReWoP> but i could be a server problem..
[20:07:15] <ReWoP> i tryed with polaris version and was woking
[20:07:47] <ReWoP> then i have a DB problem and re-intalled it and this error occured..
[20:08:05] <sylvieg> yes it is a conflict between server/ and tiki
[20:08:30] <ReWoP> now was trying it with -Sirius- version and not workig 2.
[20:08:50] <ReWoP> the server is nt2003 server
[20:09:38] <sylvieg> there is 2 lines I don't understrand in tiki-index.php (header("...404...") I am pretty sure there are the guilty ones
[20:09:48] <ReWoP> i thing that there is error only on this part, because i can create/edit modules, menus pages premitions...
[20:10:05] <ReWoP> mabe
[20:11:01] <ReWoP> but dosnt answer why worked on my 1st polaris version, and dind on my 2nd and on 1st Sirius.....
[20:11:14] <ReWoP> dont thing its code problem...
[20:11:38] <ReWoP> if it was mabe it wold be random error
[20:11:53] <ReWoP> after all it already worked once...
[20:11:59] <red_adair> nt2003 ? what's that ?
[20:12:20] <ReWoP> windows 2003 server :p
[20:12:21] <sylvieg> you can try to put into comment the 2 line header"... 404..) in tiki-index.php

Additional information:
[18:56:51] <ReWoP> i wanted to add that there is other tiki installed on the same server but it works !
~/pp~

{syntax type="tiki" editor="plain"}
When you don't want an autoconnect by the cookie, (this for example because you are testing the product with various usernames which correspond to various usersgroups), then you let Firefox to fill automatically the password.

When the password is sent by Firefox this closes the popup-form. You must re-open it to validate.

If you are experienced you are able to understand what appends, but I receiced mail from users saying I am unable to login.

Further, sometimes the login_scr is displayed, and people think that they must give their username and their e-mail and the password. This because of the template.
In fact it is either the username or the e-mail address.

I look the form into the XXX.tpl.php without finding anything to explain the phenomenon.

we're having a charset issue when displaying tikiwiki pages.
The pages themselves are correctly sent as UTF-8: data coming from the localization files is fine.
However, data coming from the tikiwiki database is latin1, and those characters are shown as ? in a lozenge.

The database is encoded as UTF-8, but the default encoding for MySQL, set at build-time, is Latin1. So it appears that there is an implicit conversion done when getting/putting data to and from the DB.
Data received is converted from UTF-8 to Latin1, and data sent is considered to be Latin1 (though it is UTF-8), and converted again: the end result in the database is corrupted again.

It seems that this happens because tikiwiki uses the default charset encoding from the MySQL engine. On another system, with the same MySQL version, but built to use UTF-8 as default (--with-charset=utf-8), there is no problem.

It should probably use the "SET NAMES utf8" command to set the charset encoding, as described there:

http://dev.mysql.com/doc/refman/5.0/en/set-option.html

Software used is:
Solaris 9
Apache 2.2.3
PHP 4.4.4
MySQL 5.0.24a

{syntax type="tiki" editor="plain"}
tiki-check.php does not check for the availability of Command-Line -+npm+- or the version of -+npm+-. It should.

I believe Tiki does not need npm to run, npm is required only for running -+sh setup.sh+-.
-+sh setup.sh+- is needed for GIT installations.

The absence of -+npm+- with a propoer version means installing from GIT is not possible and tiki-check.php should inform of this.

There is a related discussion during the [https://recordings.rna1.blindsidenetworks.com/citadelrock/d559965849921585c1849af03b7a51638700d979-1763647044279/presentation/|November 2025 Roundtable Meeting]