Table 'phpbb_db.system' doesn't exist
| Project: | phpBB2Drupal |
| Version: | 5.x-3.0 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | duplicate |
Jump to:
I have both phpbb and drupal installed locally on my computer and with their separate databases running on the same mysql server on localhost (under XAMPP). The drupal installation is a fresh installation, no content, just admin user and no other module installed other than basic core modules and those required by the phpbb2drupal module.
I configure the migration properly and get the OK to proceed (no red warnings on the config screen and db info properly in place).
When I execute the migration, the scripts warns about a missing phpbbeduc.system table (phpbbeduc being my phpbb database) and stops abruptly, but upon retrying it seems to work fine. There is no system table on the phpbb database as far as I can tell (just did a fresh install to confirm). Other than that the migration appears to be fine and I end up with a fully working successfully imported Drupal forum.
Missing system table Warning Importing Users
When I attempt to import users, the process seems to run for a while and then displays a blank screen with this message:
Warning: Table 'phpbbeduc.system' doesn't exist query: SELECT * FROM system WHERE type = 'theme' in C:\xampp\htdocs\drupal\includes\database.mysql.inc on line 172
If I return to the ?q=admin/phpbb2drupal/migrate page, I then see the same error, but with a notice that the users have been properly imported (I checked the db and they were indeed imported).
Execute Migration
user warning: Table 'phpbbeduc.system' doesn't exist query: SELECT * FROM system WHERE type = 'theme' in C:\xampp\htdocs\drupal\includes\database.mysql.inc on line 172.
- Found 5190 users: Beginning Import
- Successfully Imported 5190 Users
No Warning Importing Categories
The next step (categories import) works without an error.
Missing system table Warning Importing Topics
The topics import presents the same situation.
When I attempt to import topics, the process seems to run for a while and then displays a blank screen with this message:
Warning: Table 'phpbbeduc.system' doesn't exist query: SELECT * FROM system WHERE type = 'theme' in C:\xampp\htdocs\drupal\includes\database.mysql.inc on line 172
If I return to the ?q=admin/phpbb2drupal/migrate page, I then see the same error, but with a notice that the topics have been properly imported (I checked the db and they were indeed imported).
Execute Migration
user warning: Table 'phpbbeduc.system' doesn't exist query: SELECT * FROM system WHERE type = 'theme' in C:\xampp\htdocs\drupal\includes\database.mysql.inc on line 172.
- Found 2172 topics: Beginning Import
- Successfully Imported 2172 topics
Missing system table Warning Importing Polls
The polls import presents the same situation. Not that it matters since I don't have any polls. But I thought it was worth mentioning.
When I attempt to import polls, the process seems to run for a while and then displays a blank screen with this message:
Warning: Table 'phpbbeduc.system' doesn't exist query: SELECT * FROM system WHERE type = 'theme' in C:\xampp\htdocs\drupal\includes\database.mysql.inc on line 172
If I return to the ?q=admin/phpbb2drupal/migrate page, I then see the same error, and a notice that no polls where imported because of course I have no polls.
Missing system table Warning Importing Posts
The posts import presents the same situation.
When I attempt to import posts, the process seems to run for a while and then displays a blank screen with this message:
Warning: Table 'phpbbeduc.system' doesn't exist query: SELECT * FROM system WHERE type = 'theme' in C:\xampp\htdocs\drupal\includes\database.mysql.inc on line 172
If I return to the ?q=admin/phpbb2drupal/migrate page, I then see the same error, but with a notice that the posts have been properly imported (I checked the db and they were indeed imported).
Execute Migration
user warning: Table 'phpbbeduc.system' doesn't exist query: SELECT * FROM system WHERE type = 'theme' in C:\xampp\htdocs\drupal\includes\database.mysql.inc on line 172.
- Found 1013 posts: Beginning Import
- Successfully Imported posts
- The were 8940 loops executed
- There 0 errors while importing posts
#1
Yes, I have run into those errors a few times myself. however, I have no idea what causes them, or how to get rid of them.
Since they do not seem to affect the import in any way (except for the worrying messages themselves), I have just ignored them til now.
These errors will take someone more knowledgeable in the databases and the drupal implementation to atleast point me in the right direction.
#2
I too am encountering a similar error while developing a module.
It occurs when I make a call to a foreign database using mysql_query() rather than db_query().
After peeking in the db_query() function, I changed my mysql_* calls to db_* and it has eliminated the error.
While I'm not certain that this is the cause of the error, it has resolved it for me. Maybe it will help others as well.
#3
While it is to do with external database handling, the errors come from some code which does not contain any mysql_ calls (nor does this module - just did a quick search for the term "mysql_" and got zero matches)
The function _phpbb2drupal_check_tables() seems to cause a lot of these errors and has its own issue already at #282216: function _phpbb2drupal_check_tables() causes theming errors. Any help would be much appreciated.
#4
This was a duplicate of the above.