SimplePortal

Support => Install and Upgrade => Topic started by: kavodoros on January 04, 2011, 10:27:55 PM

Title: Problem importing production database to test forum
Post by: kavodoros on January 04, 2011, 10:27:55 PM
Hello everybody,

I want to run a test site before i install SP on my basic forum.
So, i first installed a new SMF 1.1.12 (Greek) say under folder /testforum and then the package of SP 2.3.3 and everything is ok.
Now i want to import everything from the database of the basic forum (say under folder /forum), to the new one, to see messages, users, pm's and all the stuff how they look like with Simple Portal installed.

The problem is that when i import the database of the basic forum to the test forum and go to the Simple Portal configuration it keeps informing me (in Greek) that PortalAdmin cannot be loaded.

So i tried something else;
I installed SMF, first imported the databases of the basic forum there (so i had a second forum exactly like the first one),  and then tried to install Simple Portal.
Again the same message appears, but now, its worse; I can't even click a menu item without this message to appear!

Thanks in advance for your support.

Nikos
Title: Re: New installation with an existing forum
Post by: AngelinaBelle on January 11, 2011, 08:41:03 AM
Everything is OK until you imported the database -- correct?
The database actually contains information about your forum.
 
Please have a look at this post from another user with a similar problem, and see if it helps you solve your problem:
http://simpleportal.net/index.php?topic=7297.msg40895#msg40895 (http://simpleportal.net/index.php?topic=7297.msg40895#msg40895)
 
 
Title: Re: Problem importing production database to test forum
Post by: kavodoros on January 18, 2011, 12:05:28 PM
Angelina Thank you for your answer,

Unfortunately, it seems to be a different issue than mine's.

In my first post i described 2 alternate ways of installing SP and try to make it work on my forum and both of them failed. Did i do something wrong there?

In both situations, there was an error message coming from SMF, appearing at every single page, saying (in Greek language) that "portal module, could not be loaded".

So anyways, should i send a print screen or something, maybe to make my question a little more clear and help me?
...or nobody else has encountered this issue? (so i have to find the solution by myself)

Anyway, as soon as i have any news, i will post again

Thanks
Title: Re: Problem importing production database to test forum
Post by: AngelinaBelle on January 19, 2011, 07:07:58 AM
This does seem like a strange error.
Please:
1) Switch to English Language and give me the exact error message you received.
2) Are there any errors in the error log (please give them in English)
3) Please go through your database to make sure it does not contain paths for your production database.  Another poster reported finding path information in the following places:
 
smf_settings
smf_themes
smf_aeva_settings
The following table contained paths from my production page AND my first ISP on GoDaddy (contained /j/p/b/)
smf_themes
Title: Re: Problem importing production database to test forum
Post by: kavodoros on January 25, 2011, 07:07:39 PM
Angelina,

Error Log does not return any related errors (just old errors about wrong login password).
Before switching to English language i checked the databases and they contained paths of my production site, the same issue like this guy's!

So, for the moment, i manually changed the paths on table smf_themes and smf_settings and the test page seems to be working almost well.
"Almost" because some buttons like "expand" and "collide" do not appear nice, so there must be some more path to change...

Any ideas, where could these paths be?

Thank you again,
Nick


This does seem like a strange error.
Please:
1) Switch to English Language and give me the exact error message you received.
2) Are there any errors in the error log (please give them in English)
3) Please go through your database to make sure it does not contain paths for your production database.  Another poster reported finding path information in the following places:
 
smf_settings
smf_themes
smf_aeva_settings
The following table contained paths from my production page AND my first ISP on GoDaddy (contained /j/p/b/)
smf_themes
Title: Re: Problem importing production database to test forum
Post by: AngelinaBelle on January 26, 2011, 07:22:44 AM
Now it seems like your database is in good shape.
The buttons are handled in the php files.
 
Please see what those files link to. Maybe you could provide a link for me to look at?
Title: Re: Problem importing production database to test forum
Post by: kavodoros on January 31, 2011, 06:14:18 PM
Yes of course Angelina.
The link of my test portal is here:
http://www.kyklogenesis.gr/testforum/

I'm a little afraid of getting into these php files, because an 'innocent' mistake such as adding a line on the top of a file may result to errors or a complete crash of the page...(as it has happened before)

So, according to what you see there, if you could figure out where should i look to change the paths, i would be glad.

Nick
Title: Re: Problem importing production database to test forum
Post by: AngelinaBelle on February 03, 2011, 07:43:24 AM
  You are almost finished setting up your test forum.
I think you need to copy the contents of Themes/default/images/sp into your testforum, if you care about them, and to correct the URL of your logo image.
 
I am looking at the HTML for http://www.kyklogenesis.gr/testforum/index.php (http://www.kyklogenesis.gr/testforum/index.php)
I am using IE8 developer's tools (you could also use firebug for firefox). This makes it easy for me to point at an element on the page and see the HTML highlighted for it.
 
That collapse image is:
<img src="http://kyklogenesis.gr/testforum/Themes/default/images/sp/collapse.png" alt="collapse" id="sp_collapse_side1" />
 
 
And the dot in the Who's Online list is:
<img src="http://kyklogenesis.gr/testforum/Themes/default/images/sp/collapse.png" alt="collapse" id="sp_collapse_side1" />
 
And those files are just not there.
 
You have another image error -- the URL for your logo image is not correct.
http://www.kyklogenesis.gr/testforum/index.php (http://www.kyklogenesis.gr/testforum/index.php)
 
Title: Re: Problem importing production database to test forum
Post by: kavodoros on February 11, 2011, 06:12:36 PM
Thank you Angelina,

Strange thing is that there's not such a folder called "sp" under ../default/images/ !

So, should i create that folder by myself, and copy all the images inside there or, change the paths manually from the php pages?

Anyways, considering this issue with these database tables:
smf_settings
smf_themes
smf_aeva_settings

may this be related to the wrong paths in my index.php page?
I also noticed many other problems inside the administration pages, with the most important of all the fact that sp administration box does not appear on the left side!

Nikos

P.S. Sorry for my late posts, i m really trying to be a little faster, but this period of the year i dealing with many other obligations and got not spare time left! I ll try to be a little faster... :-)
Title: Re: Problem importing production database to test forum
Post by: AngelinaBelle on February 12, 2011, 09:29:46 AM
Th issues I spotted had to do with missing image file.
 
Probably, the problem was permissions when you installed -- the installer was unable to create the directory and put the files in it.
 
You can do this step yourself.
That should make all the simpleportal images show up.
SimplePortal 2.3.8 © 2008-2024, SimplePortal