Loading...
 

UserPagepeter5

Peter's Pages


biggrin My Tikiwiki sites:



exclaim My Tikiwiki notes:


Admin -> Security Admin

Function: 'Check all tiki php files'

On 1.8.5, it reports a file /db/local.php as not belonging to Tiki! Do not delete this file! You will not be able to log in or to re-install the TikiWiki!

If you ever accidentally delete this file, it has to look like this:

<?php
$db_tiki='mysql';
$dbversion_tiki='1.8';
$host_tiki='localhost';
$user_tiki='sapcity';
$pass_tiki='DATABASE PASSWORD GOES HERE!';
$dbs_tiki='sapcity_com_-_peter5tiki';
?>


Directory Paths for Files:

Directory plus a forward-slash at the end!
Example:
STORE_IMG/

--> this was apparently fixed
--> careful, I lost all links to photos and files stroed in directories and not in the database when upgrading from 1.8.4 to 1.8.5


A Hint from Tiki:

If you lose you login module use tiki-login_scr.php to be able to log in!


Safe-mode Errors:

In file lib\pear\Date\TimeZone.php: Comment out the daylight savings time detection (1.8.3):

"...
/**
* Is the given date/time in DST for this time zone
*
* Attempts to determine if a given Date object represents a date/time
* that is in DST for this time zone. WARNINGS: this basically attempts to
* "trick" the system into telling us if we're in DST for a given time zone.
* This uses putenv() which may not work in safe mode, and relies on unix time
* which is only valid for dates from 1970 to ~2038. This relies on the
* underlying OS calls, so it may not work on Windows or on a system where
* zoneinfo is not installed or configured properly.
*
* @access public
* @param object Date $date the date/time to test
* @return boolean true if this date is in DST for this time zone
*/

//pwi: safemode warning
function inDaylightTime($date)
{
// $env_tz = "";
// if"TZ" {
// $env_tz = getenv("TZ");
// }
// putenv("TZ=".$this->id);
// $ltime = localtime($date->getTime(), true);
// putenv("TZ=".$env_tz);
// return $ltime'tm_isdst';
}
//end pwi
..."


Expandable Trees in Wiki Pages:

Pasting this piece of SAP-ABAP source code into a wiki page actually resulted in an expandable tree, not sure why and if this is documented:

"FORM fulpbeg. "routine completely changed "P30K044682

  • --------------------------*
  • LPBEG/LPEND can be nested now *
  • --------------------------*

"



Tikiwiki Forum Questions and Answers:

Question: Long WIKI Pagenames: page list only shows 17 characters


I am using longish Wiki pagenames, but the list view of Wiki pages only shows the first 17 characters and then 3 dots... Anything I can do about this quickly?

Answer:
By jamesoftopiya:
Edit your tiki-list_articles.tpl file.
In there you will find a place that says
listpageschanges.title|truncate:20:"...":true
You can change the 20 to what ever you want, this is the no. of places allowed.

Damian suggests that, you can always totally remove the |truncate to show all of the title no matter how many characters.

Question: Image Galleries: Upload and Storage


2 silly little questions:

1. On one website the images get stored in the subdirectory with permissions 640 and in ftp I cannot change the permissions on the files: 'Permission Denied' to change permissions (I am trying to change the permissions to 644 like it is automatically on my other website). Now I cannot retrieve the files, I want to do a backup. What am I doing wrong? Or is it the hosting company?

2. On the second website I cannot upload images larger than 26KB, on 28KB it gives an 'Internal Server Error, contact the webmaster....'. The PHP limit is 2MB. I increased 2 values in php.ini, but I really don't know what I'm doing here:

memory_limit = 64M
max_execution_time = 240

Now I can upload images of about 50kb and not more, but it still has another problem in that it does not create the thumbnail (the 'rebuild thumbnail'-button in the image gallery also does nothing to the non-existing thumbnails). PHP is apparently running in save mode on this site. Is this something I have control over somehow and that I can influence? (Sometime when I try to upload an image I get 'Refresh Browser...', when I do the image gets uploaded twice, without thumbnails).

Answer:
1. On one website the images get stored in the subdirectory with permissions 640 and in ftp I cannot change the permissions on the files: 'Permission Denied' to change permissions (I am trying to change the permissions to 644 like it is automatically on my other website). Now I cannot retrieve the files, I want to do a backup. What am I doing wrong? Or is it the hosting company?

Because they were created by Apache, apache can work with them. Some hosts put apache in the same group as users or visaversa and it allows access to those files. A little script to get apache to chmod them differently should do the trick tho.

2. On the second website I cannot upload images larger than 26KB, on 28KB it gives an 'Internal Server Error, contact the webmaster....'. The PHP limit is 2MB. I increased 2 values in php.ini, but I really don't know what I'm doing here:

What version of GD or ImageMagick is this second host using? Also whats the LimitRequestBody? set to in apache?

Damian



SAPcity Install:

during installation, not in Tiki-db.php:
database server alias
username = DB username
enter the DB user password


Localhost Install:

During install of Tikiwiki on EasyPHP:
username = root
password = empty



sad Errors:

My Tikiwiki on SAPcity locked up! Error message:

Warning: mysql error: Can't open file: 'tiki_pages.MYI'. (errno: 145) in query:
select `pageName` from `tiki_pages` where `pageName` = ?
in /home2/www/sapcity/tiki/lib/tikidblib.php on line 125
Values:
Array ( 0 => SAPcity )
$result is false
$result is empty


...it happened out of the blue as I clicked <Safe> after editing a page...

Check this idea:

http://tikiwiki.org/tiki-view_forum_thread.php?comments_parentId=7268&forumId=1&highlight=tiki_pages.MYI

See below! The command 'myisamchk -r *.MYI' normally helps!

"hormigaga:/var/lib/mysql/tiki# myisamchk tiki_pages.MYI
Checking MyISAM file: tiki_pages.MYI
Data records: 15 Deleted blocks: 0
myisamchk: warning: Table is marked as crashed
myisamchk: warning: 1 clients is using or hasn't closed the table properly
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check data record references index: 4
- check data record references index: 5
- check record links
MyISAM-table 'tiki_pages.MYI' is usable but should be fixed


Here is the log:

myisamchk -e *.MYI
//actually the result was the bad for all tables (ver. 3 --> ver. 4 ?)

MyISAM-table 'name_of_table.MYI' is usable but should be fixed


backup the data: cp -r /var/lib/mysql/tiki somewhere
myisamchk -r *.MYI
"






Page last modified on Sunday 27 February 2011 08:21:07 GMT-0000

Upcoming Events

1)  Wed 23 Sep 2020 14:00 GMT-0000
September TRM

Why Register?

Register at tiki.org and you'll be able to use the account at any *.tiki.org site, thanks to the InterTiki feature. A valid email address is required to receive site notifications and occasional newsletters. You can opt out of these items at any time.