I moved an existing phpbt-installation to another server.
Old version was 1.0.1 (I think - I just have an sql-dump and the attachements) and I installed the latest release 1.0.4.
To make sure I don't miss any database changes, I added the data table-by-table to the new database using phpMyAdmin and the sql-dump.
In two tables I had to add missing values, since there has been added a new field meanwhile.
So, I just thought this should work.
Now to the problem:
The installation seems to work pretty well - I can log in, see my bugs, download attachments etc.
BUT when I call any queries, I get an unknown database error.
Result:
DB Error: unknown error
select b.bug_id as bug_link_id, severity.severity_color, priority.priority_color, b.bug_id, title, reporter.login as reporter, owner.login as owner, severity.severity_name, priority.priority_name, status.status_name, resolution_name from phpbt_bug b left join phpbt_auth_user owner on b.assigned_to = owner.user_id left join phpbt_auth_user reporter on b.created_by = reporter.user_id left join phpbt_auth_user lastmodifier on b.last_modified_by = lastmodifier.user_id left join phpbt_comment comment on b.bug_id = comment.bug_id left join phpbt_attachment attachment on b.bug_id = attachment.bug_id left join phpbt_bug_vote vote on b.bug_id = vote.bug_id left join phpbt_bookmark bookmark on b.bug_id = bookmark.bug_id left join phpbt_resolution resolution on b.resolution_id = resolution.resolution_id left join phpbt_database_server on b.database_id = phpbt_database_server.database_id left join phpbt_version version2 on b.to_be_closed_in_version_id = version2.version_id left join phpbt_version version3 on b.closed_in_version_id = version3.version_id, phpbt_severity severity, phpbt_status status, phpbt_os os, phpbt_site site, phpbt_version version, phpbt_component component, phpbt_project project, phpbt_priority priority where b.severity_id = severity.severity_id and b.priority = priority.priority_id and b.status_id = status.status_id and b.os_id = os.os_id and b.site_id = site.site_id and b.version_id = version.version_id and b.component_id = component.component_id and b.project_id = project.project_id and b.status_id in (1, 2, 3, 4) and assigned_to = 2 group by b.bug_id order by b.bug_id asc, b.bug_id asc LIMIT 0, 20 [nativecode=1104 ** The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay]
I don't know what that message means.
I tried the suggested calls - 'SET SQL_BIG_SELECTS=1' and 'SET SQL_MAX_JOIN_SIZE=10000' (without knowing what's exactly doing).
But that didn't help..
I have no idea what went wrong here. Any help appreciated..
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I moved an existing phpbt-installation to another server.
Old version was 1.0.1 (I think - I just have an sql-dump and the attachements) and I installed the latest release 1.0.4.
To make sure I don't miss any database changes, I added the data table-by-table to the new database using phpMyAdmin and the sql-dump.
In two tables I had to add missing values, since there has been added a new field meanwhile.
So, I just thought this should work.
Now to the problem:
The installation seems to work pretty well - I can log in, see my bugs, download attachments etc.
BUT when I call any queries, I get an unknown database error.
Example:
http://bugs.mydomain.com/query.php?op=mybugs&assignedto=1&open=1
Result:
DB Error: unknown error
select b.bug_id as bug_link_id, severity.severity_color, priority.priority_color, b.bug_id, title, reporter.login as reporter, owner.login as owner, severity.severity_name, priority.priority_name, status.status_name, resolution_name from phpbt_bug b left join phpbt_auth_user owner on b.assigned_to = owner.user_id left join phpbt_auth_user reporter on b.created_by = reporter.user_id left join phpbt_auth_user lastmodifier on b.last_modified_by = lastmodifier.user_id left join phpbt_comment comment on b.bug_id = comment.bug_id left join phpbt_attachment attachment on b.bug_id = attachment.bug_id left join phpbt_bug_vote vote on b.bug_id = vote.bug_id left join phpbt_bookmark bookmark on b.bug_id = bookmark.bug_id left join phpbt_resolution resolution on b.resolution_id = resolution.resolution_id left join phpbt_database_server on b.database_id = phpbt_database_server.database_id left join phpbt_version version2 on b.to_be_closed_in_version_id = version2.version_id left join phpbt_version version3 on b.closed_in_version_id = version3.version_id, phpbt_severity severity, phpbt_status status, phpbt_os os, phpbt_site site, phpbt_version version, phpbt_component component, phpbt_project project, phpbt_priority priority where b.severity_id = severity.severity_id and b.priority = priority.priority_id and b.status_id = status.status_id and b.os_id = os.os_id and b.site_id = site.site_id and b.version_id = version.version_id and b.component_id = component.component_id and b.project_id = project.project_id and b.status_id in (1, 2, 3, 4) and assigned_to = 2 group by b.bug_id order by b.bug_id asc, b.bug_id asc LIMIT 0, 20 [nativecode=1104 ** The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay]
I don't know what that message means.
I tried the suggested calls - 'SET SQL_BIG_SELECTS=1' and 'SET SQL_MAX_JOIN_SIZE=10000' (without knowing what's exactly doing).
But that didn't help..
I have no idea what went wrong here. Any help appreciated..