PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Photopost Pro How Do I...? (http://www.photopost.com/forum/photopost-pro-how-do-i/)
-   -   Moving the Database (http://www.photopost.com/forum/photopost-pro-how-do-i/129735-moving-database.html)

JakeC January 5th, 2007 04:39 PM

Moving the Database
 
Here is the situation. Currently PhotoPost Pro version 3.1.1 is running in the same database as my Vbulletin version 2.2.9. I would like to separate the databases.

I've copied all of the PhotoPost tables into a new database and gave that database the same user and therefore the same permissions as the original database. I've re-configured the config-inc.php file so that $database="the new database";. I left $database_bb="the forum database";.

When I go to the PhotoPost main page the headers and footers look ok but otherwise I get this error:
Quote:

MySQL error reported!
Query:

Result: Query was empty

Database handle: Resource id #8
I'm new at this. What am I doing wrong? Could it be how I copied the database? I exported the tables and then imported them into the new database. Is there any settings in the import / export process that I need to be carful of? Thanks.

Jake

Chuck S January 5th, 2007 05:29 PM

I can not say what your doing wrong cause nothing is telling me where your error lies? Is this a vbulletin error or Photopost one. See what I mean there is nothing in that error report to tell me. Turn of your vb integration and see if it loads.

JakeC January 5th, 2007 06:06 PM

1 Attachment(s)
Here is a screen shot. It says it is a photopost message. I'll see if I can turn off VB intigration.

JakeC January 5th, 2007 06:15 PM

This is an older version of PP (3.1.1). There is not a Config-Int.php file. Where is the setting for turning off integration? Is it in the database or one of the php files? Thanks.

Jake

Chuck S January 6th, 2007 08:07 AM

Turning off integration in header-inc.php

Your error must be in whatever your doing

My advise is to keep things where they work and then upgrade to the latest then try separating the databases

JakeC January 6th, 2007 09:00 AM

Yeah, that sounds wise. Thanks Chuck.

It just bothers me that I can't do it. I'm still learning about Mysql databases and how they work - interesting stuff.

Jake


All times are GMT -5. The time now is 06:00 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97