Invision Power Services: Driver error after posting issue and viewing existing one -> IP.Tracker -> Tracker

Jump to content

Report ID 15576 Title Driver error after posting issue and viewing existing one
Product IP.Tracker Status Fixed (Severity 5 - Critical)
Version 1.3.0 RC 2 Fixed in 1.3.0 RC 2

Page 1 of 1
  • Cannot start a new Issue
  • You cannot reply to this issue

Issue Timeline Issue Timeline
Report ID #15576: Driver error after posting issue and viewing existing one

#1 User is offline  
Wareczek Icon

  • IPB Newbie
  • Icon
  • Group: +Active Customers
  • Posts: 34
  • Joined: 14-February 07
  • Location:Bielsko-Biała, Poland

Posted 12 June 2009 - 10:29 PM

Quote

Error: Table '***.tracker_issue_markers' doesn't exist
IP Address: 87.205.45.243
Page: /index.php?app=tracker&showissue=1
Debug: array (
1 =>
array (
'file' => '/root/ips_kernel/classDb.php',
'line' => 982,
'function' => 'query',
'class' => 'db_driver_mysql',
),
3 =>
array (
'file' => '/root/admin/sources/base/ipsController.php',
'line' => 291,
'function' => 'doExecute',
'class' => 'public_tracker_projects_issues',
),
)
mySQL query error: SELECT * FROM tracker_issue_markers WHERE marker_project_id=1 AND marker_member_id=1

Clean install. With this error aplication is not usefull.
Posted Image Polish IP.Board Support - mods, skins, fast help and more...

Page 1 of 1  
  • Cannot start a new Issue
  • You cannot reply to this issue

Replies (1 - 5)

#2 User is offline  
AlbusDumbledore Icon

  • Sees All
  • Icon
  • Group: +Active Customers
  • Posts: 1,155
  • Joined: 16-February 02
  • Location:South Carolina

Posted 13 June 2009 - 07:16 AM

That table was installed in RC1, but the upgrader for RC2 drops it.
Posted Image
My Skins at IP Resources

#3 User is offline  
Adriano Faria Icon

  • Spam Happy
  • Icon
  • Group: +Active Customers
  • Posts: 963
  • Joined: 11-April 07
  • Location:Brazil

Posted 13 June 2009 - 01:44 PM

Same problem.

Temporary fix: on your Admin CP SQL Toolbox or PHPMyAdmin:

CREATE TABLE PREFIX_tracker_issue_markers (
   marker_member_id int(8) NOT NULL default '0',
   marker_project_id int(10) NOT NULL default '0',
   marker_last_update int(10) NOT NULL default '0',
   marker_unread smallint(5) NOT NULL default '0',
   marker_issues_read text,
   marker_last_cleared int(10) NOT NULL default '0',
   UNIQUE KEY marker_project_id (marker_project_id,marker_member_id),
   KEY marker_member_id (marker_member_id)
 );

REMEMBER to change PREFIX_ to your prefix.
Posted Image

#4 User is offline  
Alex Icon

  • Needs Hobby
  • PipPipPipPipPipPipPip
  • Group: IPS Resources
  • Posts: 3,211
  • Joined: 19-April 07
  • Location:Bristol, England

Posted 13 June 2009 - 02:20 PM

Updating status to: Fixed
Updating severity to: 5 - Critical
Issue fixed in: 1.3.0 RC 2

Quote

It has come to our attention that whilst viewing an issue, a critical driver error occurred. There was a temporary fix of adding the table that was missing to the database, however this was not needed because the upgrader was correct in removing this table in the first place. We simply did not realise part of the code will still calling it.

To fix this issue, simply redownload the release. You only need to upload the following changed file: admin/applications_addon/other/tracker/modules_public/projects/issues.php.

Once this is done, you should now be able to view an issue!

Sorry for the mishap.

Alex Hobbs
Community Resources
AIM: ahmodding Twitter: @alexhobbs

Looking to buy IP.Board? - Looking to convert to IP.Board?

Posted Image <--- Go on, you know you want to!

Quote

Alex Hobbs: God your pushy
Brian Garcia: Cause you are the type of person you need to remind 940390 times cause you get distracted with something else
Brian Garcia: Xbox 360, Lost, bleeding out somewhere, bracelet, making fun of Charles, making fun of Mark, taking millions of photos of your dog

#5 User is offline  
Adriano Faria Icon

  • Spam Happy
  • Icon
  • Group: +Active Customers
  • Posts: 963
  • Joined: 11-April 07
  • Location:Brazil

Posted 13 June 2009 - 04:05 PM

As I said on that topic, happened with on a Fresh Install.
Posted Image

#6 User is offline  
teraßyte Icon

  • The SVN gatekeeper
  • Icon
  • Group: IPS Staff
  • Posts: 2,647
  • Joined: 29-September 07
  • Location:Italy

Posted 13 June 2009 - 04:38 PM

That's because we had the old table on our dev boards and we didn't realize the old calls not needed anymore, upload the new file and you're good to go :)
IPS Staff

~ (T30) Tickets System in progress, click here to read more! ~

~ My Site ~ All My Mods ~

Donations are always appreciated :)


Latest Releases: (T30) Group Format 2.0.0 | (T30) PM on Group Change 1.0.0 | (T30) Database Optimizer 1.1.0 | (T30) Display Members Browser 1.0.0 | (T30) Show Reputation in Topic View 1.0.1 | (T30) Hide Content 1.1.0 | (T30) Bump Up Topics 1.0.1 | (T30) Email Address in New User Notifications 1.0.1 | (T30) Auto Prune Invisible Topics 1.0.1 | (T30) Close Only Poll 1.0.0

Page 1 of 1
  • Cannot start a new Issue
  • You cannot reply to this issue

0 User(s) are reading this issue
0 Guests and 0 Anonymous Users


Powered by IP.Tracker 1.3.1a © 2010  IPS, Inc.