Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By mcsolas on
I had a site just about ready to launch when it was decided to launch from a new domain. So today, I tried to move the site over. its working more or less, but I had to run install.php to get it back online. It seems to have reset a few things, like a block I had on the right column, defaulted to the original theme.. a few other things. I have managed to get it all back in order, minus these error messages that keep popping up. How can I address this:
# user warning: Table 'solas_jacochamber.node_group' doesn't exist query: SELECT * FROM node_group ORDER BY weight, group_name in /home/httpd/vhosts/jacochamber.com/httpdocs/sites/all/modules/cck/modules/fieldgroup/fieldgroup.module on line 230.
# user warning: Table 'solas_jacochamber.node_group' doesn't exist query: SELECT nfi.*, ng.group_name FROM node_group ng INNER JOIN node_group_fields ngf ON ngf.type_name = ng.type_name AND ngf.group_name = ng.group_name INNER JOIN node_field_instance nfi ON nfi.field_name = ngf.field_name AND nfi.type_name = ngf.type_name WHERE nfi.widget_active = 1 ORDER BY nfi.weight in /home/httpd/vhosts/jacochamber.com/httpdocs/sites/all/modules/cck/modules/fieldgroup/fieldgroup.module on line 243.
Comments
=-=
looks like a module isn't installed correctly or at least it's tables. Did you import the old database? There shouldn't have been a reason to run install.php to move a site.
backup old domain database
import to new host
move all files and folders
clear all cache tables, watchdog table and sessions table in the database
open settings.php add new $db_url string
login to site.
I also take the time to disable clean urls and reenable after the move.
sweet.. its working!
followed the instructions & its back online. got stuck on one last thing and had to search the database for the string of my old site name. found the issues in the variables table for the temp directory and manually updated it to the correct info.. which removed this last error msg:
warning: realpath() [function.realpath]: open_basedir restriction in effect. File(/home/httpd/vhosts/oldsite/httpdocs/tmp) is not within the allowed path(s): (/home/httpd/vhosts/newsite/httpdocs:/tmp) in /home/httpd/vhosts/newsite/httpdocs/includes/file.inc on line 190.
=-=
in adminster -> file system
try moving the tmp folder to files/tmp which will put the tmp folder in your sites/default/files folder. This avoids sharing a servers default tmp folder especially when on a shared host.
ok.
thanks for the tip, I made the change. Makes sense to have it there.