Loading...
 
Skip to main content

Add field to mirror table fails

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
Add field to mirror table fails
Version
1.9.x
Category
  • Usability
Feature
~Trackers (mirror)
Resolution status
Out of Date
Submitted by
Bruce L. Van Buren
Lastmod by
Bruce L. Van Buren
Rating
(0)
Description

While adding field Group as a group selector got following error (Tried again for a text field & same error):

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 'Group TEXT' at line 1 in query:

alter table tiki_trk_Groups add column Group TEXT

in /home/tikivam/public_html/cms/lib/tikidblib.php on line 134

Warning: Invalid argument supplied for foreach() in /home/tikivam/public_html/cms/lib/tikidblib.php on line 145

Then when list tracker items:
Notice: Undefined index: Group in /home/tikivam/public_html/cms/lib/trackers/trkWithMirrorTablesLib.php on line 594

for each item.

Then when edit item:
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 'Group='yrc94' where `itemId`='18'' at line 1 in query:

update tiki_trk_Groups set Group=? where `itemId`=?

in /home/tikivam/public_html/cms/lib/tikidblib.php on line 134

Checking DB: Group column was not created in table.

This is from a test site http://tiki.vamason.orgQuestion while trying to recreate trackers as mirrors from http://cms.vamason.orgQuestion. I installed lastbranch1.9 on 8/3 and copied the DB & ran 1.8-1.9 upgrade. Deleted old trackers, changed Tracker feature to use mirror tables. Emptied tracker tables using SQLyog before starting. Loaded data from CVS using SQLyog.

Priority
25
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
1282
Created
Sunday 05 August, 2007 19:21:39 UTC
by Unknown
LastModif
Tuesday 26 October, 2021 13:31:08 UTC


Show PHP error messages