1
Tyson0317
Problem with migrating xoops from one server to another...
  • 2007/1/14 4:38

  • Tyson0317

  • Just popping in

  • Posts: 54

  • Since: 2006/4/21


Here is the situation... We upgraded our web server which had XOOPS on it. Both old and new servers were running XOOPS on IIS (old one Windows 2000, new on 2003). I have migraded mySQL and when I do show databases; in the sql console, I can see my database there. PHP seems to be working OK too - I have made a few simple PHP test scripts and they execute properly... However, the XOOPS site loads just a plain white blank page.

No errors, nothing! I have checked permissions, I have checked path statements in the mainfile.php, I dont know what else to try! What could be going wrong?

2
irmtfan
Re: Problem with migrating xoops from one server to another...
  • 2007/1/14 4:52

  • irmtfan

  • Module Developer

  • Posts: 3419

  • Since: 2003/12/7


could you turn on php debug?
see faq no.80 for blank pages.
https://xoops.org/modules/smartfaq/faq.php?faqid=80

also read this faq carefully
How do I move my site from one server to another?

3
Tyson0317
Re: Problem with migrating xoops from one server to another...
  • 2007/1/14 5:04

  • Tyson0317

  • Just popping in

  • Posts: 54

  • Since: 2006/4/21


Ok, so from searching the site I now realize that this is a generic error problem... So I found the FAQ on blank screens and tried to turn on error reporting. Here is where I got:

1. I cannot get to the administration menu.
2. When in the mySQL command line util I do the following ang get:

mysql> UPDATE XOOPS SET conf_value=1 WHERE conf_name = 'debug_mode';
ERROR 1046 (3D000): No database selected

I know my database name, but I dont know how to select it for this command. Please help!

3. I have eddited the "include/common.php" and set error_reporting to (E_ALL)

4. I have ensured that display_errors is set to ON in my php.ini

I am still getting a blank screen with no errors...

4
Tyson0317
Re: Problem with migrating xoops from one server to another...
  • 2007/1/14 5:42

  • Tyson0317

  • Just popping in

  • Posts: 54

  • Since: 2006/4/21


Ok I read over the migration FAQ. Given that I am a server admin, I was able to move the whole SQL DB, and the entire contents of the folder also... One part I did not get was:

"set cache, templates_c and uploads directories to be writeable by the server"

WTF is "server"?! Windows/IIS does not have "server". What user needs access to these? In ether case, I gave the EVERYONE group full access to these directories and that still did not solve my problem, so I dont think that this is it...

Please look at my previous post above as I still am getting no errors and a blank screen.

5
irmtfan
Re: Problem with migrating xoops from one server to another...
  • 2007/1/14 6:56

  • irmtfan

  • Module Developer

  • Posts: 3419

  • Since: 2003/12/7


dont you have phpmyadmin in your new host?
unfortunately i dont know much about IIS and windows environment.just for sure all 3 directories must have read&write attributes

6
leostotch
Re: Problem with migrating xoops from one server to another...
  • 2007/1/14 8:11

  • leostotch

  • Just popping in

  • Posts: 76

  • Since: 2006/4/1 1


Quote:
WTF is "server"?!

The IIS process

Quote:
Windows/IIS does not have "server".

Well, some would tell you that IIS is a "web server"

Quote:
What user needs access to these? In ether case, I gave the EVERYONE group full access to these directories and that still did not solve my problem, so I dont think that this is it...

The IIS service uses a special system account normally called IUSR_SOMETHING, that's the one that needs to be able to write to those folders.

Also, you may get more help by telling us the error message you get (if you're using the latest XOOPS version, the "blank page" is not blank... there should be a message written in white on white background. You can reveal it by using "edit/select all" in your browser).

7
Tyson0317
Re: Problem with migrating xoops from one server to another...
  • 2007/1/14 19:59

  • Tyson0317

  • Just popping in

  • Posts: 54

  • Since: 2006/4/21


Apperantly I dont have the latest XOOPS - no secret white on white errors...

I guess I dont have phpmyadmin. What will that do for me? Where do I get it?

Thanks for clarifying the user that needs access, someone should tweak the FAQ to reflect this, because it makes no sence to us Windows guys...

In ether case, what is my next step here?

8
Tyson0317
Re: Problem with migrating xoops from one server to another...
  • 2007/1/15 20:11

  • Tyson0317

  • Just popping in

  • Posts: 54

  • Since: 2006/4/21


Anyone home?

9
Tyson0317
Re: Problem with migrating xoops from one server to another...
  • 2007/1/15 21:23

  • Tyson0317

  • Just popping in

  • Posts: 54

  • Since: 2006/4/21


Ok guys, I need some help please! My site has been down for 5 days and I can do little else than click Refrsh on this page every few minutes to see no new responces! I have still been unsuccessful in getting any kind of error from my blank screen. I hace completed all of the steps on the FAQ with the exemption of:

mysql> UPDATE XOOPS SET conf_value=1 WHERE conf_name = 'debug_mode';
ERROR 1046 (3D000): No database selected

I know my database name, but I dont know how to select it for this command.

Please help!!

10
rlankford
Re: Problem with migrating xoops from one server to another...
  • 2007/1/16 3:22

  • rlankford

  • Not too shy to talk

  • Posts: 158

  • Since: 2004/8/27


It sounds like you need to use the database first.

Login

Who's Online

175 user(s) are online (134 user(s) are browsing Support Forums)


Members: 0


Guests: 175


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits