TIA for your help.
Migration
1. Copied all files from old site, zipped and unpacked on new loaction on new server.
2. Edited config/config.php to reflect new login credentials.
3. Using phpMyAdmin, I created the database on the new server.
4. Using phpMyAdmin, I took an export of the database on the old site, with complete structure and data dump, imported into mysql on new site using phpmaydmin.
5. Loaded index.php into browser (see results below.)
Old "Server" Setup
Windows XP Professional box running xampp
xampp 1.70
PHP Version: 5.2.8
MySQL Version: 5.1.30-community
New Server Setup
Ubuntu 10.04 Server
Apache 2.2.14 (Ubuntu)
PHP Version: 5.3.2-1ubuntu4.2
MySQL Version: 5.1.41-3ubuntu12.6
Troubleshooting
1. Ensured all DB setting were correct.
2. Changed encoding to every possible charset available in both the export and the DB creation on the new box.
3. Dumped the pnTemp/xxx_compiled folders of everything.
4. Cleared the sessions table in the DB.
5. Resisted the urge to throw my massive, spry fist through the !@#$%&ing screen.
6. Exported/imported the DB about 10 different times, 10 different ways (DB encoding related)
7. Each time I refresh the page, a different session is showing up in the errors.
8. Tried the ZRC, wasn't helpful for this.
9. Broke down and came to the forum, begging for help.
index.php yields:
Code
Unknown column 'pn_remember' in 'field list'
SELECT pn_sessid as "sessid",pn_ipaddr as "ipaddr",pn_lastused as "lastused",pn_uid as "uid",pn_remember as "remember",pn_vars as "vars" FROM pn_session_info as tbl WHERE pn_sessid='c0fmobuoqs7bh0vkva4d0oc2upt9psrt'
Unknown column 'pn_url' in 'field list'
SELECT pn_id as "id",pn_name as "name",pn_type as "type",pn_displayname as "displayname",pn_url as "url",pn_description as "description",pn_regid as "regid",pn_directory as "directory",pn_version as "version",pn_official as "official",pn_author as "author",pn_contact as "contact",pn_admin_capable as "admin_capable",pn_user_capable as "user_capable",pn_profile_capable as "profile_capable",pn_message_capable as "message_capable",pn_state as "state",pn_credits as "credits",pn_changelog as "changelog",pn_help as "help",pn_license as "license",pn_securityschema as "securityschema" FROM pn_modules as tbl
Table 'omahadco.pn_themes' doesn't exist
SELECT pn_id AS "id",pn_name AS "name",pn_type AS "type",pn_displayname AS "displayname",pn_description AS "description",pn_regid AS "regid",pn_directory AS "directory",pn_version AS "version",pn_official AS "official",pn_author AS "author",pn_contact AS "contact",pn_admin AS "admin",pn_user AS "user",pn_system AS "system",pn_state AS "state",pn_credits AS "credits",pn_changelog AS "changelog",pn_help AS "help",pn_license AS "license",pn_xhtml AS "xhtml" FROM pn_themes AS tbl
Table 'omahadco.pn_themes' doesn't exist
SELECT pn_id as "id",pn_name as "name",pn_type as "type",pn_displayname as "displayname",pn_description as "description",pn_regid as "regid",pn_directory as "directory",pn_version as "version",pn_official as "official",pn_author as "author",pn_contact as "contact",pn_admin as "admin",pn_user as "user",pn_system as "system",pn_state as "state",pn_credits as "credits",pn_changelog as "changelog",pn_help as "help",pn_license as "license",pn_xhtml as "xhtml" FROM pn_themes as tbl
Table 'omahadco.pn_themes' doesn't exist
SELECT pn_id AS "id",pn_name AS "name",pn_type AS "type",pn_displayname AS "displayname",pn_description AS "description",pn_regid AS "regid",pn_directory AS "directory",pn_version AS "version",pn_official AS "official",pn_author AS "author",pn_contact AS "contact",pn_admin AS "admin",pn_user AS "user",pn_system AS "system",pn_state AS "state",pn_credits AS "credits",pn_changelog AS "changelog",pn_help AS "help",pn_license AS "license",pn_xhtml AS "xhtml" FROM pn_themes AS tbl
Unknown column 'pn_sequence' in 'field list'
SELECT pn_id AS "id",pn_object AS "object",pn_action AS "action",pn_smodule AS "smodule",pn_stype AS "stype",pn_tarea AS "tarea",pn_tmodule AS "tmodule",pn_ttype AS "ttype",pn_tfunc AS "tfunc",pn_sequence AS "sequence" FROM pn_hooks AS tbl WHERE pn_smodule = 'zikula' ORDER BY pn_sequence ASC
Unknown column 'pn_remember' in 'field list'
INSERT INTO pn_session_info (pn_sessid,pn_ipaddr,pn_lastused,pn_uid,pn_remember,pn_vars)VALUES ('hagin6ro3ct72i7d8vq5edho0oimugb7','4955be4eb06471362e3d8061e27bf347','2010-08-28 23:07:00',0,0,'PNSV_PNErrorMsg|a:11:{i:0;s:36:\"Exit handler:Exiting after SQL-error\";i:1;s:44:\"Exit handler:Error! Invalid result received.\";i:2;s:36:\"Exit handler:Exiting after SQL-error\";i:3;s:44:\"Exit handler:Error! Invalid result received.\";i:4;s:36:\"Exit handler:Exiting after SQL-error\";i:5;s:44:\"Exit handler:Error! Invalid result received.\";i:6;s:36:\"Exit handler:Exiting after SQL-error\";i:7;s:44:\"Exit handler:Error! Invalid result received.\";i:8;s:36:\"Exit handler:Exiting after SQL-error\";i:9;s:44:\"Exit handler:Error! Invalid result received.\";i:10;s:46:\"The \'News\' module is not currently accessible.\";}PNSVrand|a:0:{}PNSVuseragent|s:40:\"f052681fc36488098e3ff1b1a57e60c3776a6407\";PNSV_PNStatusMsg|a:0:{}')
SELECT pn_sessid as "sessid",pn_ipaddr as "ipaddr",pn_lastused as "lastused",pn_uid as "uid",pn_remember as "remember",pn_vars as "vars" FROM pn_session_info as tbl WHERE pn_sessid='c0fmobuoqs7bh0vkva4d0oc2upt9psrt'
Unknown column 'pn_url' in 'field list'
SELECT pn_id as "id",pn_name as "name",pn_type as "type",pn_displayname as "displayname",pn_url as "url",pn_description as "description",pn_regid as "regid",pn_directory as "directory",pn_version as "version",pn_official as "official",pn_author as "author",pn_contact as "contact",pn_admin_capable as "admin_capable",pn_user_capable as "user_capable",pn_profile_capable as "profile_capable",pn_message_capable as "message_capable",pn_state as "state",pn_credits as "credits",pn_changelog as "changelog",pn_help as "help",pn_license as "license",pn_securityschema as "securityschema" FROM pn_modules as tbl
Table 'omahadco.pn_themes' doesn't exist
SELECT pn_id AS "id",pn_name AS "name",pn_type AS "type",pn_displayname AS "displayname",pn_description AS "description",pn_regid AS "regid",pn_directory AS "directory",pn_version AS "version",pn_official AS "official",pn_author AS "author",pn_contact AS "contact",pn_admin AS "admin",pn_user AS "user",pn_system AS "system",pn_state AS "state",pn_credits AS "credits",pn_changelog AS "changelog",pn_help AS "help",pn_license AS "license",pn_xhtml AS "xhtml" FROM pn_themes AS tbl
Table 'omahadco.pn_themes' doesn't exist
SELECT pn_id as "id",pn_name as "name",pn_type as "type",pn_displayname as "displayname",pn_description as "description",pn_regid as "regid",pn_directory as "directory",pn_version as "version",pn_official as "official",pn_author as "author",pn_contact as "contact",pn_admin as "admin",pn_user as "user",pn_system as "system",pn_state as "state",pn_credits as "credits",pn_changelog as "changelog",pn_help as "help",pn_license as "license",pn_xhtml as "xhtml" FROM pn_themes as tbl
Table 'omahadco.pn_themes' doesn't exist
SELECT pn_id AS "id",pn_name AS "name",pn_type AS "type",pn_displayname AS "displayname",pn_description AS "description",pn_regid AS "regid",pn_directory AS "directory",pn_version AS "version",pn_official AS "official",pn_author AS "author",pn_contact AS "contact",pn_admin AS "admin",pn_user AS "user",pn_system AS "system",pn_state AS "state",pn_credits AS "credits",pn_changelog AS "changelog",pn_help AS "help",pn_license AS "license",pn_xhtml AS "xhtml" FROM pn_themes AS tbl
Unknown column 'pn_sequence' in 'field list'
SELECT pn_id AS "id",pn_object AS "object",pn_action AS "action",pn_smodule AS "smodule",pn_stype AS "stype",pn_tarea AS "tarea",pn_tmodule AS "tmodule",pn_ttype AS "ttype",pn_tfunc AS "tfunc",pn_sequence AS "sequence" FROM pn_hooks AS tbl WHERE pn_smodule = 'zikula' ORDER BY pn_sequence ASC
Unknown column 'pn_remember' in 'field list'
INSERT INTO pn_session_info (pn_sessid,pn_ipaddr,pn_lastused,pn_uid,pn_remember,pn_vars)VALUES ('hagin6ro3ct72i7d8vq5edho0oimugb7','4955be4eb06471362e3d8061e27bf347','2010-08-28 23:07:00',0,0,'PNSV_PNErrorMsg|a:11:{i:0;s:36:\"Exit handler:Exiting after SQL-error\";i:1;s:44:\"Exit handler:Error! Invalid result received.\";i:2;s:36:\"Exit handler:Exiting after SQL-error\";i:3;s:44:\"Exit handler:Error! Invalid result received.\";i:4;s:36:\"Exit handler:Exiting after SQL-error\";i:5;s:44:\"Exit handler:Error! Invalid result received.\";i:6;s:36:\"Exit handler:Exiting after SQL-error\";i:7;s:44:\"Exit handler:Error! Invalid result received.\";i:8;s:36:\"Exit handler:Exiting after SQL-error\";i:9;s:44:\"Exit handler:Error! Invalid result received.\";i:10;s:46:\"The \'News\' module is not currently accessible.\";}PNSVrand|a:0:{}PNSVuseragent|s:40:\"f052681fc36488098e3ff1b1a57e60c3776a6407\";PNSV_PNStatusMsg|a:0:{}')
--
[ stevencopley.com ]
