Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

Welcome to IPS!

Feel free to browse our community to get a feel for how our community software operates. Post in the pre-sales forum with any questions you have before purchasing or use the Test Posting forum to post a few messages yourself! You can also get a free demo to try the IPS Community Suite yourself.

Already an active IPS client?

Login with the same email address and password you use for the client area to access client-only areas.

Issue information

Issue ID
#015576
Status
Fixed
Version
1.x
Fixed in
1.3.1
Severity
0 - None Assigned

Issue Confirmations

Yes (0)No (0)

0

Driver error after posting issue and viewing existing one

Posted by Wareczek on 12 June 2009 - 05: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.

Back to top

AlbusDumbledore

Jun 13 2009 02:16 AM

That table was installed in RC1, but the upgrader for RC2 drops it.

Back to top

Adriano Faria
Pip

Jun 13 2009 08:44 AM

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.

Back to top

Alex

Jun 13 2009 09:20 AM

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.

Back to top

Adriano Faria
Pip

Jun 13 2009 11:05 AM

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

Back to top

teraßyte

Jun 13 2009 11:38 AM

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