Category: Error

Get this on image view pages like...
http://cefn.com/cefntiki/tiki-browse_image.php?galleryId=2&imageId=2

An error occured in a database query!

Context:
File /cefn.com/cefntiki/tiki-browse_image.php
Url /cefntiki/tiki-browse_image.php?galleryId=2&imageId=2
Query:
select `catObjectId` from `tiki_categorized_objects` where `type`=? and `objId`=?
Values:
0 image gallery
1 2
Message:
Error Message

{syntax type="tiki" editor="plain"}
The "Database dumps and restores" feature in the "Wiki" control panel creates corrupt tar files.

Steps to reproduce:
# As admin, go to Settings -> Control Panels -> Main Features -> Wiki -> Database dumps and restores
# Create a dump by filling in "Name for dump" and click "Create database dump"
# Create a dump file by clicking "Dump files" (below) -> Create dump file
# Download dump file by clicking "Download dump file".
# Go to your browser's download directory and try to list its contents:
+{CODE(theme="default")}LANG=C.UTF-8 tar tf dump_wiki.tar{CODE}
+ I get this result:{CODE(theme="default")}...
tar: Archive contains ‘ml000066’ where numeric mode_t value expected
...
tar: Skipping to next header
tar: A lone zero block at 19529
tar: Exiting with failure status due to previous errors{CODE}

{syntax type="tiki" editor="plain"}
An error occured in a database query!

Context:
File tiki-objectpermissions.php
Url tiki-objectpermissions.php
Query:
insert into `users_objectpermissions`(`groupName`, `objectId`, `objectType`, `permName`) values(?, ?, ?, ?)
Values:
0 Registered
1 23bfc265681dcc129a658e8a8552cccff26613d0
2 wiki page
3 tiki_p_view
Message:
Built query was probably:
insert into `users_objectpermissions`(`groupName`, `objectId`, `objectType`, `permName`) values('Registered', '23bfc265681dcc129a658e8a8552cccff26613d0', 'wiki page', 'tiki_p_view')

when trying to assign tiki_p_view to registered group under Perms button.

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

Database error as follows:

#
Context:
#
File tiki-editpage.php
#
Url tiki-editpage.php
#
Query:
#
insert into `tiki_objects`(`type`,`itemId`,`description`,`name`,`href`,`created`,`hits`,`comments_locked`) values(?,?,?,?,?,?,?,?)
Message:
#
Unknown column 'comments_locked' in 'field list'

installer/schema/20090205_forum_and_comments_locking_tiki.sql appears not to be run on fresh install. This file was introduced in:

http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki?view=rev&revision=17801

Shouldn't the filename be 20090405....? Is this the problem?

Also, is this related to http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki?view=rev&revision=17919

{syntax type="tiki" editor="plain"}
Cannot create a calendar item. Working as user admin. Receive error "An error occured in a database query!".

System config: Win XP SP3. Tiki 3.0, IIS version 5.1, MySQL 5.0.24, PHP for Windows 5.2.9.2.


Error text follows:

Context:
File tiki-calendar_edit_item.php
Url tiki-calendar_edit_item.php?
Query:
INSERT INTO `tiki_calendar_items` (`user`,`calendarId`,`name`,`description`,`status`,`url`,`lang`,`allday`,`start`,`end`,`priority`,`locationId`,`categoryId`,`nlId`,`recurrenceId`,`lastmodif`,`created`) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Values:
0 admin
1 1
2 A test event
3 This is text for a test event.
4 1
5
6
7 0
8 1243332000
9 1243342800
10 0
11 0
12 0
13 0
14 NULL
15 1243280012
16 1243280012
Message:

Built query was probably:
INSERT INTO `tiki_calendar_items` (`user`,`calendarId`,`name`,`description`,`status`,`url`,`lang`,`allday`,`start`,`end`,`priority`,`locationId`,`categoryId`,`nlId`,`recurrenceId`,`lastmodif`,`created`) VALUES ('admin','1','A test event','This is text for a test event.','1','','','0','1243332000','1243342800','0','0','0','0',NULL,'1243280012','1243280012')

I'm trying to upgrade a Tiki 12.9 site to Tiki 15.5 site. Composer runs fine, but when updating database I got several erros after run this command:

{CODE(colors="shell",wrap=0,ln=1)}
php console.php database:update
{CODE}

!! Error

{CODE(caption="php console.php database:update" theme="default")}Error 0 in 20151203_tiki_score_revamp_tiki
#Add needed columns
ALTER TABLE tiki_score change event event varchar(255); #increase varchar length
ALTER TABLE tiki_score ADD COLUMN data TEXT
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ALTER TABLE tiki_score ADD COLUMN data TEXT' at line 3
Error 1 in 20151203_tiki_score_revamp_tiki
# Insert old values from tiki_score into new format
# Insert user stuff. Login, message, friend pts.
INSERT INTO tiki_score (event, data)
SELECT "tiki.user.login" AS event, concat('[{"ruleId":"User logs in","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='login'
Unknown column 'data' in 'field list'
Error 2 in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.user.view" AS event, concat('[{"ruleId":"See other user''s profile","recipientType":"user","recipient":"user","score":"',max(case when event = 'profile_see' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Have your profile seen","recipientType":"user","recipient":"object","score":"',max(case when event = 'profile_is_seen' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'data' in 'field list'
Error 3 in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.user.friend" AS event, concat('[{"ruleId":"Make friends","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='friend_new'
Unknown column 'data' in 'field list'
Error 4 in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.user.message" AS event, concat('[{"ruleId":"Send message","recipientType":"user","recipient":"user","score":"',max(case when event = 'message_send' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Receive message","recipientType":"user","recipient":"object","score":"',max(case when event = 'message_receive' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'data' in 'field list'
Error 5 in 20151203_tiki_score_revamp_tiki
# Articles
INSERT INTO tiki_score (event, data)
SELECT "tiki.article.create" AS event, concat('[{"ruleId":"Publish new article","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='article_new'
Unknown column 'data' in 'field list'
Error 6 in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.article.view" AS event, concat('[{"ruleId":"Read an article","recipientType":"user","recipient":"user","score":"',max(case when event = 'article_read' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Have your article read","recipientType":"user","recipient":"author","score":"',max(case when event = 'article_is_read' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'data' in 'field list'
Error 7 in 20151203_tiki_score_revamp_tiki
# File Gallery
INSERT INTO tiki_score (event, data)
SELECT "tiki.filegallery.create" AS event, concat('[{"ruleId":"Create new file gallery","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='fgallery_new'
Unknown column 'data' in 'field list'
Error 8 in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.file.create" AS event, concat('[{"ruleId":"Upload new file to gallery","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='fgallery_new_file'
Unknown column 'data' in 'field list'
Error 9 in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.file.download" AS event, concat('[{"ruleId":"Download other user''s file","recipientType":"user","recipient":"user","score":"',max(case when event = 'fgallery_download' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Have your file downloaded","recipientType":"user","recipient":"owner","score":"',max(case when event = 'fgallery_is_downloaded' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'data' in 'field list'
Error 10 in 20151203_tiki_score_revamp_tiki
# Image Gallery
INSERT INTO tiki_score (event, data)
SELECT "tiki.imagegallery.create" AS event, concat('[{"ruleId":"Create new image gallery","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='igallery_new'
Unknown column 'data' in 'field list'
Error 11 in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.image.create" AS event, concat('[{"ruleId":"Upload new image to gallery","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='igallery_new_img'
Unknown column 'data' in 'field list'
Error 12 in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.image.view" AS event, concat('[{"ruleId":"See other user''s image","recipientType":"user","recipient":"user","score":"',max(case when event = 'igallery_see_img' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Have your image seen","recipientType":"user","recipient":"owner","score":"',max(case when event = 'igallery_img_seen' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'data' in 'field list'
Error 13 in 20151203_tiki_score_revamp_tiki
#Blogs
INSERT INTO tiki_score (event, data)
SELECT "tiki.blog.create" AS event, concat('[{"ruleId":"Create new blog","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='blog_new'
Unknown column 'data' in 'field list'
Error 14 in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.blogpost.create" AS event, concat('[{"ruleId":"Post in a blog","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='blog_post'
Unknown column 'data' in 'field list'
Error 15 in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.blog.view" AS event, concat('[{"ruleId":"Read other user''s blog","recipientType":"user","recipient":"user","score":"',max(case when event = 'blog_read' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Have your blog read","recipientType":"user","recipient":"author","score":"',max(case when event = 'blog_is_read' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'data' in 'field list'
Error 16 in 20151203_tiki_score_revamp_tiki
# Wikis
INSERT INTO tiki_score (event, data)
SELECT "tiki.wiki.create" AS event, concat('[{"ruleId":"Create a wiki page","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='wiki_new'
Unknown column 'data' in 'field list'
Error 17 in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.wiki.update" AS event, concat('[{"ruleId":"Edit an existing wiki page","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='wiki_edit'
Unknown column 'data' in 'field list'
Error 18 in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.wiki.attachfile" AS event, concat('[{"ruleId":"Attach file to wiki page","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='wiki_attach_file'
Unknown column 'data' in 'field list'
Error 19 in 20151203_tiki_score_revamp_tiki
#remove old scores from the tiki_score table
DELETE FROM tiki_score WHERE data is null
Unknown column 'data' in 'where clause'
{CODE}

!! System details

1. MySQL version
{CODE(colors="shell",wrap=0,ln=1)}
root@45af11331f6a:/# mysql --version
mysql Ver 15.1 Distrib 10.2.10-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

root@45af11331f6a:/# mysqld --version
mysqld Ver 10.2.10-MariaDB-10.2.10+maria~jessie for debian-linux-gnu on x86_64 (mariadb.org binary distribution)
{CODE}

2. PHP Version
{CODE(colors="shell",wrap=0,ln=1)}
root@6575eef728ba:/var/www/html# php --version
PHP 5.6.33 (cli) (built: Jan 9 2018 02:55:39)
Copyright (c) 1997-2016 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies
with Xdebug v2.5.5, Copyright (c) 2002-2017, by Derick Rethans
{CODE}

3. PHP modules
{CODE(colors="shell",wrap=0,ln=1)}
root@6575eef728ba:/var/www/html# php -m
[PHP Modules]
apcu
calendar
Core
ctype
curl
date
dom
ereg
fileinfo
filter
ftp
gd
hash
iconv
json
libxml
mbstring
mcrypt
memcached
mysqli
mysqlnd
openssl
pcre
PDO
pdo_sqlite
Phar
posix
readline
Reflection
session
SimpleXML
SPL
sqlite3
standard
tokenizer
xdebug
xml
xmlreader
xmlwriter
Zend OPcache
zip
zlib

[Zend Modules]
Xdebug
Zend OPcache
{CODE}

10 MySQL "create table" commands are not compatible w/ the 3.23.58 version of MySQL

The last 2 use tables use ENGINE=MyISAM instead of TYPE=MyISAM and have a VARCHAR field of size 256 (255 is ok to use)

Here are those queries
Command: CREATE TABLE tiki_modules (
moduleId int(8) NOT NULL auto_increment,
name varchar(200) NOT NULL default '',
position char(1) default NULL,
ord int(4) default NULL,
type char(1) default NULL,
title varchar(255) default NULL,
cache_time int(14) default NULL,
rows int(4) default NULL,
params varchar(255) default NULL,
groups text,
PRIMARY KEY (name, position, ord),
KEY positionType (position, type),
KEY moduleId (moduleId)
) TYPE=MyISAM
Message: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead

Command: CREATE TABLE tiki_page_drafts (
user varchar(200) default '',
pageName varchar(255) NOT NULL,
data mediumtext,
description varchar(200) default NULL,
comment varchar(200) default NULL,
lastModif int(14) default NULL,
PRIMARY KEY (pageName(120), `user`(120))
) TYPE=MyISAM
Message: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead

Command: CREATE TABLE tiki_tracker_item_fields (
itemId int(12) NOT NULL default '0',
fieldId int(12) NOT NULL default '0',
lang char(16) default NULL,
value text,
PRIMARY KEY (itemId,fieldId,lang),
FULLTEXT KEY ft (value)
) TYPE=MyISAM
Message: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead

Command: CREATE TABLE tiki_user_assigned_modules (
name varchar(200) NOT NULL default '',
position char(1) default NULL,
ord int(4) default NULL,
type char(1) default NULL,
user varchar(200) NOT NULL default '',
PRIMARY KEY (name(30),user,position)
) TYPE=MyISAM
Message: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead

Command: CREATE TABLE `tiki_webmail_contacts_ext` (
`contactId` int(11) NOT NULL,
`fieldId` int(10) unsigned NOT NULL,
`value` varchar(256) NOT NULL,
`hidden` tinyint(1) NOT NULL,
KEY `contactId` (`contactId`)
) ENGINE=MyISAM
Message: Too big column length for column 'value' (max = 255). Use BLOB instead

Command: CREATE TABLE `tiki_webmail_contacts_fields` (
`fieldId` int(10) unsigned NOT NULL auto_increment,
`user` VARCHAR( 200 ) NOT NULL ,
`fieldname` VARCHAR( 256 ) NOT NULL ,
`order` int(2) NOT NULL default '0',
`show` char(1) NOT NULL default 'n',
PRIMARY KEY ( `fieldId` ),
INDEX ( `user` )
) ENGINE = MyISAM
Message: Too big column length for column 'fieldname' (max = 255). Use BLOB instead

I installed from git a new Tiki22.
Create (externally) the database and populate it with a Tiki21 previous database.
Completed the installation. with the following error:

{img fileId="1453" thumb="box"}

Accessing to the admin it shows there is an issue with the database.
From ssh using database:update I get an error and I can’t neither rebuilt the index:

{CODE()}
root@ec2-xx-xx-xx-xxx:/home/xxx/public_html# php console.php database:update
PDO::query(): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'tsaharoniki_tiki22.sessions' doesn't exist on line 104 of /home/xxxx/public_html/lib/core/TikiDb/Pdo.php
Update completed.
Failed: 20200513_expand_sessions_data_column_tiki
Queries executed successfully: 3
Error in 20200513_expand_sessions_data_column_tiki
ALTER TABLE `sessions` CHANGE `data` `data` LONGBLOB NOT NULL
Table 'tsaharoniki_tiki22.sessions' doesn't exist

root@ec2-xx-xx-xx-xxx:/home/xxx/public_html# php console.php i:r
Command not available at this stage.
The database needs to be updated. Solved by: php console.php database:update
{CODE}

I compared 2 tikis created at different times.
One that was created before Tiki18 and has a "sessions" table with a data col.
And one created after Tiki19 that doesn’t have a "sessions" table.

May be this should be conditioned to the table existence ?
Or if this table is legacy it should be removed (data moved to tiki_sessions ?)

I upgraded a Tiki21.5 from the release package to a 21.8.
Database upgrade failed with the following errors:

^
Update completed.
Failed: 20120423_add_page_refs_tiki
Failed: 20151203_tiki_score_revamp_tiki
Queries executed successfully: 14
Error in 20120423_add_page_refs_tiki
ALTER TABLE tiki_page_references ADD UNIQUE INDEX uk1_tiki_page_ref_biblio_code (page_id, biblio_code)
Duplicate key name 'uk1_tiki_page_ref_biblio_code'
Error in 20120423_add_page_refs_tiki
ALTER TABLE tiki_page_references ADD INDEX idx_tiki_page_ref_title (title)
Duplicate key name 'idx_tiki_page_ref_title'
Error in 20120423_add_page_refs_tiki
ALTER TABLE tiki_page_references ADD INDEX idx_tiki_page_ref_author (author)
Duplicate key name 'idx_tiki_page_ref_author'
Error in 20151203_tiki_score_revamp_tiki
ALTER TABLE tiki_score ADD COLUMN reversalEvent varchar(255)
Duplicate column name 'reversalEvent'
Error in 20151203_tiki_score_revamp_tiki
# Insert old values from tiki_score into new format
# Insert user stuff. Login, message, friend pts.
INSERT INTO tiki_score (event, data)
SELECT "tiki.user.login" AS event, concat('[{"ruleId":"User logs in","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='login'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.user.view" AS event, concat('[{"ruleId":"See other user''s profile","recipientType":"user","recipient":"user","score":"',max(case when event = 'profile_see' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Have your profile seen","recipientType":"user","recipient":"object","score":"',max(case when event = 'profile_is_seen' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.user.friend" AS event, concat('[{"ruleId":"Make friends","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='friend_new'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.user.message" AS event, concat('[{"ruleId":"Send message","recipientType":"user","recipient":"user","score":"',max(case when event = 'message_send' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Receive message","recipientType":"user","recipient":"object","score":"',max(case when event = 'message_receive' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
# Articles
INSERT INTO tiki_score (event, data)
SELECT "tiki.article.create" AS event, concat('[{"ruleId":"Publish new article","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='article_new'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.article.view" AS event, concat('[{"ruleId":"Read an article","recipientType":"user","recipient":"user","score":"',max(case when event = 'article_read' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Have your article read","recipientType":"user","recipient":"author","score":"',max(case when event = 'article_is_read' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
# File Gallery
INSERT INTO tiki_score (event, data)
SELECT "tiki.filegallery.create" AS event, concat('[{"ruleId":"Create new file gallery","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='fgallery_new'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.file.create" AS event, concat('[{"ruleId":"Upload new file to gallery","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='fgallery_new_file'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.file.download" AS event, concat('[{"ruleId":"Download other user''s file","recipientType":"user","recipient":"user","score":"',max(case when event = 'fgallery_download' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Have your file downloaded","recipientType":"user","recipient":"owner","score":"',max(case when event = 'fgallery_is_downloaded' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
# Image Gallery
INSERT INTO tiki_score (event, data)
SELECT "tiki.imagegallery.create" AS event, concat('[{"ruleId":"Create new image gallery","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='igallery_new'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.image.create" AS event, concat('[{"ruleId":"Upload new image to gallery","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='igallery_new_img'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.image.view" AS event, concat('[{"ruleId":"See other user''s image","recipientType":"user","recipient":"user","score":"',max(case when event = 'igallery_see_img' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Have your image seen","recipientType":"user","recipient":"owner","score":"',max(case when event = 'igallery_img_seen' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
#Blogs
INSERT INTO tiki_score (event, data)
SELECT "tiki.blog.create" AS event, concat('[{"ruleId":"Create new blog","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='blog_new'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.blogpost.create" AS event, concat('[{"ruleId":"Post in a blog","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='blog_post'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.blog.view" AS event, concat('[{"ruleId":"Read other user''s blog","recipientType":"user","recipient":"user","score":"',max(case when event = 'blog_read' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Have your blog read","recipientType":"user","recipient":"author","score":"',max(case when event = 'blog_is_read' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
# Wikis
INSERT INTO tiki_score (event, data)
SELECT "tiki.wiki.create" AS event, concat('[{"ruleId":"Create a wiki page","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='wiki_new'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.wiki.update" AS event, concat('[{"ruleId":"Edit an existing wiki page","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='wiki_edit'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.wiki.attachfile" AS event, concat('[{"ruleId":"Attach file to wiki page","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='wiki_attach_file'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
# Remove unnecessary fields
ALTER TABLE tiki_score DROP COLUMN score
Can't DROP 'score'; check that column/key exists
Error in 20151203_tiki_score_revamp_tiki
ALTER TABLE tiki_score DROP COLUMN expiration
Can't DROP 'expiration'; check that column/key exists
Error in 20151203_tiki_score_revamp_tiki
ALTER TABLE tiki_score DROP COLUMN validObjectIds
Can't DROP 'validObjectIds'; check that column/key exists
Error in 20151203_tiki_score_revamp_tiki
# Import legacy score from users table
INSERT INTO tiki_object_scores (triggerObjectType, triggerObjectId, triggerUser, triggerEvent, ruleId, recipientObjectType, recipientObjectId, pointsAssigned, pointsBalance, date)
SELECT 'legacy_score', '0', login, 'tiki.legacy.score', 'Legacy Score', 'user', login, score, score, UNIX_TIMESTAMP() FROM users_users
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
# Drop users score column, we now use pointsBalance from tiki_object_scores table
ALTER TABLE users_users DROP COLUMN score
Can't DROP 'score'; check that column/key exists
^

A tracker is created using Date Only field, after the tracker is displayed in a wiki page with a user submitted date, the date format looks something like this.
-1167609600

A show instance will be created with a tracker to use to display date in a wiki page.
Thank you for inspecting this bug.

At google search console (https://search.google.com/search-console/sitemaps) my sitemap (using https://bernardsfez.com/storage/public/sitemap-index.xml) is submitted via the console.php command (using the Tiki scheduler).

{img fileId="1670" thumb="box"}

If I click on the corresponding row it open a detailed table where I see that Google fetched 2 XML and that fetching my articles XML it produce 1 error.

{img fileId="1671" thumb="box"}

When I click on it to see the details I see error about the lasted date.

{img fileId="1672" thumb="box"}

And when I look at https://bernardsfez.com/storage/public/articles.xml the dates are all wrong.
It seems to prevent Google to index my articles.
When I index one by one articles using https://search.google.com/search-console/inspect (when a page is not indexed I have an option to index it) It work just fine with the right date.

I also checked at tiki.org and I see the same errors: https://tiki.org/storage/public/articles.xml

{FADE(label="XML where we can see the date errors" icon="y")}

<!-- Generated by https://git.io/phpseo -->
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
<url>
<loc>https://example.com/%25D7%25AA%25D7%2595%25D7%259B%25D7%25A0%25D7%2594-%25D7%259E%25D7%25A7%25D7%2595%25D7%2595%25D7%259F-%25D7%259C%25D7%25A0%25D7%2599%25D7%2594%25D7%2595%25D7%259C-%25D7%25A6%25D7%2594%25D7%25A8%25D7%2595%25D7%259F-%25D7%2597%25D7%2595%25D7%2592%25D7%2599%25D7%259D-%25D7%2595%25D7%2592%25D7%25A0%25D7%2599-%25D7%2599%25D7%259C%25D7%2593%25D7%2599%25D7%259D</loc>
<priority>0.6</priority>
<changefreq>weekly</changefreq>
~~#F00:<lastmod>6773-12-06T16:34:41+02:00</lastmod>~~
</url>
<url>
...
~~#F00:<lastmod>1970-01-01T02:00:00+02:00</lastmod>~~
</url>
<url>
...
~~#F00:<lastmod>1970-01-01T02:00:00+02:00</lastmod>~~
</url>
<url>
...
~~#F00:<lastmod>5887-12-06T16:05:59+02:00</lastmod>~~
</url>
<url>
...
~~#F00:<lastmod>1970-01-01T02:00:00+02:00</lastmod>~~
</url>
<url>

{FADE}

{syntax type="tiki" editor="plain"}
I've updated a Tiki27.x (after the Tiki 25.7 release) and now the date and time selectors are broken.
It is visual and forbid entering a date. I found a workaround, see below.

This is an old Tiki (started in Tiki9x) that was updated years after years.
I couldn't reproduce on demo.

{img fileId="3233" thumb="box"}

I don't see errors on the console on Brave.

On chrome:
{CODE()}
min_main_235ae2033a9c3fb4320e739db2fbcd55.js:137 JQMIGRATE: Migrate is installed, version 3.5.2
injected.js:3 [Detection] Sign in with intersection observer was watching an unacceptable node.
WI @ injected.js:3
injected.js:3 [Detection] Sign in with intersection observer was watching an unacceptable node.
WI @ injected.js:3
{CODE}

{CODE()}
if (!No(o)) {
console.error("[Detection]", "Sign in with intersection observer was watching an unacceptable node.") || logger.report(["Sign in with intersection observer was watching an unacceptable node."], {
severity: "error",
fileName: "js/b5x/ui/inline/frame-manager/src/sign-in-with/detection/manager.ts",
lineNumber: 230,
prefix: "[Detection]",
highlight: !1
}),
t.unobserve(o);
continue
}
{CODE}

Date validation (at Registration) is not validation the date field correctly. Validation only accept if day of the date is under 12. It seems it understand the number as as months not days. And it is not themonth field, since the month field popup menu is just next to the date field.

I checked all the date formats and reseted it to the Tiki default and the error still persists.

{syntax type="tiki" editor="plain"}
db error in group inclusion (tiki 3.3)
Installed barebones profile on tiki 3.3, then applied Collaborative Community on top, which created the group SubAdmins.
Then I attempted to rename group SubAdmins (which includes Editors) to Editors_Web, and I got this error:

{CODE(wrap=>1)}
Context:
File tiki-admingroups.php
Url tiki-admingroups.php
Query:
insert into `tiki_group_inclusion`(`groupName`,`includeGroup`) values(?,?)
Values:
0 Editors_Web
1 Editors
Message:
Built query was probably:
insert into `tiki_group_inclusion`(`groupName`,`includeGroup`) values('Editors_Web','Editors')
{CODE}

{syntax type="tiki" editor="plain"}
When activating the TAG plugin, the following error occurs when trying to open a page containing the plugin Tag code:
Context:
File tiki-index.php
Url tiki-index.php?page=Help_Syntax%20Tekst_2
Query:
INSERT INTO tiki_plugin_security (fingerprint, status, added_by, last_objectType, last_objectId) VALUES(?, ?, ?, ?, ?)
Values:
0 tag-1b3231655cebb7a1f783eddf27d254ca-d0fb7a014946e0f0c38342e8d958f992-500000-260000
1 pending
2 admin
3 wiki page
4 Help_Syntax Tekst_2
Message:

Built query was probably:
INSERT INTO tiki_plugin_security (fingerprint, status, added_by, last_objectType, last_objectId) VALUES('tag-1b3231655cebb7a1f783eddf27d254ca-d0fb7a014946e0f0c38342e8d958f992-500000-260000', 'pending', 'admin', 'wiki page', 'Help_Syntax Tekst_2')

{syntax type="tiki" editor="plain"}
Under Menu > Navigation in the admin settings, attempting to edit the menu's Details/Options (via the dialog accessed using the edit/pencil button) results in the following error:

* Incorrect integer value: '' for column `tikiwiki`.`tiki_menu_options`.`userlevel` at row 1

This means that no options can be updated for menus. Name, group restrictions, et al. Menus can still be re-ordered and re-arranged, but no settings, labels, or other features are saving.

This is a brand-new, fresh install, and I am not seeing any errors when updating any other content or items.

__Steps to reproduce:__
# Visit Admin > Menu > Navigation
# Click on the Pencil/Edit Icon next to a menu option
# Make changes and click "Save"

__Faulty consequence:__
* Error appears at top of page, and no settings are changed.

__Expected behavior:__
* I expect the settings to be saved and no error to appear.

__Workaround:__
Use menus without permissions or customization. This means that menu items that should not appear for, say, anonymous users will still appear, and take the visitor to an error/access denied message. Menu link, title and position are the only things that can be changed, as they can be adjusted through the menu options list.

I was running 1.9.9 on a SLES 10 linux box, and we are running MySQL on Novell Netware, MySQL version 4.0.26a.

I tried an upgrade directly over the top of 1.9.9, and I got that error. So, I tried a Clean install on a new database, and I got the same error.

As a troubleshooting step, I tried creating a blank database with the name that it specifies, but then it just gives the following error message
"Unknown column 'bits.translation_bit_id' in 'field list'".

I suspect the installer script isn't creating this table and fields properly.

This error occurs anytime any Page is clicked on, including the main index page. It is a major roadblock to basic functionality.

Operations failed: 1 SQL queries. Display details.

During an upgrade, it is normal to have SQL failures resulting with Table already exists messages.

tiki
- --------------------------------------------------------
-- Database : Tiki
-- --------------------------------------------------------

DROP TABLE IF EXISTS `messu_messages`
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 '- --------------------------------------------------------
-- Database : Tiki
-' at line 1

Bug report available at
https://sourceforge.net/tracker/index.php?func=detail&aid=1174695&group_id=64258&atid=506846

{syntax type="tiki" editor="plain"}
When debugger is activated, the admin panel is no more working. I have mainly 2 effects :
* when I am on tiki-admin.php (the main page), I cannot go to any of the admin panel (features, freetags, look, etc...)
* When I go directly to an admin page by giving the url by my own (eg. tiki-admin?page=look), the tabs are not working.

Once debugger console is deactivated, everything works well.

{syntax type="tiki" editor="plain"}
In group settings, there is an option to set a default category for any uncategorized objects edited by the object. This feature does not work.

Default pref allowMsgs set to y but not set to new users

The default size of article images is the least little bit too high in my view.

The explanation given to the admin reminds the admin "Maximum file size for an article image. Article images are stored in the database so it should remain low". And after stating that, the default is 500.000. Kilobytes :-) That's 500 MBytes for one single image. I wonder what MySQL thinks about a blob of 500 meg... And imagine a backup of that DB in .sql format... :-)

{CODE(Colors="Tiki")}
'article_image_file_size_max' => [
'name' => tra('Article image maximum file size'),
'description' => tra('Maximum file size for an article image. Article images are stored in the database so it should remain low.'),
'type' => 'text',
'size' => '10',
'filter' => 'digits',
'units' => tra('kilobytes'),
'default' => 500000,
],
{CODE}

{syntax type="tiki" editor="plain"}
there is still that issue sometimes with the error undefined "thread sort mode" if you preview an answer before posting it at tw. forums.

It heppened to me again when attempting to reply to a thread with a comment already, and I previewed my post first before attemptint to post it.
When I clicked on post, I saw that message.

TW.o is currently using tiki5beta1 r26677