I recently have completed an upgrade from D6 to D7 (D6:www.pflogging.com, D7:test.pflogging.com). I needed to move the resulting of this conversion to a new shared host, and so I selected Bluehost as my provider, and created a new domain (thrivingonsystems.com). Bluehost supports scripted creation of a new site, which I used to build a template of the required sites/default/settings.php file. That site operates correctly (thrivingsystems.com/thrivingsystems). I then transferred all modules and themes from the D7 site into the sites/all folders on the new site, and exported my existing site's database (using the backup migrate module), created a new database on the Bluehost site, and imported the mysql into that new database. I then made a copy of the settings.php generated by the working drupal site, and modified it to point to the new database.
Unfortunately, I get the following error:
The website encountered an unexpected error. Please try again later.
Error messagePDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'thrivip7_prod.dpl_semaphore' doesn't exist: SELECT expire, value FROM {semaphore} WHERE name = :name; Array ( [:name] => variable_init ) in lock_may_be_available() (line 167 of /home3/thrivip7/public_html/thrivingonsystems/includes/lock.inc).
My searching for solutions have suggested running upgrade.php, but I get the same error. Others seem to suggest deleting all content from the old site, but that's not an acceptable solution. I really want to move to D7, and have been very impressed with what it offers... but it seems just out of reach, and I'm at the limits of my technical abilities, and have 16 hours invested in getting where I am.
I'm at a loss of what to do. I thought I had a strategy that worked, but I appear to have backed myself into a corner. I'm hoping someone can suggest what I might try next. The Bluehost people have been very helpful, but as I'm still able to get the scripted site to work, I'm hoping someone from the Drupal community can throw me a life ring!
Comments
=-=
the old database seems to be using a table prefix. does the new the new database that was created also utilize a prefix?
have you checked the DB to make sure the table that the table in question is there?
one click host installs are great for testing however, I'm of the opinion that prod sites should utilize drupal's native installer. There are a multitude of threads on the forums where users have run into issues when the site require updating. This seems to be the case regardless of the offering used.
Prefixes
That has really helped. I looked at the old site's settings file and noticed it used as username which had a prefix already made (xxxx_user), i.e.
'database' => 'sitename_db',
'username' => 'sitename_user',
'password' => 'xxxxxxxxxx',
'host' => 'localhost',
'prefix' => '',
I checked and noticed the new settings file (a derivative of the auto-generated one) instead employed defined the prefix directly in the array. When I instead set the prefix to null as in the original, and inserted the account assigned from the hosting service, the new drupal site began to respond, and I was able to log in to the uploaded database. I still appear to be missing display of the node bodies after login, but that's another problem that I can set about to try to uncover.
In the meantime, thanks so very much for the suggestion.